[Resolved] Displaying MySQL data onto webpage

Jon12345

I have a MySQL database full of data. About 5 fields in the database and one table.

I want to click a link and it will go to that page and display the relevant data.

What code do I need for:

The link
The page that displays the data?

TheDefender

You'd need the code to connect to the DB, Query the DB, and Fetch the array results. Then, it's a matter of echoing out the fields in a loop. Since it's the simplist of basics in MySQL, I am not going to give you any details, since very simple searching of these forums as well as the PHP manual will get you some results. (and I realize you are a newbie posting in the newbie forums, but being a newbie doesn't justify a lack of effort, only a lack of knowledge.)

Here's some stuff for you to start looking at...
[man]mysql_db_connect[/man]
[man]mysql_query[/man]
[man]mysql_fetch_array[/man]

Jon12345

Ahh, great links. Thanks! I now have it listing my data.

I will have an A to Z of links across the top of my page. When I click F, I want it to display all the entries in the database that begin with F. This I can do using the WHERE statement.

But what do I put on the link itself?

Do I pass a parameter and then this gets stored in a variable that I use to query the database? Are there any good examples of this?

Jon12345

I'm testing this bit of code:

$result = mysql_query("SELECT * FROM Articles WHERE TopicName='%filter' ORDER BY TopicName");

I have a link that sets the variable filter to a value, e.g. F

When I click the link I go to a page that has the above filter. It should then only show all Topics that begin with the letter F.

I am making good progress here! But stuck on this.

Any ideas?

Norman_Graham

Hi Jon

You add the variable to the URL in the link, i.e. http://www.mysite.com/mypage.php?myvariable=X

At the top of the page mypage.php you pick up the variable using $_GET[] and then do whatever you have to do with it.

HTH

Norm

Jon12345

I managed to get that bit. But how do I filter out stuff using the parameter passed? In my SQL statement, I am not sure how to filter the list so it only shows items that are beginning with the first letter of the variable passed

e.g. If filiter=F it should show all the Topics which begin with F.

What modifications do I need to my existing SQL string to achieve that?

Norman_Graham

Hi Jon

Like this:

$filter=$_GET['filter'];
$sql="SELECT * FROM mytable WHERE filter='$filter'";

You just substitute hard-coded values for variables in your select statements.

HTH

Norm

TheDefender

MySQL has some nifty functions for this...

$filter=$_GET['filter']; 
$result = mysql_query("SELECT * FROM Articles WHERE upper(left(TopicName,1))='".$filter."' ORDER BY TopicName");

This assumes you are passing a capital letter in the variable as in your example.

Jon12345

Yes, that did it! Thank you so much. I now have almost completed my mini project! Thought it was completely beyond me.

Can also refer to my examples now for future sites.

🙂