How to Execute a Mysql Query in PHP

<div dir="ltr" style="text-align: left;" trbidi="on"> <div class="separator" style="clear: both; text-align: center;"> <a href="http://1.bp.blogspot.com/-4sRKW7_Un_o/VfRN9wLjvKI/AAAAAAAAG_I/WZ1KeMPYB8Y/s1600/learn%2Bphp%2Bintro%2B-min.png" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="Execute Mysql Query Using PHP" border="0" src="http://1.bp.blogspot.com/-4sRKW7_Un_o/VfRN9wLjvKI/AAAAAAAAG_I/WZ1KeMPYB8Y/s1600/learn%2Bphp%2Bintro%2B-min.png" title="Execute Mysql Query Using PHP" /></a></div> <h2 style="text-align: left;"> Introduction :</h2> <div> In the previous lesson, you learned about different connection methods in PHP 5 to connect Mysql Database with PHP. Today on this article you are going to learn about an important function in PHP. This feature will allow you to execute Mysql Query using PHP. It is very important to know about PHP Mysql Query executing function because every program needs a Back-End and the program must be able to execute the Back-End using its code.</div> <h4 style="text-align: left;"> How to Execute Mysql Query in PHP?</h4> <div> It is very easy to Execute Mysql Query in PHP, To do this you must have minimum knowledge about creating the connection between Mysql Database and PHP first. If you don't know How to connect Database and PHP program, then <a href="http://www.howi.in/2015/09/database-connections-methods-in-php-5.html" target="_blank">click here</a>.</div> <div> <ul style="text-align: left;"> <li><span style="font-family: "georgia" , "times new roman" , serif;">First of all, you need to make a connection between your PHP program and Mysql Database, For that use the code which given below.</span></li> </ul> <pre class="brush: js;">$con = @mysql_connect("localhost","root","password");</pre> <ul style="text-align: left;"> <li><span style="font-family: "georgia" , "times new roman" , serif;">Don't forget to replace the "<b>root</b>" With your Mysql Database Username and "<b>Password</b>" With your Database password.</span></li> <li><span style="font-family: "georgia" , "times new roman" , serif;">Now you need to select Database, For that you need to use the below PHP code.</span></li> </ul> <pre class="brush: js;">$database = mysql_select_db("police");</pre> <ul style="text-align: left;"> <li><span style="font-family: "georgia" , "times new roman" , serif;">Now you need to make a variable which contain the Mysql Query, Use the following code that given below. It is just an example Mysql Query to create a table. </span></li> </ul> <pre class="brush: js;">$query = "CREATE TABLE LOGIN (name varchar(50), class int(10))";</pre> <ul> <li><span style="font-family: "georgia" , "times new roman" , serif;">The variable "<b>$query</b>" Contain the Mysql Query to create a table named "<b>Login</b>" and some values in it. </span></li> <li><span style="font-family: "georgia" , "times new roman" , serif;">Now it times to execute the Mysql Query using PHP. </span></li> </ul> <pre class="brush: js;">$result = mysql_query($query, $con);</pre> <ul style="text-align: left;"> <li><span style="font-family: "georgia" , "times new roman" , serif;">The above code will execute the Mysql Query which contained in the "<b>$query</b>" Using the "<b>$con</b>" Database connection and store to "<b>$result</b>" .</span></li> <li><span style="font-family: "georgia" , "times new roman" , serif;">Now you need to take a look at the full example code and understand each and every step that I described above. </span></li> </ul> <pre class="brush: js;"><?php $con = @mysql_connect("localhost","root",""); $database = mysql_select_db("police"); $query = "CREATE TABLE LOGIN (name varchar(50), class int(10))"; $result = mysql_query($query, $con); if(!$result) { echo "Table Not Created " .mysql_error(); } else { echo "Table created"; } ?></pre> <ul style="text-align: left;"> <li><span style="font-family: "georgia" , "times new roman" , serif;">If Mysql Query successfully executed,  then you can see "<b>Table Created</b>" Message else you can see the "<b>Table Not Created</b>" Message and what the reason for not executing the query.</span></li> </ul> <h4 style="text-align: left;"> Suggested Article for PHP Developers:</h4> <div> <ul style="text-align: left;"> <li>Chapter 4: Insert Values to Database Table Using PHP.</li> <li>Chapter 5: Fetch Data from Database Using PHP.</li> <li>Chapter 6: Update Data of Database Table Using PHP.</li> </ul> <div> I hope you well enjoyed this article. If you have any doubts or suggestions related to this article. Please let us know by using the comment box given below. Thanks</div> </div> </div> </div>

How to Execute a Mysql Query in PHP

Introduction : In the previous lesson, you learned about different connection methods in PHP 5 to connect Mysql Database with PHP. Tod...

+ Read more »