Miscellaneous > Programming & Networking

Database

<< < (3/3)

Calum:
MoR changed it yesterday   ;)   but thank you for the debugs guys, maybe we can work it now...

edit - aha! not that i know what i am doing, but try http://members.lycos.co.uk/faqfuckmicrosoft/index2.php now!!
(sorry, but that's a big acheivement for me...)

[ September 17, 2002: Message edited by: Calum ]

voidmain:
That php link does show that the PHP code is now being executed.  Now you just have to get the database/tables etc created and throw some data into it.

I would suggest creating a FAQ entry page that would be used to populate the database, and an edit page that would allow you to change FAQ entries.  The "add" and "edit" and "delete" pages can actually be the same page using the same FORM fields but just change the role via passed parameters. You would use "insert" and "update" queries for this and of course FORMS in your HTML...  If you need examples or help with this I can whip up a very basic page that will work for your database and could be a starting point for you to refine/beautify.

Once you get the basic functionionality of select/insert/update/delete then you can refine the way you want to display the data and add search functionality (which is really very easy).

Of course you will not want the world to have the ability to add/edit/delete FAQ entries so you will want to also add authentication into those pages.  Does the server you have the database on allow "htaccess" authentication?  I would assume they do.  You can either use "htaccess/htpasswd" files to control access to the "editor" page(s) or you can write http authentication into your PHP scripts.  There are examples of this on php.net that should give you the basics for building authentication into your scripts:
http://www.php.net/manual/en/features.http-auth.php

[ September 17, 2002: Message edited by: void main ]

Calum:
created the table alright, but i think i will leave it to the quirk to write the php for now...

rtgwbmsr:
On a similar note:
At 6-7 PM EST (11-12 PM GMT) I will switch to Linux for hopefully the last configuration, and stay put in Linux. I may need help, so stick around.
After I get SSH working, if anyone wants to log on to the server and help me it would be greatly appreciated.

[ September 17, 2002: Message edited by: The_Muffin_Man/B0b ]

TheQuirk:
I uploaded it onto Lycos after it didn't work on my machine, then I had to go and didn't get to actually make hte database. I'll try now.

Edit: Doh, nevermind! Calum got it already!

[ September 17, 2002: Message edited by: TheQuirk ]

Navigation

[0] Message Index

[*] Previous page