PHP MySQL Revision

db.md

connect to the database, CRUD

$con = mysql_connect("localhost","root","");

// select database 
mysql_select_db("database-name");

// perform query 
// insert query
$query = "insert into table-name values(value1, value2,...);

// update query
$query = "update table-name set column-name=value1 where column-name1=value1;

// delete query
$query = "delete from table-name where column-name=value;

// select query
$query = "select * from table-name;

// execute query
$result = mysql_query($query);

echo "<table border=1">;
echo "<tr> <th>column-names</th> </tr>"
while($row = mysql_fetch_array($result)) {
    echo "<tr>";
    echo "<td>$row[column-name]</td>"
    echo "</tr>";
}

echo "</table">;

php-mysql.md

some notes on how to connect to mysql and perform crud(create,retrieve,update,delete) operations