Forum Moderators: coopster

Message Too Old, No Replies

New to php and am trying to make a database

Trying to build an online community

         

madmatt69

6:39 am on Mar 13, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi everyone!

I'm really new to php, but I'm hoping to pick up a few tips and tricks on this forum. I have a site which I recently launched, and one of the features I'd like to add is a way that people can look up other users. Something where people can register, put in some info about themselves, and then search for other people in the same location of the world.

Does anyone know of a freeware php script/application that can do this, or one that I can modify and learn from?

Thanks for any help - Webmaster World is the best!

Cheers,
Matt

madmatt69

12:35 am on Mar 14, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Can ANYBODY give me some advice?

jatar_k

12:39 am on Mar 14, 2003 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



sorry madmatt69, this thread seems to have slipped by me.

Have you tried looking through sourceforge.net and hotscripts.com? They usually have some good stuff. It wouldn't be too tough to write from scratch either. A simple sign up form with an insert script and then a search form with a search script.

You could start with a simple db structure for learning and then go from there.

Is it with mysql?

madmatt69

4:36 am on Mar 14, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hey jatar_k, thanks for those sites - haven't heard of them! I'll have a look through.

Yeah, I'm thinking it'll probably have to use a mysql database. I've already got one set up with my isp, but again the problem is I don't know much of anything about how to use it :) About time I learned how!

Thanks!
Matt

jatar_k

5:11 am on Mar 14, 2003 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



well these you probably know but mysql.com and php.net are the two sites that count.

since these sites are a little hard to navigate when you aren't 100% sure where to start try some of these

PHP
MYSQL Functions [php.net]
Function Reference [php.net] When looking through the function reference just think of what data you are working with and you can probably find a page full of functions
working with files - Filesystem Functions [php.net]
working with strings - String Functions [php.net]

I'm sure you get my drift. Some other useful ones
Getting Started [php.net]
Predefined Variables [php.net]
Language reference [php.net]

MySQL
Documentation [mysql.com]
Tutorial Introduction [mysql.com]
Language Reference [mysql.com]

Some Basic/Essential Commands
CREATE, DROP, ALTER [mysql.com]
SELECT, INSERT, UPDATE, DELETE [mysql.com]
Functions for use with GROUP BY [mysql.com]

[edited by: jatar_k at 8:17 pm (utc) on April 9, 2003]

madmatt69

5:24 am on Mar 14, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Wow - Thank you! That'll give me lots of reference material :)