How to use mysql query in PHP

In this article I am going to explain about mysql_query function in PHP.
  • 1515

PHP mysql_query() Function

The PHP mysql_query function is used to execute any query statement in MySQL database.

Syntax of mysql_query function

mysql_query(query,connection)

Parameters in mysql_query function

It have two parameter:

Parameter Description
query It specifies sql query.
connection It is optional parameter and it specifies a MySQL connetion.

Example of mysql_query function

<?php

$con=mysql_connect("localhost","gupta","sharad");

if(!$con)

{

die("Could not connect:".mysql_error());

}

if(mysql_query("CREATE DATABASE testlog",$con))

{

echo "Database is craeted";

}

else

{

echo "Error creating database";

}

mysql_close($con);

?>


Output:

mysql-query-PHP.jpg

You may also want to read these related articles :
here

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.