Looking for some help with a simple PHP/MYSQL Database.

CookieD89 · 09-30-2008, 05:11 PM

Hi everyone,

I am currently looking at writing up a simple PHP/MYSQL database for work.. & i'm after some advice as to how I can go about it.
I have installed Xampp etc and I am running the pages I create via http://localhost/something.php.

What I am after is a simple login system, where users can register an account, login, and log the amount of hours they do each day.
They do work for a number of different states/terriroties, so they'd have to be able to select from a dropdown box which state they worked for and the amount of hours for each.

I had a look online and found some scripts 'PHP Login System with Admin feature' See - ( http://www.evolt.org/PHP-Login-Syste...Admin-Features )
So I've tweaked that a little bit and have it all working/talking to the local mySQL database. What I want is when users login to have their OWN page come up.. where they can enter in their data for the day, modify their data for previous days, but not anyone elses. How hard would it be to get a calander in there, that might make things easier. A set of tables that displays the data and generates weekly/monthly totals would also be a good idea.

I also want to have the admin feature set up so that an account with administrative rights can login and be able to print out simple tables or export an excel spreadsheet that contains the total number of hours worked for each State by all. (Adds everybody's information together) .. perhaps being able to select "Week ending" Or "For the month of August" .. so I'd obviously have it connecting into the database and running queries to pull this info out.

It is so very simple to visualise it but I need help as to how I would construct/setup the tables in mySql and what kind of types they will be! Like Varchart etc. Finally, are there any programs, or web resources/forums that will assist me in generating php code, CSS sheets (I plan to create a simple one, with a nav bar across the top, and use the include feature to make all the pages have the same formatting) ? If anybody would be able to take the time to give me a few pointers so that I have more of an idea about how I am going to tackle this I would really appreciate it. I plan to have this running on one of the servers at work so It has to be easily movable without the need to change *too* many lines in the script.

If you need any more information from me just ask!
Thanks in advance guys . :)

Slapshot · 10-03-2008, 02:37 PM

That evolt tut is a bit outdated. Your going to have to do a lot of modifications. Try Joomla.org and see if you can find a mod that has what you need.

Also, I'm a freelance PHP coder so I can code it for you at a small price if you'd like.

**dm01** · 10-03-2008, 04:36 PM

http://www.devshed.com/c/a/PHP/Creat...-Login-Script/ is probably more what you are looking for. We can assist in building everything else you require.

A simple login form:

HTML Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--PHP data-->
<?PHP
	$employeename = $_POST["employeename"]    ;
	$password =  = $_POST["password"]    ;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--PHP data-->
<?PHP
	$employeename = $_POST["employeename"]    ;
	$password =  = $_POST["password"]    ;
?>
<!--end PHP data-->
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<title>Employee Login</title>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
<!--Form-->
	<form method="post" action="<?php echo $PHP_SELF;?>">
		<p>
			<input type="text" name="employeename" value="Employee Name" />
			<br />
			<input name= type="password" "password" />
			<br />
			<input type="submit" value="submit" />
		</p>
	</form>
<!--End form-->
</body>
</html>

Indentation added for readability, but not required.

User pages would be kind of a pain, but are possible.

Slapshot · 10-03-2008, 07:18 PM

Of course, make sure you clean the variables

**carsey** · 10-04-2008, 07:07 AM

What do you want your PHP database to do?

I could probly supply you some coding which lets you have a login system with login protected pages, a simple database and echoing of that data on a page.

Slapshot · 10-04-2008, 08:09 AM

www.techtuts.com

Lots of tuts including a usersystem with a crapload of addon tuts. It might not be exactly what you want.

09-30-2008, 05:11 PM	#1 (permalink)
CookieD89 Registered User Join Date: Sep 2008 Posts: 2 OS: WindowsXP SP3	Looking for some help with a simple PHP/MYSQL Database. Hi everyone, I am currently looking at writing up a simple PHP/MYSQL database for work.. & i'm after some advice as to how I can go about it. I have installed Xampp etc and I am running the pages I create via http://localhost/something.php. What I am after is a simple login system, where users can register an account, login, and log the amount of hours they do each day. They do work for a number of different states/terriroties, so they'd have to be able to select from a dropdown box which state they worked for and the amount of hours for each. I had a look online and found some scripts 'PHP Login System with Admin feature' See - ( http://www.evolt.org/PHP-Login-Syste...Admin-Features ) So I've tweaked that a little bit and have it all working/talking to the local mySQL database. What I want is when users login to have their OWN page come up.. where they can enter in their data for the day, modify their data for previous days, but not anyone elses. How hard would it be to get a calander in there, that might make things easier. A set of tables that displays the data and generates weekly/monthly totals would also be a good idea. I also want to have the admin feature set up so that an account with administrative rights can login and be able to print out simple tables or export an excel spreadsheet that contains the total number of hours worked for each State by all. (Adds everybody's information together) .. perhaps being able to select "Week ending" Or "For the month of August" .. so I'd obviously have it connecting into the database and running queries to pull this info out. It is so very simple to visualise it but I need help as to how I would construct/setup the tables in mySql and what kind of types they will be! Like Varchart etc. Finally, are there any programs, or web resources/forums that will assist me in generating php code, CSS sheets (I plan to create a simple one, with a nav bar across the top, and use the include feature to make all the pages have the same formatting) ? If anybody would be able to take the time to give me a few pointers so that I have more of an idea about how I am going to tackle this I would really appreciate it. I plan to have this running on one of the servers at work so It has to be easily movable without the need to change too many lines in the script. If you need any more information from me just ask! Thanks in advance guys . :)

10-03-2008, 02:37 PM	#2 (permalink)
Slapshot Registered User Join Date: Feb 2008 Posts: 269 OS: Vista	Re: Looking for some help with a simple PHP/MYSQL Database. That evolt tut is a bit outdated. Your going to have to do a lot of modifications. Try Joomla.org and see if you can find a mod that has what you need. Also, I'm a freelance PHP coder so I can code it for you at a small price if you'd like.

10-03-2008, 07:18 PM	#4 (permalink)
Slapshot Registered User Join Date: Feb 2008 Posts: 269 OS: Vista	Re: Looking for some help with a simple PHP/MYSQL Database. Of course, make sure you clean the variables

10-04-2008, 07:07 AM	#5 (permalink)
carsey Moderator, TSF Articles Join Date: Aug 2006 Location: Hunwick, Co. Durham England Posts: 9,847 OS: XP Pro SP3 My System	Re: Looking for some help with a simple PHP/MYSQL Database. What do you want your PHP database to do? I could probly supply you some coding which lets you have a login system with login protected pages, a simple database and echoing of that data on a page. __________________ Submit New Articles Here

10-04-2008, 08:09 AM	#6 (permalink)
Slapshot Registered User Join Date: Feb 2008 Posts: 269 OS: Vista	Re: Looking for some help with a simple PHP/MYSQL Database. www.techtuts.com Lots of tuts including a usersystem with a crapload of addon tuts. It might not be exactly what you want.