This code doesnt write! And i am bleeding!

itandme

Hey its me again! Its not like i am not trying myself, but i am a bit under time pressure, and the PHP book i got isnt very giving.

For some reason, this code doesnt write into the database. The form validation works just fine, however i belive that it never actually goes past the validation. I think it stops there for some strange reason, as it never actually makes the insciption.

if (($REQUEST_METHOD=='POST')) {
if ((!$name || !$abbrev || !$email || !ereg(".+@.+..+", $email)) || (!ereg("^{[a-zA-Z0-9_@.-]+$",} $email))) {
$error = "There seems to be something wrong...";
} else {
$db = mysql_connect ("localhost"*********","**") or die
("Could not create a connection");
mysql_select_db("lorens_sfs",$db);
$sql = "INSERT INTO guilds (name,shard,abbrev,charter,location,site,uosite,email,password,rp,pk,pvp,faction,alignment,waring) VALUES ('$name','$shard','$abbrev','$sharter','$location', '$site','$uosite','$email','$pass','$rp','$pk','$pk','$pvp','$faction','$alignment','$waring')";
$result = mysql_query($sql);

$id = mysql_insert_id();

$subject = "Thank you for registering at the guild listings!";
$body = "If you need to edit your guild info, do so by going to this adress:\n";
$body .= "http://scencesfromsos.net/guilds/editguild.php?id=$id\n\n";
$body .= "Your password is:\n";
$body .= "$password\n\n";
$body .= "Regards\n";
$body .= "Scenes from Sosaria - http://www.scenesfromsos.net";
$headlines = "From: Scenes from Sosaria guild listings\n";
mail($email,$subject,$body,$headlines);

}
}

Thankyoua! bows

stolzyboy

are you getting any errors???

also you have in the insert statement the variable $sharter, and it is inserting into field name charter, should the variable be $charter or was this on purpose, not sure that that would cause the problem, it may if you aren't allowing null fields and that variable doesn't have anything

itandme

I dont get any errors, that what a bit odd. The validation is fine, and the code even send the mail. But it doesnt write into tha database! And also I coreccted the sharter thingy, no difference though.

What do you mean with not allowing null fields?

thx

stolzyboy

a lot of times, if you have NOT NULL in your mysql fields, and you try to send a NULL variable to it, the whole query will die and will not insert, meaning if you have $var and it isn't filled in by end user, you will be trying to insert nothing into a field designated as a NOT NULL field, probably not your problem, but wanted you to understand what i meant

stolzyboy

also try using an or die statement with the mysql_errno() to see if it will give you an error

itandme

I have set all my rows except the ID one to null, but ít still make no difference.

Also i made a or die ("error") but it doesnt even give me a error msg...

Its like it just ignore the mysql code. It does EVERYTHING except writing to the database... ...

Very strange... indeed...

stolzyboy

also probably not the problem, but has posed problems for me in the past

after your insert statement place a semicolon after the ), but before the quote, so it would be );";

again probably not it, but having a hard time finding a problem with it

itandme

This is now the current code:

<?
if (($REQUEST_METHOD=='POST')) {
if ((!$name || !$abbrev || !$email || !ereg(".+@.+..+", $email)) || (!ereg("^{[a-zA-Z0-9_@.-]+$",} $email))) {
$error = "There seems to be something wrong...";
} else {

mysql_connect("localhost","**","***") or die
("Could not create a connection");
mysql_select_db("lorens_sfs");
$sql = "INSERT INTO guilds (name,shard,abbrev,charter,location,website,uosite,email,password,rp,pk,pvp,faction,align,waring) VALUES ('$name','$shard','$abbrev','$charter','$location', '$site','$uosite','$email','$pass','$rp','$pk','$pk','$pvp','$faction','$alignment','$waring');";
mysql_query($sql);

$id = mysql_insert_id();

$subject = "Thank you for registering at the guild listings!";
$body = "If you need to edit your guild info, do so by going to this adress:\n";
$body .= "http://scencesfromsos.net/guilds/editguild.php?id=$id\n\n";
$body .= "Your password is:\n";
$body .= "$pass\n\n";
$body .= "Regards\n";
$body .= "Scenes from Sosaria - http://www.scenesfromsos.net";
$headlines = "From: Scenes from Sosaria guild listings\n";
mail($email,$subject,$body,$headlines);

}
}
?>

I suppose that if its $something = mysql_query, or just mysql_query makes no difference. None of them works though.

Do you wanna see the mysql fields?

thx

stolzyboy

actually it does, i didn't realize you were doing that, oops, lol

$something = mysql_query($sql) or die("could not insert");

it also needs to be that way with your connection to your database and table

all you have is mysql_connect, this is how i do it

$conn = mysql_connect("localhost", "xxxxx", "xxxxx") or die ("Could not connect to database!");

$db = mysql_select_db("database_name") or die ("Could not select database");

itandme

Ok, this is what i got now... Some progess, not it actually gives me a error! Johoo! It gives me mysql_query error. (not working thióugh)

try it at lorenscorn.net/guilds/register2.php

thanks

<?
if (($REQUEST_METHOD=='POST')) {
if ((!$name || !$abbrev || !$email || !ereg(".+@.+..+", $email)) || (!ereg("^{[a-zA-Z0-9_@.-]+$",} $email))) {
$error = "Either is one of the requierd fields blank, or your email is invalid... ";
} else {

$conn = mysql_connect("localhost","***","***") or die
("Could not create a connection");
$db = mysql_select_db("lorens_sfs") or die("Could not select database");
$sql = "INSERT INTO guilds (name,shard,abbrev,charter,location,website,uosite,email,password,rp,pk,pvp,faction,align,waring)";
$sql .= "VALUES ('$name','$shard','$abbrev','$charter','$location', '$site','$uosite','$email','$pass','$rp','$pk','$pk','$pvp','$faction','$alignment','$waring')";
$insert = mysql_query($sql) or die("nf");

$id = mysql_insert_id();

$subject = "Thank you for registering at the guild listings!";
$body = "If you need to edit your guild info, do so by going to this adress:\n";
$body .= "http://scencesfromsos.net/guilds/editguild.php?id=$id\n\n";
$body .= "Your password is:\n";
$body .= "$pass\n\n";
$body .= "Regards\n";
$body .= "Scenes from Sosaria - http://www.scenesfromsos.net";
$headlines = "From: Scenes from Sosaria guild listings";
mail($email,$subject,$body,$headlines);

}
}
?>

stolzyboy

use this in your or die statement

or die (mysql_error());

this will probably give you a better error

itandme

ARGHHH!!! I got the error the rows doesnt match the values, and I made some serius countin.

AND DESPITE ONE DAY OF COUNTIN AND RECOUNTING, there was one more value than collumn! the 'pk' thingy was written TWICE!!!
How frustrating!

Once again, thank you! bows deeply