DaniWeb Forum Index > Web Development > PHP

PHP Form and Database Help Please

Please support our PHP advertiser: 50% off 6 Months Dedicated Server Hosting from 1&1!

Thread Solved

Last »

•

Join Date: Apr 2007

Posts: 26

Reputation: mattyb15 is an unknown quantity at this point

Solved Threads: 0

mattyb15

Offline

Light Poster

PHP Form and Database Help Please

Sep 16th, 2008

Okay. I'm a php newbie.

I have a form where the user enters their name.

I then on the next form I want it to access the database and add 1 to the row named 'number' that matches the persons name that they previously entered. If the name does not exist, I want it to create new data for that person.

Any help would be much appreciated.

If I helped +rep please,
Thanks

•

Join Date: Feb 2008

Posts: 213

Reputation: nikesh.yadav is an unknown quantity at this point

Solved Threads: 17

nikesh.yadav nikesh.yadav is offline

Offline

Posting Whiz in Training

Re: PHP Form and Database Help Please

Sep 16th, 2008

wat u need code or suggestion?

Help as an alias

I think programming is great................
Tour Travel weblink by me and about Tour ,
Go To My Home Page and I m in Webdevelopment.

•

Join Date: Feb 2008

Posts: 213

Reputation: nikesh.yadav is an unknown quantity at this point

Solved Threads: 17

nikesh.yadav nikesh.yadav is offline

Offline

Posting Whiz in Training

Re: PHP Form and Database Help Please

Sep 16th, 2008

if u need suggestion....

first u check weather the data is present or not.
if not then insert a new row.

Help as an alias

I think programming is great................
Tour Travel weblink by me and about Tour ,
Go To My Home Page and I m in Webdevelopment.

•

Join Date: Apr 2007

Posts: 26

Reputation: mattyb15 is an unknown quantity at this point

Solved Threads: 0

mattyb15

Offline

Light Poster

Re: PHP Form and Database Help Please

Sep 16th, 2008

The code would be great. I'm new to PHP and don't really know how to use it properly yet.

•

Join Date: Feb 2008

Posts: 213

Reputation: nikesh.yadav is an unknown quantity at this point

Solved Threads: 17

nikesh.yadav nikesh.yadav is offline

Offline

Posting Whiz in Training

Re: PHP Form and Database Help Please

Sep 16th, 2008

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$result=mysql_query('select * from user where table='.$user_id.'');
if(mysql_num_rows($result) == 0){
$insert_user= 'insert into user set id='.$user_id.'';
mysql_query($insert_user) || die(mysql_error());
}
$result=mysql_query('select * from user where table='.$user_id.'');
if(mysql_num_rows($result) == 0){
$insert_user= 'insert into user set id='.$user_id.'';
mysql_query($insert_user) || die(mysql_error());
}

modify as ur enties

Help as an alias

I think programming is great................
Tour Travel weblink by me and about Tour ,
Go To My Home Page and I m in Webdevelopment.

•

Join Date: Feb 2008

Posts: 213

Reputation: nikesh.yadav is an unknown quantity at this point

Solved Threads: 17

nikesh.yadav nikesh.yadav is offline

Offline

Posting Whiz in Training

Re: PHP Form and Database Help Please

Sep 16th, 2008

sorry forgot last enrty

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 
 
$result=mysql_query('select * from tablename where id='.$user_id.'');
if(mysql_num_rows($result) == 0){
$insert_user= 'insert into tablename set id='.$user_id.'';
mysql_query($insert_user) || die(mysql_error());
}

$result=mysql_query('select * from tablename where id='.$user_id.'');
if(mysql_num_rows($result) == 0){
$insert_user= 'insert into tablename set id='.$user_id.'';
mysql_query($insert_user) || die(mysql_error());
}

modify as ur enties

Help as an alias

I think programming is great................
Tour Travel weblink by me and about Tour ,
Go To My Home Page and I m in Webdevelopment.

•

Join Date: Apr 2007

Posts: 26

Reputation: mattyb15 is an unknown quantity at this point

Solved Threads: 0

mattyb15

Offline

Light Poster

Re: PHP Form and Database Help Please

Sep 16th, 2008

Sorry, but how would I go about adding one to that persons 'number' row?

If I helped +rep please,
Thanks

•

Join Date: Jul 2008

Posts: 1,076

Reputation: Shanti Chepuru is on a distinguished road

Solved Threads: 98

Shanti Chepuru Shanti Chepuru is offline

Offline

Veteran Poster

Re: PHP Form and Database Help Please

Sep 16th, 2008

i think you are not complete with your posts.....

Please provide your thread clearly...

Last edited by Shanti Chepuru; Sep 16th, 2008 at 7:30 am.

Be intelligent, But Don't try to cheat.. Be innocent But Don't get cheated..

•

Join Date: Apr 2007

Posts: 26

Reputation: mattyb15 is an unknown quantity at this point

Solved Threads: 0

mattyb15

Offline

Light Poster

Re: PHP Form and Database Help Please

Sep 16th, 2008

This is my code so far.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
  $name = $_REQUEST['name'];
  $set = $_REQUEST['set'];
  $email = $_REQUEST['email'];
 
$con = mysql_connect("XXXXXXXXXXXXXX","XXXXXXX","XXXXX");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("a6114672_dope", $con);
 
$result=mysql_query('select * from turf_table where id='.$name.'');
if(mysql_num_rows($result) == 0){
$insert_user= 'insert into turf_table set id='.$name.'';
mysql_query($insert_user) || die(mysql_error());
}
 
mysql_close($con);
  $name = $_REQUEST['name'];
  $set = $_REQUEST['set'];
  $email = $_REQUEST['email'];

$con = mysql_connect("XXXXXXXXXXXXXX","XXXXXXX","XXXXX");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("a6114672_dope", $con);

$result=mysql_query('select * from turf_table where id='.$name.'');
if(mysql_num_rows($result) == 0){
$insert_user= 'insert into turf_table set id='.$name.'';
mysql_query($insert_user) || die(mysql_error());
}

mysql_close($con);