Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

PHP Forum


You are currently viewing our PHP Forum as a guest. Please register to participate.
Login



Freelance Jobs

Reply
Php Category Index Using MySQL Back
Old 06-16-2011, 09:53 PM Php Category Index Using MySQL Back
Brian07002's Avatar
Defies a Status

Posts: 2,162
Name: ...
Location: ...
Trades: 0
Hi,

I have looked almost everywhere on the INTERNET (found nothing so far) for a 'stand alone' php script that I could simply create categories (subcategories a plus) via an admin area, set a link to each category and output them on to a page in a horizontal layout. Pagination built in would be a big plus, but not really needed if the script can be modified to add it.

Anyone know of such a script? I am building an advertising site using a very basic ad manager script, NOT a fully featured ad manager package. I just want to look like the big guys.

An example of how I would like the layout is here: http://www.reunitemysite.com/scripts/links/

Of course, the categories are the under the text block and the table code. 3 across

Thank you for looking in advance!
Brian
__________________
Made2Own

Please login or register to view this content. Registration is FREE

Last edited by Brian07002; 06-16-2011 at 10:21 PM..
Brian07002 is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 06-17-2011, 08:58 AM Re: Php Category Index Using MySQL Back
Super Spam Talker

Posts: 879
Name: Paul W
Trades: 0
Quicker to write your own, I'd have thought. Database = one table for category, one table for site with each keyed to category, then the script does one query to get category link and site count, and outputs a bit of HTML with CSS on it.

Or am I missing something?
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE


*** New:
Please login or register to view this content. Registration is FREE
PaulW is offline
Reply With Quote
View Public Profile
 
Old 06-17-2011, 05:41 PM Re: Php Category Index Using MySQL Back
Brian07002's Avatar
Defies a Status

Posts: 2,162
Name: ...
Location: ...
Trades: 0
How much would you charge to do something like that for me? Cause you got it right. As long as you follow what I have wrote in the first post, you will be ok. I am just not good with programming. It's funny, cause I learned alot over the years, but I am still not ready to begin a project on my own yet. Let me know.

Thank you.
Brian
__________________
Made2Own

Please login or register to view this content. Registration is FREE
Brian07002 is offline
Reply With Quote
View Public Profile
 
Old 06-17-2011, 06:11 PM Re: Php Category Index Using MySQL Back
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,384
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Actually starting a project that you WANT to work is the best way to increase your programming skills.

Tutorials are fine but nothing beats your own projects.
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 06-17-2011, 06:27 PM Re: Php Category Index Using MySQL Back
lynxus's Avatar
Awesomeo-Maximo

Posts: 1,618
Location: UK
Trades: 1
Quote:
Originally Posted by chrishirst View Post
Actually starting a project that you WANT to work is the best way to increase your programming skills.

Tutorials are fine but nothing beats your own projects.

I couldn't agree more.

Ive had more than my fair share of "Please help me" threads on here, Each one answered perfectly.

I would do the following.
- Understand exactly what you are trying to achieve ( Draw it on some paper? )
- Break it down into smaller parts that you can work on.
- Work on each bit, by bit.
+ Stuck on a small bit? Ask here.

What your looking for is quite a basic system that tbh can be done by anyone with some basic sql and php / perl / whatever.

id suggest reading these two:
http://www.tizag.com/phpT/
http://www.tizag.com/mysqlTutorial/

( They look long,, But they are not.. )

Take your time and I promise you that after completing these two sections ( may some html and css also ) and you will be able to do this yourself.

While this may take longer than you want, It means that any future ideas you have can be realised quicker ( and cheaper / free )
__________________

Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE



Last edited by lynxus; 06-17-2011 at 06:28 PM..
lynxus is offline
Reply With Quote
View Public Profile Visit lynxus's homepage!
 
Old 06-17-2011, 10:42 PM Re: Php Category Index Using MySQL Back
Brian07002's Avatar
Defies a Status

Posts: 2,162
Name: ...
Location: ...
Trades: 0
For some strange reason, I am having one of those "don't know where to begin" moments. Someone just give me a clue on how to start this project, and I will try to figure it out.

I really didn't want this to turn into a big project for myself, but even if it does turn out that way, I guess I won't mind, but having a step in the correct direction will make me feel better at attempting this project.
__________________
Made2Own

Please login or register to view this content. Registration is FREE

Last edited by Brian07002; 06-17-2011 at 10:56 PM..
Brian07002 is offline
Reply With Quote
View Public Profile
 
Old 06-18-2011, 11:31 AM Re: Php Category Index Using MySQL Back
Super Spam Talker

Posts: 879
Name: Paul W
Trades: 0
Think of the page you want to generate as several discrete sections, perhaps start, middle and end. Start and end will be mainly static HTML, perhaps with the odd variable like page title. Write a function for each start_page($title) and end_page() perhaps.

Now another function for the middle bit. This connects to db and runs the query. Then it outputs each returned row, ie db values with a bit of HTML/CSS around them. Your script is thus:

Code:
start_page($title);
do_middle();
end_page();
Now refine the middle bit if you want.
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE


*** New:
Please login or register to view this content. Registration is FREE
PaulW is offline
Reply With Quote
View Public Profile
 
Old 06-18-2011, 11:35 AM Re: Php Category Index Using MySQL Back
Super Spam Talker

Posts: 879
Name: Paul W
Trades: 0
And the middle function is just:

Code:
 
connect to database
execute query
for each row returned
    echo values and markup
end-for
close db connection
Worry about paging and layout as and when you need to - go for the simple top-down approach and life is so much easier.
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE


*** New:
Please login or register to view this content. Registration is FREE
PaulW is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Php Category Index Using MySQL Back
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.37729 seconds with 12 queries