PDA

Click to See Complete Forum and Search --> : Ideas Needed

spinnyscripter
10-12-2005, 09:52 PM
Hi, i was just wondering if any of you would like to give me som ideas and some info on what i need to start a project for my own training and the benifet of everybody out on the net!!!!!


Daniel.
spinnyscripter
10-12-2005, 09:56 PM
just nothing big like a forum or a full CMS Syatem please a simple and easy starter project :D :D :D


:D :D :D :D :D for being Cheeky
cwrath
10-13-2005, 05:56 AM
Task Management System with User Authentification, that was my first one.

Post and edit tasks,
You can a user management system with Sessions

i would design it first, enter some example data then start with the php.
spinnyscripter
10-13-2005, 06:59 AM
so, start with a database and then write scripts to read, edit, and delete tasks from the database.
spinnyscripter
10-13-2005, 09:39 AM
what if i was to design the databse in access and the make it in MySQL and enter sample data like that?
cwrath
10-13-2005, 10:24 AM
hmm design in access? well...


you can actually get an access to mysql program, a demo version is availible which will convert the first three rows of every table (and create the tables)


however, you should really do it by hand, its a lot easier (Zend do have an inbuilt table editor/creator).


and you should be getting familiar with basic SQL syntax


CREATE DATABASE
CREATE TABLE

INSERT INTO table VALUES ('','3','4')

SELECT * FROM

REPLACE INTO

UPDATE

etc.



Yes always start from a database, sometimes i dont and it always ends up in a mess.
spinnyscripter
10-13-2005, 10:28 AM
ok, good advice. i have a program called SQLyog and that allows me to design from it. but not visually. like access i cant see what the table looks like intilli have completely wrote the code and run it and the looked at the structure
cwrath
10-13-2005, 10:33 AM
i know what you mean, that is why i write out what the table will look like
spinnyscripter
10-13-2005, 11:03 AM
ok, i remember doing somthing like this on my GNVQ ICT 2 cource at college you list all the feilds and make the conections and include the one to many many to many and one to one links?
cwrath
10-13-2005, 11:39 AM
NO! NO NO! dont do that. You want relationships? FOREIGN KEYS as they are call in database-speak. Sigh. That can get complicated. It can also be quite simple. You will have to find tutorials on how to do that, look up foriegn keys mysql.

Oh and i didnt like GNVQ ict, waste of time, i was teaching the teachers by the end of it.

most of the time 'relationships' will make something getting the data eaiser but manipulating it harder. I simply use 'advanced' select statements or a combination of select statements, because all-to-often my 'relationships' are serverely limited.
spinnyscripter
10-13-2005, 12:01 PM
ok, well i have just found problems in my installation of PHP such as it wont connect to MySQL saying the mysql_connect() function undefined so i hvae to fix this first.
cwrath
10-13-2005, 12:48 PM
there isnt a problem with your php installation, php5 does not have mysql_?? functions turned on by default, some licensing problem...
spinnyscripter
10-13-2005, 12:55 PM
well, i cant be bother with configaration of servers so i am ownloading and installing a new server (a complete ready configerd server)
spinnyscripter
10-13-2005, 12:59 PM
[QUOTE=cwrath]
Oh and i didnt like GNVQ ict, waste of time, i was teaching the teachers by the end of it.
QUOTE]

I went to Exeter College for Mine. Didn't finish the course it drove me mad trying to learn stuff i knew and all the coursework!!!!!!!
cwrath
10-13-2005, 01:48 PM
"it drove me mad trying to learn stuff i knew and all the coursework!"

indeed
spinnyscripter
10-13-2005, 02:31 PM
well, add ADHD on top of that and boom a catastrophy