PHP - Running a SQL Statement in PHP

Running a SQL Statement in PHP

Q

How To Run a SQL Statement in PHP?

✍: 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

⇒Working with MySQL Database in PHP

⇒⇒PHP Tutorials

2016-10-20, 688👍, 0💬

Creating a Table in PHP
How To Create a Table in PHP? 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 VARCHAR(80) NOT NULL" . ", notes VARCHAR(1024)... 2016-10-20, 762👍, 0💬

Creating a Database in PHP
How To Create a Database in PHP? A database in a MySQL server is a logical container used to group tables and other data objects together as a unit. If you are the administrator of the server, you can create and delete databases using the CREATE/DROP DATABASE statements. The following PHP script sho... 2016-10-20, 755👍, 0💬

Number of Rows Affected by a SQL Statement in PHP
How To Get the Number of Rows Selected or Affected by a SQL Statement in PHP? 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 object returned from SELECT statement. mysql... 2016-10-20, 739👍, 0💬

Running a SQL Statement in PHP
How To Run a SQL Statement in PHP? 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 re... 2016-10-20, 689👍, 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.