Web Hosting Vodahost    

Home Take The Royal Tour! Order Now Features Prices
Go Back   Web Hosting > VodaHost Web Hosting Support > mySQL & PHP

Notices

mySQL & PHP Discussions, information and help with mySQL and PHP.

Reply
 
LinkBack Thread Tools
  #1  
Old 01-24-2007, 04:16 PM
Private
 
Join Date: Jan 2007
Posts: 1
Question Using mySQL tables to fill pages on my site.

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2  
Old 01-24-2007, 06:26 PM
navaldesign's Avatar
General & Forum Moderator
 
Join Date: Oct 2005
Location: Italy
Posts: 9,346
Default Re: Using mySQL tables to fill pages on my site.

Youneed a custom made script in php to do that. If you wish, visit Forms and DB Applications scripting Services
__________________
Navaldesign
Logger Lite: Low Cost, Customizable, multifeatured Login script
Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old 01-28-2007, 06:10 PM
Staff Sergeant
 
Join Date: Sep 2006
Posts: 44
Question Re: Using mySQL tables to fill pages on my site.

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/o...-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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4  
Old 01-28-2007, 06:34 PM
navaldesign's Avatar
General & Forum Moderator
 
Join Date: Oct 2005
Location: Italy
Posts: 9,346
Default Re: Using mySQL tables to fill pages on my site.

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. 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.
__________________
Navaldesign
Logger Lite: Low Cost, Customizable, multifeatured Login script
Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5  
Old 01-28-2007, 06:38 PM
Staff Sergeant
 
Join Date: Sep 2006
Posts: 44
Thumbs up Re: Using mySQL tables to fill pages on my site.

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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 On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 03:32 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC7
2005-2009 VodaHost Web Hosting Your Perfect Web Host - All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176