این اسم جداولش
mysql_query("CREATE TABLE haghighi(
`name` varchar(32) NOT NULL default '',
`family` varchar(32) NOT NULL default '',
`code` varchar(32) NOT NULL default '',
`tell` varchar(32) NOT NULL default '',
`mob` varchar(32) NOT NULL default '',
`email` varchar(32) NOT NULL default '',
`addres` varchar(32) NOT NULL default '',
`codeposti` varchar(32) NOT NULL default '',
`fathername` varchar(32) NOT NULL default '',
`codemeli` varchar(32) NOT NULL default '',
`databrit` varchar(32) NOT NULL default '',
`placebrit` varchar(32) NOT NULL default '',
`salso` varchar(32) NOT NULL default '',
`mahal` varchar(32) NOT NULL default '',
PRIMARY KEY (`codemeli`))");
این کد اکشن:
<?php
include('../../config.php');
mysql_connect($hostname, $user, $password) or die('Connection error');
mysql_select_db($dbname) or die('Database error');
mysql_query('SET NAMES \'utf8\'');
$name = isset($_POST['name']) ? mysql_real_escape_string($_POST['name']) : '';
$family = isset($_POST['family']) ? mysql_real_escape_string($_POST['family']) : '';
$code = isset($_POST['code']) ? mysql_real_escape_string($_POST['code']) : '';
$fathername = isset($_POST['fathername']) ? mysql_real_escape_string($_POST['fathername']) : '';
$codemeli = isset($_POST['codemeli']) ? mysql_real_escape_string($_POST['codemeli']) : '';
$datebirt = isset($_POST['datebirt']) ? mysql_real_escape_string($_POST['datebirt']) : '';
$placebirt = isset($_POST['placebirt']) ? mysql_real_escape_string($_POST['placebirt']) : '';
$salso = isset($_POST['salso']) ? mysql_real_escape_string($_POST['salso']) : '';
$mahal = isset($_POST['mahal']) ? mysql_real_escape_string($_POST['mahal']) : '';
$tell = isset($_POST['tell']) ? mysql_real_escape_string($_POST['tell']) : '';
$mob = isset($_POST['mob']) ? mysql_real_escape_string($_POST['mob']) : '';
$email = isset($_POST['email']) ? mysql_real_escape_string($_POST['email']) : '';
$adres = isset($_POST['adres']) ? mysql_real_escape_string($_POST['adres']) : '';
$codeposti = isset($_POST['codeposti']) ? mysql_real_escape_string($_POST['codeposti']) : '';
mysql_query("INSERT INTO `haghighi`
(`name`,`family`,`code`,`fathername`,`datebirt`,`c odemeli`,`placebirt`,`salso`,`mahal`,`tell`,`mob`, `email`,`addres`,`codeposti`)
VALUES ('$name','$family','$code','$fathername','$datebir t','$codemeli','$placebirt','$salso','$mahal','$te ll','$mob','$email','$adres','$codeposti')
");
if(mysql_affected_rows() > 0) {
header('location: haghi.php');
exit();
}
else {
echo '<p>Not sent...</p>'.mysql_error();
}
?>
و اینم فرم:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>مدیریت مشتری حقیقی</title>
</head>
<style>
#header{
background-image:url(../images/haghighi.png);
width:500px;
height:119px;
margin:auto;
}
</style>
<body>
<div id="header"></div>
<form action="ac-haghi.php" method="post">
<fieldset>
<table cellPadding="10" width="28%" border="0" align="center" >
<tr>
<td vAlign="top" width="5%" align="right">
<input name="name" type="text" />
<td>نام</td>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="family" type="text" />
<td>نام خانوادگی</td>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="code" type="text" />
<td>شماره شناسنامه</td>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="fathername" type="text" />
<td>نام پدر</td>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="codemeli" type="text" />
<td>کد ملی</td>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="databirt" type="text" />
<td>تاریخ تولد</td>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="birt" type="text" />
<td>محل تولد</td>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="salso" type="text" />
<td>سال صدور</td>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="mahal" type="text" />
<td>محل صدور</td>
</tr>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="tell" type="text" />
<td>تلفن ثابت</td>
</tr>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="mob" type="text" />
<td>تلفن همراه</td>
</tr>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="email" type="text" />
<td>ایمیل</td>
</tr>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="adres" type="text" />
<td>نشانی</td>
</tr>
</tr>
<tr>
<td vAlign="top" width="5%" align="right">
<input name="codeposti" type="text" />
<td>کد پستی</td>
</tr>
</table>
<input name="action" type="submit" value="افزودن" />
</fieldset>
</form>
</div>