Ad:

PHP Discussion Thread
Unsolved
Views: 393

Jul 4th, 2009

Whats the error

Expand Post »

php Syntax (Toggle Plain Text)
<?php
$con=mysql_connect("localhost","root","");
if(!$con)
	{
	die('Could not connect:'.mysql_error());
	}
mysql_select_db(customer1,$con)             
$sql1="INSERT INTO details(companyname,companyadd,comstate,telephone,fax,email,fname,lname,nic,mobile,username,password);VALUES('$_POST[coname]','$_POST[coadd]','$_POST[cost]','$_POST[tel]','$_POST[fax]','$_POST[mail]','$_POST[fname]','$_POST[lname]','$_POST[nic]','$_POST[mob]','$_POST[user]','$_POST[password]')"; 
if(!mysql_query($sql1,$con))
{
	die('Error:'.mysql_error());
}
echo"1 record added";
mysql_close($con)
?>
<?php
$con=mysql_connect("localhost","root","");
if(!$con)
	{
	die('Could not connect:'.mysql_error());
	}
mysql_select_db(customer1,$con)             
$sql1="INSERT INTO details(companyname,companyadd,comstate,telephone,fax,email,fname,lname,nic,mobile,username,password);VALUES('$_POST[coname]','$_POST[coadd]','$_POST[cost]','$_POST[tel]','$_POST[fax]','$_POST[mail]','$_POST[fname]','$_POST[lname]','$_POST[nic]','$_POST[mob]','$_POST[user]','$_POST[password]')"; 
if(!mysql_query($sql1,$con))
{
	die('Error:'.mysql_error());
}
echo"1 record added";
mysql_close($con)
?>

Last edited by peter_budo; Jul 6th, 2009 at 6:54 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Similar Threads

C++ Program have one error :) in C++
error warning in PHP
Ned Help With Hijack This Log! in Viruses, Spyware and other Nasties
newcommer to c++ need help with simple program in C++
RIS Question in Windows NT / 2000 / XP

dilan_n

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jul 2009

Permalink

Jul 4th, 2009

Re: Whats the error

Hi..
check this two lines

(Toggle Plain Text)

mysql_select_db($customer1,$con)  

and

$sql1="INSERT INTO details(companyname,companyadd,comstate,telephone,fax,email,fname,lname,nic,mobile,username,password) VALUES('$_POST[coname]','$_POST[coadd]','$_POST[cost]','$_POST[tel]','$_POST[fax]','$_POST[mail]','$_POST[fname]','$_POST[lname]','$_POST[nic]','$_POST[mob]','$_POST[user]','$_POST[password]')";

Click to Expand / Collapse Quote originally posted by dilan_n ...

<?php
$con=mysql_connect("localhost","root","");
if(!$con)
{
die('Could not connect:'.mysql_error());
}
mysql_select_db(customer1,$con)
$sql1="INSERT INTO details(companyname,companyadd,comstate,telephone,fax,email,fname,lname,nic,mobile,username,password);VALUES('$_POST[coname]','$_POST[coadd]','$_POST[cost]','$_POST[tel]','$_POST[fax]','$_POST[mail]','$_POST[fname]','$_POST[lname]','$_POST[nic]','$_POST[mob]','$_POST[user]','$_POST[password]')";
if(!mysql_query($sql1,$con))
{
die('Error:'.mysql_error());
}
echo"1 record added";
mysql_close($con)
?>

sarithak

Reputation Points: 10

Solved Threads: 7

Junior Poster

Offline

183 posts
since Aug 2008

Permalink

Jul 4th, 2009

Re: Whats the error

check out this code

php Syntax (Toggle Plain Text)
<?php
$con=mysql_connect("localhost","root","");
if(!$con)
{
die('Could not connect:'.mysql_error());
}
mysql_select_db(customer1,$con) 
$sql1="INSERT INTO details(companyname,companyadd,comstate,telephone,fax,email,fname,lname,nic,mobile,username,password)
VALUES('".$_POST['conam'e]."','".$_POST['coadd']."','".$_POST['cost']"','".$_POST['tel']."','".$_POST['fax']."','".$_POST['mail']."','".$_POST['fname']."','."$_POST['lname']."','".$_POST['nic']."','".$_POST['mob']."','".$_POST['user']."','".$_POST['password']."')";
if(!mysql_query($sql1,$con))
{
die('Error:'.mysql_error());
}
echo"1 record added";
mysql_close($con)
?>
<?php
$con=mysql_connect("localhost","root","");
if(!$con)
{
die('Could not connect:'.mysql_error());
}
mysql_select_db(customer1,$con) 
$sql1="INSERT INTO details(companyname,companyadd,comstate,telephone,fax,email,fname,lname,nic,mobile,username,password)
VALUES('".$_POST['conam'e]."','".$_POST['coadd']."','".$_POST['cost']"','".$_POST['tel']."','".$_POST['fax']."','".$_POST['mail']."','".$_POST['fname']."','."$_POST['lname']."','".$_POST['nic']."','".$_POST['mob']."','".$_POST['user']."','".$_POST['password']."')";
if(!mysql_query($sql1,$con))
{
die('Error:'.mysql_error());
}
echo"1 record added";
mysql_close($con)
?>

praveen_dusari

Reputation Points: 21

Solved Threads: 29

Posting Whiz in Training

Offline

202 posts
since Jun 2008

Permalink

Jul 4th, 2009

Re: Whats the error

Hi..

As in C or Perl, PHP requires instructions to be terminated with a semicolon at the end of each statement.

http://sk.php.net/manual/en/language...separation.php

and check this two lines

(Toggle Plain Text)

mysql_select_db($customer1,$con) ;

and

(Toggle Plain Text)

mysql_close($con);

I hope it's gonna be OK.

Yayo_SK

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

11 posts
since Jan 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: cannot post an end date

Next Thread in PHP Forum Timeline: videos in PHP

DaniWeb Message

Cancel Changes

User Name
Password