Learn VBA & Macros in 1 Week!

PHP - Update Access Level

Full Excel VBA Course - Beginner to Expert

Update Access Level	View Content

Hello. Basically I have created a form that you fill in and an email gets sent to your in box and you have an access_level of 1. Within this email there is one field. A validation_id. Now what im trying to do is when you click this link it opens the webpage and updates your access_level to 2. I have wrote my query and array and i can see exactly which bit is wrong.

Its where i have

validation_id= $validation_id")

Now its not working and I can see the error. Problem is im too new at this to understand why its wrong and how to fix it can anyone help? Here is the rest of the code. Also could you please explain? I would really like to understand it before i move any further.
p.s. I have already selected my database in the included file

      <? include('database_name');
session_start();

  $validation_id =$_GET['validation_id'];
  $FullRec__query=sprintf("SELECT * FROM Members WHERE validation_id= $validation_id");

  $FullRec = mysql_query($FullRec__query, $database name) or die(mysql_error());

  $FullRecArray = mysql_fetch_array($FullRec);

  $UdateAccessQuery = sprintf("UPDATE Members SET access_level = '2' WHERE validation_id = $validation_id");

  mysql_query($UdateAccessQuery, $database_name) or die(mysql_error());
?>

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Php Access Level Control ( Permissions) Help

Access Level From Database To Login In Myphpadmin

Simple Update Form Not Update Field On Database Help

Need A Generic Update Function To Update A Mysql Table

Select Rows To Update Using Checkbox... Echo Rows To Update... Update Rows...

Two Level Mapping!

Update Multiple Rows In Php With Update!

Update.php Form Update Script.

Update Function Only Update If Not Empty

Update Query Inserts Instead Of Update.

Update Table And Other Update Sql Questions

Multi Level Menu Help

Login With Different User Level

Multi Level Methods?

Help With A Multi-level Array

Multiple Level Array

N Level Tree Traversing

Php Search (basic Level)

Post On Wrong Url Level

Php Error Reporting Level

Learn VBA & Macros for Excel in 1 Week!

Php Access Level Control ( Permissions) Help

Similar Tutorials

Hi everyone, am developing an application that has two views 1 for administrator and 1 for staff. Administrator can perform all application tasks and Staff can ONLY perform certain task. I have implemented sessions quite alright and are working. Now the problem is that when I login as Staff and then I change the URL to point to an administrator's page the application is allowing that, How can I prevent that from happening. Staff MUST NOT see administrators pages. Here is my login code, logout code and code am using to protect webpages below.

Here is my login code

<?php

//start the session
session_start();

$username=$_POST['username'];
$password=$_POST['password'];

$encrypted=md5($password);

// set connection to database

$hostname="localhost"; // Host name
$mysql_server_username="root"; // Mysql username
$server_password=""; // Mysql password
$db_name="db_inventory"; // Database name
$table = "tbl_users"; // Table name

// Connect to server and select database.
mysql_connect("$hostname", "$mysql_server_username", "$server_password")or die("cannot connect to database server");
mysql_select_db("$db_name") or die ("Couldn't select the database.");

$admin=("select * from $table where username='$username' AND password='$encrypted' AND type = 'admin'");
$staff=("select * from $table where username='$username' AND password='$encrypted' AND type = 'staff'");

//check that at least one row was returned
$adminresult=mysql_query($admin);
$admincount = mysql_num_rows($adminresult);

$staffresult=mysql_query($staff);
$staffcount = mysql_num_rows($staffresult);

if($admincount> 0){
$_SESSION['valid_user'] = $username ;
header( "Location: main_menu.php" );
}
else if($staffcount> 0){
$_SESSION['valid_user'] = $username ;
header( "Location: staff/main_menu.php" );
}
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>title> | Login</title>
</head>

<body bgcolor="#FFFFFF" background-repeat:no-repeat; background="images/images1.jpg">
<div align="center">
<table width="800" height="501" border="0" cellpadding="1" cellspacing="1">
<tr>
<td height="100"> </td>
</tr>
<tr>
<td height="350">
<div align="center">
<form method="post" action="login_process.php">
<h4 align="center"><font color="red">Incorrect Username / Password ! Please Try Again</font></h4>
<img name="" src=images/padlock_closed.gif width="34" height="32" alt="" /><br /><br />
<table width="314" border="0" cellspacing="1" cellpadding="1">
<tr>
<td>Username:</td>
<td><label>
<input type="text" name="username" />
</label></td>
</tr>
<tr>
<td>Password:</td>
<td><label>
<input type="password" name="password" />
</label></td>
</tr>
<tr>
<td colspan="2">
<p>               
<input type="submit" name ="submit" value="Login" />     <input type="reset" value="Reset" />
</p>
</td>
</tr>
</table>
</form>
</div>
</td>
</tr>
<tr>
<td height="100"> </td>
</tr>
</table>
</div>
</body>
</html>

<?php

}
?>

Here is my logout code

<?php
//start the session
session_start();

//check to make sure the session variable is registered
if(isset($_SESSION['valid_user'])){

//session variable is registered, the user is ready to logout
session_unset();
session_destroy();

//the session variable isn't registered, the user shouldn't even be on this page
header( "Location: index.php" );
}
else
{
//check to see if the session variable is not registered
if(!isset($_SESSION['valid_user'])){
//redirect to login page
header( "Location: index.php" );
}
}
?>

Here is code I am using to protect pages

<?php
//start the session
session_start();
//check to make sure the session variable is registered

if(!isset($_SESSION['valid_user'])){
//redirect to login page
header( "Location: index.php" );
}
?>
<!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=iso-8859-1" />
<title> | Main Menu</title>
<link rel="stylesheet" type="text/css" href="css.css" />
</head>

<body>

<div id="tabsF">
<ul>

<li id="current"><a href="main_menu.php"><span>MAIN MENU</span></a></li>
<li><a href="stockmaster.php"><span>STOCK MASTER</span></a></li>
<li><a href="controlpanel.php"><span>CONTROL PANEL</span></a></li>
<li><a href="logout.php"><span>LOGOUT</span></a></li>

</ul>
</div>
</body>
</html>

Thank you.

Access Level From Database To Login In Myphpadmin

Similar Tutorials

We have setup a member login page in CS5 using a myphpadmin database. We want to give members access to particular areas of our site depending on what username and password they enter. ie member 1 only requires access to specific documents/webpages - member 2 requires access to other documents/webpages. Not sure how to do this.

Simple Update Form Not Update Field On Database Help

Similar Tutorials

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

Need A Generic Update Function To Update A Mysql Table

Similar Tutorials

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

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

Select Rows To Update Using Checkbox... Echo Rows To Update... Update Rows...

Similar Tutorials

what Im basically trying to do is just like a phpmyadmin function... you select rows you want to update with a checkbox and then it takes you to a page where the rows that are clicked are shown in forms so that you can view and edit info in them... and then have 1 submit button to update them all at once.

Two Level Mapping!

Similar Tutorials

Hi -
I've got a program to allow the user to upload a file and then select, for each column
of an existing table, the column from the new source table to insert. However, what
I need to do is do the insert using the actual names, but show the user a drop-down
menu of the LABELS they've chosen for each of these real, target columns. Is there
a "clean" or "tricky" way of doing this? The code to do the inserts works by just reading
the translation table that has two columns -- source column fieldname and target column
(in the existing table) fieldnames (both real fieldnames, of course).

Here's what I've got:

<form action="index.php" method="post">
   <input type="hidden" id="unique" name="unique" value="<?php echo $unique_nm; ?>" />
   <input type="hidden" id="savetotable" name="savetotable" value="1" />
   <?php foreach($LabelList as $c_name){ ?>
      <div>
         <div style="float: left; width: 300px;"; >
            <?php echo $c_name; ?>
         </div>
         <div style="float: left; width: 400px;">
            <select id="<?php echo $c_name; ?>" name="<?php echo $c_name; ?>">
               <option value=""></option>
               <?php foreach($SourceColumns as $h_name){ ?>
                  <option value="<?php echo trim($h_name); ?>">
                     <?php echo trim($h_name); ?>
                  </option>
               <?php } ?>
            </select>
         </div>
         <div style="clear: both;"></div>
      </div>
   <?php } ?>
   <input type="submit" value="Save to Database" />
</form>

So, while I could load the data into the targetfile pretty easily using the
real target table column names, how can I present the user with a drop-down
menu of LABELS, but insert the data into the REAL target fields?

Here's the list of ACTUAL fields:
   $output = array();
   $gather = 'select FieldName from MapTable where User = UserID'
   $this->call($gather);
      foreach($this->data as $row){
         $ActualFields[] = $row['COLUMN_NAME'];
      }
      return $ActualFields;
   }

Here's the list of LABELS (phony field names):
   $output = array();
   $gather = 'select LabelName from MapTable where User = UserID'
   $this->call($gather);
      foreach($this->data as $row){
         $LabelList[] = $row['COLUMN_NAME'];
      }
      return $LabelList;
   }

The list of fields from the sourcefile the user is loading
are all actual, real names ($SourceColumns)

Update Multiple Rows In Php With Update!

Similar Tutorials

As the title says I need help with multiple update system.. Can't really get it to work at all >.<
Here's some code:

$selectt = mysql_query("SELECT * FROM exercises WHERE user='" . $_SESSION["user"] . "' AND exname='" . $_GET["edit"] . "'");
echo '<form method="POST" action="exercises.php?edited">';
echo '<div id="newexx">';
while($raw = mysql_fetch_array($selectt))
{
echo '<input type="text" name="up[' . $raw["id"] . ']" value="' . $raw["swe"] . '">';
echo '<input type="text" name="up1[' . $raw["id"] . ']" value="' . $raw["eng"] . '"><br>';
echo '<input type="hidden" name="id[' . $raw["id"] . ']">';
}
echo '</div>';
echo '<input type="submit" value="Update Exercise">';
echo '</form>';
if(isset($_GET["edited"]))
{
$swe = $_POST["up"];
$eng = $_POST["up1"];
$id = $_POST["id"];
foreach($id as $value => $index)
{
$update = "UPDATE exercises SET swe='".$swe."', eng='".$eng."' WHERE id='".$index."'";
mysql_query($update);
}

Would be thankful for reply!

Update.php Form Update Script.

Similar Tutorials

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?

Update Function Only Update If Not Empty

Similar Tutorials

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' "));
?>

Update Query Inserts Instead Of Update.

Similar Tutorials

I created this code to upload a member's main picture on his member page on website. I'll only include the query part of the code since that's what is relevant to my problem. The idea is basically to upload a new picture onto the database if no picture already exists for that member and display the picture on the page. If a picture already exists, then the script replaces the old picture with the new one upon upload. But for whatever reason
I don't understand, when I try to replace the old pic, it gets inserted in a new row on the database instead of replacing the old row, and the new pic gets displayed on the web page alongside the old. Code: [Select]
$query = "SELECT username FROM images WHERE member_id = '".$_SESSION['id']."' AND image_cartegory = 'main'";
$result = @mysql_query($query);
$num = @mysql_num_rows($result);

if ($num> 0) {

//Update the image

$update = mysql_query("UPDATE images SET image = '" . $image['name'] . "' WHERE member_id = '".$_SESSION['id']."' AND image_cartegory = 'main'");

$_SESSION['error'] = "File updated successfully."; //really should be session success message.

header("Location: member.php");

exit;
}

else

{
// NOTE: This is where a lot of people make mistakes.
// We are *not* putting the image into the database; we are putting a reference to the file's location on the server

$sql = "insert into images (member_id, image_cartegory, image_date, image) values ('{$_SESSION['id']}', 'main', NOW(), '" . $image['name'] . "')";

$result = mysql_query($sql) or die ("Could not insert data into DB: " . mysql_error());

$_SESSION['error'] = "File uploaded succussfully."; //really should be session success message.

header("Location: member.php");
}

So can anyone tell me what the problem is? Could the fact that my insert script actually uploads the image onto a folder on my server and only stores the path name in the database have anything to contribute to the mixup? Appreciate your responses in advance.

Update Table And Other Update Sql Questions

Similar Tutorials

I'm new to PHP and I was able to figure out how to populate data from my database into my text fields. I am trying to add the update information to the same php file; however, I am now receiving errors within the data I was able to populate,

Notice: Undefined variable: stmt in C:\xampp\htdocs\Cust_App\update.php on line 47

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\Cust_App\update.php on line 47

and errors with the Update statement

Notice: Undefined variable: stmtupdate in C:\xampp\htdocs\Cust_App\update.php on line 96

Notice: Trying to access array offset on value of type null in C:\xampp\htdocs\Cust_App\update.php on line 96

Notice: Undefined variable: customerID in C:\xampp\htdocs\Cust_App\update.php on line 96

I had defined the customerID variable above in the code, but it isn't being captured from here.

I tried setting up this query like the one which gathered the data, but I'm off by a little bit. I would like the option to be able to update all fields.

Any help is appreciated. I'm trying to learn as I may get asked to update other forms in the future. (new boss asks a lot)

<?php
require_once('database.php');


?>



<!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">

<!-- the head section -->
<head>
    <title>My Guitar Shop</title>
    <link rel="stylesheet" type="text/css" href="main.css" />
</head>

<!-- the body section -->
<body>
<div id="page">

    <div id="header">
        <h1>SportsPro Technical Support</h1>
        <p>Sports management software for the sports enthusiast.</p></h1>
    </div>

    <div id="main">

        <h1>View/Update Customer</h1>

        <form action="update.php" method="get" >
        <?php

        if(isset($_GET['customerID'])) {
            $customerID = filter_input(INPUT_GET, 'customerID', FILTER_SANITIZE_NUMBER_INT);
            $sql = "SELECT * FROM customers  WHERE customerID =$customerID ";
            $stmt = $db->query($sql);

        }

        ?>
        <div id="content">
            <!-- display a table of products -->
            <h2>Customers</h2>
            <form method = "edit">
               <?php foreach ($stmt as $cust) { ?>
                <div>
                    <label>First Name</label>
            <input type="text" name="name" class ="form-control" value ="<?php echo $cust['firstName']; ?>">
            </div><br>
                <div>
                    <label>Last Name</label>
                    <input type="text" name="name" class ="form-control" value ="<?php echo $cust['lastName']; ?>">
                </div><br>
            <div>
            <label>Address</label>
            <input type="text" name="address" class ="form-control" value ="<?php echo $cust['address']; ?>">
                </div><br>
                <div>
                    <label>City</label>
            <input type="text" name="city" class ="form-control" value ="<?php echo $cust['city']; ?>">
                </div><br>
                <div>
                    <label>State</label>
            <input type="text" name="state" class ="form-control" value ="<?php echo $cust['state']; ?>">
                </div><br>
                <div>
                    <label>Country</label>
            <input type="text" name="countryCode" class ="form-control" value ="<?php echo $cust['countryCode']; ?>">
                </div><br>
                <div>
                    <label>Zip Code</label>
            <input type="text" name="postalCode" class ="form-control" value ="<?php echo $cust['postalCode']; ?>">
                </div><br>
                <div>
                    <label>Email </label>
            <input type="text" name="email" class ="form-control" value ="<?php echo $cust['email']; ?>">
                </div><br>
                <div>
                    <label>Phone Number </label>
            <input type="text" name="phone" class ="form-control" value ="<?php echo $cust['phone']; ?>">
                </div><br>
                <div>
                    <label>Password </label>
            <input type="text" name="password" class ="form-control" value ="<?php echo $cust['password']; ?>">
                </div><br>
                <div>

                <?php    }


                ?>
            <input type="Submit" name="Update_Data" value="Update Data"></input>
                    <?php
                    $sql2 = "UPDATE customers SET firstName = ". $stmtupdate['firstName']." WHERE customerID =$customerID ";
                    $stmtupdate = $db->query($sql2);

                    ?>
        </div>
    </div>

    <div id="footer">
        <p>
            &copy; <?php echo date("Y"); ?> SportsPro, Inc.
        </p>
    </div>

</div><!-- end page -->
</body>
</html>

Multi Level Menu Help

Similar Tutorials

Hi all

I have a menu function which basically produces a menu which looks like

Code: [Select]
Products
Apple
iMac
iPod
iPhone
Microsoft
Windows
Office
and the code I use is;

THE FUNCTION

function menu($parentID, $mymenu)
{
   $html = "";
   if (isset($mymenu['parentID'][$parentID]))
   {
      $html .= "
      <ul>\n";
       foreach ($mymenu['parentID'][$parentID] as $menu_id)
       {
          if(!isset($mymenu['parentID'][$menu_id]))
          {
             $html .= "<li>\n  <a href='/".$mymenu['menu_item'][$menu_id]['url']."'>".$mymenu['menu_item'][$menu_id]['value']."</a>\n</li>";
          }
          if(isset($mymenu['parentID'][$menu_id]))
          {
             $html .= "<li>\n  <a href='/".$mymenu['menu_item'][$menu_id]['url']."'>".$mymenu['menu_item'][$menu_id]['value']."</a>";
             $html .= menu($menu_id, $mymenu);
             $html .= "</li>";
          }
       }
       $html .= "</ul>";
   }
   return $html;
}

CREATE MENU CODE

$result = mysql_query("SELECT id, value, url, parentID FROM menu WHERE active = 1 AND deleted = 1 ORDER BY position ASC");
$mymenu = array('menu_item' => array(),'parentID' => array());
while ($menu_item = mysql_fetch_assoc($result))
{
$mymenu['menu_item'][$menu_item['id']] = $menu_item;
$mymenu['parentID'][$menu_item['parentID']][] = $menu_item['id'];
}

echo menu(0, $mymenu);

The problem I have is the URLS, at the moment the menu URLS are outputted as

Code: [Select]
Products - http://localhost/Products
Apple - http://localhost/Apple
iMac - http://localhost/iMac
iPod - http://localhost/iPod
But I need to alter my function so that URLS are outputted as

Code: [Select]
Products - http://localhost/Products
Apple - http://localhost/Products/Apple
iMac - http://localhost/Products/Apple/iMac
iPod - http://localhost/Products/Apple/iPod
Is this at all possible?

Thanks very much everyone

John

Login With Different User Level

Similar Tutorials

i try to create login page with two different user level for example admin and staff. i did not get any error on my code but it just did not direct to the page it been set to. it just display wrong username or password. i not really sure what is wrong.

here is the code

loginForm.php

Code: [Select]
<form action="login.php" method ="post">

<table>
<tr><td>Usernama</td>
<td><input name="username" type="text" size = "15" maxlength = "15"/></td></tr>

<tr><td>Password</td>
<td><input name="password" type="password" size = "15" maxlength = "15"/></td></tr>
</table>

<br><input name="submit" type ="submit" value ="Login"/></td>

</form>

login.php

Code: [Select]
<?php
ob_start();
$host="localhost";
$user="root";
$pass="";
$db_name="office";
$tbl_name="login";

mysql_connect("$host", "$user", "$pass")or die("cannot connect");
mysql_select_db("$db_name")or die("Cannot Select Database");

// username and password sent from form
$sername=$_POST['username'];
$password=$_POST['password'];

$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);

$sql="SELECT * FROM daftarPenyelia WHERE user='$username' AND pass='$password' AND userLevel='$userLevel'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);

if ($count == $userLevel)
{
   if ($userLevel == 1)
  {
        $_SESSION['username'] = $username;
        $_SESSION['password'] = $password;
        header("location:adminMenu.php");
   }
   else if ($userLevel == 2)
  {
        $_SESSION['username'] = $username;
        $_SESSION['password'] = $password;
        header("location:staffMenu.php");
   }
}
else
{
echo "Wrong Username or Password";
}
?>

can someone help me with this code and tell me what is wrong so that i can fix them

Multi Level Methods?

Similar Tutorials

In javascript you can do multiple methods on the same line like:
if(document.getElementById('myElement').className.match(/^[0-9]/)){/*Do something*/}

in that we have getElementById() and match() on the same line, and it works the same as if you were to split them on multiple lines.

Is it possible to do that with php?

For example:
$obj = new MyObject();

$obj->add(2, 3)->to_string();

Help With A Multi-level Array

Similar Tutorials

What am I missing here?

The array:
protected $form_bonus = array(
"Attacker" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38),
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array(
"normal" => 1.195,
"rps" => 1.494),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
),
"Defender" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38),
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array(
"normal" => 1.15,
"rps" => 1.38),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
)
);

accessing it:
$bonus *= form_bonus[$this->role][$this->race]['rps'];

error:
PHP Parse error: syntax error, unexpected '['

Multiple Level Array

Similar Tutorials

Hi All,

I have a function that creates an array using a few sql quereys. I then use the array to output to html. I am wanting to add more data to the array to populate another column in the created table.

I am unsure how to add $miqty to the array and then output it in the Qty On Order column.

I feel like i need to add the [] to

$menuItemsInCat[$mcatname][$miid] = $miname;

section but i am not sure where in there it should be.

<?php if (session_status() == PHP_SESSION_NONE) {
session_start();
}
if (!isset($_SESSION['user_id'])){
	header("location: index.php");
	exit;
}
//name of the pagea
$_SESSION['this_page'] = 'new-menu';

function getMenuItems($conn){
	$output = '';
	$stmt = $conn -> query("
	                         SELECT menu_category_name
	                         FROM ssm_menu_items
	                         INNER JOIN  ssm_menu_category on menu_item_category_id = menu_category_id
	                         ORDER BY menu_category_display_order
	                         ");
	//create an empty array of all of the menu categories that are in use
	foreach ($stmt as $item){
		$menuItemsInCat[$item['menu_category_name']] = [];
	}
	$stmt = $conn -> prepare("
	                         	SELECT menu_item_id, menu_item_name, menu_category_name, sum(menu_item_qty)
								FROM ssm_menu_items mi
								INNER JOIN ssm_menu_category mcat ON mi.menu_item_category_id = mcat.menu_category_id
								left join ssm_menu_order USING (menu_item_id)
								GROUP BY menu_item_id
	                         ");
	$stmt -> execute();
	$stmt -> bind_result($miid, $miname, $mcatname, $miqty);
	while ($row = $stmt -> fetch()) {
		//put items into the blank array created above under their correct category
		
		$menuItemsInCat[$mcatname][$miid] = $miname;
	}

	echo "<pre>";
	print_r($menuItemsInCat);
	echo "</pre>";

		//foreach thing in $menuItemInCat array there is $menucat array associated with $menuit(ems) array
		//we want the menu cat
	foreach ($menuItemsInCat as $menucat => $menuit) {
		$output .= "<tbody>";
		$output .= "<tr class='bg-secondary text-white text-center'><th>$menucat</th>";
		$output .= "<th>Qty On Order</th><th>Manage</th></tr>";
		//foreach thing in menu items array there is an array of ids and an array of items
		foreach ($menuit as $itemId => $itemName) {
			$output .= "<tr><td>$itemName</td>";
			$output .= "<td></td>";
			$output .= "<td><div class='btn btn-primary'>Manage</div></td></tr>";
		}
		$output .= "</tbody>";
	}
	return $output;
}



?>
<?php include '_includes/head.php'; ?>
<div class="container-fluid">
	<div class="row">
		<?php include '_includes/header.php'; ?>
	</div>
	<div class="row" >
		<div class="col-sm-2 p-0 bg-dark text-light">
			<?php include '_includes/nav.php'; ?>
		</div>
		<div class="col-sm-10" style="height: calc(100vh - 80px);overflow:scroll;">
			<div class="mt-3">
				<table class="table table-striped table-hover table-bordered text-center align-middle">
					<?= getMenuItems($conn) ?>
				</table>
			</div>
			<div class="col-sm-12"><?php include '_includes/footer.php'; ?></div>
		</div>
	</div>
	
</div>
<script>
	//set sidebar active indicator
	//XX = name of parent if in dropdown eg "sheet"
	if(document.getElementById('menu')){
		document.getElementById('menu').classList.add('show')
	}
	//nav button ID
	if(document.getElementById('newMenu')){
		document.getElementById('newMenu').classList.add('blOrange')
	}
</script>

As always your help is very appreciated.

Edited February 5, 2020 by Adamhumbug

N Level Tree Traversing

Similar Tutorials

Hello everybody,

i am working on n level category tree structure, for your information the category tree structure image is attached with this post.

Let's consider, each of the category have hundreds( n level ) of category in each, i want to traverse each category without using recursive functions, reason being recursive functions are very slow, is there any way to do this??

Thanks,
phpeid

Php Search (basic Level)

Similar Tutorials

Hi everyone,
I'm very new to PHP and have been following Kevin Yank's "How to build a db driven website using php & mysql" 3rd ed. and am working through Chapter 6, where a basic search page is created. What I would like to be able to do is, in the results, display not only the joketext (as done in the book), but also the author's name (which is located in a different table in the db), as well as the date it was submitted (in the same db as joketext), possibly a link to another site and extra info like the joke category. In general, I would like to be able to understand how to adjust the php code to add data related to the results of any given search. The information is already related through the database, how do I use it in the results of a search?

I've used the same names of variables and tables as used in the book.

Thank you in advance for any help you can offer! I really appreciate it.

Below is the code for the part of the code I would like to change (highlighted parts) followed by the code for whole page (2 main sections "search" and "results". In the main code, the excerpt below is located a few lines from the bottom (in "results"):

Note: the only variable currently displaying in the results in $joketext (also highlighted). Ok, enough explaining!

/////////// EXCERPT : PART I WANT TO DISPLAY DIFFERENTLY //////////////

<?php
echo "<li id=\"jump\">
<article class=\"entry\">
<header>
<h3 class=\"entry-title\"><a href=''$VAR for email or weblink from author table">$VAR for author name from author table</a></h3>
</header>
<div class=\"entry-content\">
<p>$joketext</p></div>
<footer class=\"entry-info\">
<abbr class=\"published\" title=\"2011-09-22T14:07:00-07:00\">$VAR for date uploaded in joke table</abbr>
<p>$VAR for joke category from jokecategory table</p>
</footer>
</article>
</li>";
}
?>
//////////////////////////// MAIN CODE ///////////////////////

<html>
<body>
.
<header></header>
.
<section id="search">

<?php

$dbcnx = @mysql_connect('localhost', 'root', 'password');

if (!$dbcnx) {
exit('<p>Unable to connect to the ' . 'database server at this time.</p>');
}

if (!@mysql_select_db('ijdb')) {
exit('<p>Unable to locate the joke ' . 'database at this time.</p>');
}

$authors = @mysql_query('SELECT id, name FROM author');
if (!$authors) {
exit('<p>Unable to obtain author list from the database.</p>');
}

$cats = @mysql_query('SELECT id, name FROM category');
if (!$cats) {
exit( '<p>Unable to obtain category list from the database.</p>');
}

$themes = @mysql_query('SELECT id, name FROM theme');
if (!$themes) {
exit( '<p>Unable to obtain category list from the database.</p>');
}

$geofoci = @mysql_query('SELECT id, name FROM geofocus');
if (!$geofoci) {
exit( '<p>Unable to obtain category list from the database.</p>');
}

?>

<form class="searchField" name="input" action="main_search.php#jump" method="post">
<input type="text" name="searchtext">
<input type="submit" value="Search">
<ul>
<li>
<label><select name="aid" size="1">
<option selected value="">Any Author</option>
<?php
while ($author = mysql_fetch_array($authors)) {
$aid = $author['id'];
$aname = htmlspecialchars($author['name']);
echo "<option value='$aid'>$aname</option>\n";
}
?>
</select></label>
</li>
<li>
<label><select name="cid" size="1">
<option selected value="">Any Category</option>
<?php
while ($cat = mysql_fetch_array($cats)) {
$cid = $cat['id'];
$cname = htmlspecialchars($cat['name']);
echo "<option value='$cid'>$cname</option>\n";
}
?>
</select></label>
</li>
<li>
<label><select name="tid" size="1">
<option selected value="">Any Theme</option>
<?php
while ($theme = mysql_fetch_array($themes)) {
$tid = $theme['id'];
$tname = htmlspecialchars($theme['name']);
echo "<option value='$tid'>$tname</option>\n";
}
?>
</select></label>
</li>
<li>
<label><select name="gfid" size="1">
<option selected value="">Any Region</option>
<?php
while ($geofocus = mysql_fetch_array($geofoci)) {
$gfid = $geofocus['id'];
$gfname = htmlspecialchars($geofocus['name']);
echo "<option value='$gfid'>$gfname</option>\n";
}
?>
</select></label>
</li>
<li><a href="">Closing Date</a></li>
</ul>
</form>
</section>

<section id="results">
<?php

$dbcnx = @mysql_connect('localhost', 'root', 'password');

if (!$dbcnx) {
exit('<p>Unable to connect to the ' . 'database server at this time.</p>');
}

if (!@mysql_select_db('ijdb')) {
exit('<p>Unable to locate the joke ' . 'database at this time.</p>');
}

// The basic SELECT statement

$select = 'SELECT DISTINCT id, joketext';
$from = ' FROM joke';
$where = ' WHERE 1=1';

$aid = $_POST['aid'];
if ($aid != '') { // An author is selected
$where .= " AND authorid='$aid'";
}

$cid = $_POST['cid'];
if ($cid != '') { // A category is selected
$from .= ', jokecategory';
$where .= " AND joke.id=jokecategory.jokeid AND categoryid='$cid'";
}

$tid = $_POST['tid'];
if ($tid != '') { // A theme is selected
$from .= ', joketheme';
$where .= " AND joke.id=joketheme.jokeid AND themeid='$tid'";
}

$gfid = $_POST['gfid'];
if ($gfid != '') { // A region is selected
$from .= ', jokegeofocus';
$where .= " AND joke.id=jokegeofocus.jokeid AND geofocusid='$gfid'";
}

$searchtext = $_POST['searchtext'];
if ($searchtext != '') { // Some search text was specified
$where .= " AND joketext LIKE '%$searchtext%'";
}

?>

<ol id="results-list">

<?php
$jokes = @mysql_query($select . $from . $where);
if (!$jokes) {
echo '</table>'; exit('<p>Error retrieving jokes from database!<br />'.
'Error: ' . mysql_error() . '</p>');
}

while ($joke = mysql_fetch_array($jokes)) {
$id = $joke['id'];
$joketext = htmlspecialchars($joke['joketext']);
echo "<li id=\"jump\">
<article class=\"entry\">
<header>
<h3 class=\"entry-title\"><a href=''>variable title</a></h3>
</header>
<div class=\"entry-content\">
<p>$joketext</p></div>
<footer class=\"entry-info\">
<abbr class=\"published\" title=\"2011-09-22T14:07:00-07:00\">Sept. 22, 2011</abbr>
</footer>
</article>
</li>";
}

?>

</ol>
</section>
.
<footer></footer>
.
.
</body>
</html>

Post On Wrong Url Level

Similar Tutorials

The way I understand posting a form to work is that when you hit submit the information is attached to the end of the url of the new page where your script can then get it and use it.

I have a form that is an include on a page, like so:

thepage.php
include: theform.php

When i fill out the form and hit submit.. the next page acts as if it has not received any of the posted information.

example: echo $_POST['input1'] results in nothing

If i go directly to theform.php and fill out and submit the form it works fine.

example: echo $_POST['input1'] results in whatever was typed in the first box.

So how can I get it to work while being included?

Php Error Reporting Level

Similar Tutorials

When I use ini_get to check my error_reporting level, I get a weird value ( 4983 ) that I can't find anywhere by googling.

Also not on the list of possible levels here ( http://itech.hubpages.com/hub/php-error_reporting ) .. does anyone know how to determine what exactly this level is?

Thanks!