inserting data to database problem

pixeltrace · February 20, 2007

guys,

i need help,

i have 2 page

add.php and addclient.php

my problem is, i cant make insert new data to the database

and when i click on the save button

its opening a new window of the same page

need help please

this is the link

http://www.jobhirings.com/admean/clientmngr.php?id=1

and this is the code for my add.php

<form target="addclient.php" method="post" id="add" name="add" enctype="multipart/form-data" >

<tr>

</tr>

<tr>

<tr>

</tr>

<tr>

<td colspan="3" bgcolor="#999999" class="text2">CLIENT INFORMATION </td>

</tr>

<tr>

</tr>

<tr>

<td width="137" align="right" valign="top" class="text6">Date Joined : </td>

</select>

</select>

</select></td>

</tr>

<tr>

<td align="right" valign="top" class="text6">Company Name: </td>

</span></td>

</tr>

<tr>

<td align="right" valign="top" class="text6">Address : </td>

</tr>

<tr>

<td align="right" valign="top" class="text6">Telephone No : </td>

</span></td>

</tr>

<tr>

</span></td>

</tr>

<tr>

<td align="right" valign="top" class="text6">Website : </td>

</span></td>

</tr>

<tr>

<td align="right"><span class="text6">Country : </span></td>

<option value="AF">Afghanistan</option>

<option value="AL">Albania</option>

<option value="DZ">Algeria</option>

<option value="AS">American Samoa</option>

<option value="AD">Andorra</option>

<option value="AO">Angola</option>

<option value="AI">Anguilla</option>

<option value="AQ">Antarctica</option>

<option value="AG">Antigua and Barbuda</option>

<option value="AR">Argentina</option>

<option value="AM">Armenia</option>

<option value="AW">Aruba</option>

<option value="AU">Australia</option>

<option value="AT">Austria</option>

<option value="AZ">Azerbaijan</option>

<option value="BS">Bahamas</option>

<option value="BH">Bahrain</option>

<option value="BD">Bangladesh</option>

<option value="BB">Barbados</option>

<option value="BY">Belarus</option>

<option value="BE">Belgium</option>

<option value="BZ">Belize</option>

<option value="BJ">Benin</option>

<option value="BM">Bermuda</option>

<option value="BT">Bhutan</option>

<option value="BO">Bolivia</option>

<option value="BA">Bosnia Hercegovina</option>

<option value="BW">Botswana</option>

<option value="BV">Bouvet Island</option>

<option value="BR">Brazil</option>

<option value="IO">British Indian Ocean Territory</option>

<option value="BN">Brunei Darussalam</option>

<option value="BG">Bulgaria</option>

<option value="BF">Burkina Faso</option>

<option value="BI">Burundi</option>

<option value="KH">Cambodia</option>

<option value="CM">Cameroon</option>

<option value="CA">Canada</option>

<option value="CV">Cape Verde</option>

<option value="KY">Cayman Islands</option>

<option value="CF">Central African Republic</option>

<option value="CL">Chile</option>

<option value="CN">China</option>

<option value="CX">Christmas Island</option>

<option value="CC">Cocos (Keeling) Islands</option>

<option value="CO">Colombia</option>

<option value="KM">Comoros</option>

<option value="CG">Congo</option>

<option value="CK">Cook Islands</option>

<option value="CR">Costa Rica</option>

<option value="CI">Cote D'ivoire</option>

<option value="HR">Croatia</option>

<option value="CY">Cyprus</option>

<option value="CZ">Czech Republic</option>

<option value="DK">Denmark</option>

<option value="DJ">Djibouti</option>

<option value="DM">Dominica</option>

<option value="DO">Dominican Republic</option>

<option value="TP">East Timor</option>

<option value="EC">Ecuador</option>

<option value="EG">Egypt</option>

<option value="SV">EL Salvador</option>

<option value="GQ">Equatorial Guinea</option>

<option value="ER">Eritrea</option>

<option value="EE">Estonia</option>

<option value="ET">Ethiopia</option>

<option value="FK">Falkland Islands (Malvinas)</option>

<option value="FO">Faroe Islands</option>

<option value="FI">Finland</option>

<option value="FR">France</option>

<option value="GF">French Guiana</option>

<option value="PF">French Polynesia</option>

<option value="TF">French Southern Territories</option>

<option value="GA">Gabon</option>

<option value="GM">Gambia</option>

<option value="GE">Georgia</option>

<option value="DE">Germany</option>

<option value="GH">Ghana</option>

<option value="GI">Gibraltar</option>

<option value="GR">Greece</option>

<option value="GL">Greenland</option>

<option value="GD">Grenada</option>

<option value="GP">Guadeloupe</option>

<option value="GT">Guatemala</option>

<option value="GN">Guinea</option>

<option value="GW">Guinea-Bissau</option>

<option value="GY">Guyana</option>

<option value="HT">Haiti</option>

<option value="HM">Heard and Mc Donald Islands</option>

<option value="HN">Honduras</option>

<option value="HU">Hungary</option>

<option value="IS">Iceland</option>

<option value="IN">India</option>

<option value="ID">Indonesia</option>

<option value="IE">Ireland</option>

<option value="IL">Israel</option>

<option value="IT">Italy</option>

<option value="JM">Jamaica</option>

<option value="JP">Japan</option>

<option value="JO">Jordan</option>

<option value="KZ">Kazakhstan</option>

<option value="KE">Kenya</option>

<option value="KI">Kiribati</option>

<option value="KP">Korea (North)</option>

<option value="KR">Korea (South)</option>

<option value="KW">Kuwait</option>

<option value="KG">Kyrgyzstan</option>

<option value="LV">Latvia</option>

<option value="LB">Lebanon</option>

<option value="LS">Lesotho</option>

<option value="LR">Liberia</option>

<option value="LY">Libyan Arab Jamahiriya</option>

<option value="LI">Liechtenstein</option>

<option value="LT">Lithuania</option>

<option value="LU">Luxembourg</option>

<option value="MO">Macau</option>

<option value="MK">Macedonia</option>

<option value="MG">Madagascar</option>

<option value="MW">Malawi</option>

<option value="MY">Malaysia</option>

<option value="MV">Maldives</option>

<option value="MT">Malta</option>

<option value="MH">Marshall Islands</option>

<option value="MQ">Martinique</option>

<option value="MR">Mauritania</option>

<option value="MU">Mauritius</option>

<option value="YT">Mayotte</option>

<option value="MX">Mexico</option>

<option value="FM">Micronesia</option>

<option value="MC">Monaco</option>

<option value="MN">Mongolia</option>

<option value="MS">Montserrat</option>

<option value="MA">Morocco</option>

<option value="MZ">Mozambique</option>

<option value="MM">Myanmar</option>

<option value="NA">Nambia</option>

<option value="NR">Nauru</option>

<option value="NP">Nepal</option>

<option value="NL">Netherlands</option>

<option value="AN">Netherlands Antilles</option>

<option value="NC">New Caledonia</option>

<option value="NZ">New Zealand</option>

<option value="NI">Nicaragua</option>

<option value="NE">Niger</option>

<option value="NG">Nigeria</option>

<option value="NF">Norfolk Island</option>

<option value="MP">Northern Mariana Islands</option>

<option value="NO">Norway</option>

<option value="OT">Others</option>

<option value="PK">Pakistan</option>

<option value="PW">Palau</option>

<option value="PS">Palestinian Territory, Occupied</option>

<option value="PA">Panama</option>

<option value="PG">Papua New Guinea</option>

<option value="PY">Paraguay</option>

<option value="PH">Philippines</option>

<option value="PN">Pitcairn</option>

<option value="PL">Poland</option>

<option value="PT">Portugal</option>

<option value="PR">Puerto Rico</option>

<option value="QA">Qatar</option>

<option value="MD">Republic Of Moldova</option>

<option value="RE">Reunion</option>

<option value="RO">Romania</option>

<option value="RU">Russia</option>

<option value="RW">Rwanda</option>

<option value="KN">Saint Kitts And Nevis</option>

<option value="LC">Saint Lucia</option>

<option value="VC">Saint Vincent and The Grenadines</option>

<option value="WS">Samoa</option>

<option value="SM">San Marino</option>

<option value="ST">Sao Tome and Principe</option>

<option value="SA">Saudi Arabia</option>

<option value="SN">Senegal</option>

<option value="SC">Seychelles</option>

<option value="SL">Sierra Leone</option>

<option value="SG" selected>Singapore</option>

<option value="SK">Slovakia</option>

<option value="SI">Slovenia</option>

<option value="SB">Solomon Islands</option>

<option value="SO">Somalia</option>

<option value="ZA">South Africa</option>

<option value="GS">South Georgia And South Sandwich Islands</option>

<option value="ES">Spain</option>

<option value="LK">Sri Lanka</option>

<option value="SH">St. Helena</option>

<option value="PM">St. Pierre and Miquelon</option>

<option value="SD">Sudan</option>

<option value="SR">Suriname</option>

<option value="SJ">Svalbard and Jan Mayen Islands</option>

<option value="SZ">Swaziland</option>

<option value="SE">Sweden</option>

<option value="CH">Switzerland</option>

<option value="SY">Syrian Arab Republic</option>

<option value="TW">Taiwan</option>

<option value="TJ">Tajikistan</option>

<option value="TZ">Tanzania</option>

<option value="TH">Thailand</option>

<option value="TK">Tokelau</option>

<option value="TO">Tonga</option>

<option value="TT">Trinidad and Tobago</option>

<option value="TN">Tunisia</option>

<option value="TR">Turkey</option>

<option value="TM">Turkmenistan</option>

<option value="TC">Turks and Caicos Islands</option>

<option value="TV">Tuvalu</option>

<option value="UG">Uganda</option>

<option value="UA">Ukraine</option>

<option value="AE">United Arab Emirates</option>

<option value="GB">United Kingdom</option>

<option value="US">United States</option>

<option value="UM">United States Minor Outlying Islands</option>

<option value="UY">Uruguay</option>

<option value="UZ">Uzbekistan</option>

<option value="VU">Vanuatu</option>

<option value="VA">Vatican City State (Holy See)</option>

<option value="VE">Venezuela</option>

<option value="VN">Vietnam</option>

<option value="VG">Virgin Islands (British)</option>

<option value="VI">Virgin Islands (U.S.)</option>

<option value="WF">Wallis and Futuna Islands</option>

<option value="EH">Western Sahara</option>

<option value="YE">Yemen</option>

<option value="YU">Yugoslavia</option>

<option value="CD">Zaire</option>

<option value="ZM">Zambia</option>

<option value="ZW">Zimbabwe</option>

</select> </td>

</tr>

<tr>

</tr>

<tr>

<td colspan="3" bgcolor="#999999" class="text2">TERMS OF AGREEMENT </td>

</tr>

<tr>

</tr>

<tr>

<td align="right" valign="top" class="text6">Rate Agreed : </td>

</span></td>

</tr>

<tr>

<td align="right" class="text6">Warranty Period : </td>

</span></td>

</tr>

<tr>

<td align="right" valign="top" class="text6">Credit Term : </td>

</span></td>

</tr>

<tr>

<td align="right" class="text6">Date Signed : </td>

</select>

</select>

</select>

</span></td>

</tr>

<tr>

<td align="right" valign="top" class="text6">Remark :</td>

</tr>

<tr>

<td align="right" valign="top" class="text6">&nbsp

JBS103 · February 20, 2007

Well if you want to form to go to add.php so it can process the information, you need adjust the form tags and point it in the right direction with <form action="add.php">...

Otherwise I am a little confused as to what you need.

karthikeyan_coder · February 20, 2007

replace target="addclient.php" with action = "addclient.php" and show us the code of addclient.php

JasonLewis · February 20, 2007

well i cant see a submit button there. if you cant post all your code then try wrapping it in [ code ] [ /code ] tags, minus the spaces.

pixeltrace · February 20, 2007

this is the error that i am getting now after changing the "target" to "action"

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'client_warranty, client_term, day_signed, month_signed, year_sig

also this is the code for my addclient.php

<?

include '../db_connect.php';

$dayjoined = $_POST['dayjoined'];

$monthjoined = $_POST['monthjoined'];

$yearjoined = $_POST['yearjoined'];

$cname = $_POST['cname'];

$cadd = $_POST['cadd'];

$cphone = $_POST['cphone'];

$cfax = $_POST['cfax'];

$cwebsite = $_POST['cwebsite'];

$ccountry = $_POST['ccountry'];

$crate = $_POST['crate'];

$cwarranty = $_POST['cwarranty'];

$cterm = $_POST['cterm'];

$daysigned = $_POST['daysigned'];

$monthsigned = $_POST['monthsigned'];

$yearsigned = $_POST['yearsigned'];

$cremark = $_POST['cremark'];

$username = $_POST['username'];

$dayjoined = stripslashes($dayjoined);

$monthjoined = stripslashes($monthjoined);

$yearjoined = stripslashes($yearjoined);

$cname = stripslashes($cname);

$cadd = stripslashes($cadd);

$cphone = stripslashes($cphone);

$cfax = stripslashes($cfax);

$cwebsite = stripslashes($cwebsite);

$ccountry = stripslashes($ccountry);

$crate = stripslashes($crate);

$cwarranty = stripslashes($cwarranty);

$cterm = stripslashes($cterm);

$daysigned = stripslashes($daysigned);

$monthsigned = stripslashes($monthsigned);

$yearsigned = stripslashes($yearsigned);

$cremark = stripslashes($cremark);

$username = stripslashes($username);

// --- for the company logo

//if ($clientImage == '$EventImage') {$clientImageLink = '2';}

// else {$clientImageLink = '1';}

$sql_cname_check = mysql_query("SELECT client_name FROM clients WHERE client_name='$cname'");

$cname_check = mysql_num_rows($sql_cname_check);

if($cname_check > 0){

echo '<script language=javascript> alert("Client name already exist!");top.location = "clientmngr.php?id=1";</script>';

unset($cname);

exit();

}

$sql = mysql_query("INSERT INTO clients (day_joined, month_joined, year_joined, client_name, client_add, client_phone, client_fax, client_site, client_country, client_rate, ,client_warranty, client_term, day_signed, month_signed, year_signed, client_remarks, staff_created )

VALUES('$dayjoined', '$monthjoined', '$yearjoined', '$cname', '$cadd', '$cphone', '$cfax', '$cwebsite', '$ccountry', '$crate', '$cwarranty', '$cterm', '$daysigned', '$monthsigned', '$yearsigned', '$cremark', '$username')") or die (mysql_error());

if(!$sql){

echo '<script language=javascript> alert("Error adding client");top.location = "clientmngr.php?id=1";</script>';

exit();

} else {

$clientid = mysql_insert_id();

echo '<script language=javascript> alert("New client has been added by '.$username.';!");top.location = "clientmngr.php?id=2";</script>';

}

?>

pixeltrace · February 20, 2007

this is the error that i am getting now after changing the "target" to "action"

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'client_warranty, client_term, day_signed, month_signed, year_sig

also this is the code for my addclient.php

<?
include '../db_connect.php';

$dayjoined = $_POST['dayjoined'];
$monthjoined = $_POST['monthjoined'];
$yearjoined = $_POST['yearjoined'];
$cname = $_POST['cname'];
$cadd = $_POST['cadd'];
$cphone = $_POST['cphone'];
$cfax = $_POST['cfax'];
$cwebsite = $_POST['cwebsite'];
$ccountry = $_POST['ccountry'];
$crate = $_POST['crate'];
$cwarranty = $_POST['cwarranty'];
$cterm = $_POST['cterm'];
$daysigned = $_POST['daysigned'];
$monthsigned = $_POST['monthsigned'];
$yearsigned = $_POST['yearsigned'];
$cremark = $_POST['cremark'];
$username = $_POST['username'];


$dayjoined = stripslashes($dayjoined);
$monthjoined = stripslashes($monthjoined);
$yearjoined = stripslashes($yearjoined);
$cname = stripslashes($cname);
$cadd = stripslashes($cadd);
$cphone = stripslashes($cphone);
$cfax = stripslashes($cfax);
$cwebsite = stripslashes($cwebsite);
$ccountry = stripslashes($ccountry);
$crate = stripslashes($crate);
$cwarranty = stripslashes($cwarranty);
$cterm = stripslashes($cterm);
$daysigned = stripslashes($daysigned);
$monthsigned = stripslashes($monthsigned);
$yearsigned = stripslashes($yearsigned);
$cremark = stripslashes($cremark);
$username = stripslashes($username);
// --- for the company logo
//if ($clientImage == '$EventImage') {$clientImageLink = '2';}
//	else {$clientImageLink = '1';}

$sql_cname_check = mysql_query("SELECT client_name FROM clients WHERE client_name='$cname'");
  $cname_check = mysql_num_rows($sql_cname_check);
	if($cname_check > 0){
		echo '<script language=javascript> alert("Client name already exist!");top.location = "clientmngr.php?id=1";</script>';
		unset($cname);
		exit();
	} 	 

  $sql = mysql_query("INSERT INTO clients (day_joined, month_joined, year_joined, client_name, client_add, client_phone, client_fax, client_site, client_country, client_rate, ,client_warranty, client_term, day_signed, month_signed, year_signed, client_remarks, staff_created )
	VALUES('$dayjoined', '$monthjoined', '$yearjoined', '$cname', '$cadd', '$cphone', '$cfax', '$cwebsite', '$ccountry', '$crate', '$cwarranty', '$cterm', '$daysigned', '$monthsigned', '$yearsigned', '$cremark', '$username')") or die (mysql_error());
  
     if(!$sql){
    echo '<script language=javascript> alert("Error adding client");top.location = "clientmngr.php?id=1";</script>';
	exit();
     } else {
   $clientid = mysql_insert_id();	   

   echo '<script language=javascript> alert("New client has been added by '.$username.';!");top.location = "clientmngr.php?id=2";</script>';
     }
?>

JBS103 · February 20, 2007

mysql_query("INSERT INTO clients (day_joined, month_joined, year_joined, client_name, client_add, client_phone, client_fax, client_site, client_country, client_rate, client_warranty, client_term, day_signed, month_signed, year_signed, client_remarks, staff_created )....

After client_rate and before client_warrenty you have a ", ,".

Fix that so it is:

mysql_query("INSERT INTO clients (day_joined, month_joined, year_joined, client_name, client_add, client_phone, client_fax, client_site, client_country, client_rate, client_warranty, client_term, day_signed, month_signed, year_signed, client_remarks, staff_created )....

karthikeyan_coder · February 20, 2007

$sql = mysql_query("INSERT INTO clients (day_joined, month_joined, year_joined, client_name, client_add, client_phone, client_fax, client_site, client_country, client_rate ,client_warranty, client_term, day_signed, month_signed, year_signed, client_remarks, staff_created )

VALUES('$dayjoined', '$monthjoined', '$yearjoined', '$cname', '$cadd', '$cphone', '$cfax', '$cwebsite', '$ccountry', '$crate', '$cwarranty', '$cterm', '$daysigned', '$monthsigned', '$yearsigned', '$cremark', '$username')") or die (mysql_error());

use above statement...

error is... two commas after client_rate ,,

pixeltrace · February 20, 2007

i am getting a new error now

---------

Warning: main(../db_connect.php): failed to open stream: No such file or directory in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 2

Warning: main(): Failed opening '../db_connect.php' for inclusion (include_path='.;c:\php\pear') in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 2

Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 44

Warning: mysql_query(): A link to the server could not be established in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 44

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 45

Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 53

Warning: mysql_query(): A link to the server could not be established in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 53

Access denied for user 'ODBC'@'localhost' (using password: NO)

------------

what seems to be the problem here?

karthikeyan_coder · February 20, 2007

php cannot find "db_connect.php" ...

include '../db_connect.php'; //is your code

it is searching for db_connect.php in some other folder...

just change it to

include 'db_connect.php';

if your db_connect.php file is available within the current folder, where your addclient.php presents.

JasonLewis · February 20, 2007

your database connect file, db_connect.php could not be included (top error and second from top)

the rest of the errors are query fails because your database has not connected.

pixeltrace · February 20, 2007

hi, thanks!

its working now

Sign In

inserting data to database problem

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Archived

Important Information