Learn VBA & Macros in 1 Week!

PHP - Status Update Form Edit Functionality

Full Excel VBA Course - Beginner to Expert

Status Update Form Edit Functionality	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>

}
?>

Full Excel VBA Course - Beginner to Expert

Problem With A Simple Edit Page Functionality

Similar Tutorials

View Content

Hi There

I am trying to create a page that edit mysql database from a php page. I can get the edit page to show the orginal information but it wont update the data in the mysql database.

I am sure I have entered everything right. If anyone could help with this I would greatly appreciated

<?php

include("dbconnect.php");

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

{

// Set global variables to easier names
// and prevent sql injection and apostrophe to break the db.

$ProductName = mysql_escape_string($_POST['ProductName']);
$ProductText = mysql_escape_string($_POST['ProductText']);
$ProductImage = mysql_escape_string($_POST['ProductImage']);
$ProductPrice = mysql_escape_string($_POST['ProductPrice']);

$result = mysql_query("UPDATE Product SET ProductName='$ProductName', ProductText='$ProductText', ProductImage='$ProductImage', ProductPrice='$ProductPrice' WHERE ID='$ID' ",$dbconnect);

echo "<b>Thank you! Product UPDATED Successfully!<br>You'll be redirected to View Page after (2) Seconds";

echo "<meta http-equiv=Refresh content=2;url=view.php>";

echo "$ProductName <br> $ProductText <br> $ProductImage <br> $ProductPrice";

}

elseif(isset($_GET['ID']))

{

$result = mysql_query("SELECT * FROM Product WHERE ID='$_GET[ID]' ",$dbconnect);

while($myrow = mysql_fetch_assoc($result))

{

$ProductName = $myrow["ProductName"];
$ProductText= $myrow["ProductText"];
$ProductImage = $myrow["ProductImage"];
$ProductPrice = $myrow["ProductPrice"];

?>

<br>

<h3>::Edit Product</h3>

   <form method="post" action="<?php echo $PHP_SELF ?>">

      <input type="hidden" name="ID" value="<? echo $myrow['ID']?>">
      Product Name: <input name="ProductName" size="40" maxlength="255" value="<? echo $ProductName; ?>"><br>
      Product Text: <textarea name="ProductText" rows="7" cols="30"><? echo $ProductText; ?></textarea><br>
      Product Image: <textarea name="ProductImage" rows="7" cols="30"><? echo $ProductImage; ?></textarea><br>
      Product Price: <textarea name="ProductPrice" rows="7" cols="30"><? echo $ProductPrice; ?></textarea><br>
      <input type="submit" name="submit" value="Update Product">

   </form>

<?

}//end of while loop

}//end else

?>

Facebook Pages Status Update

Similar Tutorials

View Content

Cms Update/edit Function Not Working

Similar Tutorials

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']) ?>

Email Update Form

Similar Tutorials

View Content

I am trying to create a form on my website to have people sign up for email notifications.

Little confuse on this. i know i can do a form to submit info into a db or for an email to be sent to me.

i have seen some on website that have a sign up form for newsletters or etc...

how do these forms work? is there someone receiving all these emails or getting signed up user from a db and emailing each person?

confuse on this topic. can someone explain?

Update Using A Pre-populated Form

Similar Tutorials

View Content

Hopefully I can explain this well. I have a list, which is linked he

http://hoosierhoopsreport.com/test-11-rank/

When I'm done, I'm trying to set up the list I, as ADMIN, can make changes to the list without having to go into my database. I'm mostly concerned with the # column, but once we get through this, I can apply what I've learned.

I'm setting the form to print # and school as text fields. I'm getting id, nameFirst and nameLast as hidden values to pass to my form handler.

When I hit submit, I'm getting this error:
Quote

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id='172'' at line 5
Query: UPDATE wp_playerRank_copy SET rankClass='10', hschool='Avon HS', WHERE id='172'

I'm pretty sure it's just filtering through the information to most last piece of data handled, which isn't what I want, but I also don't understand why I'm getting the error.

Here is the code dealing with the form:

Code: [Select]
<form id="class2011" action="/resources/form/dbplayerUpdate.php" method="post">

<table class="playerTable" border="0" width="100%">
<thead>
<tr>
<th class="num">#</th>
<th class="top">Top 10</th>
<th class="height">HT</th>
<th class="pos">POS</th>';

if (current_user_can("access_s2member_level4")){
echo '<th class="level">Level</th>';
}
echo '<th class="school">City (School)</th>';

if (current_user_can("access_s2member_level4")){
echo '<th class="summer">Summer Team</th>';
}
echo '<th class="college">College</th>
</tr>
</thead>

<tfoot>
<tr>
<td colspan="8" align="right">(+) moved up; (d) debut; (s) switched from another position / <b>Colleges in bold print means committed</b></td>
</tr>
<tr>
<td><input id="Submit" name="Submit" type="submit" value="Submit" /></td>
</tr>
</tfoot>

<tbody>';$query = 'SELECT * FROM wp_playerRank_copy WHERE year="2011" ORDER BY rankClass ASC';
$results = mysql_query($query);
while($line = mysql_fetch_assoc($results)) {

if ($line['rankClass'] != 0) {

echo '
<tr>
<td>
<input type="hidden" name="db_id" value="' . $line['id'] . '"size="2">
<input type="text" name="rankClass" value="' . $line['rankClass'] . '"size="2">' . $line['devClass'] .'</td>
<td>';

if ($line['wpID'] > '0') {
echo '
<input type="hidden" name="nameFirst" value="' . $line['nameFirst'] . '"size="2">
<input type="hidden" name="nameLast" value="' . $line['nameLast'] . '"size="2">
<a href="/tag/' . $line['nameFirst'] . '-' . $line['nameLast'] .'">'. $line['nameFirst'] . ' ' . $line['nameLast'] . '</a>';
}
else
{
echo $line['nameFirst'] . ' ' . $line['nameLast'];
}
echo '</td><td>'. $line['height'] . '</td>
<td>'. $line['position'] . '</td>';

if (current_user_can("access_s2member_level4")){
echo '<td>'. $line['level'] . '</td>';
}
echo '<td><input type="text" name="hschool" value="' . $line['hschool'] .'"size="30"></td>';

if (current_user_can("access_s2member_level4")){
echo '<td>'. $line['summer'] . '</td>';
}

if ($line['committed'] == 'y') {
echo '
<td><strong>'. $line['college'] . '</strong></td>
';}

echo '</tr>
';}

}
echo '

</tbody></table></form>

Here is the form handler:

Code: [Select]
if(!$con = mysql_connect("localhost","jwrbloom_","redcoach")) {
die("Could not connect to database: ".mysql_error());
}
mysql_select_db("jwrbloom_wpHHR", $con);

$nameFirst = $_POST['nameFirst'];
$nameLast = $_POST['nameLast'];
$db_id = $_POST['db_id'];
$rankClass = $_POST['rankClass'];
$hschool = $_POST['hschool'];

//$grade = $_POST['grade'];
//$coachSchool = $_POST['coachSchool'];
//$feet = $_POST['feet'];
//$inches = $_POST['inches'];

/*
search for existing row
*/
$sql = "SELECT id FROM wp_playerRank_copy WHERE nameFirst='".mysql_real_escape_string($nameFirst)."' AND nameLast='".mysql_real_escape_string($nameLast)." '";
if(!$result = mysql_query($sql)) {
die(mysql_error()."<br />Query: ".$sql);
}
if(mysql_num_rows($result)) {
$row = mysql_fetch_assoc($result);
/*
update existing row
*/
$sql = "UPDATE wp_playerRank_copy SET
rankClass='".mysql_real_escape_string($rankClass)."',
hschool='".mysql_real_escape_string($hschool)."',

WHERE id='".$row['id']."'";
if(!$result = mysql_query($sql)) {
die(mysql_error()."<br />Query: ".$sql);
}
}

Update Form With Image

Similar Tutorials

View Content

have 2 scripts one that allows me to insert and upload image and one that allows me to delete and remove image so i was thinking in mix both together so it would be like this
first the delete image in an if statment then close } and then { an insert image but with an update mysql query}

i am trying to do a modify form where user can modify the data so i will need to update the image on the directory so with both delete and insert would it do the job???

<?php
define('ROOT_DIR', './');
define('PROPER', TRUE);
/**
* include common files
*/
include_once(ROOT_DIR. 'includes/common.inc.php');
// No album id has been selected
if (isset($_GET['drivers']))
{
   // get the image file name so we
   // can delete it from the server
   $sql = "SELECT id, image

           FROM driversnew

           WHERE id = {$_GET['drivers']}";

   $result = mysql_query($sql)

             or die('Delete photo failed. ' . mysql_error());

   if (mysql_num_rows($result) == 1) {

      $row = mysql_fetch_assoc($result);

define("GALLERY_IMG_DIR", "./images/");

      // remove the image and the thumbnail from the server
      unlink(GALLERY_IMG_DIR . $row['image']);

      unlink(GALLERY_IMG_DIR . 'thumbs/' . $row['image']);

      // and then remove the database entry


   }

}

/////////// this where the upload script starts/////////// this where the upload script starts//////// this where the upload script starts

//define a maxim size for the uploaded images
define ("MAX_SIZE","100");
// define the width and height for the thumbnail
// note that theese dimmensions are considered the maximum dimmension and are not fixed,
// because we have to keep the image ratio intact or it will be deformed
define ("WIDTH","150");
define ("HEIGHT","100");

// this is the function that will create the thumbnail image from the uploaded image
// the resize will be done considering the width and height defined, but without deforming the image
function make_thumb($img_name,$filename,$new_w,$new_h)
{
//get image extension.
$ext=getExtension($img_name);
//creates the new image using the appropriate function from gd library
if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))
$src_img=imagecreatefromjpeg($img_name);

if(!strcmp("png",$ext))
$src_img=imagecreatefrompng($img_name);

//gets the dimmensions of the image
$old_x=imageSX($src_img);
$old_y=imageSY($src_img);

// next we will calculate the new dimmensions for the thumbnail image
// the next steps will be taken:
// 1. calculate the ratio by dividing the old dimmensions with the new ones
// 2. if the ratio for the width is higher, the width will remain the one define in WIDTH variable
// and the height will be calculated so the image ratio will not change
// 3. otherwise we will use the height ratio for the image
// as a result, only one of the dimmensions will be from the fixed ones
$ratio1=$old_x/$new_w;
$ratio2=$old_y/$new_h;
if($ratio1>$ratio2) {
$thumb_w=$new_w;
$thumb_h=$old_y/$ratio1;
}
else {
$thumb_h=$new_h;
$thumb_w=$old_x/$ratio2;
}

// we create a new image with the new dimmensions
$dst_img=ImageCreateTrueColor($thumb_w,$thumb_h);

// resize the big image to the new created one
imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y);

// output the created image to the file. Now we will have the thumbnail into the file named by $filename
if(!strcmp("png",$ext))
imagepng($dst_img,$filename);
else
imagejpeg($dst_img,$filename);

//destroys source and destination images.
imagedestroy($dst_img);
imagedestroy($src_img);
}

// This function reads the extension of the file.
// It is used to determine if the file is an image by checking the extension.
function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return ""; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}

// This variable is used as a flag. The value is initialized with 0 (meaning no error found)
//and it will be changed to 1 if an errro occures. If the error occures the file will not be uploaded.
$errors=0;
// checks if the form has been submitted
if(isset($_POST['Submit']))
{
//reads the name of the file the user submitted for uploading
$image=$_FILES['image']['name'];
// if it is not empty
if ($image)
{
// get the original name of the file from the clients machine
$filename = stripslashes($_FILES['image']['name']);

// get the extension of the file in a lower case format
$extension = getExtension($filename);
$extension = strtolower($extension);
// if it is not a known extension, we will suppose it is an error, print an error message
//and will not upload the file, otherwise we continue
if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png"))
{
echo '<h1>Unknown extension!</h1>';
$errors=1;
}
else
{
// get the size of the image in bytes
// $_FILES[\'image\'][\'tmp_name\'] is the temporary filename of the file in which the uploaded file was stored on the server
$size=getimagesize($_FILES['image']['tmp_name']);
$sizekb=filesize($_FILES['image']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger
if ($sizekb > MAX_SIZE*1024)
{
echo '<h1>You have exceeded the size limit!</h1>';
$errors=1;
}

//we will give an unique name, for example the time in unix time format
$image_name=time().'.'.$extension;
//the new name will be containing the full path where will be stored (images folder)
$newname="images/".$image_name;
$copied = copy($_FILES['image']['tmp_name'], $newname);
//we verify if the image has been uploaded, and print error instead
if (!$copied)
{
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}
else
{
// the new thumbnail image will be placed in images/thumbs/ folder
$thumb_name='images/thumbs/'.$image_name;
// call the function that will create the thumbnail. The function will get as parameters
//the image name, the thumbnail name and the width and height desired for the thumbnail
$thumb=make_thumb($newname,$thumb_name,WIDTH,HEIGHT);
}} }}

//If no errors registred, print the success message and show the thumbnail image created
if(isset($_POST['Submit']) && !$errors)
{

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("eurico_edy", $con);

$query = "UPDATE products SET name = '$name',   location = '$location', date_of_birth='$date_of_birth', car_number='$car_number', favourite_track='$favourite_track', least_favourite_track='$least_favourite_track', achievements='$achievements', achievements='$achievements' email='$email', image='$image'   WHERE id = '$id'";

echo "<h1>Thumbnail created Successfully!</h1>";
echo '<img src="'.$thumb_name.'">';
echo ''.$newname.'';
mysql_close($con);
}

?>