PHP freaks
- Started
- Last post
- 16 Responses
- vsc
hello all, can anyone point me to a simple PHP tutorial on how to build a simple database feeding html iframes?
i need to build a site for architects. they will be indexing their projects in something like:
1st table data /row: Status/ProjectType/NumberDate/Ti...
table row:
Description.2nd tabledata:
1-5 clickable images.I would like to have a db file running all this and serving info to the page.
anyone? many many thx in advance.
- ********0
talk to COSMO
- jevad0
cosmo is the man
- ********0
i like this pic
- aka0
- BonSeff0
nuther vote for comso here
- version30
if you want php help online there is only one place
- vsc0
obrigado! (thx!)
i find it so difficult learning how to desing properly and code... surely not 1 man's job... i mean, there's no time left to live if we take it all. if it gets to difficult i must outsource the job.
that picture, ahaha! that's my dog barking over my shoulder in some mountain cruise where i live presently... that bark is about a million decibels smashing your brain... that's why i have no brains left for coding...
- vsc0
i'll try to find that Cosmo person tomorrow...
thanks all for the links.
- vsc0
aka from AUS = that looks simple enough for me to know how it works. I'll go into the other links after I get how the thing runs.
many thanks moites ;)
- Kevin_Sweeney0
PHP doesn't build databases. You CAN use it however, to grab data from sources like mySQL, Oracle, etc. You can even hook it up to Access, but that's a special case as you need to be hosted on a Windows box with the proper ODBC driver installed.
I suggest you find out what your hosting service supports (or maybe even supplies). Your best bet is going to be a mySQL database because it's free. It doesn't have a GUI, but you can install a php program called PHP myAdmin that will create an interface that you can access from your browser.
Here are some links to get you started:
http://www.php.net/
http://www.mysql.com/
http://www.phpmyadmin.net/
http://www.devshed.com/
http://www.freewebmasterhelp.com…
- ********0
i recommand this book if your just starting out http://www.amazon.com/exec/obido…
- vsc0
ok, thnks. it's 4 am here and i'm just unable to think. tomorrow I«ll check your kind links :)
thank you so much. I maybe needing some professional help (pays in Euros) so i'll be around for the best proposal. Meanwhile i'm gathering your profile e-mails. Cheers.
- tomkat0
as i can see you are from portugal.. search for a man called unfittoprint, he's portuguese and he got skills.
- dc_again0
er.... i'm not been funny (considering your title), but you have tried:
haven't you. it's really, really good.
anyway, really easy what you need to do. split it down into parts, that's the best way. first, install phpMyAdmin on your server:
http://www.phpmyadmin.net/home_p…this isn't as quick as using MySQL on the command line, but it is great when you're starting out. this will build your database for you (do some quick reading up on data types for your table columns).
then you'll need a quick tutorial on writing to a db and one for reading from a db, both of which you'll get from php freaks.
and that's it! from then on, it's about making your stuff bigger, better, faster, stronger.
good luck!
- unfittoprint0
I did this for a private section of my folio, including architectural stuff.
you need to create the following mysql tables:
#1 categories [categoryID, title, description]
#2 subcategories [subcategoryID, categoryID, title, description]
# projects [workID, subcategoryID, title, description, date, status]
#images [imageID, workID]
you'll have to LEFT JOIN all this tables in your query order to display your project's info.
mail me if you have any doubts regarding this procedure.
- vsc0
Thank's all so much for your help. Great links.
Unfit: Olá. Nesta fase vou arrancar com o site de forma simples. Tenho um mês para o fazer. É um projecto relativamente pequeno (em Euros...). Numa segunda fase que vou propôr (por outros Euros) gostava de implementar uma BD, e estou a avaliar agora se consigo fazer isso sozinho. Mas depois entro em contacto. Obrigado pela disponibilidade e as dicas.