Advance PHP | Basic MYSQLI - video #39
We will discuss basic mySQL connection, mysql_fetch_array function, “prepare” statement. When you prepare an SQL statement, you can insert a placeholder (?) - where a column value would go.
Then we use the “bind_param()” to safely substitute the placeholder for the real column's value. This prevents any possibility of an SQL injection.
The “mysql_fetch_array” function fetches a result row as an associative array and numeric array.
We will specify what type of array that should be produced. We will use the “prepare” statement. The “prepare()” / “mysqli_prepare()” function is used to prepare an SQL statement for execution.
When you prepare an SQL statement, you can insert a placeholder (?) - where a column value would go. Then we use the “bind_param()” to safely substitute the placeholder for the real column's value. This prevents any possibility of an SQL injection.
Here are the source codes for this project in php and txt.
https://convertowordpress.com/chkCRUD...
https://convertowordpress.com/chkCRUD...
Here, I am providing you with a PDF document. This document has all of the examples with explanations.
https://convertowordpress.com/practic...
Check out the PHP manual that is available online -
https://www.php.net/docs.php
If you want a developer to create your web design project.
Visit: https://convertowordpress.com