$host = 'xxx.xxx.xxx.xxx';
$user = 'alan';
$passwd = 'password';
$db = 'test';
$conn = mysql_connect($host,$user,$passwd);
if (!$conn) {
die('Could not connect: ' . mysql_error());
}
echo "select data from MySQL
";
mysql_select_db($db, $conn);
$select_sql = "select * from login";
$result = mysql_query($select_sql);
echo "
uid | time | text |
---|
while ($row = mysql_fetch_array($result)) {
echo "
";echo "
".$row['uid']."";echo "
".$row['dt']."";echo "
".$row['text']."";echo "
";}
echo "
";
echo "
Name:
text:
";mysql_close($conn);
?>
insert.php
$host = 'xxx.xxx.xxx.xxx';
$conn = mysql_connect($host,$user,$passwd);
die('Could not connect: ' . mysql_error());
mysql_select_db($db, $conn);
$insert_sql = "insert into login(uid,dt,text) values('$_POST[uid]', $dt, '$_POST[text]')";
echo "SQL: ".$insert_sql."
";
if (!mysql_query($insert_sql, $conn)) {
die('Error: ' . mysql_error());
echo "1 record added.
";
1. 访问页面
2. 提交表单,执行一条sql插入语句
3. 返回页面刷新查看结果
相关配置与环境
Apache主配置文件:/etc/httpd/conf/httpd.conf
Apache主配置目录,可以将不同类型的配置分门别类放入这个目录中:/etc/httpd/conf.d/
Apache网站根目录:/var/www/html/
Apache日志文件目录:/var/log/httpd
MySQL的my.cnf配置文件:/etc/my.cnf
MySQL数据库文件位置:/usr/lib/mysql