a smal page making script.

**aog** · 07-13-2004, 09:25 AM

I see you use first, last, phone, ect. as the names on your form. Do you use that becouse the table have rows called the same? so when you use $first','$last','$phone' in the insert.php, the value of $first','$last','$phone' will be added to the rows first, last, phone?

**Veter** · 07-13-2004, 09:46 AM

Thats correct

**aog** · 10:07 AM

k

One more question.
Lets say I have the rows "Item", "Items Type", "Ql", "Price", ect.

Then I want to post my info in the database. I could use what you showed me Veter, but what if I want to post the data sorted by "Items Type", and then "Items".
how whould I do that?

(I whould like it to look some thing like this

Quote:

Items Type: <a value of item type>

Items: Ql: Price:
Boots 23 500$

Items Type: <a new value>
ect

**aog** · 01:14 PM

Quote:

mysql_connect("69.49.230.13",$username,$password);

Why the ip?
Is that the localhost?
I can't connect to my databse.

Can I use localhost?
On the server "admin page" it says: "MySQL 4.0.16 runing on localhost as housemaa_vingtor@localhost"
I have tryed
a. ($host,$username,$password)
b. ($username,$host,$password)
c. ($password,$host,$username)
d. ($username,$password,$host)
e. ($password,$username,$host)

Nothing works

**nestyra** · 07-13-2004, 01:55 PM

there is alot of information on php.net ,like the online manual. I virtually learned everything I can form there. Spend some time reading there, and try it out. Dont get too complicated too fast... There is information at mysql.com too.

**aog** · 06:21 PM

ok..
Thanks to David Gowans I have now learned a lot about building databses.

There is still some questions I need aswer to.
I'll start with question 1.

I know how I can sort the data in a table using "ORDER BY".
But can I sort sort lik this:

my table.
__________________
row1 row2 row3 row4
aaaa 1111 aaaa aaaa
bbbb 1111 bbbb bbbb
bbbb 2222 bbbb bbbb
cccc 3333 cccc cccc

how I want it to look:

row2 1111
_____________
row1 row3 row4
aaaa aaaa aaaa
bbbb bbbb bbbb

row2 2222
_____________
row1 row3 row4
bbbb bbbb bbbb

row2 3333
_____________
row1 row3 row4
cccc cccc cccc

Can that be done, or do I have to put all row2 in a own table like below, and then use "ORDER BY" on each table and out put it on my webpage?

table 1111
_____________
row1 row2 row3
aaaa aaaa aaaa
bbbb bbbb bbbb

table 2222
_____________
row1 row2 row3
bbbb bbbb bbbb

table 3333
_____________
row1 row2 row3
cccc cccc cccc

EDIT:
Ok, I can fix the problem I just wrote about by making more tables.

But what I don't understand now, is why don't this work?
$query=" SELECT * FROM contacts WHERE id='1'";
I have a row called "id", and I have the value "1" in that row.
Should it not work?
The error I get it:

Quote:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result

**aog** · 07-14-2004, 03:34 PM

Ok..

I think this will be the last question.

What I can do now is:

- Creat a databse
- Create a table
- Add a record to a table
- Edit a record
- Delete a record
- Output a table
- Output from a table were $field holds the $info
- Sort the output of a table
- Search in a table

What I need to do is this:

$query="SELECT * FROM contacts WHERE first LIKE '%$search%' ORDER BY first, last ASC";
If there is nothing in the database, then I want to echo "No match was found. Pleace try again."

How do I do that?

Btw Veter, Thank you for making me do this!

I have learned SO much. Thank you.

**Kyrnt** · 07-14-2004, 03:46 PM

Perform a query then call the mysql_num_rows() function on the result.

PHP Code:


			
<?php



$link = mysql_connect("localhost", "mysql_user", "mysql_password");

mysql_select_db("database", $link);



$query = "SELECT * FROM contacts WHERE first LIKE '%$search%' ORDER BY first, last ASC"



$result = mysql_query($query, $link);

$num_rows = mysql_num_rows($result);



if( $num_rows == 0 )

{

    print "No match was found. Please try again." 

}

else

{

    // Go do something amazing with your data!

}



?>

**aog** · 07-14-2004, 04:08 PM

Sweet!

**aog** · 07-14-2004, 06:28 PM

doh..

What is it I can't see...

This wont give me the same information as the script on the bottom.

Not working...

Quote:

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM contacts WHERE first LIKE '%$search%' ORDER BY first, last ASC";
$result = mysql_query($query);
$num_rows = mysql_numrows($result);

mysql_close();

?>

<?
if( $num_rows == 0 )
{
echo ("No match was found. Please try again.");
}
elseif( $num_rows >= 1 )
{
echo ('Serach ressult for "'."$search".'"');
echo ('<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th>Name</th>
<th>Phone</th>
<th>Mobile</th>
<th>Fax</th>
<th>E-mail</th>
<th>Website</th>
<th></th>
</tr>');

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

$id=mysql_result($result,$i,"id");
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
}

echo ('
<tr>
<td>'."$first".' '."$last".'</td>
<td>'."$phone".'</td>
<td>'."$mobile".'</td>
<td>'."$fax".'</td>
<td><a href="mailto:'."$email".'">E-mail</a></td>
<td><a href="'."$web".'">Website</a></td>
<td><a href="delete.php?id='."$id".'">Delete</a></td>
</tr>');

?>
<?
$i++;
}

echo "</table>";

?>

Working

Quote:

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM contacts WHERE first LIKE '%$search%' ORDER BY first, last ASC";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo ('<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th>Name</th>
<th>Phone</th>
<th>Mobile</th>
<th>Fax</th>
<th>E-mail</th>
<th>Website</th>
<th></th>
</tr>');

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

$id=mysql_result($result,$i,"id");
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");

echo ('<tr>
<td>'."$first".' '."$last".'</td>
<td>'."$phone".'</td>
<td>'."$mobile".'</td>
<td>'."$fax".'</td>
<td><a href="mailto:'."$email".'">E-mail</a></td>
<td><a href="'."$web".'">Website</a></td>
<td><a href="delete.php?id='."$id".'">Delete</a></td>
</tr>');

$i++;
}

echo ('</table>');

?>

The one that don't work is only giving out 1 person from the database, and only prints the 3 last rows. (E-mail, website and delete)

What am I doing wrong?
I can't seem to find the error..
I'm sure I'll scream out "Doh! That was it. How stupid of me not to see that" when you show me the error.. hehe

**Kyrnt** · 07-14-2004, 06:30 PM

aog,

Not sure why, but your script is using mysql_numrows() instead of mysql_num_rows(). Maybe it is a variant I'm not aware of.

**aog** · 07-14-2004, 06:33 PM

well..
I don't know either

but, mysql_numrows() works in the other script.
(the script who don't give a messag if nothing was found when searching.)

**Veter** · 07-14-2004, 06:39 PM

lol. put mysql_close(); at the bottom of the page

**aog** · 07-14-2004, 06:43 PM

well... the ressult is still the same.

**Veter** · 07-14-2004, 06:54 PM

Hmm. Here is how would i did:

Quote:

$row = mysql_fetch_assoc($result);
$num = mysql_num_rows($result);

And you can use your variables like $row['id'], $row['first'], etc. instead of

Quote:

$id=mysql_result($result,$i,"id");
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");

and

Quote:

<?php do { ?>
echo ('<tr>
<td>'."$first".' '."$last".'</td>
<td>'."$phone".'</td>
<td>'."$mobile".'</td>
<td>'."$fax".'</td>
<td><a href="mailto:'."$email".'">E-mail</a></td>
<td><a href="'."$web".'">Website</a></td>
<td><a href="delete.php?id='."$id".'">Delete</a></td>
</tr>');
<?php } while ($row = mysql_fetch_assoc($result)); ?>

**Veter** · 07-14-2004, 07:08 PM

This one is correct for your code

Quote:

<?php do {
echo "<tr>
<td>".$row['first']." ".$row['last']."</td>
<td>".$row['phone']."</td>
<td>".$row['mobile']."</td>
<td>".$row['fax.']"</td>
<td><a href='mailto:".$row['email']."'>E-mail</a></td>
<td><a href='".$row['web']."'>Website</a></td>
<td><a href='delete.php?id=".$row['id']."'>Delete</a></td>
</tr>";
} while ($row = mysql_fetch_assoc($result)); ?>

**aog** · 07-14-2004, 07:31 PM

hmm...

now I get this:

Quote:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/housemaa/public_html/db/test/sok.php on line 43

Name Phone Mobile Fax E-mail Website

line 43 is this: $fax=$row['fax'];

**Veter** · 07-14-2004, 07:50 PM

What is on 43 line?

**Veter** · 07-14-2004, 07:53 PM

Ahh sorry

Get rid of that line

And remove all such lines

**aog** · 08:09 PM

That helped

..but... take a look at this:
http://www.housemaadiah.com/db/test/sok.php
That is a search were I have entered the serach for Arne.
The 2 last outputs should not be there.. they don't exsicts in the database.
If you look at the "Delete" link, then you see it has link
http://www.housemaadiah.com/db/test/delete.php?id=.
All posts should have that link, but the post with id1 should have link http://www.housemaadiah.com/db/test/delete.php?id=1

EDIT:
Can I add some thing to $query="SELECT * FROM contacts WHERE first LIKE '%Arne%' ORDER BY first, last ASC"; saying that WHERE id LIKE $id
where $id = ( >= 1) or some thing like that?