PHP Coding Adding Information To A Database.

[Rakim]

Hi i am making 3 websites at the same time with almost the same content

1) www.game-unit.com
2) www.irc-unit.com
3) www.nukehq.net

but anyway the 3rd NukeHQ will have a clan on it for a game and i want to make a members section anyway i have compiled the database fine but i cannot make the php work i made the form 😉 fine but now i need to make the form process page in php only i have done this already twice on the 2nd site for Links And News but as of yet i havnt made it work in the way of actualy adding it to the database so so far here is what i have got...

my problem lies on the add_member.php line 7. which i have made Bold For you to find it better.

---

add_new.php

<form name="links" method="post" action="add_member.php">
<p>Member Name :
<input type="text" name="title">
<br>
<br>
Rank :
<input type="text" name="url">
<br>
<br>
Real Name :
<input type="text" name="url">
<br>
<br>
E-Mail Address :
<input type="text" name="url">
<br>
<br>
MSN Messenger Address :
<input type="text" name="url">
<br>
<br>
Male/Female :
<input type="text" name="url">
<br>
<br>
Date Joined :
<input type="text" name="url">
<br>
<br>
Country :
<input type="text" name="url">
<br>
<br>
Town/City :
<input type="text" name="url">
<br>
<br>
Age :
<input type="text" name="url">
<br>
<br>
Favorite Saying :
<input type="text" name="url">
<br>
<br>
Favorite Map/Level :
<input type="text" name="url">
<br>
<br>
Image URL :
<input type="text" name="url">
</p>
<p>
<input type="submit" name="Submit" value="Submit">

</p></form>

add_member.php

<?php
include "config.php";

$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
$query = "INSERT INTO members (mname , rank , name , mail , msn , mf , dj , from , city , age , line , map , img)
VALUES('".$POST['mname']."','".$POST['rank']."', '".$POST['name']."', '".$POST['mail']."', '".$POST['msn']."', '".$POST['mf']."', '".$POST['dj']."', '".$POST['from']."', '".$POST['city']."', '".$POST['age']."', '".$POST['line']."', '".$POST['map']."', '".$_POST['img']."' )";
$result = mysql_query($query);
echo ("New Recruit Added.");
?>

---

config.php

<?php
$db_host = "localhost";
$db_user = "e_novative";
$db_pass = "e_novative";
$db_name = "news2";

?>

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

This is what i get in inetnet explorer when i open it.

Notice: Undefined index: mname in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: rank in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: name in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: mail in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: msn in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: mf in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: dj in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: from in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: city in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: age in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: line in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: map in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7

Notice: Undefined index: img in c:\program files\apache group\apache\htdocs\members\add_member.php on line 7
New Recruit Added.

Please Please Try And Help it must be finished before the end of may when the clan takes off 4 days max !

PS:
thanks for any help in advance.

[The_Chancer]

Have a look at your original form, all the names are URL, not the associated names you are later refering to in the $_POST['variable'] area as noted on line 7 (in bold)..

Try changing those to the relavent names...

[Rakim]

i have done as you said but now i have done that the error no longer shows but now i get no error but at the same time no work done :S i dont have a clue wots happend

i fill in my form and click submit

i allow it to go and then it says the echo"new recruit added" after that i thought yea who da man to myself
i then opened phpmyadmin for confirmation clicked browse but there is nothing there sadly and im real gutted now after i put a smile on my face for one bit of progress but i want the whole lot please reply thanks.

[The_Chancer]

It is always good practice to error check your code...

put in an echo line which lets you know what the query was...

e.g.

echo "INSERT INTO members (mname , rank , name , mail , msn , mf , dj , from , city , age , line , map , img) 
VALUES('".$_POST['mname']."','".$_POST['rank']."', '".$_POST['name']."', '".$_POST['mail']."', '".$_POST['msn']."', '".$_POST['mf']."', '".$_POST['dj']."', '".$_POST['from']."', '".$_POST['city']."', '".$_POST['age']."', '".$_POST['line']."', '".$_POST['map']."', '".$_POST['img']."' )"; 

At the moment, regardless of what happens you will get the
"New Recruit Added" message...

Your code does not say
"If it is added then print"
but
"After trying to insert, regardless of what has happened, print 'New recruit added' "

Something to think about.....

[OhLordy]

Try echoeing your sql and post it up here 🙂
Rob

[Rakim]

1) me name aint rob
2) echo to find my error gave me this...

New Recruit Added.INSERT INTO members (mname , rank , name , mail , msn , mf , dj , from , city , age , line , map , img) VALUES('na','na', 'na', 'na', 'na', 'na', 'na', 'na', 'na', 'na', 'na', 'na', 'na' )

word for word.

dont mind the na it was just a test one !

[The_Chancer]

Put this

printf ("Updated records: %d\n", mysql_affected_rows());

After the query as well, see if it gives you 1 Updated....

Check your PHPMYADMIN as well, could be wrong....

[OhLordy]

1) my name is Rob
2) Has it inserted into the database?
if it hasn't do
$result=mysql_query($query) or die(mysql_error());
HTH
Rob

[Rakim]

ok hi rob 😃
and 2 could one of you 2 copy my code from above for the add_member.php page and put that in for me as i dont know where to put it and im sorry to be like this im new to php and learning fast 😃 so far ive coded 2 things that work 3 including a php hit counter with a counter.txt file to work with it but thats not the point at the moment but here is a sample of mine...

http://labs.nukehq.net
http://www.irc-unit.com

thanks 😃

[OhLordy]

Add member.php

<?php
include "config.php";

$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
$query = "INSERT INTO members (mname , rank , name , mail , msn , mf , dj , from , city , age , line , map , img)
VALUES('".$_POST['mname']."','".$_POST['rank']."', '".$_POST['name']."', '".$_POST['mail']."', '".$_POST['msn']."', '".$_POST['mf']."', '".$_POST['dj']."', '".$_POST['from']."', '".$_POST['city']."', '".$_POST['age']."', '".$_POST['line']."', '".$_POST['map']."', '".$_POST['img']."' )";
echo($query);
$result = mysql_query($query) or die(mysql_error());
echo ("New Recruit Added.");
?>

[The_Chancer]

<?php 
include "config.php"; 

$db = mysql_connect($db_host,$db_user,$db_pass); 
mysql_select_db ($db_name) or die ("Cannot connect to database"); 
$query = "INSERT INTO members (mname , rank , name , mail , msn , mf , dj , from , city , age , line , map , img) 
VALUES('".$_POST['mname']."','".$_POST['rank']."', '".$_POST['name']."', '".$_POST['mail']."', '".$_POST['msn']."', '".$_POST['mf']."', '".$_POST['dj']."', '".$_POST['from']."', '".$_POST['city']."', '".$_POST['age']."', '".$_POST['line']."', '".$_POST['map']."', '".$_POST['img']."' )"; 
$result = mysql_query($query);
echo $query;
printf ("Updated records: %d\n", mysql_affected_rows()); 
echo ("New Recruit Added."); 
?>

Should give you what you need.

[edit]
why am I always the slower typer ???[/edit]

[Rakim]

ok now i have the image below i decided to screen it as thats alot lot easyer 😃

is this ok ? o hope it is lol😃

[Rakim]

do any of you guys have msn messenger i find that alot lot easyer add me or ill add you

[e-mail] online all the time im a 24/7 phper not a good one tho lol

[The_Chancer]

Have a look at the restricted words in Mysql...

See

here for more details

I'm a closet PHPBUILDER poster... and my boss doesn't know cos I am at work - no MSN for me.....

[Rakim]

i hate to say this mate but either i dont understand that or it doesnt help in the slightest way 😃 sorry about this 😉

[The_Chancer]

Sorry should have been a bit clearer... but the boss came in...

You have a field in the database called FROM - if you look in the restricted word list, it shows all words you can't have as fields (basically) so you need to change the FROM field to another name.

Hope that doesn't cause you too much change of code....

[Rakim]

dont appologise to me your helping alot i really really appreciate it mate and if your boss comes in and u could get in trouble dont risk it just close it you got a job to look after before me so its ok :p

but nahh shouldnt be too much code change i hope

[Rakim]

ok i done that but now i have this one

INSERT INTO members (mname , rank , name , mail , msn , mf , dj , frm , city , age , line , map , img) VALUES('test','test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test' )Updated records: -1 New Recruit Added. but nothing in phpmyadmin still

ill upload it to a webspace in a sec im sure i got a few domains with nothing in them lol i own 26 domains lol

[The_Chancer]

Have you tried a hand coded entry to see if you can enter something ?

ie

$query=mysql_query("INSERT INTO members (mname) VALUES ('this')");

See if you can do that and if it appears in PHPMYADMIN....

Code change....

<?php 
include "config.php"; 

$db = mysql_connect($db_host,$db_user,$db_pass); 
mysql_select_db ($db_name) or die ("Cannot connect to database"); 
$query = "INSERT INTO members (mname , rank , name , mail , msn , mf , dj , from , city , age , line , map , img) 
VALUES('".$_POST['mname']."','".$_POST['rank']."', '".$_POST['name']."', '".$_POST['mail']."', '".$_POST['msn']."', '".$_POST['mf']."', '".$_POST['dj']."', '".$_POST['from']."', '".$_POST['city']."', '".$_POST['age']."', '".$_POST['line']."', '".$_POST['map']."', '".$_POST['img']."' )"; 
$result = mysql_query($query);
if (!mysql_affected_rows){
echo ("Recruit NOT Added.\nQuery $query is wrong");
}
else {
echo ("New Recruit Added.\nYour query $query is correct");
}
?>

Just looks prettier and gives you the correct answer... LOL

[Rakim]

umm :S no that didnt quite work out !

here is the code now.

http://php.nukehq.net

and thanks again u helped me find out i have unlimited sub domains on here and how to make em 😃