By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,964 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,964 IT Pros & Developers. It's quick & easy.

A real challenge for real PHP programmers

P: n/a
<?php
/*
A challenge to every PHP programmer.The one who's gonna solve this
problem would be deemed as

PSP(PHP Supreme Programmer).The problem is this : You have to write a
script that displays a list of

categories and subcategorieslike this one:

<select name="category">
<option value="1">Main</option>
<option value="2">Main > Computers</option>
<option value="4">Main > Computers > Hardware </option>
<option value="8">Main > Computers > Hardware > PC</option>
<option value="7">Main > Computers > Hardware > Mac</option>
<option value="9">Main > Computers > Hardware > Atari</option>
<option value="11">Main > Computers > Hardware > PC > History of
Pc</option>
<option value="">etc...</option>
</select>
The categories and subcategories details are stored in these two
tables in a MySQL database.
-categories : the categories names and ids.
-cat_relations : the relations between categories.It shows which
subcategory belongs to which category.
The belongings between categories can go very deep and the number of
categories is unlimited. This script will create the two tables and
fill them with sample data. All you need to do is to change the four
variables below. You can send the script back to this email :
ya******@yahoo.com.
*/

//Here starts the script. Please change the values of these variables
to fit your settings
$user = "prospective_PSP";
$database = "db";
$server = "localhost" ;
$pwd = "" ;
//Connection to the database that you created
mysql_connect($server,$user,$pwd) ;
mysql_select_db($database);
//Creation of the two tables : categories and cat_relations
$categories = " CREATE TABLE `categories` (`id` INT not null
AUTO_INCREMENT, `name` VARCHAR(100) not null , PRIMARY KEY (`id`),
INDEX (`id`), UNIQUE (`id`)) comment = 'The categories details' ";
mysql_query($categories) ;
$cat_relations = "CREATE TABLE `cat_relations` (`id` INT not null
AUTO_INCREMENT, `daughter_id` INT not null, `mother_id` INT not null ,
PRIMARY KEY (`id`), INDEX (`id`), UNIQUE (`id`)) comment = 'Which
category is the daughter of which category'";
mysql_query($cat_relations) ;

//Filling the two tables with sample data
$cats = array('Main','Computers','Countries','Hardware','S oftware','Programming
languages','Mac','PC','Atari','Winamp','History of the
PC','IBM','Components','High
level','USA','NYC','LA','Manhattan','India','Winzi p');
for ($i=0;$i<count($cats);$i++){
$sql = mysql_query("insert into categories (name)
values('".$cats[$i]."')");
}
mysql_query("insert into cat_relations (daughter_id,mother_id) values
(2,1),(3,1),(4,2),(5,2),(6,2),(7,4),(8,4),(9,4),(1 1,8),(12,8),(13,8),(10,5),(20,5),(14,6),(15,3),(16

,15),(17,15),(18,16),(19,3)");
//Now you can have a look on them through phpMyAdmin
?>
Jul 17 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 12 Dec 2003 20:38:23 -0800, ya******@yahoo.com (Brian Murphy) wrote:
<?php
/*
A challenge to every PHP programmer.The one who's gonna solve this
problem would be deemed as

PSP(PHP Supreme Programmer).The problem is this : You have to write a
script that displays a list of


Are you trying to get custom made scripts for free?

If you are having trouble with a piece of code and need some help, just
ask. That's one thing, but I suspect you are just being cheap. I'm sure
there are a lot of good PHP coders here that would be more than willing to
write your code for you, provided you reciprocate with cash.

Just my humble opinion.

T

Jul 17 '05 #2

P: n/a
Tom Lynn <to*******@hotmail.com> writes:
On 12 Dec 2003 20:38:23 -0800, ya******@yahoo.com (Brian Murphy) wrote:
<?php
/*
A challenge to every PHP programmer.The one who's gonna solve this
problem would be deemed as

PSP(PHP Supreme Programmer).The problem is this : You have to write a
script that displays a list of


Are you trying to get custom made scripts for free?

If you are having trouble with a piece of code and need some help, just
ask. That's one thing, but I suspect you are just being cheap. I'm sure
there are a lot of good PHP coders here that would be more than willing to
write your code for you, provided you reciprocate with cash.

Just my humble opinion.


Not to mention the low standard for the "PHP Supreme Programmer"
appellation. Sounds more like a kind of pizza.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Jul 17 '05 #3

P: n/a
Tom Lynn wrote:
Are you trying to get custom made scripts for free?

If you are having trouble with a piece of code and need some help, just
ask. That's one thing, but I suspect you are just being cheap. I'm sure
there are a lot of good PHP coders here that would be more than willing to
write your code for you, provided you reciprocate with cash.

Just my humble opinion.


Sounds more like some cheesy kid trying to get his homework done for free.
--
Bob
Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.