Creating A Page To Edit Information And Update The Information On The Database

Arsenal_Rule

I recently (with some help from some good guys) created a page which displays the data in my sql database, in table form. I then designed it so that when you click on the users name in the table it will go to a view.php page, which shows further details of the user in question.

this is the code once we've gone into the view.php:

<?php
			if(isset($_REQUEST['id']))
			{
			$user_id = $_REQUEST['id'];

		$conn = mysql_connect("localhost","root","") or die("Could Not 

Connect To The Database"); 
		mysql_select_db("aziz",$conn) or die("Could Not Select The Database"); 

		//sql query somethinglike

		$sql = "SELECT * FROM azizpassword WHERE user_id = '".$user_id."'"; 
		$result = mysql_query($sql); 
		$row = mysql_fetch_assoc($result); 

	echo "<h1>"."Name:" . " " . $row['az_firstname'] . " " . $row['az_surname'] 

. "</h1>"; 
		echo "<h4>"."Username:" . " " . $row['username'] . " " . "</h4>";
		echo "<h4>"."User ID:" . " " . $row['user_id'] . " " . "</h4>";
		echo "<h4>"."Password:"." " . $row['password']. "</h4>";
		echo '<br> ';
		echo '<br> ';
		if (isset($HTTP_REFERER)) {echo "<a href='$HTTP_REFERER'>BACK</a>"; } 
		else {echo "<a href='javascript:history.back()'>BACK</a>"; 
		}


		}
		?>

What I need to do is to do is allow the information shown on view.php of the selected username to be allowed to be edited and then allowed to be updated on it's correct place on the database. Making sure that the data updated is the data chosen and shown on view.php.So I was wondering if anyone had any ways or suggestions in which to bring the data shown back in text boxes, so that i can update the table by typing, deleting and modifying, basically editing the information and then there will be a submit button which then clicking on the submit button it will update the information about that chosen user only on my sql database.

I hope someone can help me with this problem that would be great

Thank You really appreciate it

Take Care

LiLaaron

Alrite mate,

this is the first time i have helped someone 🙂

but this is a simple code to do.

So basically first we need to call the information before we can display it, so just from you code:

<?php 
            if(isset($_REQUEST['id'])) 
            { 
            $user_id = $_REQUEST['id']; 

        $conn = mysql_connect("localhost","root","") or die("Could Not 

Connect To The Database");  

        mysql_select_db("aziz",$conn) or die("Could Not Select The Database");  

        //sql query somethinglike 

        $sql = "SELECT * FROM azizpassword WHERE user_id = '".$user_id."'";  
        $result = mysql_query($sql);  
        $row = mysql_fetch_assoc($result);
}
?>

Now we have to make the text areas and boxes

<?php

echo "<center>Edit Your Information</center><br><br>"
	."<table border='0' align='center'>"
	.  "<form method='post' action='view.php'>"
.      "<label for='name'><strong>Name:</strong></label>"
		.      "<br>"
		.      "<input name='name' id='name' value='$row['az_firstname']' type='text' size='55' maxlength='55'>"
		.    "</td>"
		.  "</tr>"
		.  "<tr>"
		.  	 "<td>"
		.      "<label for='username'><strong>Username:</strong></label>"
		.      "<br>"
		.      "<input name='username' id='username' value='$row['username']' type='text' size='55' maxlength='55'>"
		.    "</td>"
		.  "</tr>"
		.  "<tr>"
		.  	 "<td>"
                                .      "<label for='userid'><strong>User ID:</strong></label>"
		.      "<br>"
		.      "<input name='userid' id='userid' value='$row['user_id']' type='text' size='55' maxlength='55'>"
		.    "</td>"
		.  "</tr>"
		.  "<tr>"
		.  	 "<td>"
                                .      "<label for='password'><strong>Password:</strong></label>"
		.      "<br>"
		.      "<input name='password' id='password' value='$row['password']' type='text' size='55' maxlength='55'>"
		.    "</td>"
		.  "</tr>"

	.  "<tr>"
	.  	 "<td>"
	.      "<input type='submit' value='Submit'>"
	.    "</td>"
	.  "</tr>"
	.  "<input type='hidden' name='user_id' value='$user_id'>"
	.  "<input type='hidden' value='savetodatabase.php'>"
	.  "</form>";

	echo "</table>";
?>

Now once they have editted there information, you will need to save it!

<?php

$sql ->sql_query ("UPDATE azizpassword
	  	SET 
	   	az_firstname='$name',
		username='$username',
		user_id='$userid',
		password='$password'
		WHERE user_id = '$user_id'");
?>

I dont no the name of you tables and databases and that but i think you should get the general idea

Hope this helps

🙂

Arsenal_Rule

Sup dude thank you very much for replying so quickly I have created the testview.php which calls the information before we can display it and view.php is where the information is viewed.

The code you gave for the textboxes area and the sql code does this all go in the view.php file.

Can you explain the code you given me for the text area and boxes and the sql code in more indepth so I can understand it more better see how everything links from the calling file (testview.php) to the viewing and editing file (view.php).

And also weather both codes you gave go together in the same PHP file view.php or in different ones. Basically I am a beginner with PHP I just want to understand what I have to do do solve this problem so hopefully you can help to understand to solve this problem more efficiently.

Thank you again fr replying so quickly

Take Care

LiLaaron

First of your welcome 🙂

There are some items of coding i get stuck on... like noobish... hint $_POST :rolleyes:

But neways...

You can do either make its own page maybe a popup or something up too you, but the code like calling the database and tables must be with it, or you can include the data

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

but anyways, what i basically done was called the information of the user, that will want to modify there information, and instead on displaying the information as text, i placed it in textboxs, but putting the code in the Value, then submitting the new information, this could also be in a new page, and maybe have something like, Information Successfully Updated, This page will close in 5 Seconds 😃 use your imagination for that part.

The mysql part, the first part was just a copy of your code, as editing the information will only need the same code to view it but in different contents and layout.

Sending the information, what we are doing here its basically updating the database, with giving it new information, without deleting or creating a new table, so we are updating the table instead.

All you have to do is make sure the correct table names are right and its in the correct order as you wouldnt want lets say password going in username now would ya ? :p

I reckon you should make different files, so then it wont confuse ya, do it like this for now, and when you progress then try and make it all 1 file, also mate, different files makes it easier to modify as you wont have to keep on search thru a large file for 1 piece of code :bemused: makes sense... huh?

anyways hope this helped

🆒