View Single Post
  #1 (permalink)  
Old 09-01-05, 06:17 PM
HoTDaWg's Avatar
HoTDaWg HoTDaWg is offline
Newbie Coder
 
Join Date: Aug 2005
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Question Cool tutorial I found, One of my scripts, and a question I REALLY NEED HELP WITH

Hi,

I am currently learning the outstanding feature of php know as, "User authentication". I found a great tutorial on it,
Here's the url:
http://www.howthenetworks.org/view.php?id=2

The script worked, and I decided to make a user panel
(A page which would display all the users and their details)
(You guys can use it for free as I based it on another tutorial I learned on http://www.greycobra.com/)

Here's the script:
Code:
<?php

//First, we need to connect to the server
//the format is $connection = mysql_connect("address","username","password");
$conn = mysql_connect("localhost","username","password");

//now choose the database to use
mysql_select_db("mydatabase");

$getusers = mysql_query("SELECT * FROM users ORDER BY id DESC");//query 
//the database for all of the news



while($r=mysql_fetch_array($getusers)){//while there 
//are rows in the table

extract($r);//remove the $r so its just $variable 




echo("<hr>

<font size=3>Username: $username <br></font>
<font size=3>Password: $password </font><p>");



}



?>
Now, my question is, how can delete a user from the database? As well as how can I edit a users details? I know it's a lot to ask for but, what else can I do? If you know any tutorials, or even better know the code PLZ HELP ME OUT. Help would be greatly appreciated.
Reply With Quote