How To Run a SQL Statement

Q

How To Run a SQL Statement? - PHP Script Tips - Working with MySQL Database

✍: FYIcenter.com

A

You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status:

Returning FALSE, if the execution failed.
Returning a result set object, if the execution is successful on a SELECT statement or other statement returning multiple rows of data.
Returning TRUE, if the execution is successful on other statements.

Here is a good example of running a SQL statement with the mysql_query() function:

<?php
  include "mysql_connection.php";

  $sql = 'SELECT sysdate() FROM dual';
  $rs = mysql_query($sql, $con);
  $row = mysql_fetch_array($rs);
  print("Database current time: ". $row[0] ."\n");

  mysql_close($con); 
?>

If you run this script, you will get something like this:

Database current time: 2006-02-26 21:34:57

2007-04-18, 4988👍, 0💬

How To Connect to MySQL from a PHP Script
How To Connect to MySQL from a PHP Script? - PHP Script Tips - Working with MySQL Database If you want access the MySQL server, you must create a connection object first by calling the mysql_connect() function in the following format: $con = mysql_connect($server, $username, $password); If you are c... 2007-04-18, 5141👍, 0💬

How To Install MySQL
How To Install MySQL? - PHP Script Tips - Working with MySQL Database MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local computer. Here is how you can do this: Go to http://dev.mysql.com/downloads /mysql... 2007-04-18, 5108👍, 0💬

What Do You Need to Connect PHP to MySQL
What Do You Need to Connect PHP to MySQL? - PHP Script Tips - Working with MySQL Database If you want to access MySQL database server in your PHP script, you need to make sure that MySQL module is installed and turned on in your PHP engine. Check the PHP configuration file, php.ini, to make sure the... 2007-04-18, 5096👍, 0💬

How To Select an Exiting Database
How To Select an Exiting Database? - PHP Script Tips - Working with MySQL Database The first thing after you have created a connection object to the MySQL server is to select the database where your tables are locate, by using the mysql_select_db() function. If your MySQL server is offered by your W... 2007-04-18, 5063👍, 0💬

How To Get the Number of Rows Selected or Affected by a SQL Statement
How To Get the Number of Rows Selected or Affected by a SQL Statement? - PHP Script Tips - Working with MySQL Database There are two functions you can use the get the number of rows selected or affected by a SQL statement: mysql_num_rows($rs) - Returns the number of rows selected in a result set obj... 2007-04-19, 5053👍, 0💬

How To Create a Table
How To Create a Table? - PHP Script Tips - Working with MySQL Database If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script: <?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER NOT NULL" . ", url VARCH... 2007-04-19, 5039👍, 0💬

What Is a Result Set Object
What Is a Result Set Object? - PHP Script Tips - Working with MySQL Database A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in the result set. Once ... 2007-04-19, 5019👍, 0💬

How To Run a SQL Statement
How To Run a SQL Statement? - PHP Script Tips - Working with MySQL Database You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status: Returning FALSE... 2007-04-18, 4989👍, 0💬

How To Insert Rows Based on SELECT Statements
How To Insert Rows Based on SELECT Statements? - PHP Script Tips - Working with MySQL Database If want to insert rows into a table based on data rows from other tables, you can use a sub-query inside the INSERT statement as shown in the following script example: <?php include "mysql_connectio... 2007-04-19, 4976👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.