PDA

View Full Version : Using mySQL tables to fill pages on my site.



vincependley
01-24-2007, 03:16 PM
Hello, I have been working on a online form for professsors to fill out at our local college to put the syllabus info on. They would hopefully fill out the blanks and then it would show them the formatted syllabus and they could print it out. I've got the forms and tables. How do I get the db to interact with a page?

Thanks for your help
Vince Pendley

http://www.wildcatcountryonnicholasville.com

navaldesign
01-24-2007, 05:26 PM
Youneed a custom made script in php to do that. If you wish, visit Forms and DB Applications scripting Services (http://www.vodahost.com/vodatalk/services/17337-forms-db-applications-scripting-services.html)

tp22
01-28-2007, 05:10 PM
Hi Naval -

Is mySQL the best way to create consistent tables on a page? If so, is there a tutorial?

Here is a sample page that I would use this for:
http://www.onlinedegreechannel.com/online-project-management-training.html

Ideally, I'd like to be able to use the database to switch the individual entries on and off and to have the table on the page respond dynamically, without my having to manually adjust tables on the page. Is this possible?

Also, is it possible to have the table rows width respond dynamically to the amount of text input into the database? eg some rows might need 5 lines of text, while others would need 10.

Thanks very much!
tp22

navaldesign
01-28-2007, 05:34 PM
Yes, MySQL is the best way. No tutorial here though.

Yes, table rows can be dunamicaly (it is done automatically, no special effort to acheive that) to the amount of content in one of the cels.

There is no tutorial here, but there are many on the net. Do a google search

However, the tables are almost pure html. Only the cell content makes use of php to echo the necessary text. Also the images are retreived from the database, but you are going to need a sub-script to retreive the image file from the database,automatically resize it to the appropriate dimensions and display it, as i do in my search directory scripts.

Make a submission from my contact form (http://www.dbtechnosystems.com/contact.php). You will receive a html autoresponder message. If you use a comments text long enough, you will see how the table (it's in a table) automatically resizes the row.

tp22
01-28-2007, 05:38 PM
Thanks for your instant response Naval, extremely helpful. I see I have a lot of learning to do... I will search the web to get started. Thank you very much!

Any other replies are also welcome! Thanks all...

tp22