PHP - Update Multiple Records Depending On Another Query

I have 2 tables, access_level and pages. In pages table i will have all the details of page like page_id, code, herf, pagename.. and i will select few from this table and store it in access_level table depending on the department and position. 

Now while editing, i will display all the pages which is stored in access_level pages with a particular page code along with those pages from pages table. if the page_id exists in access_level table, its has to get updated, if its not present then it should get inserted into access_level table. 

These things am doing with checkbox and <li>. 

my access_level table    access_level.JPG   18.19KB   0 downloads   and my pages table    pages.JPG   37.86KB   0 downloads   here is my code

$s1 = mysql_query("SELECT pages.page_id as pid, pages.code, pages.page, 
            pages.href, access_level.aid, access_level.page_id as pgid, 
            access_level.department, access_level.position, 
            access_level.active 
        FROM pages
        LEFT JOIN access_level ON (pages.page_id=access_level.page_id 
            AND access_level.department=".$department." 
            AND access_level.position=".$position.") WHERE pages.code='snor die(mysql_error());
				while($s2 = mysql_fetch_array($s1)) {  ?>
				<tr><td><li><?php echo $s2['page']; ?>  </td><td><input type="checkbox" name="sn[]" value="<?php echo $s2['pid']; ?>" <?php if($s2['pgid'] === $s2['pid']) echo 'checked="checked"';?> />
                <input type="hidden" value="<?php echo $s2['pid']; ?>" name="page_id[<?php echo $s2['pgid']; ?>]">

while submittings i am not getting the logic, how can be done. Please somebody suggest me

I am really not sure if this is a problem with me (probably is), php or mysql.

I have a calendar that I am adding events to. If I want to edit only the date I can but only once after I make this update I am out. If I attempt to update the time or event title the database is never updated and I am no longer able to update the date.
here is the controller for the save.
Code: [Select]
<?php 
function eventsave() {
$details = $_POST;
$this->load->model('eventsmodel');

$this->eventsmodel->eventsave($details,'', TRUE);

redirect('/admin/events', 'location');

}
?>
I have turned off the redirect to see if I was getting any errors and they seem to be non existent.

Here is the model that is used to create a new entry and update a record.
Code: [Select]
<?php
function eventsave($event) {

$startdate = explode('-', $event['startdate']);

$start = mktime($event['starthour'], $event['startmin'], 0, $startdate['0'], $startdate['1'], $startdate['2']);
$end = mktime($event['endhour'], $event['endmin'], 0, $startdate['0'], $startdate['1'], $startdate['2']);
$name = $event['name'];


if (isset($event['id'])) { // if is true then this is an update not a new event
$data = array(
'name' => $name,
                 'start' => $start,
                 'end' => $end
                        );
$this->db->where('id', $id);
$this->db->update('events', $data); 
}else{
$this->db->set('name', $name);
$this->db->set('start', $start);
$this->db->set('end', $end);
$this->db->insert('events');
}

}
?>


I am using code igniter if that helps and the information being submitted by the form looks good.

This is the submitted update array and the new event array is just missing the "id"
Code: [Select]
Array
(
    [name] => test
    [startdate] => 05-14-2011
    [starthour] => 1
    [startmin] => 0
    [endhour] => 1
    [endmin] => 0
    [id] => 54
    [saveevent] => save
)


Any suggestions would be appreciated. Thank you.

Hi guys, I am trying to UPDATE some records on a mySQL database but can't seem to find out why it is not working. This is my code.


Code: [Select]
<?php


$latitude = $_POST['lat_location'];
$longitude = $_POST['long_location'];
$unique_ID = $_POST['unique_ID'];

include('connect2.php');



$query = mysql_query("SELECT * FROM user_location WHERE unit = '$unique_ID'");

$numrows = mysql_num_rows($query);


if ($numrows == 1) {



$query2="UPDATE user_location SET lat = '$latitude', long = '$longitude' WHERE unit = '$unique_ID'";
mysql_query($query2);



$test = "matches";



} else {

mysql_query("INSERT INTO user_location VALUES ('','$unique_ID','$latitude','$longitude')");

$test = "not match";

}

echo $test . "<br />";
echo $numrows;

?>
The script receives the data via the POST method and assigns it to variables. Then I query the database for one of those variables and check how many results are found. If 0 results are found then a new record is created on the database, but if there is 1 record found then the record that is found has to be UPDATED. When the result is 0 the scripts creates the new record fine, but if the result is 1 it doesn't update. I just can't figure out why. Any help will be greatly appreciated.

Thanks in advanced,

I have a problem .
I 've been trying for a long time to make an update for php mysql to change the data.
but every time I do not manage to make it work with a form.
but it works if I only if I put this ($ sql = "UPDATE users SET username = 'value' WHERE id = 10 " ; )
so it only works when I put the value of the id.

but I want in an html form to indicate what I want to change and what id goes.

but I have tried so long that I do not feel like I so want someone help me.

make the same database and same as my records and make the code and test it if it works show me please
my database name : web test
my table called : users
my records are called :

id int ( 11) AUTO_INNCREMENT
username , varchar ( 255 )
password , varchar ( 255 )
first_name , varchar ( 255 )
last_name , varchar ( 255 )
email, varchar ( 255 )
Age, int ( 11)             Look, my update.php is like this now
<?php
$servername = "localhost";
$username = "root";
$password = ".....";
$dbname = "webtest";


$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 

$sql = "UPDATE users SET password='cotton candy' WHERE id=10";

if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}

$conn->close();
?>
but now i have still have to go into the php file to change the valeu or the id 
but i looked on site and youtube how to put it in a simple html form 
but it still does not work.

i want it in a html from.
I want that when I enter the ID that the data of the user appears and that I can change any valeu separately.

i have a small search profile search and need to set $getuname variable to users username

if((trim($country) !== ''&&($state) !== ''&&($city) !== '')){


   $data = mysql_query("SELECT    *  FROM users WHERE users.state='$state' AND users.country='$Country' AND users.city='$city' ORDER BY RAND() DESC LIMIT 1 ");   
Echo "Country city state search";
$getuname = mysql_real_escape_string($_GET['username']);

am i meant to use the get or is that only for forms?

Hi there, hope have some help. I have a form where a user select time and days of the week (monday, tuesday..) that he is available. The insert script works fine, it insert and the days of week he checked in the table, the only problme is when i try to update each of them. I used this code above, but is not working, instead of updating/inserting days that is selected is inserting multi-records with the same day of the week value. here it is:

foreach($weekDay as $DaysofWeek){

$sql_days = "UPDATE available SET day_time = '$day_time', week_day = '$DaysofWeek' WHERE user_id = '$id_user'";

$update_availability = mysql_query($sql_days);

}

Hello there, i`m trying to figure out a way to reorder a query string depending on variables.

So the url would have the following query:
/result/index.php?page=Weissenfels+Clack+and+Go&tyre=155_70_12&option1=30_02&option2=43_02&v_t=car&options=2

It should depend what page they come from if the page is equal to option2 then option1 is op1 and option2 is op2

To make it myself easier i have converted some variables
On every first two digits ie 43 from the 43_02 can have 13 different ending digits, ie _03 or _04 or _05 etc...

So i have converted all 43_02 43_03 etc to one variable ie $chain1 or $chain2 which holds in this case 43

a 43 is equal to Weissenfels+Clack+and+Go

in the index page i have included the following process.

At the moment i can only use php coding, unfortunately no mysql atm

thank you in advance.

Code: [Select]
<?php


$tyre = $_GET['tyre'];  // finds the tyre size
$op1 = $_GET['option1'];  // finds the first chain size if applicable
$op2 = $_GET['option2'];  // finds the second chain size if applicable
$op3 = $_GET['option3'];  // finds the third chain size if applicable
$op4 = $_GET['option4'];  // finds the fourth chain size if applicable
$op5 = $_GET['option5'];  // finds the fith chain size if applicable
$op6 = $_GET['option6'];  // finds the sixth chain size if applicable
$op7 = $_GET['option7'];  // finds the seventh chain size if applicable
$op8 = $_GET['option8'];  // finds the eighth chain size if applicable
$options = $_GET['options'];
$page = $_GET['page'];
$error = $_GET['info'];
$vehicle_type = $_GET['v_t']; // finds the vehicle type

$b = "Weissenfels+WeissTech+Tecna";
$c = "Weissenfels+Clack+and+Go";


if (($op1 == "30_02") || ($op1 == "30_03"))
{
$chain1 = "m30";
}

elseif (($op2 == "43_02") || ($op2 == "43_03"))
{
$chain2 = "m43";
}
else echo "error";

switch ($page)
{
case (($page == $c) && ($chain1 == "m43"));
$option1 = $op1;
$option2 = $op2;
break;
case (($page == $c) && ($chain2 == "m43"));
$option1 = $op2;
$option2 = $op1;
break;
default;
        $option1 = $op1;
$option2 = $op2;
    break;
}

if ($options=="1") // calculates the possible combination
{

// outputs the results

include 'options_1.php'; // type the amount of possible chains in here ie options_3 options_4 etc

}

elseif ($options=="2")
{
// outputs the results

include 'options_2.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="3")
{
// outputs the results

include 'options_3.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="4")
{
// outputs the results

include 'options_4.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="5")
{
// outputs the results

include 'options_5.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="6")
{
// outputs the results

include 'options_6.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="7")
{
// outputs the results

include 'options_7.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="8")
{
// outputs the results

include 'options_8.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}


else
echo "there is an error on process_action2";


?>

I've got query.

When I run this query to exclude records where id = $userarray['id'],

$q = "SELECT * FROM users WHERE inst_id = '". $userarray['inst_id'] ."' AND id != '". $userarray['id'] ."' ";


it actually ONLY returns records with $userarray['id']  as opposed to excluding them.  Isn't the way to exclude them to use != ?

Hello just wondering if someone can help me...

I have a select multiple form that sends the id numbers of records I want to get...

how do I construct the query to the mysql db to do this?

$array-$_POST['form-array']

so something like $r = ("SELECT column from 'Table' WHERE ID = (array, values, here)")

Thanks for any help.

Hello all,   Based on the suggestion of you wonderful folks here, I went away for a few days (to learn about PDO and Prepared Statements) in order to replace the MySQLi commands in my code. That's gone pretty well thus far...with me having learnt and successfully replaced most of my "bad" code with elegant, SQL-Injection-proof code (or so I hope).   The one-and-only problem I'm having (for now at least) is that I'm having trouble understanding how to execute an UPDATE query within the resultset of a SELECT query (using PDO and prepared statements, of course).   Let me explain (my scenario), and since a picture speaks a thousand words I've also inlcuded a screenshot to show you guys my setup:   In my table I have two columns (which are essentially flags i.e. Y/N), one for "items alreay purchased" and the other for "items to be purchased later". The first flag, if/when set ON (Y) will highlight row(s) in red...and the second flag will highlight row(s) in blue (when set ON).   I initially had four buttons, two each for setting the flags/columns to "Y", and another two to reverse the columns/flags to "N". That was when I had my delete functionality as a separate operation on a separate tab/list item, and that was fine.   Now that I've realized I can include both operations (update and delete) on just the one tab, I've also figured it would be better to pare down those four buttons (into just two), and set them up as a toggle feature i.e. if the value is currently "Y" then the button will set it to "N", and vice versa.   So, looking at my attached picture, if a person selects (using the checkboxes) the first four rows and clicks the first button (labeled "Toggle selected items as Purchased/Not Purchased") then the following must happen:   1. The purchased_flag for rows # 2 and 4 must be switched OFF (set to N)...so they will no longer be highlighted in red. 2. The purchased_flag for row # 3 must be switched ON (set to Y)...so that row will now be highlighted in red. 3. Nothing must be done to rows # 1 and 5 since: a) row 5 was not selected/checked to begin with, and b) row # 1 has its purchase_later_flag set ON (to Y), so it must be skipped over.   Looking at my code below, I'm guessing (and here's where I need the help) that there's something wrong in the code within the section that says "/*** loop through the results/collection of checked items ***/". I've probably made it more complex than it should be, and that's due to the fact that I have no idea what I'm doing (or rather, how I should be doing it), and this has driven me insane for the last 2 days...which prompted me to "throw in the towel" and seek the help of you very helpful and intellegent folks. BTW, I am a newbie at this, so if I could be provided the exact code, that would be most wonderful, and much highly appreciated.   Thanks to you folks, I'm feeling real good (with a great sense of achievement) after having come here and got the great advice to learn PDO and prepared statements.   Just this one nasty little hurdle is stopping me from getting to "end-of-job" on my very first WebApp. BTW, sorry about the long post...this is the best/only way I could clearly explaing my situation.   Cheers guys!

case "update-delete":
	if(isset($_POST['highlight-purchased'])) 
		{
			// ****** Setup customized query to obtain only items that are checked ******
			$sql = "SELECT * FROM shoplist WHERE";
					for($i=0; $i < count($_POST['checkboxes']); $i++)
						{
							$sql=$sql . " idnumber=" . $_POST['checkboxes'][$i] . " or";
						}
					$sql= rtrim($sql, "or");
											
			$statement = $conn->prepare($sql);
			$statement->execute();
																						
			// *** fetch results for all checked items (1st query) *** //
			$result = $statement->fetchAll();

			$statement->closeCursor();
											
			// Setup query that will change the purchased flag to "N", if it's currently set to "Y"
			$sqlSetToN = "UPDATE shoplist SET purchased = 'N' WHERE purchased = 'Y'";
											
			// Setup query that will change the purchased flag to "Y", if it's currently set to "N", "", or NULL
			$sqlSetToY = "UPDATE shoplist SET purchased = 'Y' WHERE purchased = 'N' OR purchased = '' OR purchased IS NULL";

			$statementSetToN = $conn->prepare($sqlSetToN);
			$statementSetToY = $conn->prepare($sqlSetToY);
											
			/*** loop through the results/collection of checked items ***/
			foreach($result as $row)
				{
					if ($row["purchased"] != "Y")
						{
							// *** fetch one row at a time pertaining to the 2nd query *** //
							$resultSetToY = $statementSetToY->fetch();
															
							foreach($resultSetToY as $row)
								{															
									$statementSetToY->execute();																
								}
						}
					else
						{
							// *** fetch one row at a time pertaining to the 2nd query *** //
							$resultSetToN = $statementSetToN->fetch();
															
							foreach($resultSetToN as $row)
								{															
									$statementSetToN->execute();																
								}
						}
				}
				break;
		}

 CRUD Queston.png   20.68KB   0 downloads    

Have a web page that displays a number of update forms depending on the amout of records that get returned from a mysql query, if query returns 4 records then the page will display 4 identical forms, the trouble i'm having is getting the each  of the 4 forms to display a different record as at the moment they all show just first record of query.

I have played around with loops but not getting anywhere which may be due to my limited knowledge code for page is below

Code: [Select]
<?php $numberofrow =mysql_num_rows($Recordset1);
 
for($counter = 1;$counter<=$numberofrow;$counter++){ 
?>
  <label for="hometeam2"></label>
<form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>">
  <label for="hometeam"></label>
 
 
 
  <input name="fixid" type="text" id="fixid" value="<?php echo $row_Recordset1['FixtureID']; ?>" />
  <input name="hometeam" type="text" id="hometeam2" value="<?php echo $row_Recordset1['hometeamname']; ?>" />
  <label for="homescore"></label>
  <input name="homescore" type="text" id="homescore" value="<?php echo $row_Recordset1['homescore']; ?>" />
  <label for="awayscore"></label>
  <label for="fixid"></label>
  <input name="awayscore" type="text" id="awayscore" value="<?php echo $row_Recordset1['awayscore']; ?>" />
<label for="awayteam"></label>
<input name="awayteam" type="text" id="awayteam" value="<?php echo $row_Recordset1['awayteamname']; ?>" />
<input type="submit" name="update" id="update" value="Submit" />
<input type="hidden" name="MM_update" value="form1" />

Hello guys,

I have an website where I have 5 category blocks in my index page to show last 3 posts in each category.
But I having problems showing the content in my "last added" block.
Sometimes works, and sometimes not. Dont know what is happening...

Look:
http://screensnapr.com/e/Zm4ssA.jpg

Only "Filmes" is showing, but not "Series"...

the movies block sometimes have this issue too... the code is almost the same as above, maybe is the same problem...

For each category that I want to show their posts, I have a file called newhome_x.php

In my templates/dirvideo/main.tpl file, I have this code:
Code: [Select]
<div id="page_content" class="clearfix">
{info} {newhome_final} {content}
</div>
In my templates/dirvideo/newhome.tpl file, I have this code:
Code: [Select]
<li style="margin-right: 45px;" onclick="window.location='{link}'">
<a title='{home_title}' href="{link}"><img src="[xfvalue_poster]" alt='{home_title}' /></a>
<h3 style="overflow:hidden"><a title='{home_title}' href="{link}">{home_title}</a></h3>
</li>
in my index.php I have this code:
require_once ENGINE_DIR . '/modules/newhome.php';
require_once ENGINE_DIR . '/modules/newhome_b.php';
require_once ENGINE_DIR . '/modules/newhome_c.php';
require_once ENGINE_DIR . '/modules/newhome_d.php';
require_once ENGINE_DIR . '/modules/newhome_e.php';

if (clean_url ( $_SERVER['HTTP_HOST'] ) != clean_url ( $config['http_home_url'] )) {

$replace_url = array ();
$replace_url[0] = clean_url ( $config['http_home_url'] );
$replace_url[1] = clean_url ( $_SERVER['HTTP_HOST'] );

} else
$replace_url = false;

if (!$is_logged && !in_array($_GET['do'], array('register', 'lostpassword'))) { include 'index.html'; die; }
$tpl->load_template ( 'main.tpl' );
$tpl->set ( '{lastusers}', $lastusers);
$tpl->set('{forumStyle}', require_once ROOT_DIR . '/engine/bullet_energy/modules/load_style.php');
require_once ENGINE_DIR . '/modules/3news.php';$source = '<div class="index_top1" style="width: 100%; padding-top: 10px; padding-bottom: 10px; " >
<span style="font-size: 24px; margin-left: 10px;"><img border="0" src="templates/dirvideo/images/movies.gif">
</span>
<ul class="clearfix">
{newhome}
</ul>
</div>
<div class="index_top2" style="width: 100%; padding-top: 10px; padding-bottom: 10px; " >
<span style="font-size: 24px; margin-left: 10px;"><img border="0" src="templates/dirvideo/images/serie.gif">
</span>
<ul class="clearfix">
{newhome_b}
</ul>
</div>
<div class="index_top3" style="width: 100%; padding-top: 10px; padding-bottom: 10px; " >
<span style="font-size: 24px; margin-left: 10px;"><img border="0" src="templates/dirvideo/images/music.gif">
</span>
<ul class="clearfix">
{newhome_c}
</ul>
</div>
<div class="index_top6" style="width: 100%; padding-top: 10px; padding-bottom: 10px; " >
<span style="font-size: 24px; margin-left: 10px;"><img border="0" src="templates/dirvideo/images/jogo.gif">
</span>
<ul class="clearfix">
{newhome_e}
</ul>
</div>
<div class="index_top4" style="width: 100%; padding-top: 10px; padding-bottom: 10px; " >
<span style="font-size: 24px; margin-left: 10px;"><img border="0" src="templates/dirvideo/images/programas.gif">
</span>
<ul class="clearfix">
{newhome_d}
</ul>
</div>';
if (!isset($_REQUEST["catalog"]) && !isset($_REQUEST["newsid"]) && !isset($_REQUEST["do"]) && !isset($_REQUEST["page"]) && !isset($_REQUEST["category"]) && !isset($_REQUEST["cat"]) && !isset($_REQUEST["action"]) && !isset($_REQUEST["id"]) && !isset($_REQUEST["name"]) && !isset($_REQUEST["news_name"]) && !isset($_REQUEST["seourl"]) && !isset($_REQUEST["findpost"]) && !isset($_REQUEST["subaction"])) { $tpl->set ( '{newhome_final}', $source);} else { $tpl->set ( '{newhome_final}', "");}

$tpl->set ( '{referer}', $referer_block );
$tpl->set ( '{calendar}', $tpl->result['calendar'] );
$tpl->set ( '{top_news}', $top_news );
$tpl->set ( '{last_news}', $last_news );
$tpl->set ( '{rand_news}', $rand_news );
$tpl->set ( '{archives}', $tpl->result['archive'] );
$tpl->set ( '{tags}', $tpl->result['tags_cloud'] );
$tpl->set ( '{vote}', $tpl->result['vote'] );
$tpl->set ( '{topnews}', $topnews );
$tpl->set ( '{login}', $tpl->result['login_panel'] );
$tpl->set ( '{info}',  $tpl->result['info'] );
$tpl->set ( '{speedbar}', $tpl->result['speedbar'] );
$tpl->set ( '{catlist}', $catlist );
$tpl->set ( '{moviepopular}', $tpl->result['moviepopular'] );$tpl->set ( '{newhome}', $tpl->result['newhome'] );$tpl->set ( '{newhome_b}', $tpl->result['newhome_b'] );$tpl->set ( '{newhome_c}', $tpl->result['newhome_c'] );$tpl->set ( '{newhome_d}', $tpl->result['newhome_d'] );$tpl->set ( '{newhome_e}', $tpl->result['newhome_e'] );

In my engine/modules folder I have the files:
newhome.php
newhome_b.php
newhome_c.php
newhome_d.php
newhome_e.php

This is the code of engine/modules/newhome_c.php file (Series block):
<?php
if (!isset($_REQUEST["catalog"]) && !isset($_REQUEST["newsid"]) && !isset($_REQUEST["do"]) && !isset($_REQUEST["page"]) && !isset($_REQUEST["category"]) && !isset($_REQUEST["cat"]) && !isset($_REQUEST["action"]) && !isset($_REQUEST["id"]) && !isset($_REQUEST["name"]) && !isset($_REQUEST["news_name"]) && !isset($_REQUEST["seourl"]) && !isset($_REQUEST["findpost"]) && !isset($_REQUEST["subaction"])) {
 
if( ! defined( 'DATALIFEENGINE' ) ) {
 
        die( "Hacking Attempt!" );
 
}
 
 
 
$is_change = false;
 
 
 
if ($config['allow_cache'] != "yes") { $config['allow_cache'] = "yes"; $is_change = true;}
 
 
 
$tpl->result['newhome_c'] = dle_cache("newhome_c", $config['skin']);
 
 
 
$tpl->load_template( 'newhome.tpl' );
 
 
 
if( strpos( $tpl->copy_template, "[xfvalue_" ) !== false ) { $xfound = true; $xfields = xfieldsload();}
 
        else $xfound = false;
 
 
 
        if ($tpl->result['newhome_c'] === false) {
 
 
 
$sql = $db->query( "SELECT id, title, date, alt_name, category,xfields,autor FROM " . PREFIX . "_post WHERE category like '%7%' ORDER BY date DESC LIMIT 3" );
 
while ($row = $db->get_row($sql))
 
{
 
$catchecks = explode(",",$row["category"]);
 
$catpass = false;
foreach ($catchecks as $catcheck) {
        if ($catcheck == "7")
                $catpass = true;
}
 
if ($catpass) {
 
$sql2 = $db->query( "SELECT alt_name FROM " . PREFIX . "_category WHERE id='$row[category]'" );
 
 
 
$row2 = $db->get_row($sql2);
 
 
 
 
 
 
 
if( $xfound ) {
 
                        $xfieldsdata = xfieldsdataload( $row['xfields'] );
 
 
 
                        foreach ( $xfields as $value ) {
 
                                $preg_safe_name = preg_quote( $value[0], "'" );
 
 
 
                                if( empty( $xfieldsdata[$value[0]] ) ) {
 
                                        $tpl->copy_template = preg_replace( "'\\[xfgiven_{$preg_safe_name}\\](.*?)\\[/xfgiven_{$preg_safe_name}\\]'is", "", $tpl->copy_template );
 
                                } else {
 
                                        $tpl->copy_template = preg_replace( "'\\[xfgiven_{$preg_safe_name}\\](.*?)\\[/xfgiven_{$preg_safe_name}\\]'is", "\\1", $tpl->copy_template );
 
                                }
 
 
 
                                $tpl->copy_template = str_replace( "[xfvalue_{$preg_safe_name}]", stripslashes( $xfieldsdata[$value[0]] ), $tpl->copy_template );
 
                        }
 
                }
 
 
 
if($config['seo_type']=='1')
 
{
 
 
 
$link= "$row[id]".'-'."$row[alt_name]".'.html';
 
 
 
}
 
else
 
{
 
 
 
$link="$row2[alt_name]".'/'."$row[id]".'-'."$row[alt_name]".'.html';
 
 
 
}
 
 
 
 
 
$tpl->set( '{home_title}',stripslashes($row['title']));
 
$tpl->set( '{home_author}', stripslashes($row['autor']));
 
$tpl->set( '{home_date}', $row['date']);
 
$tpl->set( '{link}',$link);
 
$tpl->compile('newhome_c');
 
 
}
}
 
create_cache ("newhome_c", $tpl->result['newhome_c'], $config['skin']);
 
$tpl->clear();
 
$db->free();
 
}
 
if ($is_change) $config['allow_cache'] = false;
 
}
 
?>

I think that is everything here :-)
Can please someone help me?

I have a problem with an amend to an admin system I am trying to change. The shop stocks different colours of each product and the client wants to be able to update the stock levels of all colours of one product (which all share the same title) on one form. I have tried following some instructions on some sites and tried making my own and I can get it to display the form and the values correctly, but on submission it does nothing but direct me to a page without a title value in the address (e.g. www.example.com/example/stock_level_2.php?title=). I think it may be to do with the arrays I am using, has anyone got any ideas? Here is the code.

Form:
Code: [Select]
<?php
$pd_title = str_replace("_"," ",$_REQUEST["title"]);
$pd_title = str_replace("%","&#38;#37;",$pd_title);
$pd_title = str_replace("/","&#38;#47;",$pd_title);

$lookupqueryc = mysql_query("SELECT * FROM product WHERE pd_title = '".$pd_title."' ORDER BY pd_id DESC");

echo '<table><tr><th align="center" class="bodytext">Product<br />ID</th><th align="center" class="bodytext">Product Name</th><th align="center" class="bodytext">Stock Level</th></tr>';

$form = '<form name="frmAmendStock" method="post" action="stock_level_2.php?title="';
$form .=  $_GET["title"];
$form .= '" enctype="multipart/form-data">';
echo $form;
echo '<input name="submitted" type="hidden" value="true">';
$count=mysql_num_rows($lookupqueryc);
echo '<input name="count" type="hidden" value="';
echo $count;
echo '">';

                          
  while($lookupresultc = mysql_fetch_array($lookupqueryc)){  
  
        

echo '<tr><td align="center" class="bodytext">';
                                $id[]=$lookupresultc["pd_id"];
echo $lookupresultc["pd_id"];
echo '</td><td class="bodytext">';
echo $lookupresultc["pd_title"];
if (isset($lookupresultc["pd_colour"]) && $lookupresultc["pd_colour"] !="") {
echo " (";
echo $lookupresultc["pd_colour"];
echo ')';
}
if ($lookupresultc["pd_stock"] <= 5) {
echo '</td><td align="center" class="bodytext" style="border: 2px solid red;">';
echo '<input name="stock[]" type="text" id="stock" value="';
                                echo $lookupresultc["pd_stock"];
                                echo '"style="width: 50px;" />'; 
echo "</td></tr>";
}else{
echo '</td><td align="center" class="bodytext">';
echo '<input name="stock[]" type="text" id="stock" value="';
                                echo $lookupresultc["pd_stock"];
                                echo '"style="width: 50px;" />'; 
echo "</td></tr>";

}



} ?>
<tr>
                <td>&nbsp;</td>
                <td height="35"><a href="javascript: " onClick="javascript:document.forms.frmAmendStock.submit()" class="bodytext"><strong>click here to amend your stock </strong></a></td>
              </tr>
</form> </table>


And here is the code it should run on submission:
Code: [Select]
<?php
if (isset($_POST["submitted"])) {

for($i=0;$i<$_POST["count"];$i++){
mysql_query("UPDATE product SET pd_stock='$stock[$i]' WHERE pd_id='$id[$i]'");
}

}
?>

Hi Guys,

I am new to PHP/MYSQL. I am working on a web database project to record class attendance.
I have found this script which I have manipulated, however, I am not sure why it does not display the data. It may be something simple, I have checked over table names, field names, variable names to see that they match the database. It displays the textboxes with the php code rather than the data and all other fields display no data.

Can you help?

I will be focusing on Prepared Statements for SQL injections later.

<?php

$host="xxx"; // Host name
$username="xxx"; // Mysql username
$password="xxx"; // Mysql password
$db_name="xxx"; // Database name

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


$sql="SELECT * FROM attendance";
$result=mysql_query($sql);

// Count table rows
$count=mysql_num_rows($result);


?>


<html>
<head>
<title>Registers</title>
</head>
<body>


<?php include 'Navigation.php';?>

<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">

<table border="0" cellspacing="1" cellpadding="0" style="width: 1461px; height: 105px">

<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>Last Name</strong></td>
<td align="center"><strong>First Name</strong></td>
<td align="center"><strong>Form</strong></td>
<td align="center"><strong>Year Group </strong></td>
<td align="center"><strong>Date</strong></td>
<td align="center"><strong>Attendance</strong></td>


</tr>

<?php
while($rows=mysql_fetch_array($result)){
?>

<tr>
<td align="center"><? $Student_id[]=$rows['Student_id']; ?><? echo $rows['Student_id']; ?></td>
<td align="center"><? $firstname[]=$rows['firstname']; ?><? echo $rows['firstname']; ?></td>
<td align="center"><? $lastname[]=$rows['lastname']; ?><? echo $rows['lastname']; ?></td>
<td align="center"><? $Form_Group[]=$rows['Form_Group']; ?><? echo $rows['Form_Group']; ?></td>
<td align="center"><? $Year_Group[]=$rows['Year_Group']; ?><? echo $rows['Year_Group']; ?></td>
<td align="center"><? $Att_Date[]=$rows['Att_Date']; ?><? echo $rows['Att_Date']; ?></td>
<td align="center"><input name="Presence[]" type="text" id="Presence" value="<? echo $rows['Presence']; ?>"></td>
</tr>

<?php
}
?>

<tr>
<td colspan="7" align="center"><input type="submit" name="Submit" value="Submit Register"></td>
</tr>
</table>

</form>
</table>


<?php

// Check if button name "Submit" is active, do this
if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE attendance SET Presence='$Presence[$i]' WHERE Student_id='$Student_id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
header("location:Registers.php");
}
mysql_close();
?>