woeful
جمعه 09 مهر 1389, 22:18 عصر
سلام
من یه فرم ساده به Html نوشتم :
<html>
<head><title>Form</title></head>
<body>
<form method=POST action="savedb.php">
<table border=1 bgcolor="yellow">
<tr>
<td>English word :</td>
<td><input type="text" name="engword" size="13"></td>
</tr>
<tr>
<td>Persian description :</td>
<td><input type="text" name="farword" size="23"></td>
</tr>
<tr>
<td width="200"></td>
<td><input type="submit" value="Submit" name="submit"></td>
</tr>
</table>
</form>
</body>
</html>
همون طور که میبینید action =savedb.php هست
و اینم کد savedb.php :
<?php
$Eword=$_POST['engword'];
$Pword=$_POST['farword'];
if (strlen($Eword)==0 || strlen($Pword)==0)
{
echo "Go Back and Fill All Field.";
exit;
}
$db = mysql_connect("localhost","root","123456");
if(!$db)
{
echo "Can not open database.";
exit;
}
mysql_select_db("words");
$query="insert into word (engword,farword) values ('".$Eword."','".$Pword."')";
$result = $mysql_query($guery);
if ($result)
echo "mysql_affected_rows() <b> word inserted in database.</b>";
mysql_close($db);
?>اینم اطلاعاتی که با MySQL Command Line Client گرفتم
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
| words |
+--------------------+
4 rows in set (0.02 sec)
mysql> use words;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_words |
+-----------------+
| word |
+-----------------+
1 row in set (0.06 sec)ولی موقع اجرای کد form و زدن submit ارور زیر رو میگیرم :
از روی متن ارور میشه فهمید مشکل چیه ولی چرا و برای رفعش چه کاری میشه کرد
Warning: mysql_connect(): [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in C:\inetpub\wwwroot\chapter10\savedb.php on line 10 Warning: mysql_connect(): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\inetpub\wwwroot\chapter10\savedb.php on line 10 Can not open database.با تشکر
Woeful
من یه فرم ساده به Html نوشتم :
<html>
<head><title>Form</title></head>
<body>
<form method=POST action="savedb.php">
<table border=1 bgcolor="yellow">
<tr>
<td>English word :</td>
<td><input type="text" name="engword" size="13"></td>
</tr>
<tr>
<td>Persian description :</td>
<td><input type="text" name="farword" size="23"></td>
</tr>
<tr>
<td width="200"></td>
<td><input type="submit" value="Submit" name="submit"></td>
</tr>
</table>
</form>
</body>
</html>
همون طور که میبینید action =savedb.php هست
و اینم کد savedb.php :
<?php
$Eword=$_POST['engword'];
$Pword=$_POST['farword'];
if (strlen($Eword)==0 || strlen($Pword)==0)
{
echo "Go Back and Fill All Field.";
exit;
}
$db = mysql_connect("localhost","root","123456");
if(!$db)
{
echo "Can not open database.";
exit;
}
mysql_select_db("words");
$query="insert into word (engword,farword) values ('".$Eword."','".$Pword."')";
$result = $mysql_query($guery);
if ($result)
echo "mysql_affected_rows() <b> word inserted in database.</b>";
mysql_close($db);
?>اینم اطلاعاتی که با MySQL Command Line Client گرفتم
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
| words |
+--------------------+
4 rows in set (0.02 sec)
mysql> use words;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_words |
+-----------------+
| word |
+-----------------+
1 row in set (0.06 sec)ولی موقع اجرای کد form و زدن submit ارور زیر رو میگیرم :
از روی متن ارور میشه فهمید مشکل چیه ولی چرا و برای رفعش چه کاری میشه کرد
Warning: mysql_connect(): [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in C:\inetpub\wwwroot\chapter10\savedb.php on line 10 Warning: mysql_connect(): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\inetpub\wwwroot\chapter10\savedb.php on line 10 Can not open database.با تشکر
Woeful