Jump to content

users management(php, sqlite, sql)

compaq

By compaq
in PHP Coding Help

Recommended Posts

compaq Newbie

compaq

Posted
Posted

Hello everybody.

 

I need to create a website, this for a school project.

Website is almost ready, it has the right look, and everything, but every user gets the same content, same tasks, same mail messages

, as he/ logs in.

So, all users must get same page, but with different content out the database, after he logs in.

I copied the source of my website into this message, please look at it.

I hope this topic is clear.

 

---------------database----------------

 

-- phpMyAdmin SQL Dump

-- version 2.11.4

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generatie Tijd: 02 Jun 2008 om 10:26

-- Server versie: 5.0.51

-- PHP Versie: 5.2.5

 

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

 

--

-- Database: `memberdb`

--

 

-- --------------------------------------------------------

 

--

-- Tabel structuur voor tabel `members`

--

 

CREATE TABLE IF NOT EXISTS `members` (

  `id` int(11) NOT NULL auto_increment,

  `username` text NOT NULL,

  `password` text NOT NULL,

  `ip` text NOT NULL,

  `status` text NOT NULL,

  UNIQUE KEY `id` (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

 

--

-- Gegevens worden uitgevoerd voor tabel `members`

--

 

INSERT INTO `members` (`id`, `username`, `password`, `ip`, `status`) VALUES

(1, 'jansen', '202cb962ac59075b964b07152d234b70', '127.0.0.1', '1');

 

 

INSERT INTO `members` (`id`, `username`, `password`, `ip`, `status`) VALUES

(1, 'mark', '202cb962ac59075b964b07152d234b70', '127.0.0.1', '3');

 

 

 

 

 

 

 

 

-------------------------------------This is my index.php(page where users log in)--------------------------------------

 

<html><head><!-- ICT bedrijf --><title>index</title></head><body alink="#fbd50a" bgcolor="#000000" text="#f8f7d9" vlink="#ffffff">

 

<H1><P SIZE=8 ><div align="left">ICT bedrijf</div></P></H1>

 

<br><br>

<p align="center"><b>Om deze site te kunnen bekijken heeft u een gebruikersnaam en een wachtwoord nodig !</b><br>

<br>

<br>

 

<center>

<style type="text/css">

<!--

 

body {

background-color: #000000;

}

-->

</style>

  <title>ICT bedrijf</title><font size=3>

  <FORM action="index.php" method="post">

  <div align="center"><p><b><b> Gebruikersnaam:       

  <INPUT type="text" name="username" size=25></div>                 

  <div align="center"><p><b><b> Wachtwoord:       

         <INPUT type="password" name="pass" size=25><br></div>

                  

               <input type="submit" value="Login" name="submit"> 

  </form>

 

<?

if(isset($_POST['submit'])) {

  $username = trim(strtolower($_POST['username']));

  $pass1 = $_POST['pass'];

  $dead = "false";

  $message = "<font size=1 face=verdana>Fill in the following fields correctly";

  if(strlen($username) <= 1 or strlen($username) >=15){

      $dead = "true";

      $message .= "Username (2-14)<br>";

  }

  if(strlen($pass1) < 6 or strlen($pass1) > 20) {

      $dead = "true";

      $message .= "Password (6-20)<br>";

  }

  if($dead = "false"){

      include('connect.php');

      $pass1 = md5($pass1);

      $query = mysql_query("SELECT status FROM members WHERE username = '$username' and password = '$pass1'");

      $rows = mysql_num_rows($query);       

 

  if($rows > 0){       

        echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=start.html\">";

            $row = mysql_fetch_assoc($query);

        $username = mysql_real_escape_string($username);

        $_SESSION['login']=true;         

        $_SESSION["username"]=$username;

        $_SESSION['rank']  = $row['status'];       

      }

      else{

          echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=fout.html\">";

      }       

     

  }

  else{

      print $message;

  }

}

 

?>

</form>

<h1><div align="center">Goedendag meneer <?php echo htmlspecialchars($_POST['username']); ?>.</div></h1>

</center>

<br>

<HR>

<HR>

<P SIZE=5 ><font face="Times New Roman"><font size="-1"><br>

5456 HR Groningen<br>

The Netherlands<br>

tel: (023) 593 41 98<br>

fax: (023) 593 41 98<br>

</P>

</body></html>

 

 

 

 

 

 

 

---------------------------------------------------------------mededelingen.php----------------------------------------

 

<?php include("nl.php"); ?>

<html>

<head>

<!-- ICT bedrijf-->

 

<title>Mededelingen</title>

</head>

 

<body bgcolor="#000000" link="#d4d4d4" text="#f8f7d9" vlink="#fce503">

 <p>

 

<h1><?=$TEXT['mededelingen-head']?></h1>

 

<?=$TEXT['mededelingen-text1']?><p>

<?=$TEXT['mededelingen-text2']?><p>

 

 

<!-- hieronder een lichtkrant, na loop kan een aantal ingegeven worden of:INFINITE -->

<marquee loop="infinite">

<font face="Comic Sans MS, Verdana, sans-serif, Times New Roman"><font size="-1">Vergeet niet om regelmatig uw scherm te verversen!

</font></font></marquee>

</body>

</html>

<hr>

<hr>

 

<?php

 

if (!($db = sqlite_open('databases/mededelingen', '0666'))) {

echo "<h2>".$TEXT['mededelingen-error']."</h2>";

die;

}

?>

 

<h2><?php echo $TEXT['mededelingen-head1']; ?></h2>

 

<table border="0" cellpadding="0" cellspacing="0">

<tr bgcolor="#000033">

<td><img src="afbeeldingen/blank.gif" alt="" width="10" height="25"></td>

<td class="tabhead"><img src="afbeeldingen/blank.gif" alt="" width="150" height="6"><br><b><?php echo $TEXT['mededelingen-attrib1']; ?></b></td>

<td class="tabhead"><img src="afbeeldingen/blank.gif" alt="" width="150" height="6"><br><b><?php echo $TEXT['mededelingen-attrib2']; ?></b></td>

<td class="tabhead"><img src="afbeeldingen/blank.gif" alt="" width="150" height="6"><br><b><?php echo $TEXT['mededelingen-attrib3']; ?></b></td>

<td class="tabhead"><img src="afbeeldingen/blank.gif" alt="" width="50" height="6"><br><b><?php echo $TEXT['mededelingen-attrib4']; ?></b></td>

<td><img src="afbeeldingen/blank.gif" alt="" width="10" height="25"></td>

</tr>

 

<?php

$firstname=$_REQUEST['firstname'];

$lastname=$_REQUEST['lastname'];

$phone=$_REQUEST['phone'];

 

if($firstname!="")

{

sqlite_query($db,"INSERT INTO users (firstname,lastname,phone) VALUES('$firstname','$lastname','$phone')");

}

 

if($_REQUEST['action']=="del")

{

sqlite_query($db,"DELETE FROM users WHERE id={$_REQUEST['id']};");

}

 

$result=sqlite_query($db,"SELECT id,firstname,lastname,phone FROM users ORDER BY phone ASC;");

 

$i = 0;

while ($row = sqlite_fetch_array($result)) {

if ($i > 0) {

echo "<tr valign='bottom'>";

echo "<td bgcolor='#000033' height='1' colspan='6'></td>";

echo "</tr>";

}

echo "<tr valign='middle'>";

echo "<td class='tabval'><img src='afbeeldingen/blank.gif' alt='' width='10' height='20'></td>";

echo "<td class='tabval'><b>".$row['lastname']."</b></td>";

echo "<td class='tabval'>".$row['firstname']." </td>";

echo "<td class='tabval'>".$row['phone']." </td>";

 

echo "<td class='tabval'><a onclick=\"return confirm('".$TEXT['mededelingen-sure']."');\" href='mededelingen.php?action=del&id=".$row['id']."'><span class='red'>[".$TEXT['mededelingen-button1']."]</span></a></td>";

echo "<td class='tabval'></td>";

echo "</tr>";

$i++;

}

 

echo "<tr valign='bottom'>";

echo "<td bgcolor='#000033' colspan='6'><img src='afbeeldingen/blank.gif' alt='' width='1' height='8'></td>";

echo "</tr>";

 

sqlite_close($db);

?>

 

</table>

 

<h2><?=$TEXT['mededelingen-head2']?></h2>

 

<form action=mededelingen.php method=get>

<table border=0 cellpadding=0 cellspacing=3>

<tr><td><?=$TEXT['mededelingen-attrib1']?>:</td><td><input type=text size=42 name=lastname></td></tr>

<tr><td><?=$TEXT['mededelingen-attrib2']?>:</td><td> <input type=text size=42 name=firstname></td></tr>

<tr><td><?=$TEXT['mededelingen-attrib3']?>:</td><td> <input type=text size=10 name=phone></td></tr>

<tr><td></td><td><input type=submit border=0 value="<?=$TEXT['mededelingen-button2']?>"></td></tr>

</table>

</form>

 

</body>

</html>

 

<HTML>

 

 

<HEAD>

 

 

<title>mededeling sturen dmv. mailto</title>

 

<SCRIPT LANGUAGE="JavaScript">

 

 

<!--

 

 

   

function mailIt(form) {

var data = document.dataForm

var userInfo = ""

 

  form.action += "?subject=" + data.subject.value

 

  userInfo += "Page Title:  " + document.title + "\n"

  userInfo += "Mailed From: " + document.location + "\n\n"

  userInfo += "gegevens afzender      " + "\n"

  userInfo += "_______________________________" + "\n"

  userInfo += "naam          :" + data.naam.value + "\n"

  userInfo += "adres          :" + data.adres.value + "\n"

  userInfo += "postcode    :" + data.postcode.value + "\n"

  userInfo += "plaats        :" + data.plaats.value + "\n\n"

  form.mailBody.value = userInfo + data.body.value

 

  return true

}

 

// -->

</SCRIPT>

 

</HEAD>

 

<body  bgcolor="#ffffff" text="#000000" link="#b41b2e" vlink="#b41b2e" alink="#5d0d34" >

<hr>

 <p>

 

<h2><?=$TEXT['mededelingen-mailen']?></h2>

 

<FONT SIZE=5>

 

 

<TABLE>

 

<FORM NAME="dataForm"><!-- <TR>

 

  <TH ALIGN=right>Recipient:

 

  <TD><INPUT NAME="recipient" SIZE=40 VALUE="[email protected]">

 

</TR>

-->

  <TBODY>

 

<TR>

 

  <TH ALIGN=right>Onderwerp:

 

  <TD><INPUT NAME="subject" SIZE=40 ></TD>

 

<TR>

 

  <TH ALIGN=right VALIGN=top>Vraag:

 

  <TD><TEXTAREA name=body rows=5 wrap=virtual cols=30></TEXTAREA></TD>

<TR>

 

  <TH ALIGN=right>Afzender:

 

  <TD></TD>

 

<TR>

 

  <TH ALIGN=right>Naam:

 

  <TD><INPUT NAME="naam" SIZE=40 ></TD>

 

 

</FORM>

    <FORM name=mailForm onsubmit="return mailIt(this)"

    action="mailto:[email protected]" method=post encType=multipart/form-data

    ?><INPUT type=hidden name=mailBody>

  <TR>

    <TD align=middle colSpan=2>

      <P><INPUT id=submit1 type=submit value="Verstuur het bericht" name=submit1>

      </P>

      <P align=left> </P>

 

 

      <P align=left><FONT size=5> </FONT></P>

    </TD></FORM></TR></TBODY></TABLE>

 

<P></FONT></P></body></HTML>

 

 

 

 

 

 

 

 

 

 

--------------------------------------------taken.php--------------------------------------------------------------------

 

<?php include("nl.php"); ?>

<html>

<head>

<!-- ICT bedrijf -->

 

<title>Taken</title>

</head>

 

<body bgcolor="#000000" link="#d4d4d4" text="#f8f7d9" vlink="#fce503">

 <p>

 

<h1><?=$TEXT['taken-head']?></h1>

 

<?=$TEXT['taken-text1']?><p>

 

 

</body>

</html>

<hr>

<hr>

 

<?php

 

if (!($db = sqlite_open('databases/taken', '0666'))) {

echo "<h2>".$TEXT['taken-error']."</h2>";

die;

}

?>

 

<h2><?php echo $TEXT['taken-head1']; ?></h2>

 

<table border="0" cellpadding="0" cellspacing="0">

<tr bgcolor="#000033">

<td><img src="afbeeldingen/blank.gif" alt="" width="10" height="25"></td>

<td class="tabhead"><img src="afbeeldingen/blank.gif" alt="" width="50" height="6"><br><b><?php echo $TEXT['taken-attrib6']; ?></b></td>

<td class="tabhead"><img src="afbeeldingen/blank.gif" alt="" width="200" height="6"><br><b><?php echo $TEXT['taken-attrib1']; ?></b></td>

<td class="tabhead"><img src="afbeeldingen/blank.gif" alt="" width="200" height="6"><br><b><?php echo $TEXT['taken-attrib2']; ?></b></td>

<td class="tabhead"><img src="afbeeldingen/blank.gif" alt="" width="100" height="6"><br><b><?php echo $TEXT['taken-attrib3']; ?></b></td>

<td class="tabhead"><img src="afbeeldingen/blank.gif" alt="" width="50" height="6"><br><b><?php echo $TEXT['taken-attrib5']; ?></b></td>

<td class="tabhead"><img src="afbeeldingen/blank.gif" alt="" width="50" height="6"><br><b><?php echo $TEXT['taken-attrib4']; ?></b></td>

<td><img src="afbeeldingen/blank.gif" alt="" width="10" height="25"></td>

</tr>

 

<?php

$firstname=$_REQUEST['id'];

$firstname=$_REQUEST['firstname'];

$lastname=$_REQUEST['lastname'];

$phone=$_REQUEST['phone'];

$procent=$_REQUEST['procent'];

 

if($firstname!="")

{

sqlite_query($db,"INSERT INTO users (firstname,lastname,phone,procent) VALUES('$firstname','$lastname','$phone')");

}

 

if($_REQUEST['action']=="del")

{

sqlite_query($db,"DELETE FROM users WHERE id={$_REQUEST['id']};");

}

 

                                $result=sqlite_query($db,"SELECT id,firstname,lastname,phone,procent FROM users ORDER BY phone ASC;");

 

$i = 0;

while ($row = sqlite_fetch_array($result)) {

if ($i > 0) {

echo "<tr valign='bottom'>";

echo "<td bgcolor='#000033' height='1' colspan='6'></td>";

echo "</tr>";

}

echo "<tr valign='middle'>";

echo "<td class='tabval'><img src='afbeeldingen/blank.gif' alt='' width='10' height='20'></td>";

echo "<td class='tabval'><b>".$row['id']."</b></td>";

echo "<td class='tabval'><b>".$row['lastname']."</b></td>";

echo "<td class='tabval'>".$row['firstname']." </td>";

echo "<td class='tabval'>".$row['phone']." </td>";

                                        echo "<td class='tabval'>".$row['procent']." </td>";

 

echo "<td class='tabval'><a onclick=\"return confirm('".$TEXT['taken-sure']."');\" href='takenb.php?action=del&id=".$row['id']."'><span class='red'>[".$TEXT['taken-button1']."]</span></a></td>";

echo "<td class='tabval'></td>";

echo "</tr>";

$i++;

}

 

echo "<tr valign='bottom'>";

echo "<td bgcolor='#000033' colspan='6'><img src='afbeeldingen/blank.gif' alt='' width='1' height='8'></td>";

echo "</tr>";

 

sqlite_close($db);

?>

 

</table>

<br>

<hr>

 

                <h2><?=$TEXT['taken-head2']?></h2>

<?=$TEXT['taken-text2']?><p>

 

<form method="post">

<input name="id">

<input name="procent">

<input type="submit" value="Ja">

</form>

 

<?php

 

if (!($db = sqlite_open('databases/taken', '0666'))) {

echo "<h2>".$TEXT['taken-error']."</h2>";

die;

}

?>

<?php

 

sqlite_query($db, "UPDATE users SET procent = '$_POST[procent]' WHERE id='$_POST[id]'");

?>

 

</body>

</html>

 

Link to comment
https://forums.phpfreaks.com/topic/117934-users-managementphp-sqlite-sql/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.