Difference between revisions of "PHP111"
From mi-linux
Jump to navigationJump to search| Line 8: | Line 8: | ||
# (DEPRECATED) The [http://www.php.net/manual/en/ref.mysql.php mysql functions] are procedural and use manual escaping. | # (DEPRECATED) The [http://www.php.net/manual/en/ref.mysql.php mysql functions] are procedural and use manual escaping. | ||
| − | # [http://www.php.net/manual/en/intro.mysqli.php MySQLi] is a replacement for the mysql functions, with object-oriented and procedural versions. It has support for prepared statements. ''We will use this option on this module'' | + | # [http://www.php.net/manual/en/intro.mysqli.php MySQLi] is a replacement for the mysql functions, with object-oriented and procedural versions. It has support for prepared statements. '''We will use this option on this module''' |
| − | # PDO (PHP Data Objects) is a general database abstraction layer with support for MySQL among many other databases. It provides prepared statements, and significant flexibility in how data is returned. | + | # [http://php.net/manual/en/book.pdo.php PDO] (PHP Data Objects) is a general database abstraction layer with support for MySQL among many other databases. It provides prepared statements, and significant flexibility in how data is returned. |
| − | |||
| + | ([http://stackoverflow.com/questions/2190737/what-is-the-difference-between-mysql-mysqli-and-pdo source]) | ||
= Ready to try some more PHP/MySQL? = | = Ready to try some more PHP/MySQL? = | ||
A simple example of using a HTML form to capture search requirements and execute a custom query can be found at [[PHP112|PHP112 - Simple HTML/PHP/MySQL example]] | A simple example of using a HTML form to capture search requirements and execute a custom query can be found at [[PHP112|PHP112 - Simple HTML/PHP/MySQL example]] | ||
Revision as of 15:26, 29 June 2016
Main Page >> Web Application Development >> Workbook >> PHP and Databases
PHP and Databases – Making the Connection
How to connect
There are 3 ways to connect to a database in PHP:
- (DEPRECATED) The mysql functions are procedural and use manual escaping.
- MySQLi is a replacement for the mysql functions, with object-oriented and procedural versions. It has support for prepared statements. We will use this option on this module
- PDO (PHP Data Objects) is a general database abstraction layer with support for MySQL among many other databases. It provides prepared statements, and significant flexibility in how data is returned.
(source)
Ready to try some more PHP/MySQL?
A simple example of using a HTML form to capture search requirements and execute a custom query can be found at PHP112 - Simple HTML/PHP/MySQL example
