<< < 1 2 3   Sort: Date

How To Create a New Database
How To Create a New Database? - MySQL FAQs - PHP Connections and Query Execution 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 a the administrator of the server, you can create a new databases using the CREATE DATABASE ...
2007-05-10, 4642👍, 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, 4640👍, 0💬

How To Create a New Table
How To Create a New Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER ...
2007-05-10, 4639👍, 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: &lt;?php include "mysql_connectio...
2007-04-19, 4632👍, 0💬

What Do You Need to Connect PHP to MySQL
What Do You Need to Connect PHP to MySQL? - MySQL FAQs - PHP Connections and Query Execution If you want to access MySQL database server in your PHP script, you need to make sure that a MySQL API module (extension) is installed and turned on in your PHP engine. PHP 5 now supports two MySQL API exten...
2007-05-10, 4600👍, 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, 4596👍, 0💬

How To Quote Date and Time Values in SQL Statements
How To Quote Date and Time Values in SQL Statements? - PHP Script Tips - Working with MySQL Database If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes ('). The tutorial exercise below shows you ...
2007-04-19, 4519👍, 0💬

How To Insert Data into a Table
How To Insert Data into a Table? - PHP Script Tips - Working with MySQL Database If you want to insert a row of data into a table, you can use the INSERT INTO statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_links (id, url) VALUE...
2007-04-19, 4502👍, 0💬

How To Install PHP on Windows
How To Install PHP on Windows? - MySQL FAQs - PHP Connections and Query Execution The best way to download and install PHP on Windows systems is to: Go to http://www.php.net, which is the official Web site for PHP. Download PHP binary version for Windows in ZIP format. Unzip the downloaded file into...
2007-05-10, 4492👍, 0💬

<< < 1 2 3   Sort: Date