PHP/MySQL Database/mysql db query
Insert data to mysql table
<source lang="html4strict">
<?php
$linkID = @mysql_connect("localhost","root","") or die("Could not connect to MySQL server"); $query = "INSERT INTO mytable set id="1", title="pants", myvalue="4""; $result = mysql_db_query("mydatabase", $query); mysql_close();
?>
</source>
mysql_db_query.php
<source lang="html4strict">
<?php
$linkID = @mysql_connect("localhost","root","") or die("Could not connect to MySQL server"); $query = "INSERT INTO mytable set id="0", title="pants", myvalue="4""; $result = mysql_db_query("mydatabase", $query); mysql_close();
?>
</source>