PHP不将数据保存到MySQL [英] php does not save data to mysql
本文介绍了PHP不将数据保存到MySQL的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
下面是我的PHP代码.表mylibrary
包含isbn和标题记录. PHP脚本无法连接到mysql.为什么?
Attached below is my PHP code. Table mylibrary
contains isbn and title record. The PHP script cannot connect to mysql. Why ?
<?php
$conn_error = 'Could not connect.';
$mysql_host = 'localhost';
$mysql_user = 'root';
$mysql_pass = '';
$mysql_db='b_database';
if(!@mysql_connect($mysql_host, $mysql_user,$mysql_pass)|| !@mysql_select_db($mysql_db)){
die($conn_error);
}
?>
<html>
<head>
<meta name="description" content="Php Code for View, Search, Edit and Delete Record" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Add Student Record</title>
</head>
<body>
<center>
<h1><u>Library Database</u></h1>
</center>
<?
if($_POST["do"]=="store")
{
$isbn=$_POST["isbn"];
$title=$_POST["title"];
if($query_run = mysql_query($query)){
$query="insert into mylibrary value
('$isbn','$title')";
mysql_query($query);
echo "Successfully store in DATABASE";
}
?>
<form name="add" method="post" action="add.php">
<table style=" border:1px solid silver" cellpadding="5px" cellspacing="0px"
align="center" border="0">
<tr>
<td colspan="4" style="background:#0066FF; color:#FFFFFF; fontsize:
20px">ADD RECORD</td>
</tr>
<tr>
<tr>
<td>Enter ISBN</td>
<td><input type="text" name="isbn" size="20"></td>
</tr>
<tr>
<td>Enter TITLE</td>
<td><input type="text" name="title" size="20"></td>
</tr>
<tr>
<td colspan="4" align="center"><input type="hidden" name="do" value="store">
<input type="submit" value="ADD RECORD"></td>
</tr>
</table>
</form>
<p align="center"><a href="index.php">Go Back to Home</a></p>
<?
include("search.php");?>
</body>
</html>
推荐答案
这是数据库连接必填字段:
This is a database connection required fields:
<?php
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "database";
$username_localhost = "root";
$password_localhost = "yourpass";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>
这篇关于PHP不将数据保存到MySQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文