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

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
french2080
Forum Newbie
Posts: 6
Joined: Wed Apr 16, 2008 12:34 pm

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

Post 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- :?
matthijs
DevNet Master
Posts: 3360
Joined: Thu Oct 06, 2005 3:57 pm

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

Post 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.
french2080
Forum Newbie
Posts: 6
Joined: Wed Apr 16, 2008 12:34 pm

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

Post 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.
french2080
Forum Newbie
Posts: 6
Joined: Wed Apr 16, 2008 12:34 pm

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

Post by french2080 »

Do you think that it is I am using MySQL 5 and maybe I wrote something incorrectly above?

:?:
matthijs
DevNet Master
Posts: 3360
Joined: Thu Oct 06, 2005 3:57 pm

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

Post 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.
Post Reply