Learn VBA & Macros in 1 Week!

PHP - Php Mysql Update Html Form Bugs Or Issues

Full Excel VBA Course - Beginner to Expert

Php Mysql Update Html Form Bugs Or Issues	View Content

My problem could be odd if say it but i will spill it out, only don't say I am mad completely jut a bit !

1.when comment is first in whole news if i press edit appear html form but if i am trying to submit any information it returns to comments and don't update !
2.if there were more than one comment in news if i press edit appear html forms 1.not working | 2.working and do updates | 3.were appear but is gone but not sure does bug will return also not working !
Sample how it looks !

This is indeed odd hope somebody has knowledge in such issues or at least a cure for such severe bug

website http://hostings.flush.ws/
user guest password guest11 | to test bug go to the news comments and spam as much needed !

Link to edit code
Code: [Select]
echo "<a href='/?section=nwcomment&id=".$id."&comment=edit&id_edit=".$row_news_comment['hosting_comment_id']."'>Edit Comment</a>";

Update code as far i know it is correct at least i do hope sow (also this code is inside while cycle )
Code: [Select]
if ($_GET['comment'] == 'edit')
{
$comment_id_edit = (INT)$_GET['id_edit'];
$comment_text = $row_news_comment['hosting_comment_text'];
$edit_comment_text = $_POST['hosting_comment_text'];

if(isset($_POST['hosting_comment_text']))
{
mysql_query("UPDATE hosting_comment SET hosting_comment_text = '".$edit_comment_text."' WHERE hosting_comment_id = '".$comment_id_edit."' ") or die (mysql_error());
}

if (isset($_POST['Submit']))
{
echo "<meta http-equiv='REFRESH' content='0;url=/?section=nwcomment&id=".$id."'>";
}
echo ("<form action='/?section=nwcomment&id=".$id."&comment=edit&id_edit=".$comment_id_edit."'' id='edit_comment' name='edit_comment' method='post'>
<p>
<textarea name='hosting_comment_text' cols='50' rows='10' id='textarea' value='$edit_comment_text' ></textarea>
<p>
<input type='submit' name='Submit' id='button' value='{$lang['BODY_NEWS_COMMENT_SUBMIT']}' />
<input type='reset' name='Reset' id='button' value='{$lang['BODY_NEWS_COMMENT_RESET']}' />
</p>
</form>");
}
if is needed more complete code just ask i will publish it (i hope to fix bug as soon possible grand opening of registration will be on the Aprils Fools Day)

Full Excel VBA Course - Beginner to Expert

Mysql Update Form Help

Similar Tutorials

View Content

Hi
I currently have this form to update the names of each session in the database.
However how do I go about updating more than one value. I also want to update the 'order' swell as the name so the order in which they're displayed is updated

I want to have another text field next to it for the order which will just be a number but i can't figure out how to update both in the foreach() function

Code: [Select]
<?php

if($_POST['update_sessions']){
foreach($_POST as $sessionid => $sessionname){
mysql_query("UPDATE `sessions` SET `name`='".mysql_real_escape_string($sessionname)."' WHERE `id`='".mysql_real_escape_string($sessionid)."'");
}
echo("Done!");
}

?>
<form method="post">
<?php

$getsessions = mysql_query("SELECT * FROM `sessions` ORDER BY `order`");
while($sessions = mysql_fetch_array($getsessions)){
echo("<input type='text' name='".$sessions['id']."' value='".$sessions['name']."'><br />\n");
}
?>
<input type="submit" value="Update" name="update_sessions" />
</form>

Mysql Update With Form

Similar Tutorials

View Content

Having trouble where I think I need to provide most of my code to see what is happening. Trying to output a simple table of cameras. They are stored as part of a form with data filled in already. A user can change and hit the apply button for any camera in the row. The changes should update the db for that camera only (just that one row). The problem is that when I hit apply it doesn't make the change to the row. The exception is the very last row (last camera in the list). I tried to simplify the mysql update query to just one select (camera_status) to figure out what is going on.

The problem is that if I echo camera_status it is showing the wrong value. i.e. if I change the form select from Enabled to Disabled. Something wrong with how I'm doing the POST? I appreciate any guidance.

Code: [Select]
<?php
// Dont allow direct linking
defined('_JEXEC') or die('Direct Access to this location is not allowed.');
//get current user
$user =& JFactory::getUser();
// get a reference to the database
$db = &JFactory::getDBO();

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

    //process changes to camera options
    $camera_id = (int) $_POST['camera_id'];
    echo "CAMERA ID ".$camera_id;
    $camera_status = check_input($_POST['camera_status']);
    echo "CAMERA STATUS ".$camera_status;
    $camera_name = check_input($_POST['camera_name']);
    $camera_quality = check_input($_POST['camera_quality']);

    $query_insert_camera = 'UPDATE `#__cameras` SET `camera_status` ="'.$camera_status.'" WHERE `camera_id`='.$camera_id;
    echo "CAMERA query ".$query_insert_camera;
    $db->setQuery($query_insert_camera);
    $db->query();
}

function check_input($data, $problem='')
{
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    if ($problem && strlen($data) == 0)
    {
        show_error($problem);
    }
    return $data;
}

function show_error($myError)
{
    echo $myError;
    exit();
}

echo "<html>";
echo "<head>";

?>

<script type="text/javascript">
function oncameraSubmit(camera_id)
{
//TODO get camera name i.e. "Apply changes to <camera name>"
document.active_cameras.camera_id.value = camera_id;
return confirm('Apply changes?');
}
</script>
<?php
$query_camera_name = "SELECT camera_id, camera_name, camera_status, camera_quality, camera_hash, camera_type FROM #__cameras WHERE user_id=".$user->id." AND camera_status!='DELETED'";
$db->setQuery($query_camera_name);
//get number of cameras so we can build the table accordingly
$db->query();
$num_rows = $db->getNumRows();
// We can use array names with loadAssocList.
$result_cameras = $db->loadAssocList();

echo "</head>";
echo "<body>";

//check if we have cameras running (basically someone logged in)
if (!isset($result_cameras))
{
    //TODO check if query failed
}
else
{

    if ($num_rows == 0)
    {
        echo '<b><i><center>You currently have no cameras setup.  Add a Camera below.</center></i></b>';
    }
    else
    {
        ?>
<form name="active_cameras" action="<?php htmlentities($_SERVER['REQUEST_URI']); ?>" method="POST">
<input type="hidden" name="camera_id" value="" />
<table id="webcam-table">
<thead>
<tr>
<th>Camera Type</th>
<th>Name</th>
<th>Quality</th>
<th>Status</th>
<th>Camera Actions</th>
</tr>
</thead>
<tbody>
<?php
        for($i=0;$i<$num_rows;$i++)
        {

            //camera_status
            if ($result_cameras[$i]["camera_status"] == "ENABLED")
            {
                $enabled_option =  "value='ENABLED' selected='selected'";
                $disabled_option = "value='DISABLED'";
            }
            else
            {
                $enabled_option =  "value='ENABLED'";
                $disabled_option = "value='DISABLED' selected='selected'";
            }

            //camera_quality
            if ($result_cameras[$i]["camera_quality"] == "HIGH")
            {
                $high_option =  "value='HIGH' selected='selected'";
                $medium_option = "value='MEDIUM'";
                $mobile_option =  "value='MOBILE'";
            }
            else if ($result_cameras[$i]["camera_quality"] == "MEDIUM")
            {
                $high_option =  "value='HIGH'";
                $medium_option = "value='MEDIUM' selected='selected'";
                $mobile_option =  "value='MOBILE'";
            }
            else if ($result_cameras[$i]["camera_quality"] == "MOBILE")
            {
                $high_option =  "value='HIGH'";
                $medium_option = "value='MEDIUM'";
                $mobile_option =  "value='MOBILE' selected='selected'";
            }
            else
            {
                //TODO proper logging
            }

            //camera_type
            if ($result_cameras[$i]["camera_type"] == "WEBCAM")
            {
                $webcam =  "value='WEBCAM' selected='selected'";
                $axis = "value='AXIS'";
                $other =  "value='IPCAM'";
            }
            else if ($result_cameras[$i]["camera_type"] == "AXIS")
            {
                $webcam =  "value='WEBCAM'";
                $axis = "value='AXIS' selected='selected'";
                $other =  "value='IPCAM'";
            }
            else if ($result_cameras[$i]["camera_type"] == "IPCAM")
            {
                $webcam =  "value='WEBCAM'";
                $axis = "value='AXIS'";
                $other =  "value='IPCAM' selected='selected'";
            }
            else
            {
                //TODO proper logging
            }
            echo $result_cameras[$i]["camera_id"];

?>

<tr>
<td>
<?php echo $result_cameras[$i]["camera_type"] ?>
</td>
<td>
<input type="text" size="32" maxlength="64" name="camera_name" value="<?php echo $result_cameras[$i]["camera_name"]; ?>" />
</td>
<td>
<select name="camera_quality">
<option <?php echo $high_option; ?>>High</option>
<option <?php echo $medium_option; ?>>Medium</option>
<option <?php echo $mobile_option; ?>>Mobile</option>
</select>
</td>
<td>
<select name="camera_status">
<option <?php echo $enabled_option; ?>>Enabled</option>
<option <?php echo $disabled_option; ?>>Disabled</option>
</select>
</td>
<td>
<input type="submit" name="apply_changes" value="Apply" onClick="oncameraSubmit(<?php echo $result_cameras[$i]["camera_id"]; ?>);"/>
   
<input type="submit" name="delete" value="Delete" onClick="oncameraDelete(<?php echo $result_cameras[$i]["camera_id"]; ?>);"/>
   
<input type="submit" name="video" value="Launch" onClick="oncameraLaunch(<?php echo $result_cameras[$i]["camera_id"]; ?>);"/>

</td>
</tr>

<?php
        }

        echo "</tbody>";
        echo "</table>";
        echo "</form>";
    }
}

echo "</body>";
echo "</html>";

?>

Iis 5.1 Php 5.2.17, No Mysql - Html Form To Write Php With Form Data Saved

Similar Tutorials

View Content

There are two pieces to this- The HTML Form and the resulting php. I can't seem to make the leap, from the code to having the form produce the php page so others can view it until the form is again submitted overwriting the php, thus generating new content.

The environment I am working in is limited to IIs 5.1 and php 5.2.17 without mySQL or other DB

I'm new to php, this isn't homework,or commercialization, it's for children. I am thinking perhaps fwrite / fread but can't get my head around it.

Code snipets below. Any help, please use portions of this code in hopes I can understand it

Thanks

Code snipet from Output.php
Code: [Select]
<?php
$t1image = $_POST["t1image"];
$t1title = $_POST["t1title"];
$t1info = $_POST["t1info"];
$t2image = $_POST["t2image"];
$t2title = $_POST["t2title"];
$t2info = $_POST["t2info"];
?>
...
<tbody>
<tr>
<td style="vertical-align: top; text-align: center; background-color: rgb(204, 255, 255);">Animal</td>
<td style="vertical-align: top; text-align: center; background-color: rgb(204, 255, 255);">Image thumb<br>
</td>
<td style="vertical-align: top; text-align: center; background-color: rgb(204, 255, 255);">Date<br>
</td>
<td style="vertical-align: top; text-align: center; background-color: rgb(204, 255, 255);">Information<br>
</td>
</tr>
<tr>
<td style="vertical-align: top; text-align: center;">Monkey
</td>
<td style="vertical-align: top; text-align: center;"><img src="<?php echo $t1image.'.gif'; ?>">
</td>
<td style="vertical-align: top; text-align: center;"><?php echo date("m/d/Yh:i A"); ?>
</td>
<td style="vertical-align: top; text-align: center;"><a href="#monkey" rel="facebox"><?php echo $t1title ?></a>
<div id="Monkey" style="display:none">
<?php echo $t1info; ?>
</div>
</td>
</tr>
<tr>
<td style="vertical-align: top; text-align: center;">Cat<br>
</td>
<td style="vertical-align: top; text-align: center;"><img src="<?php echo $t2image.'.gif'?>"></td>
<td style="vertical-align: top; text-align: center;"><?php echo date("m/d/Yh:i A"); ?></td>
<td style="vertical-align: top; text-align: center;"><a href="#Cat" rel="facebox"><?php echo $t2title ?></a>
<div id="Cat" style="display:none">
<?php echo $t2info; ?>
</div>
</td>
</tr>
<tr>

This replicates several times down the page around 15-20 times ( t1### - t20###)

Code Snipet from HTML Form
Code: [Select]
<form action="animals.php" method="post">
<div style="text-align: left;"><big
style="font-family: Garamond; font-weight: bold; color: rgb(51, 51, 255);"><big><big><span>Monkey</span></big></big></big><br>
<table style="text-align: left; width: 110px;" border="0"
cellpadding="2" cellspacing="0">
<tbody><tr>
<td style="vertical-align: top;">Image thumb<br>
<input type="radio" name="t1image" value="No opinion" checked><img src="eh.gif" alt="Eh">
<input type="radio" name="t1image" value="Ok"><img src="ok.gif" alt="ok">
<input type="radio" name="t1image" value="Like"><img src="like.gif" alt="Like">
<input type="radio" name="t1image" value="Dont"><img src="dont.gif" alt="Don't Like">
<input type="radio" name="t1image" value="Hate"><img src="hate.gif" alt="Hate">
<input type="radio" name="t1image" value="Other"><img src="other.gif" alt="Other">
<br>
Why Title:<input type="text" name="t1title" size="45" value="..."/></td>
<td style="vertical-align: top;">
Explain:<br>
<textarea name="t1info" cols=45 rows=3 value="..."></textarea>
</td></tr></table>
<br>


How do I get the Form data to save to the php page for others to view?

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;

Simple Update Form Not Update Field On Database Help

Similar Tutorials

View Content

Hi i have this simple update form and scrip but somehow it doesnt seem to be update the field on the database can someone help out please.
The html form is the second form bellow where the action send to status_update.php
HTML FORM
Code: [Select]
<?php                include("../header.html");            ?>
<?php                include("header_news.html");
extract($_REQUEST,EXTR_SKIP);
?><?php
/*                print("sfilm_refnum = $sfilm_refnum<BR>");
print("sfilm_addr01 = $sfilm_addr01<BR>");
print("sfilm_postcode = $sfilm_postcode<BR>");
print("Film Client = $fclient<BR>");            */
?>
<form id="search" action="list.php" method="post" name="search">
<table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#eeeeee">
<tr>
<td align="right" width="140"></td>
<td width="320"><span class="hofblack10">
</span>
</td>
<td align="center" width="100"><input type="hidden" name="lstart" value="<?php print("$lstart"); ?>" /><input type="hidden" name="lend" value="<?php print("$lend"); ?>" /><input type="hidden" name="lamount" value="<?php print("$lamount"); ?>" /></td> <td align="center" width="100"></td>
<td align="right"></td>
</tr>
</table>
</form>
<table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#4050c4">
<tr>
<td width="60" class="hofwhite10">action</td>
<td width="140"><span class="hofwhite14">DATE</span></td>
<td width="80"><span class="hofwhite14">ID</span></td>
<td><span class="hofwhite14">News Titile</span></td>
<td width="100"><span class="hofwhite14">Status</span></td>
</tr>
<tr height="0">
<td bgcolor="white" width="60"></td>
<td bgcolor="white" width="140" height="0"></td>
<td bgcolor="white" width="80" height="0"></td>
<td bgcolor="white" height="0"></td>
<td bgcolor="white" width="100" height="0"></td>
</tr>
</table><table width="780" border="0" cellspacing="0" cellpadding="4"><tr>
<td width="60"></td>
<td width="80"></td>
<td><a class="blueullrg" href="add.php">Add News</a></td>
<td align="right" width="120"></td>
</tr>
<tr height="0">
<td width="60" height="0"></td>
<td width="80" height="0"></td>
<td height="0"></td>
<td align="right" width="120" height="0"></td>
</tr>
</table> <?php
//get the DB connection variables
include("../../../includes/config.php");
//connect to DB
$connection = @mysql_connect($db_address,$db_username,$db_password) or die("Couldn't CONNECT.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select DATABASE.");
$query2="SELECT * FROM news WHERE !(news_status='deleted')";
$result2 = mysql_query($query2) or die("Couldn't execute QUERY - Select NEWS Qty");
$fqty = mysql_num_rows($result2);
//SELECT or FIND the same USERNAME
$query3="SELECT * FROM news WHERE !(news_status='deleted') ORDER BY news_id DESC";
$result3 = mysql_query($query3) or die("Couldn't execute QUERY - Select NEWS");
while ($row = mysql_fetch_array($result3))
{
$news_id                 = $row['news_id'];
$news_title                = $row['news_title'];
$news_story                = $row['news_story'];
$news_image                = $row['news_image'];
$news_image_caption        = $row['news_image_caption'];
$news_image_link        = $row['news_image_link'];
$news_date_day            = $row['news_date_day'];
$news_date_month        = $row['news_date_month'];
$news_date_year            = $row['news_date_year'];
$news_status            = $row['news_status'];
$news_website            = $row['news_website'];
$news_date_created        = $row['news_date_created'];
        $news_date_modified        = $row['news_date_modified'];    ?>
<table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#eeeeee">
<tr>
<td width="60"><span class="hofblack10">
<?php
         if($news_status=="deleted"){
         print("<a class='hifblack10'>deleted</span>");
         }ELSE{
         print("<a class='blueul' href='edit.php?id=$news_id'>edit</a>");
         }
         ?>
</span></td>
<td width="140"><span class="titlegrey12">
<?php
          if(!$news_date_day)
          { echo "00"; }
          else{ echo $news_date_day; }
          echo "/";
           if(!$news_date_month) { echo "00"; }else{ echo $news_date_month; }
           echo "/";
           if(!$news_date_year) { echo "0000"; }else{ echo $news_date_year; }
           ?>
</span></td>
<td width="80"><span class="titlegrey12"><?php                    print("$news_id");                    ?></span>
</td>
<td><?php
           if($news_status=="deleted")
           {
           print("<class='hofblack10'>$news_title</span>");
           }ELSE{
           print("<a class='blueul' href='edit.php?id=$news_id'>$news_title</a>");
           }
           ?></td>
<td width="100">
<form id="list_update" action="status_update.php" method="post" name="list_update">
<select name="newnstatus" size="1">
<option <?php if($row['news_status'] == "")
           {
            print("selected");
           } ?>
selected="selected" value="">Status...</option>
<option <?php if($row['news_status'] == "on")
           {
            print("selected");
           } ?> value="on">On</option>
<option <?php if($row['news_status'] == "off")
           {
            print("selected");
           } ?> value="off">Off</option>
<option <?php if($row['news_status'] == "deleted")
           {
            print("selected");
           } ?> value="deleted">Delete</option>
</select>
<input type="hidden" name="nstatus" value="<?php echo $row[news_status]; ?>" />
<input type="hidden" name="id" value="<?php echo $row[news_id]; ?>" />
<input type="submit" name="update" value="update" />
</form>
</td>
</tr>
<tr height="0">
<td bgcolor="white" width="60"></td>
<td bgcolor="white" width="140" height="0"></td>
<td bgcolor="white" width="80" height="0"></td>
<td bgcolor="white" height="0"></td>
<td bgcolor="white" width="100" height="0"></td>
</tr>
</table>
<?php            }        mysql_close($connection);//}?>
<table width="780" border="0" cellspacing="0" cellpadding="4">
<tr>
<td width="60"></td>
<td width="80"></td>
<td><a class="blueullrg" href="add.php">Add News</a></td>
<td align="right" width="120"></td>
</tr>
</table><?php                // include("list_navigation.html");            ?>
<?php                include("../footer.html");            ?>
</div></body></html>
The action script php
Code: [Select]
<?php
/*    echo "fstatus: ".$fstatus."<BR>";
echo "id: ".$id."<BR>";
echo "fclient: ".$fclient."<BR>";
echo "newfstatus: ".$newfstatus."<BR>";*/
//set the date of agreement
$timestamp = date('l jS \of F Y h:i:s A');
//get the DB connection variables
include("../../../includes/config.php");
//connect to DB
$connection = @mysql_connect($db_address,$db_username,$db_password) or die("Couldn't CONNECT.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select FILMS DATABASE.");
// All appears well, so enter into database
$query= "UPDATE news SET news_status = '$newnstatus' WHERE news_id='$id'";

$result = mysql_query($query) or die("could not execute query - Update FILMS Record to DB");
//setup an email to the Admin @ hof, w/o attachment
$emailto="xx@xxx.co.uk";
$emailfrom="no-reply@xxxx.co.uk";
$emailsubject="xx Record Updated";
$emailmessage="Hello Registrar\n\n";
$emailmessage.="News ID: ".$id."\n";
$emailmessage.="Updated on: ".$timestamp."\n\n";
$emailmessage.="Status was: ".$nstatus."\n";
$emailmessage.="Status now: ".$newfnstatus."\n";
$emailmessage.="Thank you,\n\n";
$emailmessage.="Web Site ROBOT\n";
$emailmessage.="(Administrator)\n";
$emailmessage.="xxx.co.uk | xxx.biz\n";
$emailmessage.="----------------------------------------------\n";
$emailmessage.="e. http://www.xxx.co.uk/contact.php\n";
$emailmessage.="w. http://www.xxx.co.uk\n";
$emailheader="From: xxx.co.uk<$emailfrom>";
$emailheader  .= 'Cc: xxx@xxx.co.uk'."\r\n";
$emailheader  .= 'Bcc: xxx@xxxxx.co.uk'."\r\n";
$ok=mail($emailto,$emailsubject,$emailmessage,$emailheader);
mysql_close($connection);
if ($ok)
{
header("Location: list.php");
/* Redirect browser */
exit;
} else {
$errmsg="There was a problem, please try later or telephone us direct.";
$errsta="1";
include("edit_error.html");
//echo "<p>Mail could not be sent. Sorry!</p>";
exit;
}
?> Thanks in advance

Html Form That Pulls Mysql Db With Php

Similar Tutorials

View Content

Trying to figure out how to approach this. I have a form that uses php to pull from a mysql database. I can get the text submission form to work but I am having trouble with a drop down menu that pulls directly from the DB and submitting what is selected as the basis of the result query. I am including the two sets of code. one for my search.php and the other for my search_result.php.

search.php
Code: [Select]
<?php require_once('Connections/search_db.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_search_db, $search_db);

// Search engine functionality
if ($_GET['title'] || $_GET['country2']) {

$ti = $_GET['title'];
$count = $_GET['country2'];

$query_rsLinks = "SELECT * FROM tbl_links WHERE (tbl_links.linkemail LIKE '%$ti%' OR tbl_links.linktitle LIKE '%$ti%' OR tbl_links.linkurl LIKE '%$ti%') AND tbl_links.linkcat LIKE '$count' ORDER BY tbl_links.linkdate DESC";
} else {

$query_rsCountries = "SELECT search_db.tb_name FROM search_db";

}

$rsCountries = mysql_query($query_rsCountries, $search_db) or die(mysql_error());
$row_rsCountries = mysql_fetch_assoc($rsCountries);
$totalRows_rsCountries = mysql_num_rows($rsCountries);
?>
<!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>
</head>

<body><form action="search_result.php" method="get" name="fmsearch">
<table width="200" border="1">
<tr>
<td>search</td>
<td><label for="title"></label>
<input name="title" type="text" id="title" /></td>

<td><input name="Search" type="button" id="Submit" value="Submit" />
</td>
</tr>
</table>
</form>
<br>


<form id="forminsert" name="fmsearch" action="search_result.php" method="get">
<table border="0" id="tblinsert">
<caption>
search for country
</caption>
<tr>
<th><label for="title">search for:</label></td>
<th>
<input type="text" name="title" id="title"
<?php if (isset($_GET['title'])) {
  echo 'value="' .$GET['title']. '"'; } ?> />
</td>
<td><input type="submit" id="button" value="Submit" /></td>
</tr>
</table>

<form id="forminsert" name="fmsearch" action="search_result.php" method="get">
<table border="0" id="tblinsert2">
<caption>
search for country
</caption>
<tr>

<td><select name="country2" id="country2">
<option value="">All Countries</option>>
<?php
do {
?>
<option value="<?php echo $row_rsCountries['tb_name']?>">

<?php echo $row_rsCountries['tb_name']?></option>
<?php
} while ($row_rsCountries = mysql_fetch_assoc($rsCountries));
  $rows = mysql_num_rows($rsCountries);
  if($rows > 0) {
      mysql_data_seek($rsCountries, 0);
  $row_rsCountries = mysql_fetch_assoc($rsCountries);
  }
?>
</select></td>
<td><input type="submit" id="button" value="Submit" /></td>
</tr>
</table>

</form>
</body>
</html>
<?php
mysql_free_result($rsCountries);
?>

search_result.php
Code: [Select]
<?php require_once('Connections/search_db.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$colname_rs83 = "-1";
if (isset($_GET['country2'])) {
  $colname_rs83 = $_GET['country2'];
}
mysql_select_db($database_search_db, $search_db);
$query_rs83 = sprintf("SELECT * FROM search_db WHERE tb_name LIKE %s", GetSQLValueString("%" . $colname_rs83 . "%", "text"),GetSQLValueString("%" . $colname_rs83 . "%", "text"));
$rs83 = mysql_query($query_rs83, $search_db) or die(mysql_error());
$row_rs83 = mysql_fetch_assoc($rs83);
$colname_rs83 = "-1";

?>

<!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>
</head>

<body>
<?php echo $row_rs83['']; ?>
<?php do { ?>
<table width="300" border="1">
<tr>
<td rowspan="2"><img src="<?php echo $row_rs83['tb_Img']; ?>" alt="image" /></td>
<td><?php echo $row_rs83['tb_name']; ?></td>
</tr>
<tr>
<td><?php echo $row_rs83['tb_desc']; ?></td>
</tr>
</table>
<?php } while ($row_rs83 = mysql_fetch_assoc($rs83)); ?>
<a href="http://barium.worldteam.org/phptesting/search.php">Back to Search</a>
</body>
</html>
<?php
mysql_free_result($rs83);
?>

Csv Upload To Mysql Using Php And Html Form

Similar Tutorials

View Content

Hi All

I am trying to upload a csv file to a database using php html form however, the results shows none of the data passsing through to the database and it produces 1000's of empty fields

here is the form

Code: [Select]
form action="lib/import.php" method="post" enctype="multipart/form-data">

Type file name to import:

<input type="file" name="filename" size="20"><br />

<input type="submit" name="submit" value="submit"></form>
and here is the passing info

Code: [Select]
$file = $_FILES['filename'];

$sqlstatement="LOAD DATA INFILE '$file' into TABLE shop FIELDS TERMINATED BY ',' (id, merchant_name, product_name, description, category_name, Affiliate_deep_link, Affiliate_image_url, price)" ;
mysql_query($sqlstatement);
echo "it is done!";
can anyone help please?

Building Html Form From Mysql Table

Similar Tutorials

View Content

Hi, I have this script which I would like to use to build an html form from a MySQL table.

The <input text................ writes successfully to file but none of the other form types are written to file when using the elseif command

Also, I would like this script to carry out the file write foreach row in the table

It seems complicated and i am not sure if I am going about it in the right way, but here goes

Code: [Select]
//// Create Forms from MySQL

$result = mysql_query("SELECT * FROM forms");

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

$field_label = $row['field_label'];
$column_name = $row['column_name'];
$field_type = $row['field_type'];

if ($row['field_type'] = 'Text') {

$stringData = "$field_label<input type=text name=$column_name>\n";
fwrite($fh, $stringData);

} elseif ($row['field_type'] = 'Text Area') {

$stringData = "$field_label<input type=textarea name=$column_name></textarea>\n";
fwrite($fh, $stringData);

} elseif ($row['field_type'] = 'Select Menu') {

$stringData = "$field_label<select name=$column_name></select>\n";
fwrite($fh, $stringData);

} elseif ($row['field_type'] = 'Checkbox') {

$stringData = "$field_label<input type=checkbox name=$column_name></textarea>\n";
fwrite($fh, $stringData);

}

fclose($fh);
As always, any help is much appreciated

Php Mysql Putting Users Into Database Using Html Form??

Similar Tutorials

View Content

Hi,

I have two html made text boxes one that is called "name" and another that is called "regnum". I also have a submit button.

They are both used to add data to a database.

The name text box should add a name to the database under the "name" heading and the regnum should add a number under the "regnum" heading

Here is the code for them:

HTML Code:
<form action="" method="post">
<p>
Name: <input type="text" name="name"/>
</p>
<p>
Regnum: <input type="text" name="regnum"/>
</p>
<p>
<input type="submit" value="Add To Database" name = "submit2" />
</p>
</form>

Here is the PHP code that i am using for adding the user to the database:

PHP Code:
$host="localhost";
$username="root";
$password="";
$database="lab2";

mysql_connect("$host", "$username", "$password") or die(mysql_error());

mysql_select_db("$database") or die(mysql_error());

$name = $_POST['name'];
$regnum = $_POST['regnum'];

if(!$_POST['submit2']){
echo "Enter A Vaue";
}else{
mysql_query("INSERT INTO lab2('name', 'regnum')
VALUES(NULL, '$name', '$regnum')") or die(mysql_error());
echo "User Added To Database";
}

The problem i get with this is "Undefined Index name and regnum".

I watched a video on youtube and this is how the guy did it but it worked for him and for some reason it doesn't work for me.

Can anyone help??

Thanks.

Trying To Search A Mysql Db Using Php Code Searching Html Form

Similar Tutorials

View Content

I'm trying to do something that I thought was very simple about 2 weeks ago :-(
I want to put a form on my site and link it to a database so when a user types a surname into the form they can search the db and the page will only display the surnames that match the search criteria. I got the db set up using phpmyadmin in about 2 minutes flat, but keep getting error messages when I write the php. I'm currently working with the below script, which keeps giving me the error 'unexpected T_string' on line 176

I've searched every forum and help site I can find, and the mysql and php manuals are just mind-boggling. I'm sure I'm making some really amateur mistake, but I'd really appreciate help with this!
thanks all!

<html>
<head>
<title>SEARCH RECORDS</title>
</head>
<body>

<FORM NAME ="Search" METHOD ="POST" ACTION = "test3">

<INPUT TYPE = "TEXT" VALUE ="surname" NAME = "surname">
<INPUT TYPE = "Submit" Name = "Search" VALUE = "Search">

</FORM>
</body>
</html>

<?

$user_name = "*****";
$password = "*****";
$database = "*****";
$server = "localhost";
$db_handle = mysql_connect($server, $user_name, $password);

$db_found = mysql_select_db($database, $db_handle);

if ($db_found) {

$SQL = "SELECT * FROM *****" WHERE surname=$_POST['surname'];
$result = mysql_query($SQL);

while ($db_field = mysql_fetch_assoc($result)) {
print $db_field['Grave'] . "<BR>";
print $db_field['Surname'] . "<BR>";
print $db_field['Forenames'] . "<BR>";
print $db_field['Death_Date'] . "<BR>";
print $db_field['Birth_Year'] . "<BR>";
}

mysql_close($db_handle);
}
else {
print "Database NOT Found ";
mysql_close($db_handle);
}

?>

Simple Question About Html Form's, Php And Mysql Inserts

Similar Tutorials

View Content

Hi,

I m doing some work for my self an because of that i been reading a lot arround about PHP, and theres something that i would like to ask a bit of enlightenment. So my question is as the title says about html form's using php to insert data into mysql, i been reading tutorials arround the interwebs and even made afew successful tests, but pretty much all tutorials use 2 files to accomplish this the html file with the form and an insert.php where the actual code is stored so this made me think is this how usually it's done? in over all you will have 1 file for the form, 1 for the insert, 1 for the edit php code and 1 for delete. How do you guys usually do it?

PS: one of the tests i did was making 1 single file with all these using an switch. My interest in making this question is solo to learn how other people do it to see if i m in the right way.

Thanks in advance.

Editing Data Using A Html Form From A Mysql Database

Similar Tutorials

View Content

Hello

Im quite confused at what filtering I should use on my data when pulling it from a MySQL database. I don't sanitize my data on input because I am using prepared statements with PHP's PDO Driver which means I don't need to use mysql_real_escape_string() at all.

When I pull the data to be displayed i.e. in a HTML Table I use the below function to make it safe for HTML output.

public static function htmlSafe($data)
{ return nl2br(htmlentities($data, ENT_QUOTES)); }

However the rules change when Im using a HTML Form to edit the data, and I am unsure what I need to strip out. I.e. What would I need to do to make all data safe to insert into the following form input.

<input id = "someInput" type = "text" value = "<?php echo $someVarThatNeedsFiltering ?>" />

Also, one more question, in my html attributes (Valid ones like class, name, id, style, _target) I use a mixture of double quotes(") and single quotes ('), for quoting my values. Which one should I use or which one is more valid, doubles, or singles?

Update.php Form Update Script.

Similar Tutorials

View Content

Good morning. I am looking fo some help with an update script to update all rows in a table.

This is what I have for a form and all looks well. form.php

<?php

// run the query and put the results in an array variable called $result
$result = mysql_query("SELECT * FROM table ORDER BY 'id', 'title', 'text', 'number'");

print "<form method='post' action='update.php'>
<table width='100%' border='0' cellspacing='1' cellpadding='1'><tr>

<td align='center'><strong>ID</strong></td>
<td align='center'><strong>Title</strong></td>
<td align='center'><strong>text</strong></td>
<td align='center'><strong>Number</strong></td>
</tr>\n";

// start a loop to print all of the courses with their book information
// the mysql_fetch_array function puts each record into an array. each time it is called, it moves the array counter up until there are no more records left
while ($Update = mysql_fetch_array($result)) {

  // start displaying the info; the most important part is to make the name an array (notice bookinfo[$i])
  print "<td align='center'><p>{$Update['id']}</p></td>\n";
  print "<td align='center'><input type='text' name='title' value='{$Update['title']}' /></td>";

  print "<td align='center'><input type='text' size='40' name='text' value='{$Update['text']}' /></td>\n";
  print "<td align='center'><input type='text' size='40' name='number' value='{$Update['number']}' /></td>\n";
print "</tr>\n";
// add 1 to the count, close the loop, close the form, and the mysql connection

}
print "<tr>
<td colspan='4' align='center'><input type='submit' value='submit' />";
print "</td>
</tr>
</table>
</td>
</tr>
</form>
</table>";

print "</tr>\n";
?><br /><br />

My question is. How do I update this info into the database with the proper info. ie. Update.php?

Help With Mysql Update - It Won't Update

Similar Tutorials

View Content

Please help me with this: been doing this for 2 days and still cannot solve it. it won't update...

I have attached my file:

<?php
include('connect-database.php');
if (isset($_POST['submit']) AND $_POST['submit'] == 'update') {
   $error = false;
   extract($_POST);
   if (empty($full_name)) $error = true;
   if (!$error) {
      $update = "UPDATE users SET
               full_name = '$full_name',
               WHERE id=$id
               ";
      mysql_query($update) or die(mysql_error() . "<br><br>" . $update);
      $full_name = '';
      $message = "Record successfully updated.";
   } else {
      $message = "There is an error in your entry";
   }
} else {
   $id = intval(isset($_GET['id']) ? $_GET['id'] : 0);
}
if ($id == 0) {
   echo "<div style='margin-bottom:10px'>Invalid ID.</div>";
   exit;
}
$query = "SELECT * FROM users WHERE id=$id";
$result = mysql_query($query) or die(mysql_error() . "<br><br>" . $query);
if (mysql_num_rows($result) == 0) {
   echo "<div style='margin-bottom:10px'>Record Not Found in Database!</div>";
   exit;
}
$row = mysql_fetch_array($result);
extract($row);

?>
<div id="mainContent" class="tab_container">
<div id="tab1" class="tab_content">
<h1>Edit Personal Data</h1>
   <div style="color:red;font-weight:bold"><? echo $message; ?></div>
    <form name="submit" action="" method="post">
<ul>
     <li><b>ID # :</b> <?php echo $id?></li>
   <li><b>Name :</b> <input type="text" name="full_name" id="" size="30" value="<?php echo $full_name ?>" /></li>
<li><b>Address :</b> <input type="text" name="address" id="" size="55" maxlength="100" value="<?php echo $address ?>" /></li>
<li><b>Contact Number :</b> <input type="text" name="contact_number" id="" size="11" value="<?php echo $contact_number ?>" /></li>
<li><b>Email Address :</b> <input type="text" name="user_email" id="" size="30" value="<?php echo $user_email ?>" /></li>
<li><b>Status :</b> <input type="text" name="status" id="" size="10" value="<?php echo $status ?>" /></li>
<li><b>Nationality :</b> <input type="text" name="nationality" id="" size="20" value="<?php echo $nationality ?>" /></li>
<li><b>Religion :</b> <input type="text" name="religion" id="" size="20" value="<?php echo $religion ?>" /></li>
</ul>
<h2>Self Description</h2>
<p><textarea rows="9" cols="40" name="self_description" ><?php echo $self_description ?></textarea></p>
   <input type="hidden" name="id" value="<?php echo $id; ?>" />
   <input type="submit" name="submit" value="update" />

   </form>
</div>

Php - Mysql Update ?

Similar Tutorials

View Content

I have lost my record when I run the code below, all fields are empty...

Code: [Select]
<a href='edit.php?id={$info['person_id']}'><font color='#00AE0A'>Edit User</font> </a>
Code: [Select]
$sql = "SELECT * FROM person WHERE person_id='{$_REQUEST['id']}' ";

$result = mysql_query($sql);
if (!$result) {
echo("<p>Error performing query: " . mysql_error() . "</p>");
exit();
}

if ($row = @mysql_fetch_array($result, MYSQL_ASSOC)) {

print "

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

<table>

<tr>
<td><strong>Name</strong></td>
<td><input type=\"text\" name=\"fname\" size=\"60\" value=\"$row[fname]\"></td>
</tr>
<tr>
<td><strong>Surname</strong></td>
<td><input type=\"text\" name=\"lname\" size=\"60\" value=\"$row[lname]\"></td>
</tr>

<tr>
<td><strong>Email</strong></td>
<td><input type=\"text\" name=\"email\" size=\"60\" value=\"$row[email]\"></td>
</tr>

<tr>
<td><strong>Committee</strong></td>
<td><input type=\"text\" name=\"committee_no\" size=\"60\" value=\"$row[committee_no]\"></td>
</tr>

<tr>
<td><INPUT type=\"submit\" value=\"Send\"> </td>

</tr>

</table></form>
";

} else {
echo("There has been an error" . mysql_error());
}

/* closes connection */

?>

<?php

   $control =  mysql_query(" UPDATE person SET fname='{$_REQUEST['fname']}' , lname='{$_REQUEST['lname']}' , email='{$_REQUEST['email']}',
               committee_no='{$_REQUEST['committee_no']}'
               WHERE person_id='{$_REQUEST['id']}'");

if($control)
{
header("Location:".$_SERVER["HTTP_REFERER"]."");
}

?>

Mysql Update

Similar Tutorials

View Content

I am trying to update the content of my website which is all stored in a MySQL database.

Currently on the page I am displaying all the data stored in the database using MySQL SELECT and a while loop. Using JavaScript when the text is clicked the element changes into a text box allowing the text to be edited.

What I want to do is be able to change the data in the text box and then store it into the database updating the current data.

Code: [Select]
<form method="post" action="editindex.php">
<?php
$sql = "SELECT * FROM home ORDER BY id ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)){
echo "<span id=\"itm1\" onclick=\"exchange(this);\">" . $row['title'] . "</span><input ondblclick=\"exchange(this);\" id=\"itm1b\" class=\"replace\" type=\"text\ name=\"title\">";?>
<input type="submit" value="Save" name="submit">
<input type="hidden" name="id" value="<?php $row['id'] ?>"
</form>
<?php
if (isset ($_POST['submit'])) {
$update = "UPDATE home SET title=".$_POST['title']." WHERE id=".$_POST['id']."";
mysql_query($update);
}
?>

I have more text being output from the while loop below but I just want to get it working on the title first.

Any ideas of why the update is not working?

Mysql Update

Similar Tutorials

View Content

I have made this, although i can not seem to the status...

changeapp.php
Code: [Select]
<form method="post" name="memberadd" action="change_app_complete.php">

<label>Name:</label>
<select name="member">
<?php
$con = mysql_connect("host","user","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("database",$con);
$sqlquery="SELECT * FROM `application` Order By Name";
$result=mysql_query($sqlquery,$con);
while($row=mysql_fetch_array($result))
{
echo "<option value='".$row['ID']."'>".$row['Name']." (".$row['Status'].")</option>";
}
?>
</select>
<br>

<label>Status:</label>
<select name="Status">
<option value="PENDING">PENDING</option>
<option value="ACCEPTED">ACCEPTED</option>
<option value="DENIED">DENIED</option>
<br>
<input type="submit" value="submit" />
</form>
change_app_complete.php
Code: [Select]
<?php
$status=$_POST['Status'];

$con = mysql_connect("host","user","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("database",$con);

$sql="UPDATE application SET Status = '$status' WHERE Name= '$member'";
if(mysql_query($sql,$con))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
else
{
die('Could not submit: ' . mysql_error());
}
mysql_close($con);

?>
What is wrong?

Php And Mysql Update

Similar Tutorials

View Content

So i have this following code that doesn't work

Help With Update Mysql.

Similar Tutorials

View Content

Code: [Select]
<?php
$querySelect = mysql_query("SELECT * FROM `G4V_Videos` WHERE `counter`");
$row = mysql_fetch_assoc($querySelect);
$counter = $row['counter'];

if (empty($counter)) {

$counter = 1;
$insert = mysql_query ("INSERT INTO counter VALUES ('counter')");
$printid = (print $data['id']);
$printlink = (print $data['link']);
}

$add = $counter+1;
$insertNew = mysql_query("UPDATE G4V_Videos SET counter=('$add') WHERE id = ('$printid') AND link = ('$printlink')") or die (mysql_error());
echo "Video Views";
echo ":";
echo" ";
echo"<br />";
echo "$counter";
?>
It shows the same amount of hits on everyvideo instead of just the one video with the id
www.game4vids.com

Mysql And Php Update

Similar Tutorials

View Content

this is what i have so far but i cant get it to update the data

update page

<?php
$host="localhost"; // Host name
$username="**"; // Mysql username
$password="*****"; // Mysql password
$db_name="manews"; // Database name
$tbl_name="Shows"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// get value of id that sent from address bar
$id=$_GET['id'];

// Retrieve data from database
$sql="SELECT * FROM $tbl_name WHERE id='$id'";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<form name="form1" method="post" action="update_ac.php">
<td>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td> </td>
<td colspan="3"><strong>Update data in mysql</strong> </td>
</tr>
<tr>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<tr>
<td align="center"> </td>
<td align="center"><strong>Day</strong></td>
<td align="center"><strong>Month</strong></td>
<td align="center"><strong>Year</strong></td>
<td align="center"><strong>Song</strong></td>
<td align="center"><strong>Data</strong></td>
</tr>
<tr>
<td> </td>
<td align="center"><input name="Day" type="text" id="Day" value="<? echo $rows['Day']; ?>"></td>
<td align="center"><input name="Month" type="text" id="Month" value="<? echo $rows['Month']; ?>"></td>
<td align="center"><input name="Year" type="text" id="Year" value="<? echo $rows['Year']; ?>" size="15"></td>
<td align="center"><input name="Song" type="text" id="Song" value="<? echo $rows['Song']; ?>"></td>
<td align="center"><input name="Data" type="text" id="Data" value="<? echo $rows['Data']; ?>" size="15"></td>
</tr>
<tr>
<td> </td>
<td><input name="id" type="hidden" id="id" value="<? echo $rows['id']; ?>"></td>
<td align="center"><input type="submit" name="Submit" value="Submit"></td>
<td> </td>
</tr>
</table>
</td>
</form>
</tr>
</table>

<?

// close connection
mysql_close();

?>

update script

<?php
$host="localhost"; // Host name
$username="**"; // Mysql username
$password="**"; // Mysql password
$db_name="manews"; // Database name
$tbl_name="Shows"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// update data in mysql database
$sql="UPDATE $tbl_name SET Day='$Day', Month='$Month', Year='$Year', Year='$Song', Year='$Data' WHERE id='$id'";
$result=mysql_query($sql);

// if successfully updated.
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='list_records.php'>View result</a>";
}

else {
echo "ERROR";
}

?>