Próbuję zrobić formularz z zapisem do bazy.
Oto moje kody, które sobie z tym nie radza ;/
INDEX.PHP
[php]<html>
<head>
<title>Search my badass website !!</title>
<style type="text/css">
.text
{
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:10;
font-weight:normal;
color:#000000;
}
.inputField
{
font-family:Verdana, Arial, Helvetica, sans-serif;
color:#000000;
font-size:10px;
font-wieght:normal;
border-color:#666666;
border-width:1px;
border-style:solid;
width:150px;
height:17px;
}
.button
{
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:10;
color:#000000;
height:17px;
width:50px;
border-color:#666666;
border-width:1px;
background-color:#CCCCCC;
}
</style>
</head>
<body>
<form name="insert_form" action="
<?php echo $_SERVER['send.php'] ?>">
<table>
<tr>
<td class="text"><u>Insert Company Information Form</u></td>
</tr>
</table>
<table>
<tr>
<td class="text" valign="middle" align="right">Name : </td>
<td valign="middle"><input type="text" class="inputField" name="insertName"></td>
</tr>
<br />
<tr>
<td class="text" valign="middle" align="right">Location : </td>
<td valign="middle"><input type="text" class="inputField" name="insertLocation"></td>
</tr>
<tr>
<td class="text" valign="middle" align="right">Phone : </td>
<td valign="middle"><input type="text" class="inputField" name="insertPhone"></td>
</tr>
<tr>
<td class="text" valign="middle" align="right">Catagory : </td>
<td valign="middle"><input type="text" class="inputField" name="insertCatagory"></td>
</tr>
<tr>
<td class="text" valign="middle" align="right">Business Name : </td>
<td valign="middle"><input type="text" class="inputField" name="insertBusiness_name"></td>
</tr>
<tr>
<td> </td>
<td align="right"><input type="reset" value="Clear" class="button"> <input type="submit" value="Insert" class="button"></td>
</tr>
</table>
</form>
</body>
</html>
SEND.PHP##----[ TABLE SQL ]----##
CREATE TABLE `company_info`
(
id int() NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
location varchar(255) NOT NULL default '',
phone int(11) NOT NULL default '',
catagorie varchar(255) NOT NULL default '',
business_name varchar(255) NOT NULL default '',
PRIMARY KEY (id)
)
##----[ ADD DATA FORM ]----##
<?PHP
/*Polaczenie z baza*/
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'haslo';
$dbname = 'name';
/*Polaczenie z serwerem*/
/*Wybor bazy*/
/*Deklaracja zmiennych*/
$insertFormName = $_POST['insertName'];
$inserFormLocation = $_POST['insertLocation'];
$inserFormPhone = $_POST['insertPhone'];
$inserFormCatagory = $_POST['insertCatagory'];
$inserFormBusiness_name = $_POST['insertBusiness_name'];
$insertName = trim($inserFormName); $insertLocation = trim($inserFormLocation); $insertPhone = trim($inserFormPhone); $insertCatagory = trim($inserFormCatagory); $insertBusiness_name = trim($inserFormBusiness_name);
/*wprowadzenie danych do sql*/
if(isset('[insert_form]')) { $insert = mysql_query("INSERT INTO company_info (id, name, location, phone, catagorie, business_name) VALUES ('', '$inserName', '$insertLocation', '$insertPhone', '$insertCatagorie', '$insertBusiness_name')") } else {
echo "All fields are required to be completed !! <br />"; }
?>
Jeśli ma ktoś pomysł jak to naprawić to będę wdzięczny.
Pozdrawiam
Ten post edytował elementh 27.10.2010, 08:51:45
[php][mysql] Problem z zapisem, No nie działa no :)
elementh [php][mysql] Problem z zapisem 27.10.2010, 08:48:29 
