Insert MYSQL

[princeofpersia]

Hi guys

 

I have a registration form working fine, my database is as below:

 

userid

username

email

password

repeatpassword

 

 

I have added another column which is "name", users can update their profile once they have logged in so I have created updateprofile.php and when I login-->go to update profile and insert my name nothing adds to mysql name column

 

this is my code below:

 

<?php

 

include ("global.php");

 

 

//username session

$_SESSION['username']=='$username';

$username=$_SESSION['username'];

 

//welcome messaage

echo "Welcome, " .$_SESSION['username']."!<p>";

 

  if ($_POST['register'])

    {

    //get form data

    $name = addslashes(strip_tags($_POST['name']));

 

$update = mysql_query("INSERT INTO users (name) VALUES ('$_POST[name]') WHERE username='$username'");

   

}

 

?>

 

    <form action='updateprofile.php' method='POST'>

    Company Name:<br />

    <input type='text' name='name'><p />

 

    <input type='submit' name='register' value='Register'>

    </form>

 

 

can you please tell me where in this code is wrong? Im new in php so please excuse me if I have silly mistakes.

 

thanks in advance

 

[Pikachu2000]

Before you can make use of any session variables, you need to have session_start() in the script. Most programmers make it the first thing in the code, right after the <?php open tag.

[mikosiko]

....

//username session

$_SESSION['username']=='$username';

$username=$_SESSION['username'];

...

 

what???... I'm lost kind of lost with those 2 sentences... 

 

echo your $username variable and check if the value will be consistent with your SELECT

 

and what Pikachu2000 suggested is also valid.

[princeofpersia]

Thanks for help, I have added the session_start(); but still when i insert name, i can see the name added to my column in phpmyadmin, any ideas?

[litebearer]

ALSO when making a change to an EXISTING record use UPDATE not INSERT

http://www.tizag.com/mysqlTutorial/mysqlupdate.php

[princeofpersia]

I have echoed the username in the code

 

echo "Welcome, " .$_SESSION['username']."!<p>";

 

and it works fine, the username shows up

[princeofpersia]

Ive changed it to update but still can not see anything added,

 

its funny because i dont even get an error :'(

[litebearer]

may we see your most current coding

[Pikachu2000]

Post your current code, please.

[princeofpersia]

there you go

________________________

 

 

<?php

session_start();

include ("global.php");

 

 

//username session

$_SESSION['username']=='$username';

$username=$_SESSION['username'];

 

 

//welcome messaage

echo "Welcome, " .$_SESSION['username']."!<p>";

 

  if ($_POST['register'])

    {

    //get form data

    $name = addslashes(strip_tags($_POST['name']));

 

 

 

 

 

$update = mysql_query("UPDATE  users  VALUES ('$_POST[name]') WHERE username='$username'");

   

 

 

 

 

 

 

}

 

 

?>

 

    <form action='updateprofile.php' method='POST'>

    Company Name:<br />

    <input type='text' name='name'><p />

 

    <input type='submit' name='register' value='Register'>

    </form>

 

[litebearer]

Psuedo code

$query = "UPDATE  table_name_here   SET fieldname_here = 'variable_name_here WHERE some_field = 'some_value_here'";
$result = mysql_query($query);

[princeofpersia]

thanks im trying it but what is going to be some_field here?

[litebearer]

some_field would be replaced with an actual filed name ie user_name

so - WHERE user_name = '$user_name'

clear?

[princeofpersia]

yup, worked fantastic, u r a star mate.

 

thanks for your time and advice

[princeofpersia]

one more question, now we assume we add another column named telephonenumber and we use the same query to update. Now if user doesnt fill the name and only enteres the telephone number name field overrites the empty space. how i should avoid that?

 

SO on update we have two input text

 

name

telelphone

 

I have only inserted telephone, it added the telephone but now the name is empty in php myadmin

thanks