Learn VBA & Macros in 1 Week!

PHP - Cms Update/edit Function Not Working

Full Excel VBA Course - Beginner to Expert

Cms Update/edit Function Not Working	View Content

I am trying to create a CMS management website, but I can't seem to get the update function to work. Everything else works fine but not the update function. Can anyone please tell me why or what the problem is? I have spent too long trying to fix it and have failed. It is correctly linked to the database when I hit the edit button all i get is UPDATE_CONTENT_FORM($_GET['ID'])?>where the text boxes should be is . Please help, I am really stuck. (sorry about spelling )
code in CMS_Class.php

Class modernCMS{

var $host='localhost';
var $username='lmcmanus13';
var $password='k0gl0zfh3g1ccm4v';
var $db='lmcmanus13';

function connect(){
$con = mysql_connect($this->host, $this->username, $this->password);
mysql_select_db($this->db,$con);
}

function get_content($id =''){

if ($id != ""):
$id = mysql_real_escape_string($id);//helps to protect database from beening hacked 
$sql = "SELECT * FROM `CMS_Content` WHERE id ='$id'";

else:
$sql = 'SELECT * FROM `CMS_Content` WHERE 1';

endif;

//$query = 'SELECT * FROM `CMS_Content` WHERE 1';
$result = mysql_query($sql) or die(mysql_error());

if (mysql_num_rows($result)!=0):
while($row= mysql_fetch_assoc($result)){
echo '<h1><a href="Animals.php?id=' . $row['id'] . '">' . $row['Title'] . '</h1>';
echo '<p>' . $row['Body'] . '</p>';
}
else:
echo '<p> we are sorry there seems to be a problem with your request</p>';
endif;
echo $return='<p><a href ="Animals.php">Back</a></p>';

}

function add_content($_POST){

$Title= mysql_real_escape_string($_POST['Title']);
$Body= mysql_real_escape_string($_POST['Body']);

if(! $Title || ! $Body):
if(!$Title=""):
echo"<p>The Title is required<p>";
endif;
if(!$Body=""):
echo"<p>The Body is required<p>";
echo '<a href="add-content.php">Try Again</a>';
endif;
else:
$sql="INSERT INTO `CMS_Content`(`id`, `Title`, `Body`) VALUES ('null','$_POST[Title]','$_POST[Body]')";
$result = mysql_query($sql) or die(mysql_error());
echo "<meta http-equiv='refresh' content='0;url=added.php'>";
endif;
} 

function manage_content (){
echo '<div id ="manage">';
$sql = 'SELECT * FROM `CMS_Content`';
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)):
echo '<h1><a id=' . $row['id'] . '">' . $row['Title'] . '</h1>'
?>
<div>
<span ><a href="update-content.php?id=<?php= echo= $row['id']?>">Edit</a>|<a href="?delete=<?php echo $row['id']; ?>">Delete</a></a></span>
</div>

<?php
endwhile;
echo '</div>';//closes the manages div
}

Function delete_content($id){

if(!$id){
return false;
}else{
$id=mysql_real_escape_string($id);
$sql="DELETE FROM CMS_Content WHERE id='$id'";
$result = mysql_query($sql) or die(mysql_error());
echo "<meta http-equiv='refresh' content='0;url=deleted.php'>";
}
function update_content_form($id) {
$id = mysql_real_escape_string($id);
$sql = "SELECT * FROM CMS_Content WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($res) 
?>
<form action="Animals.php" method="post" > 
<input type="hidden" name="update" value="true" />
<input type="hidden" name="id" value="<?php=$row['id']?>" />
<div>
<label for="title">Title:</label>
<input type="text" name="Title" id="Title" value="<?php=$row['Title']?>" />
</div>
<div>
<label for="body">Body:</label>
<textarea name="body" id="body" rows="8" cols="40"><?php=$row['Body']?></textarea>
</div>
<input type="submit" name="submit" value="Update content" />
</form>
<?php

function update_content($p) {
$title = mysql_real_escape_string($s['title']);
$body = mysql_real_escape_string($s['body']);
$id = mysql_real_escape_string($p['id']);

if(!$title | !$body):

if(!$title):
echo "<p>The Title is Required</p>";
endif;
if(!$body):
echo "<p>The body is Required</p>";
endif;
echo '<p><a href=" update_content.php?id=' . $id . '">Try Again</a></p>';
else:
$sql = "UPDATE CMS_Content SET title = '$title', body = '$body' WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
echo "Updated Successfully!";
endif;
}
}
}//end of class
}
?>

code in Animals.php

<h1> Our Animals </h1>



<ul>
<li><a href="manage-content.php">Manage Content</a></li>
<li><a href="add-content.php">Add Content</a></li>
</ul>

<?php 
if(isset($_POST['add'])):
$obj->add_content($_POST);
elseif(isset($_POST['update'])):
$obj->update_content_form($_POST);
endif; 
?>
Code in update-content.php
<h1> Our Animals j,j</h1>
<h1> Update Content </h1> 
<?=$obj->update_content_form($_GET['id']) ?>

Edited by Ch0cu3r, 10 December 2014 - 11:47 AM.
Added code tags

Full Excel VBA Course - Beginner to Expert

Mysqli Update Function Not Working

Similar Tutorials

View Content

Hi, i have a user update function in my code so I can easily change user fields int he database
public function updateUser ($username, $value, $what) {
$q = "UPDATE `users` SET ? = ? WHERE username = ?";
if ($stmt = $this->db_connection->prepare($q)) {
$stmt->bind_param("sis", $what, $value, $username);
$stmt->execute();
}
}

The database is connected successfully, but say i run a updateUser('blaine0002', 'blah', 'password'); nothing would get updated and no errors are thrown.
Am i doing something wrong? Thank you!

Update Form/function Not Working. Can't Figure Out Why

Similar Tutorials

View Content

I've tried a few different methods, but I can't get this damn function to work. Can someone show me where I've gone wrong?

Here's my code & form. I'm still baffled why it doesn't work! :lol:

url is update-content.php?id=12

<?php
    include("../include/session.php");

      if(!$session->logged_in)
      {
          header('Location: ../login.php');
          die;
      }
    require_once('../include/functions.php');


    function content($id)
    {
        $id = $_GET['id'];
        $connection = db_connect();
        $query = sprintf("select * from content where id = '$id'",
                                     mysql_real_escape_string($id)
                                     );

            $result = mysql_query($query);
            $number_of_posts = mysql_num_rows($result);
            if ($number_of_posts == 0)
            {
              return false;
            }
            $row = mysql_fetch_array($result);
            return $row;
    }

function update($param)
{
     // Get the content id from url to output into the editor
     $id = $_GET['id'];
     $connect = db_connect();

            $page = mysql_real_escape_string($_POST['page']);
            $page_id = mysql_real_escape_string($_POST['page_id']);
            $title = mysql_real_escape_string($_POST['title']);
            $text = mysql_real_escape_string($_POST['text']);

            $query = ("UPDATE content SET
                                                page = '$page'
                                                page_id = '$page_id'
                                                title = '$title'
                                                text = '$text'
                                             WHERE id = '$id'
                                             ");
             $result = mysql_query($query);

            if (!$result) {
                return false;
            } else {
                return true;
            }
}

?>

<?php
        // Send form data to mysql
        if(isset($_POST['text']))
        {
            $result = update($_POST);
            if($result === true)
            {
                echo 'Success!';
                die();
            }
        }

?>

And the form..

<form form name="editor" id="editor" method="post"  action="update-content.php">
  <p><br />
        <b>Assign to page</b><br />
          <input name="page" id="page" size="60" maxlength="500" value="<?php $page = content($id);  echo stripslashes($page['page']); ?>" />

          <br />
          <br />
          <b>Page id</b>
          <input  name="page_id" id="page_id" size="4" maxlength="4" value="<?php $page_id = content($id); echo stripslashes($page_id['page_id']); ?>" />
          <br />
          <br />

    <b>Title</b>
           <span class="smalltext">(Just a short name this piece of content)</span><br />
          <input name="title" id="title" size="60" maxlength="200" value="<?php $title = content($id);  echo stripslashes($title['title']); ?>" />
          <br />
          <br />
          <br />
      <strong>Content</strong> <span class="smalltext">(paste html in here)</span><br />
      <textarea name="text" id="text" cols="75" rows="15"><?php $text = content($id); echo stripslashes($text['text']); ?></textarea>
      <?php //turn the text area into CK Editor  echo $ckeditor_ini; ?>
          <br />
          <input type="image" src="../images/button_submit.gif" alt="submit" name="submit" value="submit" />
  <a href="index.php"><img src="../images/button_cancel.gif" alt="Cancel" width="120" height="26" border="0" />
    </form>

Status Update Form Edit Functionality

Similar Tutorials

View Content

Hello Freaks,

I am currently working on a status report web application. A user inputs what they are planning on accomplishing that week. Afterwords realizes that they made a mistake and need to correct it. The way I want to go about this is sql the database and return * where the username and report date are current.

With the results of this query I insert them into the form as the value. This yields a populated form. From here I want the user to be able to change any line and submit the whole form. However, the post array is only populated with one row of data. I thought this might have to do with the names of the inputs all being the same so i tried to index those through the while loop with no luck.

Any help would be appreciated!

here's the code

Code: [Select]
<?
// renaming sess var
$UAID = $_SESSION['UAID'];
$WEND = $_SESSION['WEEK_ENDING2'];

//have we submitted our changes?
if($EDIT == TRUE){

//how many task are there this week
$results = mysql_query("Select COUNT(UAID) FROM `WPFTW` where UAID ='$UAID' and Rend = '$WEND'");
$row = mysql_fetch_row($results);

//clean $_POST
print_r($_POST);
unset($_POST['Report']);
echo "<br>";
print_r($_POST);

}
//what do we plan on editing
$results = mysql_query("Select * FROM `WPFTW` where UAID ='$UAID' and Rend = '$WEND'");

//while there are results
while($row = mysql_fetch_array($results)){

//increment for input name
$k = 1;

//date formatting
list($year,$month,$day) = explode("-",$row['Target']);
$row['Target'] = $month."-".$day."-".$year;

//empty string to uncheck checkboxes
$checked = "";

//populate checkboxes
if($row['MS'] == "on"){
$checked = "yes";
}

//select the correct drop down menu option
if(isset($row['Status'])){
if($row['Status'] == " "){
$selected = "selected";
$selected1 = "";
$selected2 = "";
$selected3 = "";
}

elseif($row['Status'] == "P"){

$selected = "";
$selected1 = "selected";
$selected2 = "";
$selected3 = "";
}

elseif($row['Status'] == "C"){

$selected = "";
$selected1 = "";
$selected2 = "selected";
$selected3 = "";
}

elseif($row['Status'] == "CL"){

$selected = "";
$selected1 = "";
$selected2 = "";
$selected3 = "selected";
}
}

//select the correct drop down menu option
if(isset($row['OT'])){
if($row['OT'] == "Y"){
$selected4 = "selected";
$selected5 = "";
}

elseif($row['OT'] == "N"){

$selected4 = "";
$selected5 = "selected";
}
}

//var to send form to self
$cani = htmlentities($_SERVER['PHP_SELF']);

//concatenate html & php for form
$test = "<form id =\"2bigform\" action=$cani method = \"post\">" . "<tr>" .
"<td><input id=\"hidden\" name=\"UAID$k\" type=\"hidden\" value=" . $_SESSION['UAID'] ."></td>".
"<td width=\"7%\"> <input id=\"SR\#$k\" name=\"SR#\" type=\"text\" size=\"10%\" maxlength=\"10\" value=" . $row['SRNUM'] . "></td>" .
"<td width=\"63%\"> <input id=\"Task$k\" name=\"Task\" type=\"textarea\" size=\"63%\" value=" . $row['Task'] . "></td>" .
"<td width=\"7%\"> <select id=\"Status$k\" name=\"Status\">".
" <option value=\" \" $selected></option>".
" <option value=\"P\" $selected1>P</option>".
" <option value=\"C\" $selected2>C</option>".
" <option value=\"CL\" $selected3>CL</option>".
"</select></td>".

"<td width=\"7%\"> <input id=\"MS$k\" name=\"MS\" type=\"checkbox\" size=\"7%\" value=" . $row['MS'] . " checked = $checked></td>".
"<td width=\"7%\"> <select id=\"OT$k\" name=\"OT\">".
" <option value=\"Y\" $selected4>Y</option>".
" <option value=\"N\" $selected5>N</option>".
"</select></td>".

"<td width=\"9%\"> <input id=\"Target$k\" name=\"Target\" type=\"text\" size=\"9%\" value=" . $row['Target'] . "></td>".
"<input id=\"hidden\" name=\"RDate$k\" type=\"hidden\" value=" . $_SESSION['WEEK_ENDING'] ."></td></tr>";
echo $test;
$k++;
echo $k;
}
echo "</table>".
"<input id=\"Sub\" type= \"Submit\" name=\"Report\" value= \"Submit\"/>".
"</form>".
"</body>".
"</html>";

//<td width="7%"> <input id="SR#" name="SR#" type="text" size="10%" maxlength="10"/></td>
//<td width="63%"> <input id="Task" name="Task" type="textarea" size= "63%"/></td>

}
?>

Need A Generic Update Function To Update A Mysql Table

Similar Tutorials

View Content

Can anyone post a generic update function to update mysql table.
The manual approach:

update $tablename
set $column1='a', $column2='b'
where $id=$value;

Edit Function For A Php

Similar Tutorials

View Content

hi...again got in a mess...i m developing this ticketing system where once i check the checkbox and press the edit button,it takes me to the edit page with the same ticket no to be printed there....how do i do this
i have attached the two pages for your smooth understanding
attachment 1-->page where i check the ticket no from a list of ticket nos
attachment2-->page where the ticket no must be displayed as checked on the previous page

help is appreciated in advance....

'edit' Function

Similar Tutorials

View Content

Hey guys,
i'm making an edit feature on my website so i can delete,edit or add more jobs,
so far i've made the delete and add function's work
however i can't seem to get the edit to work
This is the edit function
Code: [Select]
if ($action == "edit"){
print("<strong>Editing a Job:</strong>");
$editid = $_GET['editid'];
$s = 'SELECT * FROM jobs WHERE id="$editid"';
$sql = mysql_query($s) or die ('Error: '.mysql_error () . " IN $s");
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$job_title = $row['job_title'];
$job_description = $row['job_description'];
$job_type = $row['job_type'];
$job_area = $row['job_area'];
$query2 = "UPDATE jobs SET (job_title, job_description, job_type, job_area, hot_job) VALUES ('$job_title', '$job_description', '$job_type', '$job_area', '$hot') WHERE id=$id";
echo("<form name='add' method='post' action='?action=edit'>");
echo("<input type='hidden' name='?action=edit'>");
echo("<table class=main cellspacing=0 cellpadding=5 width=50%>");
echo("<tr><td>Job Title: </td><td align='right'><input type='text' size=50 name='job_title' value='$job_title'></td></tr>");
echo("<tr><td>Job Description: </td><td align='right'><textarea size=50 name='job_description'>$job_description</textarea></td></tr>");
echo("<tr><td>Job Type: </td><td align='center'><select name='job_type'><option>Permanent</option><option>Locum or Contract</option></SELECT></td></tr>");
echo("<tr><td>Hot Job? </td><td align='center'>Yes <input type='radio' name='hot' value='Yes'> No <input type='radio' name='hot' value='no'></td></tr>");
echo("<tr><td>Job Area: </td><td align='center'><select name='job_area'><option>East Anglia</option><option>All UK</option><option>London / South East</option><option>Midlands</option><option>North West</option><option>Northern Ireland</option><option>Scotland</option><option>South</option><option>South West</option><option>Southern Ireland</option><option>Wales</option><option>Yorkshire / North East</option></SELECT></td></tr>");
echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>");
echo("</table>");
}
Here is the whole code,
Code: [Select]
<?php
include'modules/sides/header.php';
?>
<table cellpadding="0" cellspacing="0" width="100%" id="mainTable">
<tr>
<td class="left">
<?php include'modules/sides/left.php';?>
</td>
<td id="centercolumn">
<table class="cont" cellspacing="0">
<tr>
<td id="centerCcolumn">
<div class="block">
<?php

if(session_is_registered('username')){
if ($userlevel = 3){ ?>
<div class="blockTitle">Administration - Add/Remove Jobs</div>
<div class="blockContent">
<?php
$action = $_GET["action"];
if ($action == "delete"){
$delid = $_GET['delid'];
$query = "DELETE FROM jobs WHERE id=".$delid." LIMIT 1";
$sql = mysql_query($query);
echo("Job succesfully deleted! [ <a href='add_jobs.php'>Back</a> ]");
}
if ($action == "edit"){
print("<strong>Editing a Job:</strong>");
$editid = $_GET['editid'];
$s = 'SELECT * FROM jobs WHERE id="$editid"';
$sql = mysql_query($s) or die ('Error: '.mysql_error () . " IN $s");
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$job_title = $row['job_title'];
$job_description = $row['job_description'];
$job_type = $row['job_type'];
$job_area = $row['job_area'];
$query2 = "UPDATE jobs SET (job_title, job_description, job_type, job_area, hot_job) VALUES ('$job_title', '$job_description', '$job_type', '$job_area', '$hot') WHERE id=$id";
echo("<form name='add' method='post' action='?action=edit'>");
echo("<input type='hidden' name='?action=edit'>");
echo("<table class=main cellspacing=0 cellpadding=5 width=50%>");
echo("<tr><td>Job Title: </td><td align='right'><input type='text' size=50 name='job_title' value='$job_title'></td></tr>");
echo("<tr><td>Job Description: </td><td align='right'><textarea size=50 name='job_description'>$job_description</textarea></td></tr>");
echo("<tr><td>Job Type: </td><td align='center'><select name='job_type'><option>Permanent</option><option>Locum or Contract</option></SELECT></td></tr>");
echo("<tr><td>Hot Job? </td><td align='center'>Yes <input type='radio' name='hot' value='Yes'> No <input type='radio' name='hot' value='no'></td></tr>");
echo("<tr><td>Job Area: </td><td align='center'><select name='job_area'><option>East Anglia</option><option>All UK</option><option>London / South East</option><option>Midlands</option><option>North West</option><option>Northern Ireland</option><option>Scotland</option><option>South</option><option>South West</option><option>Southern Ireland</option><option>Wales</option><option>Yorkshire / North East</option></SELECT></td></tr>");
echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>");
echo("</table>");
}
}
if ($action == "add"){
$add = $_POST['add'];
$job_title = $_POST['job_title'];
$job_description = $_POST['job_description'];
$job_type = $_POST['job_type'];
$job_area = $_POST['job_area'];
$hot = $_POST['hot'];
$id = mysql_insert_id();
$query = "INSERT INTO jobs (id, job_title, job_description, job_type, job_area, hot_job) VALUES ('$id', '$job_title', '$job_description', '$job_type', '$job_area', '$hot')";
$sql = mysql_query($query) or die (mysql_error());
}
print("<strong>Add A New Job!</strong>");
print("<br />");
print("<br />");
echo("<form name='add' method='post' action='?action=add'>");
echo("<input type='hidden' name='?action=add'>");

echo("<table class=main cellspacing=0 cellpadding=5 width=50%>");
echo("<tr><td>Job Title: </td><td align='right'><input type='text' size=50 name='job_title'></td></tr>");
echo("<tr><td>Job Description: </td><td align='right'><textarea size=50 name='job_description'></textarea></td></tr>");
echo("<tr><td>Job Type: </td><td align='center'><select name='job_type'><option>Permanent</option><option>Locum or Contract</option></SELECT></td></tr>");
echo("<tr><td>Hot Job? </td><td align='center'>Yes <input type='radio' name='hot' value='Yes'> No <input type='radio' name='hot' value='no' checked></td></tr>");
echo("<tr><td>Job Area: </td><td align='center'><select name='job_area'><option>East Anglia</option><option>All UK</option><option>London / South East</option><option>Midlands</option><option>North West</option><option>Northern Ireland</option><option>Scotland</option><option>South</option><option>South West</option><option>Southern Ireland</option><option>Wales</option><option>Yorkshire / North East</option></SELECT></td></tr>");
echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>");
echo("</table>");
if($success == TRUE) {
print("<strong>Success!</strong>");
}
echo("<br>");
echo("</form>");
print("<strong>Existing Jobs:</strong>");
print("<br />");
print("<br />");
echo("<table class=main cellspacing=0 cellpadding=5>");
echo("<td>ID:</td><td>Title:</td><td>Description:</td><td>Type:</td><td>Area:</td><td>Edit (DO NOT USE YET):</td><td>Delete:</td>");
$query = "SELECT * FROM jobs WHERE 1=1";
$sql = mysql_query($query);
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$job_title = $row['job_title'];
$job_description = $row['job_description'];
$job_type = $row['job_type'];
$job_area = $row['job_area'];
$position=18;
$job_description2 = substr($job_description, 0, $position);
echo("<tr><td><strong>$id</strong></td><td><strong>$job_title</strong></td><td><strong>$job_description2...</strong></td><td><strong>$job_type</strong></td><td><strong>$job_area</strong></td><td><a href='add_jobs.php?action=edit&editid=$id'>Edit</a></td><td><a href='add_jobs.php?action=delete&delid=$id'>Delete</a></td></tr>");
}
?></p></table>
</div>
</div>
<?php }else{echo'Stop hacking';}}?>
</td>
</tr>
</table>
<td class="right">
<?php
include"modules/sides/right.php";
?>
</td>
</tr>
</table>
<?php include'modules/sides/footer.php';?>

Any help would be great, thankyou!

New/edit/delete Function

Similar Tutorials

View Content

Hey i created a page to add/edit/remove job's i've posted.
I got everything running smoothly except for the edit function?
any help would be really appreciated

<?php

$action = $_GET["action"];
if ($action == "delete"){
$delid = $_GET['delid'];
$query = "DELETE FROM jobs WHERE id=".$delid." LIMIT 1";
$sql = mysql_query($query);
echo("Job succesfully deleted! [ <a href='add_jobs.php'>Back</a> ]");
}
if ($action == "edit"){
print("<strong>Editing a Job:</strong>");
$editid = $_GET['editid'];
$sql = mysql_query("SELECT * FROM jobs WHERE id = ".$editid." ") or die ('Error: '.mysql_error ());
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$job_title = $row['job_title'];
$job_description = $row['job_description'];
$job_type = $row['job_type'];
$job_area = $row['job_area'];
$query2 = "UPDATE jobs SET (job_title, job_description, job_type, job_area, hot_job) VALUES ('$job_title', '$job_description', '$job_type', '$job_area', '$hot') WHERE id=$id";
echo("<form name='add' method='post' action='?action=edit'>");
echo("<input type='hidden' name='?action=edit'>");
echo("<table class=main cellspacing=0 cellpadding=5 width=50%>");
echo("<tr><td>Job Title: </td><td align='right'><input type='text' size=50 name='job_title' value='$job_title'></td></tr>");
echo("<tr><td>Job Description: </td><td align='right'><textarea size=50 name='job_description'>$job_description</textarea></td></tr>");
echo("<tr><td>Job Type: </td><td align='center'><select name='job_type'><option>Permanent</option><option>Locum or Contract</option></SELECT></td></tr>");
echo("<tr><td>Hot Job? </td><td align='center'>Yes <input type='radio' name='hot' value='Yes'> No <input type='radio' name='hot' value='no'></td></tr>");
echo("<tr><td>Job Area: </td><td align='center'><select name='job_area'><option>East Anglia</option><option>London / South East</option><option>Midlands</option><option>North West</option><option>Northern Ireland</option><option>Scotland</option><option>South</option><option>South West</option><option>Southern Ireland</option><option>Wales</option><option>Yorkshire / North East</option></SELECT></td></tr>");
echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>");
echo("</table>");
}
}
if ($action == "add"){
$add = $_POST['add'];
$job_title = $_POST['job_title'];
$job_description = $_POST['job_description'];
$job_type = $_POST['job_type'];
$job_area = $_POST['job_area'];
$hot = $_POST['hot'];
$id = mysql_insert_id();
$query = "INSERT INTO jobs (id, job_title, job_description, job_type, job_area, hot_job) VALUES ('$id', '$job_title', '$job_description', '$job_type', '$job_area', '$hot')";
$sql = mysql_query($query) or die (mysql_error());
}
print("<strong>Add A New Job!</strong>");
print("<br />");
print("<br />");
echo("<form name='add' method='post' action='?action=add'>");
echo("<input type='hidden' name='?action=add'>");

echo("<table class=main cellspacing=0 cellpadding=5 width=50%>");
echo("<tr><td>Job Title: </td><td align='right'><input type='text' size=50 name='job_title'></td></tr>");
echo("<tr><td>Job Description: </td><td align='right'><textarea size=50 name='job_description'></textarea></td></tr>");
echo("<tr><td>Job Type: </td><td align='center'><select name='job_type'><option>Permanent</option><option>Locum or Contract</option></SELECT></td></tr>");
echo("<tr><td>Hot Job? </td><td align='center'>Yes <input type='radio' name='hot' value='Yes'> No <input type='radio' name='hot' value='no' checked></td></tr>");
echo("<tr><td>Job Area: </td><td align='center'><select name='job_area'><option>East Anglia</option><option>London / South East</option><option>Midlands</option><option>North West</option><option>Northern Ireland</option><option>Scotland</option><option>South</option><option>South West</option><option>Southern Ireland</option><option>Wales</option><option>Yorkshire / North East</option></SELECT></td></tr>");
echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>");
echo("</table>");
if($success == TRUE) {
print("<strong>Success!</strong>");
}
echo("<br>");
echo("</form>");
print("<strong>Existing Jobs:</strong>");
print("<br />");
print("<br />");
echo("<table class=main cellspacing=0 cellpadding=5>");
echo("<td>ID:</td><td>Title:</td><td>Description:</td><td>Type:</td><td>Area:</td><td>Edit (DO NOT USE YET):</td><td>Delete:</td>");
$query = "SELECT * FROM jobs WHERE 1=1";
$sql = mysql_query($query);
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$job_title = $row['job_title'];
$job_description = $row['job_description'];
$job_type = $row['job_type'];
$job_area = $row['job_area'];
$position=18;
$job_description2 = substr($job_description, 0, $position);
echo("<tr><td><strong>$id</strong></td><td><strong>$job_title</strong></td><td><strong>$job_description2...</strong></td><td><strong>$job_type</strong></td><td><strong>$job_area</strong></td><td><a href='add_jobs.php?action=edit&editid=$id'>Edit</a></td><td><a href='add_jobs.php?action=delete&delid=$id'>Delete</a></td></tr>");
}

Quick Function Edit

Similar Tutorials

View Content

How can I make this function say if $id is a set parameter, use it. If not, use globals $user_info['uid']?

Code: [Select]
function fetch_user_info_by_id()
{
global $user_info;

$sql = "SELECT
`users`.`id`,
`users`.`firstname`,
`users`.`lastname`,
`users`.`username`,
`users`.`email`,
`users`.`gender`,
`users`.`accounttype`,
`users`.`personalweb`,
`users`.`guestviews`,
`users`.`iviews`,
`users`.`eviews`,
`users`.`credentials`,
`users`.`specialties`,
`users`.`country`,
`users`.`city`,
`users`.`state`,
`users`.`phonenumber`,
`users`.`dateofbirth` AS `dob`,
`iQuestions`.`investortype`,
DATE_FORMAT(`users`.`dateofbirth`,'%D \of %M %Y') AS `dateofbirth`,
DATE_FORMAT(`users`.`signupdate`,'%D %M %Y') AS `signupdate`,
SUM(`companies`.`capitalrequested`) AS `totalrequested`,
SUM(`iQuestions`.`capitalavailable`) AS `totalavailable`
FROM `users`
LEFT JOIN `companies`
ON `users`.`id` = `companies`.`adminid`
LEFT JOIN `iQuestions`
ON `users`.`id` = `iQuestions`.`userid`
WHERE `users`.`id` = '${user_info['uid']}'";

$result = mysql_query($sql);

return mysql_fetch_assoc($result);
}

Update Function Only Update If Not Empty

Similar Tutorials

View Content

Hi Guys,

I want my UPDATE function from the code below to only update those fields that are NOT empty - if they are empty on submit then do not update or change any values from that field. I know that sounds odd, but with my file fields, when I submit to change something else at a later date it will overwrite the photo, download1,2 & 3 values and as a result I loose my files from the mysql table.

Cheers, S

<?php

include('config.php');
if (isset($_GET['Ter']) ) {
$ter = (int) $_GET['Ter'];
if (isset($_POST['submitted'])) {

//Photo & Document Upload Upload
$timestamp_photo = time();
$timestamp_download1 = time();
$timestamp_download2 = time();
$timestamp_download3 = time();
//This is the directory where the files will be saved
//Photos
$photo_target = "images/";
$photo_target = $photo_target .$timestamp_photo. basename( $_FILES['photo']['name']);
//Documents
$download_target = "documents/";
$download_target1 = $download_target .$timestamp_download1. basename( $_FILES['download1']['name']);
$download_target2 = $download_target .$timestamp_download2. basename( $_FILES['download2']['name']);
$download_target3 = $download_target .$timestamp_download3. basename( $_FILES['download3']['name']);

//This gets all the other information from the form
$photo = ($_FILES['photo']['name']);
$download1 = ($_FILES['download1']['name']);
$download2 = ($_FILES['download2']['name']);
$download3 = ($_FILES['download3']['name']);
//Pause Photo/Document Upload

foreach($_POST AS $key => $value) { $_POST[$key] = mysql_real_escape_string($value); }
$sql= "UPDATE `ter` SET `Ter` = '{$_POST['Ter']}' , `BranchName` = '{$_POST['BranchName']}' , `BranchAddress` = '{$_POST['BranchAddress']}' , `BranchTel` = '{$_POST['BranchTel']}' , `BranchEmail` = '{$_POST['BranchEmail']}' , `BranchLink` = '{$_POST['BranchLink']}' , `Theme` = '{$_POST['Theme']}' , `LocalInfo` = '{$_POST['LocalInfo']}' , `BranchInfo` = '{$_POST['BranchInfo']}' , `photo` = '$timestamp_photo{$_FILES['photo']['name']}' , `download1` = '$timestamp_download1{$_FILES['download1']['name']}' , `download1name` = '{$_POST['download1name']}' , `download2` = '$timestamp_download2{$_FILES['download2']['name']}' , `download2name` = '{$_POST['download2name']}' , `download3` = '$timestamp_download3{$_FILES['download3']['name']}' , `download3name` = '{$_POST['download3name']}' WHERE `Ter` = '$ter' ";

mysql_query($sql) or die(mysql_error());

//Unpause Photo/Document Upload
//Writes the photo to the server
if(move_uploaded_file($_FILES['photo']['tmp_name'], $photo_target))
{

echo "<br />The file ".$timestamp_photo. basename( $_FILES['photo']['name']). " has been uploaded. <br />";
}

else {
echo "";
} //End of Photo/Document Upload

//Writes the photo to the server
if(move_uploaded_file($_FILES['download1']['tmp_name'], $download_target1))
{

echo "<br />The file ".$timestamp_download1. basename( $_FILES['download1']['name']). " has been uploaded. <br />";
}

else {
echo "";
} //End of Photo/Document Upload

//Writes the photo to the server
if(move_uploaded_file($_FILES['download2']['tmp_name'], $download_target2))
{

echo "<br />The file ".$timestamp_download2. basename( $_FILES['download2']['name']). " has been uploaded. <br />";
}

else {
echo "";
} //End of Photo/Document Upload

//Writes the photo to the server
if(move_uploaded_file($_FILES['download3']['tmp_name'], $download_target3))
{

echo "<br />The file ".$timestamp_download3. basename( $_FILES['download3']['name']). " has been uploaded. <br />";
}

else {
echo "";
} //End of Photo/Document Upload

echo (mysql_affected_rows()) ? "<br />Edited Branch.<br />" : "<br />Nothing changed. <br />";
}
$row = mysql_fetch_array ( mysql_query("SELECT * FROM `ter` WHERE `Ter` = '$ter' "));
?>

Php Edit When Logged In Not Working

Similar Tutorials

View Content

hello i am stuck and hoping you can help, i have created this function and its not working correctly, what i am trying to do is
when someone is logged in they get this line of code echo "<a href=\"update-content.php?id=5\">Edit</a> | <a href=\"delete-content.php?id=5\">Delete</a>"; which is ok as i dont want that to work yet and if your not logged in you dont get it.
i have added //show when logged in and show not logged in so you know which code i want it to load when
at the moment its only loading the not logged in one even if you are.
i have looked on google read up on php sites but cant figure out how to do it, so hoping you guys will tell me were i gone wrong and how to correct it, thanks again

heres the code.

function get_left() {

if (isset($_GET['page']))
{

$page = $_GET['page'];

//Show Page not logged in
                $sql = "SELECT title,body FROM content WHERE page = '$page' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';
echo '<p>' . $row['body'] . '</p>';

}

}
//show when logged in
elseif ($_SESSION['username']&&(isset($_GET['page']))){

$sql = "SELECT title,body FROM content WHERE page = '$page' AND location = 'left' AND disabled = 'no' ORDER BY id";
$res = mysql_query($sql) or die (mysql_error());
while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';

echo '<p>' . $row['body'] . '</p>';

echo "<a href=\"update-content.php?id=5\">Edit</a> | <a href=\"delete-content.php?id=5\">Delete</a>";

}
}
}

Edit User Profil & Collect , Update Mysql "help Request"

Similar Tutorials

View Content

I am realy doing my best , but i am bad at php , when i click update bottum on edit_profil.php page it put me over to update.php, but update.php is blank , and cant see any errors. and it has not updated mysql.

Files:
// form page.
edit_profil.php

// Data from edit_profil to mysql
update.php
___________________________

edit_profil.php
Code: [Select]
<?php
// Check if user is logged in
session_start();
if ($_SESSION['s_logged_n'] == 'true'){
$username = $_SESSION['s_username'];
$usermail = $_SESSION['s_usermail'];
// Get the id
if (isset($_GET['id'])){
// Include config file
include "config.php";
// Define id
$id = $_GET['id'];
// Query table
$query = "SELECT * FROM users WHERE user_id = '$id' AND username = '$username' LIMIT 1";
$result = mysql_query($query);
$check = mysql_num_rows($result);
// If user try to edit someone's else profile it will say it can't
if (!$check == 1){
echo "You can edit your profile only";
// Else if everything is ok display form
} else {
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<link href="css/test.css" rel="stylesheet" type="text/css" />

</head>

<body>

<div class="bodyContentCenter">
<h1>My Profile</h1>
<div class="solidThickLine"></div>
<div class="breakLine"></div>

<div class="loginColumnBorder" style="width:100%;">
<form action="update.php?id=<?php echo "$id" ?>" method="post">
<table border="0" width="100%" cellspacing="10" cellpadding="0">
<tbody><tr>
<td>
<div style="font-size:16px;font-weight:bold;">Edit Profile</div>
<div class="breakLine"></div>
<div>Personal information obtained are used solely for the purpose of enhancing the functionality and level of service.</div>
<div class="breakLine" style="height:20px;"></div>

<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tbody><tr><td colspan="3" style="font-weight:bold">LOGIN E-MAIL & PASSWORD</td></tr>
<tr><td colspan="3"><div class="breakLine"></div></td></tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">E-mail Address:</td>
<td style="width:220px;">
<label for="e_mail_address"></label>
<input type="text" name="e_mail_address" value="<?php echo "$usermail"; ?>" id="e_mail_address"> *</td>

</tr>

<tr style="height:45px;" valign="top">
<td style="width:120px;">New Password:</td>
<td style="width:220px;">
<label for="password"></label>
<input type="password" name="password" id="password"> *</td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Confirm New Password:</td>
<td style="width:220px;"><label for="password_confirm"></label>
<input type="password" name="password_confirm" id="password_confirm"> *</td>

<td style="width:380px;"><div id="confirm_password_message"></div> </td>
</tr>
<tr><td colspan="3"><div class="dottedLine" style="lin-height: 2px;"> </div></td></tr>


<tr><td colspan="3" style="font-weight:bold" valign="top">PERSONAL DETAILS</td></tr>
<tr><td colspan="3"><div class="breakLine"></div></td></tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">First Name:</td>
<td style="width:220px;"><input type="text" name="edit_profile_firstname" value="lasse" id="firstname"> *</td>

</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Last Name:</td>
<td style="width:220px;"><input type="text" name="edit_profile_lastname" id="lastname"> *</td>

</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Country Code: </td>
<td style="width:220px;"><select name="edit_profile_country_code" style="width:150px;" id="country"><option value="1">Afghanistan +93</option><option value="2">Albania +355</option><option value="3">Algeria +213</option><option value="4">American Samoa +684</option><option value="5">Andorra +376</option><option value="6">Angola +244</option><option value="7">Anguilla +1264</option><option value="8">Antarctica +672</option><option value="9">Antigua and Barbuda +1268</option><option value="10">Argentina +54</option><option value="11">Armenia +374</option><option value="12">Aruba +297</option><option value="13">Australia +61</option><option value="14">Austria +43</option><option value="15">Azerbaijan +994</option><option value="16">Bahamas +1242</option><option value="17">Bahrain +973</option><option value="18">Bangladesh +880</option><option value="19">Barbados +1246</option><option value="20">Belarus +375</option><option value="21">Belgium +32</option><option value="22">Belize +501</option><option value="23">Benin +229</option><option value="24">Bermuda +1441</option><option value="25">Bhutan +975</option><option value="26">Bolivia +591</option><option value="27">Bosnia and Herzegovina +387</option><option value="28">Botswana +267</option><option value="29">Bouvet Island +47</option><option value="30">Brazil +55</option><option value="31">British Indian Ocean Territory +246</option><option value="32">Brunei Darussalam +673</option><option value="33">Bulgaria +359</option><option value="34">Burkina Faso +226</option><option value="35">Burundi +257</option><option value="36">Cambodia +855</option><option value="37">Cameroon +237</option><option value="38">Canada +1</option><option value="39">Cape Verde +238</option><option value="40">Cayman Islands +1345</option><option value="41">Central African Republic +236</option><option value="42">Chad +235</option><option value="43">Chile +56</option><option value="44">China +86</option><option value="45">Christmas Island +61</option><option value="46">Cocos (Keeling) Islands +61</option><option value="47">Colombia +57</option><option value="48">Comoros +269</option><option value="49">Congo +242</option><option value="50">Cook Islands +682</option><option value="51">Costa Rica +506</option><option value="52">Cote D'Ivoire +225</option><option value="53">Croatia +385</option><option value="54">Cuba +53</option><option value="55">Cyprus +357</option><option value="56">Czech Republic +420</option><option value="57" selected="">Denmark +45</option><option value="58">Djibouti +253</option><option value="59">Dominica +1767</option><option value="60">Dominican Republic +1809</option><option value="61">East Timor +670</option><option value="62">Ecuador +593</option><option value="63">Egypt +20</option><option value="64">El Salvador +503</option><option value="65">Equatorial Guinea +240</option><option value="66">Eritrea +291</option><option value="67">Estonia +372</option><option value="68">Ethiopia +251</option><option value="69">Falkland Islands (Malvinas) +500</option><option value="70">Faroe Islands +298</option><option value="71">Fiji +679</option><option value="72">Finland +358</option><option value="73">France +33</option><option value="74">France, Metropolitan +33</option><option value="75">French Guiana +594</option><option value="76">French Polynesia +689</option><option value="77">French Southern Territories +</option><option value="78">Gabon +241</option><option value="79">Gambia +220</option><option value="80">Georgia +995</option><option value="81">Germany +49</option><option value="82">Ghana +233</option><option value="83">Gibraltar +350</option><option value="84">Greece +30</option><option value="85">Greenland +299</option><option value="86">Grenada +1473</option><option value="87">Guadeloupe +590</option><option value="88">Guam +1671</option><option value="89">Guatemala +502</option><option value="242">Guernsey +44</option><option value="90">Guinea +224</option><option value="91">Guinea-bissau +245</option><option value="92">Guyana +592</option><option value="93">Haiti +509</option><option value="94">Heard and Mc Donald Islands +672</option><option value="95">Honduras +504</option><option value="96">Hong Kong +852</option><option value="97">Hungary +36</option><option value="98">Iceland +354</option><option value="99">India +91</option><option value="100">Indonesia +62</option><option value="101">Iran (Islamic Republic of) +98</option><option value="102">Iraq +964</option><option value="103">Ireland +353</option><option value="104">Israel +972</option><option value="105">Italy +39</option><option value="106">Jamaica +1876</option><option value="107">Japan +81</option><option value="108">Jordan +962</option><option value="109">Kazakhstan +7</option><option value="110">Kenya +254</option><option value="111">Kiribati +686</option><option value="112">Korea, Democratic People's Republic of +850</option><option value="113">Korea, Republic of +82</option><option value="114">Kuwait +965</option><option value="115">Kyrgyzstan +996</option><option value="116">Lao People's Democratic Republic +856</option><option value="117">Latvia +371</option><option value="118">Lebanon +961</option><option value="119">Lesotho +266</option><option value="120">Liberia +231</option><option value="121">Libyan Arab Jamahiriya +218</option><option value="122">Liechtenstein +423</option><option value="123">Lithuania +370</option><option value="124">Luxembourg +352</option><option value="125">Macau +853</option><option value="126">Macedonia, The Former Yugoslav Republic of +389</option><option value="127">Madagascar +261</option><option value="128">Malawi +265</option><option value="129">Malaysia +60</option><option value="130">Maldives +960</option><option value="131">Mali +223</option><option value="132">Malta +356</option><option value="133">Marshall Islands +692</option><option value="134">Martinique +596</option><option value="135">Mauritania +222</option><option value="136">Mauritius +230</option><option value="137">Mayotte +269</option><option value="138">Mexico +52</option><option value="139">Micronesia, Federated States of +591</option><option value="140">Moldova, Republic of +373</option><option value="141">Monaco +377</option><option value="142">Mongolia +976</option><option value="241">Montenegro +382</option><option value="143">Montserrat +1664</option><option value="144">Morocco +212</option><option value="145">Mozambique +258</option><option value="146">Myanmar +95</option><option value="147">Namibia +264</option><option value="148">Nauru +674</option><option value="149">Nepal +977</option><option value="150">Netherlands +31</option><option value="151">Netherlands Antilles +599</option><option value="152">New Caledonia +687</option><option value="153">New Zealand +64</option><option value="154">Nicaragua +505</option><option value="155">Niger +227</option><option value="156">Nigeria +234</option><option value="157">Niue +683</option><option value="158">Norfolk Island +672</option><option value="159">Northern Mariana Islands +1670</option><option value="160">Norway +47</option><option value="161">Oman +968</option><option value="162">Pakistan +92</option><option value="163">Palau +680</option><option value="164">Panama +507</option><option value="165">Papua New Guinea +675</option><option value="166">Paraguay +595</option><option value="167">Peru +51</option><option value="168">Philippines +63</option><option value="169">Pitcairn +872</option><option value="170">Poland +48</option><option value="171">Portugal +351</option><option value="172">Puerto Rico +1787</option><option value="173">Qatar +974</option><option value="174">Reunion +262</option><option value="175">Romania +40</option><option value="176">Russian Federation +7</option><option value="177">Rwanda +250</option><option value="178">Saint Kitts and Nevis +1869</option><option value="179">Saint Lucia +1758</option><option value="180">Saint Vincent and the Grenadines +1784</option><option value="181">Samoa +685</option><option value="182">San Marino +378</option><option value="183">Sao Tome and Principe +239</option><option value="184">Saudi Arabia +966</option><option value="185">Senegal +221</option><option value="240">Serbia +381</option><option value="186">Seychelles +248</option><option value="187">Sierra Leone +232</option><option value="188">Singapore +65</option><option value="189">Slovakia (Slovak Republic) +421</option><option value="190">Slovenia +386</option><option value="191">Solomon Islands +677</option><option value="192">Somalia +252</option><option value="193">South Africa +27</option><option value="194">South Georgia and the South Sandwich Islands +</option><option value="195">Spain +34</option><option value="196">Sri Lanka +94</option><option value="197">St. Helena +290</option><option value="198">St. Pierre and Miquelon +508</option><option value="199">Sudan +249</option><option value="200">Suriname +597</option><option value="201">Svalbard and Jan Mayen Islands +79</option><option value="202">Swaziland +268</option><option value="203">Sweden +46</option><option value="204">Switzerland +41</option><option value="205">Syrian Arab Republic +963</option><option value="206">Taiwan +886</option><option value="207">Tajikistan +992</option><option value="208">Tanzania, United Republic of +255</option><option value="209">Thailand +66</option><option value="210">Togo +228</option><option value="211">Tokelau +690</option><option value="212">Tonga +676</option><option value="213">Trinidad and Tobago +1868</option><option value="214">Tunisia +216</option><option value="215">Turkey +90</option><option value="216">Turkmenistan +993</option><option value="217">Turks and Caicos Islands +1649</option><option value="218">Tuvalu +688</option><option value="219">Uganda +256</option><option value="220">Ukraine +380</option><option value="221">United Arab Emirates +971</option><option value="222">United Kingdom +44</option><option value="223">United States +1</option><option value="224">United States Minor Outlying Islands +1</option><option value="225">Uruguay +598</option><option value="226">Uzbekistan +998</option><option value="227">Vanuatu +678</option><option value="228">Vatican City State (Holy See) +39</option><option value="229">Venezuela +58</option><option value="230">Vietnam +84</option><option value="231">Virgin Islands (British) +284</option><option value="232">Virgin Islands (U.S.) +1340</option><option value="233">Wallis and Futuna Islands +681</option><option value="234">Western Sahara +212</option><option value="235">Yemen +967</option><option value="237">Zaire +243</option><option value="238">Zambia +260</option><option value="239">Zimbabwe +263</option></select> *</td>

</tr>
<tr style="height:60px;" valign="top">
<td style="width:120px;">Contact Number: </td>
<td style="width:220px;"><input type="text" name="edit_profile_contact_number" autocomplete="off" id="contact_number"> *</td>

</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Gender:</td>
<td style="width:220px;">
<select name="edit_profile_gender" id="edit_profile_gender"><option>Female</option><option>Male</option> </select> </td>
<td style="width:380px;"> </td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Date of Birth:</td>
<td style="width:220px;"><select name="dob_month" id="month"><option value="01">January</option><option value="02">February</option><option value="03">March</option><option value="04">April</option><option value="05">May</option><option value="06">June</option><option value="07" selected="">July</option><option value="08">August</option><option value="09">September</option><option value="10">October</option><option value="11">November</option><option value="12">December</option></select>  <select name="dob_day" id="day"><option value="01">01</option><option value="02">02</option><option value="03">03</option><option value="04">04</option><option value="05">05</option><option value="06">06</option><option value="07">07</option><option value="08">08</option><option value="09">09</option><option value="10">10</option><option value="11">11</option><option value="12">12</option><option value="13">13</option><option value="14">14</option><option value="15">15</option><option value="16">16</option><option value="17">17</option><option value="18">18</option><option value="19">19</option><option value="20">20</option><option value="21">21</option><option value="22">22</option><option value="23" selected="">23</option><option value="24">24</option><option value="25">25</option><option value="26">26</option><option value="27">27</option><option value="28">28</option><option value="29">29</option><option value="30">30</option><option value="31">31</option></select>  <select name="dob_year" id="year"><option value="1900">1900</option><option value="1901">1901</option><option value="1902">1902</option><option value="1903">1903</option><option value="1904">1904</option><option value="1905">1905</option><option value="1906">1906</option><option value="1907">1907</option><option value="1908">1908</option><option value="1909">1909</option><option value="1910">1910</option><option value="1911">1911</option><option value="1912">1912</option><option value="1913">1913</option><option value="1914">1914</option><option value="1915">1915</option><option value="1916">1916</option><option value="1917">1917</option><option value="1918">1918</option><option value="1919">1919</option><option value="1920">1920</option><option value="1921">1921</option><option value="1922">1922</option><option value="1923">1923</option><option value="1924">1924</option><option value="1925">1925</option><option value="1926">1926</option><option value="1927">1927</option><option value="1928">1928</option><option value="1929">1929</option><option value="1930">1930</option><option value="1931">1931</option><option value="1932">1932</option><option value="1933">1933</option><option value="1934">1934</option><option value="1935">1935</option><option value="1936">1936</option><option value="1937">1937</option><option value="1938">1938</option><option value="1939">1939</option><option value="1940">1940</option><option value="1941">1941</option><option value="1942">1942</option><option value="1943">1943</option><option value="1944">1944</option><option value="1945">1945</option><option value="1946">1946</option><option value="1947">1947</option><option value="1948">1948</option><option value="1949">1949</option><option value="1950">1950</option><option value="1951">1951</option><option value="1952">1952</option><option value="1953">1953</option><option value="1954">1954</option><option value="1955">1955</option><option value="1956">1956</option><option value="1957">1957</option><option value="1958">1958</option><option value="1959">1959</option><option value="1960">1960</option><option value="1961">1961</option><option value="1962">1962</option><option value="1963">1963</option><option value="1964">1964</option><option value="1965">1965</option><option value="1966">1966</option><option value="1967">1967</option><option value="1968">1968</option><option value="1969">1969</option><option value="1970">1970</option><option value="1971">1971</option><option value="1972">1972</option><option value="1973">1973</option><option value="1974">1974</option><option value="1975">1975</option><option value="1976">1976</option><option value="1977">1977</option><option value="1978">1978</option><option value="1979">1979</option><option value="1980">1980</option><option value="1981">1981</option><option value="1982">1982</option><option value="1983">1983</option><option value="1984">1984</option><option value="1985">1985</option><option value="1986">1986</option><option value="1987">1987</option><option value="1988">1988</option><option value="1989" selected="">1989</option><option value="1990">1990</option><option value="1991">1991</option><option value="1992">1992</option><option value="1993">1993</option><option value="1994">1994</option><option value="1995">1995</option><option value="1996">1996</option><option value="1997">1997</option><option value="1998">1998</option><option value="1999">1999</option><option value="2000">2000</option><option value="2001">2001</option><option value="2002">2002</option><option value="2003">2003</option><option value="2004">2004</option><option value="2005">2005</option><option value="2006">2006</option><option value="2007">2007</option><option value="2008">2008</option><option value="2009">2009</option><option value="2010">2010</option></select></td>
<td style="width:380px;"><div id="dob_message"></div> </td>
</tr>
<tr style="height:45px;" valign="top">
</tr>
<tr><td colspan="3"><a name="ba"></a><div class="breakLine"></div></td></tr>

<tr>
<td colspan="3" style="font-weight:bold">ADDRESS</td></tr>
<tr><td colspan="3"><div class="breakLine"></div></td></tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Address1: </td>
<td style="width:220px;">
<input type="text" name="edit_profile_billing_address1" id="billing_address1"> *</td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Address2: </td>
<td style="width:220px;">
<input type="text" name="edit_profile_billing_address2" id="billing_address2"> *</td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">City:</td>
<td style="width:220px;">
<input type="text" name="edit_profile_billing_city" id="billing_city"> *</td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Zip/Post Code:</td>
<td style="width:220px;">
<input type="text" name="edit_profile_billing_postcode" id="billing_postcode"> *</td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Country:</td>
<td style="width:220px;">
<select name="edit_profile_billing_country" style="width:150px;" id="billing_country"><option value="1">Afghanistan</option><option value="2">Albania</option><option value="3">Algeria</option><option value="4">American Samoa</option><option value="5">Andorra</option><option value="6">Angola</option><option value="7">Anguilla</option><option value="8">Antarctica</option><option value="9">Antigua and Barbuda</option><option value="10">Argentina</option><option value="11">Armenia</option><option value="12">Aruba</option><option value="13">Australia</option><option value="14">Austria</option><option value="15">Azerbaijan</option><option value="16">Bahamas</option><option value="17">Bahrain</option><option value="18">Bangladesh</option><option value="19">Barbados</option><option value="20">Belarus</option><option value="21">Belgium</option><option value="22">Belize</option><option value="23">Benin</option><option value="24">Bermuda</option><option value="25">Bhutan</option><option value="26">Bolivia</option><option value="27">Bosnia and Herzegovina</option><option value="28">Botswana</option><option value="29">Bouvet Island</option><option value="30">Brazil</option><option value="31">British Indian Ocean Territory</option><option value="32">Brunei Darussalam</option><option value="33">Bulgaria</option><option value="34">Burkina Faso</option><option value="35">Burundi</option><option value="36">Cambodia</option><option value="37">Cameroon</option><option value="38">Canada</option><option value="39">Cape Verde</option><option value="40">Cayman Islands</option><option value="41">Central African Republic</option><option value="42">Chad</option><option value="43">Chile</option><option value="44">China</option><option value="45">Christmas Island</option><option value="46">Cocos (Keeling) Islands</option><option value="47">Colombia</option><option value="48">Comoros</option><option value="49">Congo</option><option value="50">Cook Islands</option><option value="51">Costa Rica</option><option value="52">Cote D'Ivoire</option><option value="53">Croatia</option><option value="54">Cuba</option><option value="55">Cyprus</option><option value="56">Czech Republic</option><option value="57" selected="">Denmark</option><option value="58">Djibouti</option><option value="59">Dominica</option><option value="60">Dominican Republic</option><option value="61">East Timor</option><option value="62">Ecuador</option><option value="63">Egypt</option><option value="64">El Salvador</option><option value="65">Equatorial Guinea</option><option value="66">Eritrea</option><option value="67">Estonia</option><option value="68">Ethiopia</option><option value="69">Falkland Islands (Malvinas)</option><option value="70">Faroe Islands</option><option value="71">Fiji</option><option value="72">Finland</option><option value="73">France</option><option value="74">France, Metropolitan</option><option value="75">French Guiana</option><option value="76">French Polynesia</option><option value="77">French Southern Territories</option><option value="78">Gabon</option><option value="79">Gambia</option><option value="80">Georgia</option><option value="81">Germany</option><option value="82">Ghana</option><option value="83">Gibraltar</option><option value="84">Greece</option><option value="85">Greenland</option><option value="86">Grenada</option><option value="87">Guadeloupe</option><option value="88">Guam</option><option value="89">Guatemala</option><option value="242">Guernsey</option><option value="90">Guinea</option><option value="91">Guinea-bissau</option><option value="92">Guyana</option><option value="93">Haiti</option><option value="94">Heard and Mc Donald Islands</option><option value="95">Honduras</option><option value="96">Hong Kong</option><option value="97">Hungary</option><option value="98">Iceland</option><option value="99">India</option><option value="100">Indonesia</option><option value="101">Iran (Islamic Republic of)</option><option value="102">Iraq</option><option value="103">Ireland</option><option value="104">Israel</option><option value="105">Italy</option><option value="106">Jamaica</option><option value="107">Japan</option><option value="108">Jordan</option><option value="109">Kazakhstan</option><option value="110">Kenya</option><option value="111">Kiribati</option><option value="112">Korea, Democratic People's Republic of</option><option value="113">Korea, Republic of</option><option value="114">Kuwait</option><option value="115">Kyrgyzstan</option><option value="116">Lao People's Democratic Republic</option><option value="117">Latvia</option><option value="118">Lebanon</option><option value="119">Lesotho</option><option value="120">Liberia</option><option value="121">Libyan Arab Jamahiriya</option><option value="122">Liechtenstein</option><option value="123">Lithuania</option><option value="124">Luxembourg</option><option value="125">Macau</option><option value="126">Macedonia, The Former Yugoslav Republic of</option><option value="127">Madagascar</option><option value="128">Malawi</option><option value="129">Malaysia</option><option value="130">Maldives</option><option value="131">Mali</option><option value="132">Malta</option><option value="133">Marshall Islands</option><option value="134">Martinique</option><option value="135">Mauritania</option><option value="136">Mauritius</option><option value="137">Mayotte</option><option value="138">Mexico</option><option value="139">Micronesia, Federated States of</option><option value="140">Moldova, Republic of</option><option value="141">Monaco</option><option value="142">Mongolia</option><option value="241">Montenegro</option><option value="143">Montserrat</option><option value="144">Morocco</option><option value="145">Mozambique</option><option value="146">Myanmar</option><option value="147">Namibia</option><option value="148">Nauru</option><option value="149">Nepal</option><option value="150">Netherlands</option><option value="151">Netherlands Antilles</option><option value="152">New Caledonia</option><option value="153">New Zealand</option><option value="154">Nicaragua</option><option value="155">Niger</option><option value="156">Nigeria</option><option value="157">Niue</option><option value="158">Norfolk Island</option><option value="159">Northern Mariana Islands</option><option value="160">Norway</option><option value="161">Oman</option><option value="162">Pakistan</option><option value="163">Palau</option><option value="164">Panama</option><option value="165">Papua New Guinea</option><option value="166">Paraguay</option><option value="167">Peru</option><option value="168">Philippines</option><option value="169">Pitcairn</option><option value="170">Poland</option><option value="171">Portugal</option><option value="172">Puerto Rico</option><option value="173">Qatar</option><option value="174">Reunion</option><option value="175">Romania</option><option value="176">Russian Federation</option><option value="177">Rwanda</option><option value="178">Saint Kitts and Nevis</option><option value="179">Saint Lucia</option><option value="180">Saint Vincent and the Grenadines</option><option value="181">Samoa</option><option value="182">San Marino</option><option value="183">Sao Tome and Principe</option><option value="184">Saudi Arabia</option><option value="185">Senegal</option><option value="240">Serbia</option><option value="186">Seychelles</option><option value="187">Sierra Leone</option><option value="188">Singapore</option><option value="189">Slovakia (Slovak Republic)</option><option value="190">Slovenia</option><option value="191">Solomon Islands</option><option value="192">Somalia</option><option value="193">South Africa</option><option value="194">South Georgia and the South Sandwich Islands</option><option value="195">Spain</option><option value="196">Sri Lanka</option><option value="197">St. Helena</option><option value="198">St. Pierre and Miquelon</option><option value="199">Sudan</option><option value="200">Suriname</option><option value="201">Svalbard and Jan Mayen Islands</option><option value="202">Swaziland</option><option value="203">Sweden</option><option value="204">Switzerland</option><option value="205">Syrian Arab Republic</option><option value="206">Taiwan</option><option value="207">Tajikistan</option><option value="208">Tanzania, United Republic of</option><option value="209">Thailand</option><option value="210">Togo</option><option value="211">Tokelau</option><option value="212">Tonga</option><option value="213">Trinidad and Tobago</option><option value="214">Tunisia</option><option value="215">Turkey</option><option value="216">Turkmenistan</option><option value="217">Turks and Caicos Islands</option><option value="218">Tuvalu</option><option value="219">Uganda</option><option value="220">Ukraine</option><option value="221">United Arab Emirates</option><option value="222">United Kingdom</option><option value="223">United States</option><option value="224">United States Minor Outlying Islands</option><option value="225">Uruguay</option><option value="226">Uzbekistan</option><option value="227">Vanuatu</option><option value="228">Vatican City State (Holy See)</option><option value="229">Venezuela</option><option value="230">Vietnam</option><option value="231">Virgin Islands (British)</option><option value="232">Virgin Islands (U.S.)</option><option value="233">Wallis and Futuna Islands</option><option value="234">Western Sahara</option><option value="235">Yemen</option><option value="237">Zaire</option><option value="238">Zambia</option><option value="239">Zimbabwe</option></select> </td>
<td style="width:380px;"><div id="billing_country_message"></div> </td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">State/Province:</td>
<td style="width:220px;">
<span id="state_div" style="float:left;">
<label for="state_province"></label>
<input type="text" name="state_province" id="state_province"> *</span></td>

</tr>

<tr valign="top">
<td colspan="3" style="width:100%;">
<div class="breakLine"></div>
<div class="dottedLine"></div>
<div class="breakLine"></div>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>

</tbody></table>
<div class="breakLine"></div>
</td>
</tr>
<tr><td colspan="3"><div class="dottedLine"> </div></td></tr>


<tr>
<td colspan="3">
<div style="height:66px; display: block;">
<div style="float:left; width:50px; display: inline-block;">

<div class="loginBoxLink"<a href="#"><a href="index.php"><img src="images/buttoms/button_back.gif" border="0" width="51" height="17" longdesc="index.php" /></a></div>
</div>
<div style="float:right;">
<INPUT TYPE="image" SRC="images/buttoms/button_update.gif" HEIGHT="17" WIDTH="66" BORDER="0" ALT="Submit Form">
</div>
</div>
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody></table>
</form>
</div>
<div class="break_line"></div>

</div>
<?php
}
}
} else {
// If user is not logged in and opens edit page output that he must be logged in
echo "You must be logged in to edit profile";
}
?>

</body>
</html>

update.php
Code: [Select]
<?php
// Start session
session_start();
if($_SESSION['s_logged_n'] == 'true'){
// Define $username
$username = $_SESSION['s_username'];
$new_user_mail = $_POST["e_mail_address"];
$year = $_POST["year"];
$day = $_POST["day"];
$month = $_POST["month"];
$state_province = $_POST["state_province"];
$billing_postcode = $_POST["billing_postcode"];
$billing_country = $_POST["billing_country"];
$billing_city = $_POST["billing_city"];
$billing_address2 = $_POST["billing_address2"];
$billing_address1 = $_POST["billing_address1"];
$edit_profile_gender = $_POST["edit_profile_gender"];
$lastname = $_POST["lastname"];
$contact_number = $_POST["contact_number"];
$country = $_POST["country"];
$firstname = $_POST["firstname"];
// Check if form button update has been pressed
if(isset($_POST['update'])){
// Get the id
$id = $_GET['id'];
// Include config file
include "config.php";
// Add slashes and trim password
$password = addslashes(trim($password));
$password_confirm = addslashes(trim($password_confirm));
// Check if passwords match each other
if ($password == $password_confirm){
// If they do then do md5 hash on it
$password = md5($password);
// Query users table
$query = "UPDATE users SET password = '$password', email = '$new_user_mail', dateofbirth = '$month$day$year', first_name = '$firstname', last_name = '$lastname', country_code = '$billing_postcode', contact_cumber = '$contact_number', gender = '$edit_profile_gender', address_1 = '$billing_address1', address_2 = '$billing_address2', city = '$country', zip_post_code = '$billing_postcode', country = '$country', state_province = '$state_province' WHERE user_id = '$id' AND username = '$username' LIMIT 1";
$result = mysql_query($query);
// If it was successfull change of pass then output it
if($result){
echo "You have successfully edited your password";
} else {
// Else output error
echo "There was an error editing your password";
}
} else {
// If passwords don't match each other say so
echo "Your passwords don't match each other";
}
}
} else {
// If someone just try to open file then stop them
echo "You must be logged in to access this area";
}
?>

mysql database

table: users
Code: [Select]

username email password date ip actkey activated user_id points first_name last_name country_code contact_cumber gender dateofbirth address_1 address_2 city zip_post_code country state_province

so if some one please give me a hit or help to get it done thanks

Edit Function Doesn't Pick The Respective Values

Similar Tutorials

View Content

i'm creating a ticketing system and i need some assistance. The code directly below displays the database records and the delete works fine. The edit however isn't picking the values in the various fields.

<?Php
        require "config.php";           

        $page_name="currentout.php";  
        $start=$_GET['start'];
        if(strlen($start) > 0 and !is_numeric($start)){
        echo "Data Error";
        exit;
        }


        $eu = ($start - 0); 
        $limit = 10;                                 
        $this1 = $eu + $limit; 
        $back = $eu - $limit; 
        $next = $eu + $limit; 

        $nume = $dbo->query("select count(id) from receipt")->fetchColumn();


        echo "<TABLE class='t1'>";
        echo  "<tr><th>ID</th><th>Name</th><th>Pass</th><th>Amount</th><th>Action</th></tr>";


        $query=" SELECT * FROM receipt  limit $eu, $limit ";


        foreach ($dbo->query($query) as $row) {

        @$m=$i%2;
        @$i=$i+1;   
        echo "<tr class='r$m'><td>$row[id]</td><td>$row[name]</td><td>$row[phone_num]</td><td>$row[Amount]</td><td><a href='delete.php?id=$row[id]'>delete</a></td><td><a href='edit.php?id=$row[id]'>Edit</a></td></tr>";
        }
        echo "</table>";

        if($nume > $limit ){ 
        echo "<table align = 'center' width='50%'><tr><td  align='left' width='30%'>";

        if($back >=0) { 
        print "<a href='$page_name?start=$back'><font face='Verdana' size='2'>PREV</font></a>"; 
        } 

        echo "</td><td align=center width='30%'>";
        $i=0;
        $l=1;
        for($i=0;$i < $nume;$i=$i+$limit){
        if($i <> $eu){
        echo " <a href='$page_name?start=$i'><font face='Verdana' size='2'>$l</font></a> ";
        }
        else { echo "<font face='Verdana' size='4' color=red>$l</font>";}        
        $l=$l+1;
        }


        echo "</td><td  align='right' width='30%'>";

        if($this1 < $nume) { 
        print "<a href='$page_name?start=$next'><font face='Verdana' size='2'>NEXT</font></a>";} 
        echo "</td></tr></table>";

        } 
        ?>

The code below is edit.php. It's supposed to display the various fields when clicked to allow for editing but it isn't picking any field, PLEASE assist.

<?Php
require "config.php";   
$sql = "SELECT FROM receipt  WHERE ID=  :ID";

$stmt = $dbo->prepare($sql);
$stmt->bindParam(':ID', $_GET['id'], PDO::PARAM_INT);  
$stmt->execute();
?>

    <form action="update.php" method="post" enctype="multipart/form-data">
    <table align="center">
   <tr>
   <td> <label><strong>Full Names</strong></label></td>
     <td> <input type='text' name='name' value=" <?php echo $row['name']; ?>"  />
      <input type="hidden" name="id" value="<?php echo $id; ?> " /> <br /></td>
    </tr>
    <tr>

     <td><label><strong>ID/Passport No. </strong></label></td>
  <td> <input type="text" name="pass" value="<?php echo $row['id_passno']; ?> " /><br /></td>
  </tr>
   <tr>
    <td> <label><strong>Phone No. </strong></label></td>
    <td><input type="text" name="phone" value="<?php echo $row['phone_num']; ?>" /> <br /></td>
    </tr>
    <tr>

    <td> <label><strong>Amount (KShs.) </strong></label></td>
    <td><input type="text" name="amount" value="<?php echo $row['Amount']; ?> "/> <br /></td>
   </tr>
    <tr>
  <td> 
          <input type="reset" name="Reset" value="CANCEL" onClick="return confirm('Discard changes?');" />
      <br></td>


     <td> 
          <input type="submit" name="Submit2" value="SUBMIT" />
      </td>
   </tr>
</table>
</form>

Edit Function Doesn't Pick The Respective Values

Similar Tutorials

View Content

<?Php
        require "config.php";           

        $page_name="currentout.php";  
        $start=$_GET['start'];
        if(strlen($start) > 0 and !is_numeric($start)){
        echo "Data Error";
        exit;
        }


        $eu = ($start - 0); 
        $limit = 10;                                 
        $this1 = $eu + $limit; 
        $back = $eu - $limit; 
        $next = $eu + $limit; 

        $nume = $dbo->query("select count(id) from receipt")->fetchColumn();


        echo "<TABLE class='t1'>";
        echo  "<tr><th>ID</th><th>Name</th><th>Pass</th><th>Amount</th><th>Action</th></tr>";


        $query=" SELECT * FROM receipt  limit $eu, $limit ";


        foreach ($dbo->query($query) as $row) {

        @$m=$i%2;
        @$i=$i+1;   
        echo "<tr class='r$m'><td>$row[id]</td><td>$row[name]</td><td>$row[phone_num]</td><td>$row[Amount]</td><td><a href='delete.php?id=$row[id]'>delete</a></td><td><a href='edit.php?id=$row[id]'>Edit</a></td></tr>";
        }
        echo "</table>";

        if($nume > $limit ){ 
        echo "<table align = 'center' width='50%'><tr><td  align='left' width='30%'>";

        if($back >=0) { 
        print "<a href='$page_name?start=$back'><font face='Verdana' size='2'>PREV</font></a>"; 
        } 

        echo "</td><td align=center width='30%'>";
        $i=0;
        $l=1;
        for($i=0;$i < $nume;$i=$i+$limit){
        if($i <> $eu){
        echo " <a href='$page_name?start=$i'><font face='Verdana' size='2'>$l</font></a> ";
        }
        else { echo "<font face='Verdana' size='4' color=red>$l</font>";}        
        $l=$l+1;
        }


        echo "</td><td  align='right' width='30%'>";

        if($this1 < $nume) { 
        print "<a href='$page_name?start=$next'><font face='Verdana' size='2'>NEXT</font></a>";} 
        echo "</td></tr></table>";

        } 
        ?>

The code below is edit.php. It's supposed to display the various fields when clicked to allow for editing but it isn't picking any field, PLEASE assist.

<?Php
require "config.php";   
$sql = "SELECT FROM receipt  WHERE ID=  :ID";

$stmt = $dbo->prepare($sql);
$stmt->bindParam(':ID', $_GET['id'], PDO::PARAM_INT);  
$stmt->execute();
?>

    <form action="update.php" method="post" enctype="multipart/form-data">
    <table align="center">
   <tr>
   <td> <label><strong>Full Names</strong></label></td>
     <td> <input type='text' name='name' value=" <?php echo $row['name']; ?>"  />
      <input type="hidden" name="id" value="<?php echo $id; ?> " /> <br /></td>
    </tr>
    <tr>

     <td><label><strong>ID/Passport No. </strong></label></td>
  <td> <input type="text" name="pass" value="<?php echo $row['id_passno']; ?> " /><br /></td>
  </tr>
   <tr>
    <td> <label><strong>Phone No. </strong></label></td>
    <td><input type="text" name="phone" value="<?php echo $row['phone_num']; ?>" /> <br /></td>
    </tr>
    <tr>

    <td> <label><strong>Amount (KShs.) </strong></label></td>
    <td><input type="text" name="amount" value="<?php echo $row['Amount']; ?> "/> <br /></td>
   </tr>
    <tr>
  <td> 
          <input type="reset" name="Reset" value="CANCEL" onClick="return confirm('Discard changes?');" />
      <br></td>


     <td> 
          <input type="submit" name="Submit2" value="SUBMIT" />
      </td>
   </tr>
</table>
</form>

Mysql Update Not Working For 1 Value, But Working With Other Values

Similar Tutorials

View Content

When I echo the POST, it echoes the correct value.
The MySQL portion seems to just ignore it all together.
I've tried changing the dropdown option to just a text field, same thing occurred.
I have text fields right above this particular one that update just fine with the SAME exactly scripting.
if POST, update query, done. Works.

This one for some reason will not.

MySQL portion:
if ($_POST['bUpdate']){
mysql_query("UPDATE `Patients` SET `b` = '$_POST[bUpdate]' WHERE `id` = '".$_GET['id']."'");
}
echo $_POST['bUpdate'];

Form Portion:
Code: [Select]
<tr onmouseover="color(this, '#baecff');" onmouseout="uncolor(this);">
<td width="310" colspan="2" align="center"><span class="fontoptions">Postcard Status </span><br />
<?
if ($data['b'] == 1){
echo '<select name="bUpdate"><option value="1" selected>Yes</option><option value="0">No</option></select>';
} else {
echo '<select name="bUpdate"><option value="1">Yes</option><option value="0" selected>No</option></select>';
}

?>
</td>
</tr>

My Update And Add Isn't Working/..

Similar Tutorials

View Content

Hey guys been asking a bunch of my friends that know some php to try and help me with this issue im having with no success .. so i come here hoping to get answers i need. The delete function works but add and update dont work.

<?php session_start(); require 'approve.php'; ?>
<!DOCTYPE html>
<html>
<head>
  <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  <title>Contacts</title>
  
  <!-- Include jQuery -->
  <script type='text/javascript' src='https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js'></script>
  
  <style type='text/css'>

    body {
   background-color: #333;  
   color: #999;
   font: 12px/1.4em Arial,sans-serif;
}
#wrap {
   margin: 10px auto;        
   background: #666;
   padding: 10px;
   width: 1024px;
}
#header {
   background-color: #666;
   color: #FFF;
}
#logo {
   font-size: 30px;  
   line-height: 40px;    
   padding: 5px;
}
#navWrap {
   height: 30px;
}
#nav {
   padding: 5px;
   background: #999;    
}
#nav ul {
   margin: 0;
   padding: 0;    
}
#nav li {
   float: left;
   padding: 3px 8px;
   background-color: #FFF;
   margin: 0 10px 0 0;
   color: #F00;
   list-style-type: none;
}
#nav li a {
   color: #F00;  
   text-decoration: none;    
}
#nav li a:hover {
   text-decoration: underline;   
}
br.clearLeft {
   clear: left;        
}â€‹

  </style>
  


<script type='text/javascript'>
//<![CDATA[ 

  $(function() {
    // Stick the #nav to the top of the window
    var nav = $('#nav');
    var navHomeY = nav.offset().top;
    var isFixed = false;
    var $w = $(window);
    $w.scroll(function() {
        var scrollTop = $w.scrollTop();
        var shouldBeFixed = scrollTop > navHomeY;
        if (shouldBeFixed && !isFixed) {
            nav.css({
                position: 'fixed',
                top: 0,
                left: nav.offset().left,
                width: nav.width()
            });
            isFixed = true;
        }
        else if (!shouldBeFixed && isFixed)
        {
            nav.css({
                position: 'static'
            });
            isFixed = false;
        }
    });
});

//]]>  
</script>


</head>
<body>

<div id="wrap">
    
    <!-- The header code, including the menu -->
    <div id="header">
        <div id="logo">Contacts<br /></div>
        <div id="navWrap">
            <div id="nav">
                <ul>
                    <li><a href="#" class="smoothScroll"><a href="export.php">Export Contacts</a></a></li>
                </ul>    
                <br class="clearLeft" />
            </div>
        </div>
    </div>
    
<?php

$separate = '';

ini_set('display_errors', 'On');
ini_set("xdebug.var_display_max_depth", -1);
ini_set("xdebug.var_display_max_children", -1);
ini_set("xdebug.var_display_max_data", -1);
$con = mysql_connect("66.150.xxx.xxx","contact","xxx");
if (!$con){
die("Can not connect: " . mysql_error());
}
mysql_select_db("zadmin_contact",$con);
 
if (isset($_POST['update'])){
$UpdateQuery = "UPDATE contact SET ID='$_POST[id]',Title='$_POST[title], First Name='$_POST[firstname]', Last Name='$_POST[lastname]', Company='$_POST[company]', Job Title='$_POST[jobtitle]', Business Phone='$_POST[businessphone]',Home Fax='$_POST[homefax]', Home Phone='$_POST[homephone]', Mobile Phone='$_POST[mobilephone]', E-mail Address='$_POST[email]' WHERE Name='$_POST[hidden]'";
mysql_query($UpdateQuery, $con);
};
 
if (isset($_POST['delete'])){
$DeleteQuery = "DELETE FROM contact WHERE ID='$_POST[hidden]'";
mysql_query($DeleteQuery, $con);
};
 
 
if (isset($_POST['add'])){
$AddQuery = "INSERT INTO contact (ID, Title, First Name, Last Name, Company, Job Title, Business Phone, Home Fax, Home Phone, Mobile Phone, E-mail Address) VALUES ('$_POST[uid]','$_POST[utitle]', '$_POST[ufirstname]', '$_POST[ulastname]', '$_POST[ucompany]', '$_POST[ujobtitle]', '$_POST[ubusinessphone]', '$_POST[uhomefax]', '$_POST[uhomephone]', '$_POST[umobilephone]', '$_POST[uemail]')";
mysql_query($AddQuery, $con);
};
 
 
 
$sql = "SELECT * FROM contact";
$myData = mysql_query($sql,$con);
echo "<table border=1 bgcolor=#FFFFFF align=center>
<tr>
<th>ID</th>
<th>Title</th>
<th>First Name</th>
<th>Last Name</th>
<th>Company</th>
<th>Job Title</th>
<th>Business Phone</th>
<th>Home Fax</th>
<th>Home Phone</th>
<th>Mobile Phone</th>
<th>E-mail Address</th>
</tr>";
while ($record = mysql_fetch_array($myData))
{
echo "<form action=\"dashboard.php\" method=\"post\">";
echo "<tr>";
echo "<td>" . "<input type=\"text\" name=\"id\" value=\"" . $record['ID'] . "\"> </td>";
echo "<td>" . "<input type=\"text\" name=\"title\" value=\"" . $record['Title'] . "\"> </td>";
echo "<td>" . "<input type=\"text\" name=\"firstname\"  value=\"" . $record['First Name'] . "\"> </td>";
echo "<td>" . "<input type=\"text\" name=\"lastname\"  value=\"" . $record['Last Name'] . "\"> </td>";
echo "<td>" . "<input type=\"text\" name=\"company\"  value=\"" . $record['Company'] . "\"> </td>";
echo "<td>" . "<input type=\"text\" name=\"jobtitle\"  value=\"" . $record['Job Title'] . "\"> </td>";
echo "<td>" . "<input type=\"text\" name=\"businessphone\"  value=\"" . $record['Business Phone'] . "\"> </td>";
echo "<td>" . "<input type=\"text\" name=\"homefax\"  value=\"" . $record['Home Fax'] . "\"> </td>";
echo "<td>" . "<input type=\"text\" name=\"homephone\"  value=\"" . $record['Home Phone'] . "\"> </td>";
echo "<td>" . "<input type=\"text\" name=\"mobilephone\"  value=\"" . $record['Mobile Phone'] . "\"> </td>";
echo "<td>" . "<input type=\"text\" name=\"email\"  value=\"" . $record['E-mail Address'] . "\"> </td>";
echo "<input type=\"hidden\" name=\"hidden\" value=\"" . $record ['ID'] . "\">";
echo "<td>" . "<input type=\"submit\" name=\"update\" value=\"update\"> </td>";
echo "<td>" . "<input type=\"submit\" name=\"delete\" value=\"delete\"> </td>";
echo "</tr>";
echo "</form>";
}
echo "<form action=\"dashboard.php\" method=\"post\">";
echo "<tr>";
echo "<td><input type=\"text\" placeholder=\"ID\" name=\"uid\"></td>";
echo "<td><input type=\"text\" placeholder=\"Title\" name=\"utitle\"></td>";
echo "<td><input type=\"text\" placeholder=\"Fist Name\" name=\"ufirstname\"></td>";
echo "<td><input type=\"text\" placeholder=\"Last Name\" name=\"ulastname\"></td>";
echo "<td><input type=\"text\" placeholder=\"Company\" name=\"ucompany\"></td>";
echo "<td><input type=\"text\" placeholder=\"Job Title\" name=\"ujobtitle\"></td>";
echo "<td><input type=\"text\" placeholder=\"Business Phone\" name=\"ubusinessphone\"></td>";
echo "<td><input type=\"text\" placeholder=\"Home Fax\" name=\"uhomefax\"></td>";
echo "<td><input type=\"text\" placeholder=\"Home Phone\" name=\"uhomephone\"></td>";
echo "<td><input type=\"text\" placeholder=\"Mobile Phone\" name=\"umobilephone\"></td>";
echo "<td><input type=\"text\" placeholder=\"E-mail Address\" name=\"uemail\"></td>";
echo "<td>" . "<input type=\"submit\" name=\"add\" value=\"add\"></td>";
echo "</form>";
echo "</table>";
 
 
 
mysql_close($con);

?>
<p>Copyright &copy; <?php echo date("Y"); ?> Kuro. All rights reserved.</p>

Edited by syntax556, 15 July 2014 - 08:04 AM.

Update Not Working

Similar Tutorials

View Content

Anyone have any idea why this is not wokring?

if ($_POST[partsyes] == 'yes'){
$sql10="insert into tbl_partsordered (col_ticketid, col_price, col_orderedfrom, col_part, col_date) values ($_SESSION[ticketid], '$_POST[pprice]', '$_POST[pfrom]', '$_POST[part]', CURDATE( ))";
$result10=mysql_query($sql10) or die ('Error: '.mysql_error ());
//get tech comments so we can add our parts ordered to them.
$sql11="SELECT col_techcomments FROM tbl_ticket where id = $_SESSION[ticketid]";
$result11=mysql_query($sql11) or die ('Error: '.mysql_error ());
while($row11 = mysql_fetch_array($result11)) {
$newtechcomments = $row11[col_techcomments] . " " . "Ordered Parts" . " " .$_POST[part] . " " .$_POST[pprice] . " " . "From:" .$_POST[pfrom] . " ". $today;
$sql12="update tbl_ticket set col_techcomments='$newtechcomments' where id = $_POST[ticketid]";
$result12=mysql_query($sql12) or die ('Error: '.mysql_error ());
}

}

The first query pull data out of the database. then concatenates that string with other strings.

The update query never runs? If I add echo $sql2; and copy the sql that is displayed on the screen and paste it into phpadmin it updates just fine.

I tried putting a typo in on the query just to see if it failed. It does. so I know its running the query

This is driving me nuts. I know it's gotta be a typo somewhere.

Also don't make fun of my code.. I know It's gotta be bad.

Update Php/sql Not Working.

Similar Tutorials

View Content

Hello all, I have tried the following syntax to update a record from the $_POST method, and I cannot get it to update the record. Can anyone spot where I'm going wrong in my code

Code: [Select]
<?php
$idstudent = $_POST["idstudent"];
$childname = $_POST["childname"];
$parentname = $_POST["parentname"];
$dated = $_POST["dated"];
$datem = $_POST["datem"];
$datey = $_POST["datey"];
$dob = $datey ."-". $datem ."-".$dated;
$age = $_POST["age"];
$lastupdate = date("Y\-m\-d");
$gender = $_POST["gender"];
$address1 = $_POST["address1"];
$address2= $_POST["address2"];
$city = $_POST["city"];
$postcode = $_POST["postcode"];
$phone = $_POST["phone"];
$mobile = $_POST["mobile"];
$email = $_POST["email"];
$pass= $_POST["password"];
$height = $_POST["height"];
$neck = $_POST["neck"];
$chest = $_POST["chest"];
$hips = $_POST["hips"];
$waist = $_POST["waist"];
$insideleg = $_POST["insideleg"];
$dress = $_POST["dress"];
$shoe = $_POST["shoes"];
$haircolour = $_POST["haircolour"];
$hairlength = $_POST["hairstyle"];
$eyes = $_POST["eyecolour"];
$ethnicity = $_POST["ethnicity"];
$image = $_POST["image"];
$approve = "0";
$actor = $_POST["actor"];
$standin = $_POST["standin"];
$voiceover = $_POST["voiceover"];
$stagecombat = $_POST["stagecombat"];
$daballet = $_POST["daballet"];
$dasalsa = $_POST["dasalsa"];
$dabreak = $_POST["dabreak"];
$dadisco = $_POST["dadisco"];
$dahiphop = $_POST["dahiphop"];
$dajazz = $_POST["dajazz"];
$damodern = $_POST["damodern"];
$dastreet = $_POST["dastreet"];
$datap = $_POST["datap"];
$dacontemp = $_POST["dacontemp"];
$dafreestyle = $_POST["dafreestyle"];
$daswing = $_POST["daswing"];
$dawaltz = $_POST["dawaltz"];

include ('../../source/db_config.php');
$db = mysql_connect($host,$username,$password) or die(mysql_error());
mysql_select_db($database, $db) or die(mysql_error());
$update = "UPDATE 'students' SET 'childname'='$childname', 'parentname'='$parentname', 'dob'='$dob', 'age'='$age',
'lastupdate'='$lastupdate', 'gender'='$gender', 'address1'='$address1', 'address2'='$address2', 'city'='$city',
'postcode'='$postcode', 'phone'='$phone', 'mobile'='$mobile', 'email'='$email', 'password'='$pass',
'height'='$height', 'neck'='$neck', 'chest'='$chest', 'hips'='$hips', 'waist'='$waist', 'insideleg'='$insideleg',
'dress'='$dress', 'shoe'='$shoe', 'haircolour'='$haircolour', 'hairlength'='$hairlength', 'eyes'='$eyes',
'ethnicity'='$ethnicity', 'actor'='$actor', 'standin'='$standin', 'stagecombat'='$stagecombat', 'daballet'='$daballet',
'dasalsa'='$dasalsa', 'dabreak'='$dabreak', 'dadisco'='$dadisco', 'dahiphop'='$dahiphop', 'dajazz'='$dajazz',
'damodern'='$damodern', 'dastreet'='$dastreet', 'datap'='$datap', 'dacontemp'='$dacontemp',
'dafreestyle'='$dafreestyle', 'daswing'='$daswing', 'dawaltz'='$dawaltz' WHERE 'id'='$idstudent'";
mysql_query($update);
?>
Don't worry about the password either.. it is passed through md5 encryption.

But any help will be greatly appreciated

Pls Help My Update Command Isn't Working

Similar Tutorials

View Content

Hello people,

At the moment I am really desperate. I've done this script over 20 times now, always with the same script but all of a suddon, it doesn't work anymore. heres the problem:

I made a very simple "patient database" for a doctor. Where he can upload patients, alter and delete them. The script to add the patients works fine. now im trying to make a script where he can alter the variables agian, using the UPDATE command. but instead of updating the variables it cleares all the date in the row.

can someone help me? here s the entire code:

Code: [Select]
<?PHP
include'connect.php';
?>
<?PHP
$SQL = mysql_query("SELECT * FROM leys_patienten WHERE patientid='".$_REQUEST['patientid']."'");
while ($row = mysql_fetch_array($SQL))
{
?>
<?PHP
if ($_POST[submit]) {
if (!$_POST[volgnummer]) {
echo "<font size=\"2\" color=\"#990000\"><b>--> Vul een volgnummer in a.u.b. <--</b></font>";
}
elseif (!$_POST[naam])
{
echo "<font size=\"2\" color=\"#990000\"><b>--> Vul een naam in a.u.b. <--</b></font>";
}
elseif (!$_POST[voornaam])
{
echo "<font size=\"2\" color=\"#990000\"><b>--> Vul een voornaam in a.u.b.! <--</b></font>";
}
else {

mysql_query("UPDATE leys_patienten SET volgnummer='$volgnummer',naam='$naam',voornaam='$voornaam',adres='$adres',postcode='$postcode',plaats='$plaats',telefoon='$telefoon',email='$email',geboortedatum='$geboortedatum',geboorteplaats='$geboorteplaats',opmerkingen='$opmerkingen' WHERE patientid='".$_REQUEST['patientid']."'")
or die(mysql_error());

echo "Het patientendossier is succesvol gewijzigd, let op doorschakeling.";?>
<meta http-equiv="Refresh" content="1; url=patient.php?patientid=<?PHP echo $row['patientid']?>" />
<?
}
}
?></p>

<form action="<?$PHP_SELF?>" method="post" name="post" id="post">
<table width="805" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="table_forms">Volgnummer*</td>
<td class="table_forms"><label><input name="volgnummer" type="text" id="volgnummer" value="<?PHP echo $row['volgnummer']?>" size="40" /></label></td>
</tr>
<tr>
<td width="146" class="table_forms">Naam*</td>
<td width="659" class="table_forms"><label><input name="naam" type="text" id="naam" value="<?PHP echo $row['naam']?>" size="40" /></label></td>
</tr>
<tr>
<td class="table_forms">Voornaam*</td>
<td class="table_forms"><font color="#FFFFFF" size="2">
<label><input name="voornaam" type="text" id="voornaam" value="<?PHP echo $row['voornaam']?>" size="40" /></label>
</font></td>
</tr>
<tr>
<td class="table_forms">Adres </td>
<td><font color="#FFFFFF" size="2">
<label><input name="adres" type="text" id="adres" value="<?PHP echo $row['adres']?>" size="40" /></label>
</font></td>
</tr>
<tr>
<td class="table_forms">Postcode</td>
<td><font color="#FFFFFF" size="2">
<label><input name="postcode" type="text" id="postcode" value="<?PHP echo $row['postcode']?>" size="6" /></label>
</font></td>
</tr>
<tr>
<td class="table_forms">Plaats</td>
<td><font color="#FFFFFF" size="2">
<label><input name="plaats" type="text" id="plaats" value="<?PHP echo $row['plaats']?>" size="40" /></label>
</font></td>
</tr>
<tr>
<td class="table_forms">Telefoon</td>
<td><font color="#FFFFFF" size="2">
<label><input name="telefoon" type="text" id="telefoon" value="<?PHP echo $row['telefoon']?>" size="40" /></label>
</font></td>
</tr>
<tr>
<td class="table_forms">E-mail</td>
<td><font color="#FFFFFF" size="2">
<label><input name="email" type="text" id="email" value="<?PHP echo $row['email']?>" size="40" /></label>
</font></td>
</tr>
<tr>
<td class="table_forms">Geboortedatum</td>
<td><font color="#FFFFFF" size="2">
<label><input name="geboortedatum" type="text" id="geboortedatum" value="<?PHP echo $row['geboortedatum']?>" size="40" /></label>
</font></td>
</tr>
<tr>
<td class="table_forms">Geboorteplaats</td>
<td><font color="#FFFFFF" size="2">
<label><input name="geboorteplaats" type="text" id="geboorteplaats" value="<?PHP echo $row['geboorteplaats']?>" size="40" /></label>
</font></td>
</tr>
<tr>
<td valign="top" class="table_forms">Opmerkingen</td>
<td><font color="#FFFFFF" size="2">
<label><textarea name="opmerkingen" cols="40" rows="4" id="opmerkingen"><?PHP echo $row['opmerkingen']?></textarea></label>
</font></td>
</tr>
<tr>
<td valign="top" class="table_forms"> </td>
<td><span class="body_tekst">
<input type="submit" id="submit" name="submit" value="verstuur" />
</span></td>
</tr>
</table>
<p class="body_tekst"> </p>
</form>
<?
}
?>

Update Query Not Working ... Please Help

Similar Tutorials

View Content

I would like to edit a record that I already have in my database but my query is not working for some reason. Hope someone can help.

The errors i get are
Notice: Undefined variable: first_name in C:\chemicaluser\www\editinfo.php on line 40
Notice: Undefined variable: last_name in C:\chemicaluser\www\editinfo.php on line 40
Notice: Undefined variable: log_number in C:\chemicaluser\www\editinfo.php on line 40

.... line 40 = my query
$query = "UPDATE table1 SET first_name = '$first_name', last_name = '$last_name' WHERE log_number = '$log_number' ";

Very simple database, 1 table w/ 2 fields
table name = table1
fields = first_name, last_name

my php file
Code: [Select]
<?php
  require ('/menu.php');
  require_once('sqlconnect.php');

  if (isset($_GET['log_number']) && isset($_GET['first_name']) && isset($_GET['last_name']) ) {
    $log_number = $_GET['log_number'];
    $first_name = $_GET['first_name'];
    $last_name = $_GET['last_name'];
  }
  else if
     (isset($_POST['log_number']) && isset($_POST['first_name']) && isset($_POST['last_name']) ) {
  $log_number = $_POST['log_number'];
  $first_name = $_POST['first_name'];
  $last_name = $_POST['last_name'];
  }

if (isset($_POST['submit'])) {
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$query = "UPDATE table1 SET first_name = '$first_name', last_name = '$last_name' WHERE log_number = '$log_number' ";
$result = mysqli_query($dbc, $query)
or die ('Error querying database');
mysqli_close($dbc);
}

?>

my form
Code: [Select]
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<label for="first_name">First name</label>
<input type="text" id="first_name" name="first_name" value="<?php if (!empty($first_name)) echo $first_name; ?>"/>
<label for="last_name">Last Name</label>
<input type="text" id="last_name" name="last_name" value="<?php if (!empty($last_name)) echo $last_name; ?>" />
<input type="submit" value="Edit Information" name="submit" />
</form>

Update A Profile Not Working

Similar Tutorials

View Content

ok, so I have found this code to edit profiles online, only problem is that the data is not being posted to the database, there are no errors, just basically refreshes the page. could you take a look and see if you can help me?
Code: [Select]
<?php
}
//action: edit user -----------------------------------------------------------------------------
if (isset($_GET['edit']) && isset($_GET['id'])) {
$userid = (int) $_GET['id'];
if ($userid == 0) {
die("Invalid ID provided.");
}
//execution when completed the edit user form and pressed submit button ---------------------
if (isset($_POST['editUser'])) {
//validate data ------------------------------------------------------------------------
//check empty fields
//passwords won't be checked, as they are not required
foreach ($_POST as $k=>$v) {
if ($v == "" && !in_array($k,$notRequired)) {
$error[$k] = "<strong>This field is empty</strong>";
}
}
//escape string
$name = mysql_real_escape_string($_POST['name']);
$phone = mysql_real_escape_string($_POST['phone']);
$address = mysql_real_escape_string($_POST['address']);
$city = mysql_real_escape_string($_POST['city']);
$state = mysql_real_escape_string($_POST['state']);
$zip = mysql_real_escape_string($_POST['zip']);
$cell = mysql_real_escape_string($_POST['cell']);
$email = mysql_real_escape_string($_POST['email']);
$username = mysql_real_escape_string($_POST['username']);
$badges = mysql_real_escape_string($_POST['badges']);
$rank = mysql_real_escape_string($_POST['rank']);
$accounttype = mysql_real_escape_string($_POST['accounttype']);

//check email validation, the function is available at config.php
if (!check_email($_POST['email'])) {
$error['email'] .= " <strong>Email is not valid!</strong>";
}
//check email exists in database
$res = mysql_query("SELECT email FROM members WHERE email='".$email."' AND userid != '".$userid."'");
if (mysql_num_rows($res) == 1) {
$error['email'] .= " <strong>Email already existst in database!</strong>";
}
//check username exists in database
$res = mysql_query("SELECT username FROM members WHERE username='".$username."' AND username != '".$username."'");
if (mysql_num_rows($res) == 1) {
$error['username'] .= " <strong>Username already existst in database!</strong>";
}
//check both passwords are the same when password fields are not empty

//end validate data ---------------------------------------------------------------------

//save to database when no errors are detected ------------------------------------------
if (count($error) == 0) {
$query = "UPDATE members SET username='".$username."', email='".$email."',name='".$name."', phone='".$phone."',address='".$address."', city='".$city."',state='".$state."', zip='".$zip."',cell='".$cell."', accounttype='".$accounttype."',badges='".$badges."', rank='".$rank."' ";

$query .= "username='".$username."', email='".$email."',name='".$name."', phone='".$phone."',address='".$address."', city='".$city."',state='".$state."', zip='".$zip."',cell='".$cell."', accounttype='".$accounttype."',badges='".$badges."', rank='".$rank."' WHERE userid='".$userid."'";

//update username session if you edit yourself
if ($userid == $_SESSION['auth_admin_userid']) {
$_SESSION['auth_admin_username'] = $username;
}

if (mysql_query($query)) {
echo "<p><strong>User has been edited and saved to the database.</strong></p>";
} else {
echo "<strong>User has NOT been edited and saved into the database. ".mysql_error()."</strong>";
}
}
}
//get user from the database and put data into $_POST variables.
$rs = mysql_query("SELECT name, username, phone, address, city, state, zip, cell, email, badges, rank, accounttype FROM members WHERE userid = ".$userid."");
if (mysql_num_rows($rs) == 0) {
die("User does not exists!");
}
$row = mysql_fetch_assoc($rs);
$_POST['name'] = $row['name'];
$_POST['username'] = $row['username'];
$_POST['phone'] = $row['phone'];
$_POST['address'] = $row['address'];
$_POST['city'] = $row['city'];
$_POST['state'] = $row['state'];
$_POST['zip'] = $row['zip'];
$_POST['cell'] = $row['cell'];
$_POST['email'] = $row['email'];
$_POST['badges'] = $row['badges'];
$_POST['rank'] = $row['rank'];
$_POST['accounttype'] = $row['accounttype'];

//if is admin, then $_POST['admin'] exists

?>

<div id="TabbedPanels1" class="TabbedPanels">
<ul class="TabbedPanelsTabGroup">
<li class="TabbedPanelsTab" tabindex="0">My Info</li>
<li class="TabbedPanelsTab" tabindex="0">Merit Badges</li>
<li class="TabbedPanelsTab" tabindex="0">Scout Rank</li>
</ul>
<div class="TabbedPanelsContentGroup">
<div class="TabbedPanelsContent">
<form action="admin.php?edit&id=<?php echo $userid;?>" method="post">
<table align="center" cellpadding="8" cellspacing="8">
<tr>
<td><div align="right">Name:</div></td>
<td> <p><input type="text" name="name" value='<?php echo $_POST['name'];?>' />
<?php echo(isset($error['name']))?$error['name']:"";?></p></td>
</tr>
<tr>
<td>Phone Number:</td>
<td><input type="text" name="phone" value='<?php echo $_POST['phone'];?>' />
<?php echo(isset($error['phone']))?$error['phone']:"";?></td>
</tr>
<tr>
<td><div align="right">Address:</div></td>
<td><input type="text" name="address" value='<?php echo $_POST['address'];?>' />
<?php echo(isset($error['address']))?$error['address']:"";?></td>
</tr>
<tr>
<td><div align="right">City:</div></td>
<td><input type="text" name="city" value='<?php echo $_POST['city'];?>' />
<?php echo(isset($error['city']))?$error['city']:"";?></td>
</tr>
<tr>
<td><div align="right">State:</div></td>
<td><input type="text" name="state" value='<?php echo $_POST['state'];?>' />
<?php echo(isset($error['state']))?$error['state']:"";?></td>
</tr>
<tr>
<td><div align="right">Zip Code:</div></td>
<td><input type="text" name="zip" value='<?php echo $_POST['zip'];?>' />
<?php echo(isset($error['zip']))?$error['zip']:"";?></td>
</tr>
<tr>
<td><div align="right">Email:</div></td>
<td>
<p>
<input type="text" name="email" value='<?php echo $_POST['email'];?>' />
<?php echo(isset($error['email']))?$error['email']:"";?></p></td>
</tr>
<tr>
<td><div align="right">Cell Phone:</div></td>
<td><input type="text" name="cell" value='<?php echo $_POST['cell'];?>' />
<?php echo(isset($error['cell']))?$error['cell']:"";?></td>
</tr>
<tr>
<td class="aaaaaaa" align="right">Username:</td>
<td><label for="username"></label>
<input type="text" name="username" value='<?php echo $_POST['username'];?>' />
<?php echo(isset($error['username']))?$error['username']:"";?></p>
</td>
</tr>

</table>
<p>  </p>

<input name="submit" type="submit" value="Save" />

</form>
</div>
<div class="TabbedPanelsContent">
<label for="badges"></label>
<input name="badges" type="text" id="badges" value="<?php echo "$badges"; ?>" />
</div>
<div class="TabbedPanelsContent">
<input name="badges2" type="text" id="badges2" value="<?php echo $rank; ?>" />
</div>
</div>
</div> <script type="text/javascript">
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1");
</script>
<?php
}
?>