Download to read offline
![ PHP $result = mysql_query($sql);$result = mysql_query($sql); while($row =while($row = mysql_fetch_array($result)){mysql_fetch_array($result)){ echo $row['FirstName'] . " " .echo $row['FirstName'] . " " . $row['LastName'];$row['LastName']; echo "<br />";echo "<br />"; }}](https://image.slidesharecdn.com/php-db-141221140514-conversion-gate01/75/Php-Mysql-11-2048.jpg)
![<?php $con = mysql_connect(“…",“…",“…"); if (!$con) die('Could not connect: ' . mysql_error()); mysql_select_db("my_db", $con); $sql="INSERT INTO Persons (FirstName, LastName, Age) VALUES ('$_POST[firstname]', '$_POST[lastname]', '$_POST[age]')"; if (!mysql_query($sql,$con)) die('Error: ' . mysql_error()); echo "1 record added"; mysql_close($con) ?> Contd:Contd:](https://image.slidesharecdn.com/php-db-141221140514-conversion-gate01/75/Php-Mysql-15-2048.jpg)
Uploaded byMudasir Syed
Php Mysql
Mysql is a popular open-source database management system. PHP usually works with Mysql for web-based database applications. LAMP applications are web-based applications that use Linux, Apache, Mysql, and PHP/Perl/Python. To connect a PHP application to a Mysql database, the PHP code connects to the server, selects a database, executes SQL statements to query or manipulate the data, and closes the connection. Common SQL statements in PHP/Mysql applications include creating databases and tables, selecting, inserting, updating, and deleting data.
Php Mysql
- 2. PHP and DatabasePHPand Database
- 3. MysqlMysql –popular open-source database– popular open-source database management systemmanagement system PHPPHP usually works withusually works with MysqlMysql for web-basedfor web-based database applicationsdatabase applications LAMPLAMP applications—Web-based applicationsapplications—Web-based applications that usethat use LynuxLynux,, ApacheApache,, MysqlMysql, and, and php/pearl/pythonphp/pearl/python
- 4. Connect tohost server which has MysqlConnect to host server which has Mysql installedinstalled Select a databaseSelect a database Form an SQL statementForm an SQL statement Execute the SQL statement and (optionally)Execute the SQL statement and (optionally) return a record setreturn a record set Extract data from recordset using phpExtract data from recordset using php Close connectionClose connection
- 5. <?php<?php $host = ‘localhost’;$host= ‘localhost’; $username = ‘peter’;$username = ‘peter’; $pswd = ‘!?+&*’;$pswd = ‘!?+&*’; $dbName = “myDB”;$dbName = “myDB”; $con = mysql_connect($host, $username,$con = mysql_connect($host, $username, $pswd);$pswd); if (!$con){if (!$con){ die('Could not connect: ‘die('Could not connect: ‘ . mysql_error());. mysql_error()); }} $db = mysql_select_db($dbName,$db = mysql_select_db($dbName, $con) or die(mysql_error());$con) or die(mysql_error()); ?>?>
- 6. SQL CREATEDATABASE database_name PHP $con = mysql_connect("localhost","peter", "abc123"); $sql = “CREATE DATABASE myDB”; mysql_query(“$sql”, $con));
- 7. SQL CREATETABLE table_name (column_name1 data_type, column_name2 data_type, column_name3 data_type, .... );
- 8. PHP // Connectto Mysql $con = mysql_connect(. . .); // Create database mysql_query("CREATE DATABASE my_db",$con); // Select DB mysql_select_db("my_db", $con); // Create table $sql = "CREATE TABLE Persons( FirstName varchar(15), LastName varchar(15), Age int )”; // Execute SQL statement mysql_query($sql, $con); "; Contd:Contd:
- 9. When DBalready exists:When DB already exists: PHPPHP $con = mysql_connect("localhost","peter",$con = mysql_connect("localhost","peter", "abc123");"abc123"); $db = mysql_select_db("my_db“,$db = mysql_select_db("my_db“, $con);$con);
- 10. SQL SELECT colName1,colName2, colName3SELECT colName1, colName2, colName3 FROM Persons;FROM Persons; PHP $con = mysql_connect(. . .);$con = mysql_connect(. . .); mysql_select_db("my_db“, $con);mysql_select_db("my_db“, $con); $sql = “SELECT FirstName, LastName$sql = “SELECT FirstName, LastName FROM Persons;”;FROM Persons;”; $result = mysql_query($sql);$result = mysql_query($sql);
- 11. PHP $result =mysql_query($sql);$result = mysql_query($sql); while($row =while($row = mysql_fetch_array($result)){mysql_fetch_array($result)){ echo $row['FirstName'] . " " .echo $row['FirstName'] . " " . $row['LastName'];$row['LastName']; echo "<br />";echo "<br />"; }}
- 12. SQL INSERT INTOtable_nameINSERT INTO table_name VALUES (value1, value2, value3,...)VALUES (value1, value2, value3,...) oror INSERT INTO table_nameINSERT INTO table_name (column1, column2,(column1, column2, column3,...)column3,...) VALUES (value1, value2, value3,...)VALUES (value1, value2, value3,...)
- 13. <?php $con = mysql_connect(“…",“…",“…"); if(!$con) die('Could not connect: ' . mysql_error()); mysql_select_db("my_db", $con); mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Peter','Griffin','35')"); mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Glenn', ‘Brown', '33')"); mysql_close($con); ?> Contd:Contd:
- 14. <html><html> <body><body> <form action="insert.php" method="post"><formaction="insert.php" method="post"> Firstname: <input type="text" name=“nameF" />Firstname: <input type="text" name=“nameF" /> Lastname: <input type="text" name=“nameL" />Lastname: <input type="text" name=“nameL" /> Age: <input type="text" name="age" />Age: <input type="text" name="age" /> <input type="submit" /><input type="submit" /> </form></form> </body></body> </html></html>
- 15. <?php $con = mysql_connect(“…",“…",“…"); if(!$con) die('Could not connect: ' . mysql_error()); mysql_select_db("my_db", $con); $sql="INSERT INTO Persons (FirstName, LastName, Age) VALUES ('$_POST[firstname]', '$_POST[lastname]', '$_POST[age]')"; if (!mysql_query($sql,$con)) die('Error: ' . mysql_error()); echo "1 record added"; mysql_close($con) ?> Contd:Contd:
- 16. SQL UPDATE table_nameUPDATEtable_name SET column1=value, column2=value2,...SET column1=value, column2=value2,... WHERE some_column = some_value;WHERE some_column = some_value;
- 17. <?php $con = mysql_connect(“…",“…",“…"); if(!$con) die('Could not connect: ' . mysql_error()); mysql_select_db("my_db", $con); $sql = “UPDATE Persons SET Age = ’36’ WHERE FirstName = ‘Peter’ AND LastName = “Griffin’”; mysql_query($sql, $con); mysql_close($con); ?> Contd:Contd:
- 18. SQL Delete table_nameDeletetable_name WHERE some_column = some_value;WHERE some_column = some_value;
- 19. <?php $con = mysql_connect(“…",“…",“…"); if(!$con) die('Could not connect: ' . mysql_error()); mysql_select_db("my_db", $con); $sql = “DELETE FROM Persons WHERE FirstName = ‘Peter’ AND LastName = “Griffin’”); mysql_query($sql, $con); mysql_close($con); ?> Contd:Contd: