Page 1 of 1

New to the forum, have many questions concerning PHP & MySQL

Posted: Wed Apr 16, 2008 1:31 pm
by french2080
Hello,

I read and looked through some of the tutorials concerning PHP development, and I have some basic questions I hope can be answered. I am creating a login section on my website and I am new to PHP and databases and I cannot seem to grasp the concept of creating the different .php files that do apparently different things to create authentification, sessions, login php check and other stuff. I am at work right now and I plan on being more specific with screen shots of the code. But the application I am working on is a micro-advertising system to deliever scaleable content to users locally in the Jacksonvill, Florida greater area.

I have FastJax2.0 coming out this summer and part of that will be a user login in which I plan of having the user answer some basic questions about them selves, I would assume radio buttons would do on the html part to indcate what goods and services they would like to see locally. However, after the intial setup, I would like to create an email account for each user and on the other end I need a login setup for advertisers from all walks of life looking to target their goods and services (websites) to the users of the search engine and email. I hope I am being clear, but I learned in programming that it is important to think the whole thinkg from the begining and put together a list of things that need to be accomplished and then implement them. So what what should I do to pre-pare for this section of the website and my knowledge on this is a php book from O'reily and MySQL book to reference from. Any suggestions would really go a long way for me. Thanks

-Chad- :?

Re: New to the forum, have many questions concerning PHP & MySQL

Posted: Wed Apr 16, 2008 2:05 pm
by matthijs
Take a few evenings to go through that PHP/mysql book, maybe buy another one and read through a few tutorials. That's what I'd start with. Then if you have a basic understanding of php, write a few snippets of code and if you have problems ask here in the php section.

Welcome to these forums.

Re: New to the forum, have many questions concerning PHP & MySQL

Posted: Wed Apr 16, 2008 2:57 pm
by french2080
Okay sounds good, I asume the the tutorials are up-to-date with what I have on the server. I think it the database is MYSQL 5.0. But I will most likely need help using the MYSQL interphase login form the server company I usre.

Like for example I tried to a attribute that measured the level of the login

i.e.:

username varchar(30) primary key,
password varchar(32),
userid varchar(32),
userlevel tinyint(1) unsigned not null,
email varchar(50),
timestamp int(11) unsigned not null

and it gave me a Syntax error on the userlevel mentioned it is was the not null function that was wrong....I will do a screen print later on today.

Re: New to the forum, have many questions concerning PHP & MySQL

Posted: Sun Apr 20, 2008 3:09 pm
by french2080
Do you think that it is I am using MySQL 5 and maybe I wrote something incorrectly above?

:?:

Re: New to the forum, have many questions concerning PHP & MySQL

Posted: Mon Apr 21, 2008 12:39 am
by matthijs
Hi, it's best if you post the piece of code that's causing you trouble. And then in the PHP-Code forum. If it is specifically database related you can also post in the Databases section. That way it's much easier for people to help.