Can Someone Point me to An Example?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
BobH - TAN
Forum Newbie
Posts: 20
Joined: Mon Mar 20, 2006 7:09 pm
Location: Texas

Can Someone Point me to An Example?

Post by BobH - TAN »

Hello,

I'm learning HTML, CSS, PHP, and Javascript using web tutorials and looking at websites to see examples of how it's done then adapting things to my needs. I'm not a for-hire developer, just a hacker (an old one at that - I'm 64) building a high school class website and a family site.

My high school class was over 500 people. It's too much to code pages of addresses and biographical data directly in HTML and try to keep from breaking the code. My server host provides me with a few mySQL database. I think this is the right tool for me with PHP or Javascript to access it. What I want to do is host forms for gathering data and write (or adapt) scripts to do the actual db adds/changes/deletes.

Can someone tell me if I'm heading in the right direction, and if not point me in a better one?

Also, if this sounds reasonable, can you point me to some sample scripts that scrape forms and update mySQL?

I've already built a website (http://www.broughton1960.com) that has pages with forms that I intend to use on it. Take a look at it to get a better idea of what I'm trying to do. None of the forms are functional yet, meaning that users can't enter data and I can't scrape it yet.

(Yeah, that's my ugly mug in the photo.)

TIA
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post by s.dot »

I was a bit bored and built a sample form you could look at for inserting a name into a database
You can modify it or rebuild it based on the logic it presents.

http://65.29.93.164/scottayy/sample_form.phps

good luck!
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post by Benjamin »

This might help you as well. It's a link to the MySQL PHP functions. Scroll down to the table of contents for a list of them. http://www.php.net/manual/en/ref.mysql.php Also, you can download the PHP manual in a Windows compiled help file using the link in my signature.

scottayy wrote:I was a bit bored and built a sample form you could look at for inserting a name into a database
You can modify it or rebuild it based on the logic it presents.
That was very thoughtful of you. I'm sure that should help him out quite a bit.
BobH - TAN
Forum Newbie
Posts: 20
Joined: Mon Mar 20, 2006 7:09 pm
Location: Texas

You Guys are FANTASTIC

Post by BobH - TAN »

agtlewis = I downloaded the zip. Thanks!

I really appreciate you help, too, scittayy and feyd!

I found a tute that looked like it was written just for my question at: http://www.freewebmasterhelp.com/tutorials/phpmysql/8

I hope this is not violating protocol here. If it is, whack me good! :oops: :oops:

I posted the link only because I thought it might help someone searching on DevNetwork.

Thanks a BUNCH, guys!

BobH - The Ancient Noob
Post Reply