[Resolved] Need help with this code... lol

[ashley526]

I have the database make, so I assume. Now I am just trying to set up the php code so that I can add information to it through a php page. Makes sense to you I am sure, but I am VERY NEW! 😕

So here's what I have:

<?
$server = "localhost"; 
$user = "**************"; 
$password = "****************"; 
$database = "****************"; 


mysql_connect($server, $user, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());

$query="SELECT * FROM names";
$result=mysql_query($query);

$num=mysql_numrows($result);



mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {


++$i;
}

?>

What it is doing is displaying a list of the 2 things that are already on the database, but it's not inserting the one just submitted. So, at this point I can only add then directly through phpmyadmin.

What I am wanting isn't this list that shows up. Infact I just want it to confirm the entry and then insert it into the database.

So, my question to you is... wth am I doing wrong, and how do I fix it!? LOL

Thanks ahead of time!

Ashley

[drew010]

i take it that this is a page that gets data posted to it from a form??
also is register_globals turned on or off on the server?

if it is on, all the variables from the form will be accessable like $POST['name'], $POST['meaning'] etc...

also, if you simply want to insert that data you can do it as short as this code:

<?
$server = "localhost"; 
$user = "**************"; 
$password = "****************"; 
$database = "****************"; 


mysql_connect($server, $user, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());

$query = "INSERT INTO names VALUES  ('','{$_POST['name']}','{$_POST['meaning']}','{$_POST['gender']}','{$_POST['origin']}','{$_POST['ratings']}')";

$result = mysql_query($query);

if ($result) {
    echo "Successfully inserted data.";
} else {
    echo "Error inserting data.  Reason: " . mysql_error();
}

mysql_close();

}

?> 

[strozzi]

So..the first error is here:

$num=mysql_numrows($result);
is
$num=mysql_num_rows($result);

then:

probabily u have used a counter to store the record and i see the maybe is the first field? right? then if u have used an auto-increments attribute to this field u do not have to insert in the query like this:

INSERT INTO names VALUES ('','$name','$meaning','$gender','$origin','$ratin
gs')";

but like this:

INSERT INTO names VALUES ('$name','$meaning','$gender','$origin','$ratin
gs')";

if u have not used the counter maybe u are making a mistake......

the a fast way to fetch the recordset is this:

while( ($row=mysql_fetch_array($result)) != NULL )
{
echo $row['name'];
echo $row['......etc...];
}

bye

[ashley526]

Originally posted by drew010
i take it that this is a page that gets data posted to it from a form??
also is register_globals turned on or off on the server?

if it is on, all the variables from the form will be accessable like $POST['name'], $POST['meaning'] etc...

also, if you simply want to insert that data you can do it as short as this code:

With this I get this error:

Parse error: parse error, unexpected T_STRING, expecting '}' in /home/user/public_html/database/insert.php on line 12

[drew010]

on the $query you did move all that onto one line right? the forum kept wrapping it to the next line.

[rachel2004]

Originally posted by ashley526
With this I get this error:

Parse error: parse error, unexpected T_STRING, expecting '}' in /home/user/public_html/database/insert.php on line 12

I haven't looked through all of the code, but I did spot an extra curly brace after the mysql_close().

[ashley526]

No I hadn't... so that one is fixed.... now this error appears:
Parse error: parse error, unexpected '}' in /home/user/public_html/database/submit.php on line 22

btw, I am practicing the changed with submit.php and not insert.php lol

[drew010]

rachel's post above addresses that error.

[ashley526]

You all are such a big help!! Thanks for taking the time... hugs

now this:

Error inserting data. Reason: Column count doesn't match value count at row 1

[drew010]

that basically means that the query used to insert the data isn't matching the exact table structure.

i.e. we have a table with fields:
id, name, address
but we do
insert into table values('', 'drew', '1234 my street', 'this mismatches row count!')

do you have the exact table structure available?

[ashley526]

name varchar(50) Not Null
meaning varchar(255) Not Null
gender varchar(50) Not Null
origin varchar(50) Not Null
ratings decimal(4,0) Not Null

I assume this is what you mean?

[drew010]

yep, thats what i mean, so in the query we are going to want to get rid of the '' empty insert.

have it look like this:

$query = "INSERT INTO names VALUES ('{$POST['name']}','{$POST['meaning']}','{$POST['gender']}','{$POST['origin']}','{$_POST['rat
ings']}')";

but make it all on one line again.

[ashley526]

IT WORKED!!!!! LOL

I just gotta say, I wub you all!! bighugs

Now can someone point me into the direction of organizing all the info that gets put in the database?

What I am running is for baby names... I want my members and guests to be able to insert names, but also (on another page) be able to search through them)

Anyway, thank you sooo much, you have gave me a great start!!!

Ash

[drew010]

you dont really need to worry about organizing the data you put in there, you can use select statements to bring out data you want for searches and things.

for example if you wanted to list all baby names starting with the letter a in alphabetical order you could use this:

SELECT * FROM names WHERE name LIKE 'A%' ORDER BY name ASC;
//this assumes names start with caps

or to list all names of one gender in alpha order

SELECT * FROM names WHERE gender = 'Male' ORDER BY name ASC;
//assumes gender is stored as Male or Female, not M or F

or here is one to list all female names with an irish origin

SELECT * FROM names WHERE gender = 'Female' AND origin = 'Irish';
//assumes Irish is a valid origin
// you could use others like Anglo, or Greek, or African etc....

the options go on and on. good luck with it and we're here if you need us

[ashley526]

Thank you!!!!

I am sure I will have more questions... 😉

[ashley526]

If you wanna check out what you helped me to do so far you can here:

http://www.simply-baby.net/forum/vbaindex.php?page=entername

Now when I go to search through my database with those queries, or some like them... do I have to have a php page for each one? (is there a thread that explains that stuff? I couldn't find one...)

Thanks!

[drew010]

you dont need a page for each one if you dont want. you can make a page search.php or maybe in the case of your site vbaindex.php?page=search where you give a list of different searches they can perform and use an if statement to run the query and return the results.

[ashley526]

Since I am very new and just learning are there any examples that I can follow off of to build a code, then come back here if I have issues? I'd hate to just keep asking questions and end up making you all write it for me.... lol

[rachel2004]

www.devshed.com
www.phpbuilder.com
www.webmonkey.com
www.php.net (check their manual)
www.zend.com

Of course another great resource:

www.google.com

Definitely try to do some of your own research before asking in the newsgroup. This is difficult when you're first starting out, we know, but you have to start somewhere. ;-)

There are not a lot of folks as generous with their time as drew010.

[ashley526]

Originally posted by rachel2004
There are not a lot of folks as generous with their time as drew010. [/B]

I agree! 😃

Thank you for the links.