php scripts to display data from MySql

[accelerator]

Tweet

Dear All

I am presently working on php scripts to display data from a MySql database containing data from xml product feeds.

Are there any good ready made scripts out there? The kind of things I will be needing are:
- display by product name
- display by category
- sort by price
- sort by brand
- search database
etc etc

Just wondered if any one could point me in the direction of some ready to go scripts that I could use/adapt instead of creating my own from scratch.

Many thanks

Accelerator

[morleymouse]

its not that hard just depends what query you run and how you sort the data is up to you

if your using phpMyAdmin you can sort the data how you want in there and it will show you the php qry

so like:

$result = mysql_query("SELECT * FROM database_table_name WHERE category = 'Category_Name' ORDER BY price desc LIMIT 0, 30") or die("Database Error" . mysql_error());

would get the data for all products in the table called "database_table_name" if the category of the product is "Category_Name" and sort the data by the field called price descending (alternative is asc - ascending) and the limit will only get 30 results.

then do a while statement to loop through and echo out what you want

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "$row[product_name]<br>";
}

that would just print out 30 of the product names (presuming you have a field called product_name) from category Category_Name with the highest prices.

loads of different ways to display the data between the while statement and lots of different data you can return with the $result depending on what you want


and thats the last bit of help im giving this year

[accelerator]

Thanks morleymouse, appreciated.

I'm still looking at this general area, and have been looking around for php scripts for searching MySql databases, tutorials, techniques etc etc.

Has anyone got any good urls they can point me at? I'm finding it difficult tracking down good examples.

Cheers

Accelerator

[JimboJetSet]

Thanks morleymouse, appreciated.

I'm still looking at this general area, and have been looking around for php scripts for searching MySql databases, tutorials, techniques etc etc.

Has anyone got any good urls they can point me at? I'm finding it difficult tracking down good examples.

Cheers

Accelerator

Well I got pissed off with phpmyadmin cos I had problems inserting new rows when some fields were of data-type TEXT.

So I downloaded a full-on mysql server management application http://enginsite.com/MySQL-client-ma...-for-MySQL.htm

Free for 30 days eval. Its rather slick, user-friendly and full-featured.

As for php resources try http://www.phpfreaks.com or http://www.phpbuilder.net and of course http://www.php.net/manual/en/

Regs

Jimbo