MySQL Main Query Types used in PHP to select, insert, update and delete data
MySQL Main Query Types
SELECT
SELECT * FROM tablename
INSERT
INSERT INTO tablename (col1, col2, col3,..) VALUES (val1, val2, val3,…)
UPDATE
UPDATE tablename SET `col1`=`val1`, `col2`=`val2`, `col3`=`val3`,…
DELETE
DELETE FROM tablename WHERE `col4`=`val6`
Note
You will use a lot of WHERE clauses as well along with the above.
e.g. SELECT * FROM tablename WHERE `id`=’15′
In PHP
Calling to MySQL is really easy in PHP, just use the mysql_query() function.
e.g.
mysql_query("SELECT * FROM tablename")
$query = mysql_query("SELECT * FROM tablename");
while ($result = mysql_fetch_object($query)) {
echo $result->aColumnNameInMysql;
}
$query = mysql_query("SELECT * FROM tablename");
while ($result = mysql_fetch_object($query)) {
echo $result->aColumnNameInMysql;
}
Share This Article
Trackbacks
There are no trackbacks on this entry.
Comments
There are no comments on this entry.