PHP - Moved: Using While Loop To Update Variable Names, Not Working.

As you can see here I have the following code

Code: [Select]
<?php
session_start();

session_register('hazard2');

//INITIALIZE ERROR VARIABLES
$errorFound = false;
$errorIcon['hazard2'] = '';

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

//SET SESSION VARIABLES
$_SESSION['hazard2'] = $_POST['hazard2'];

     //TEST FORM INFORMATION
     if(count($_POST['hazard2']) != 3) {
        $errorFound = true;
$errorIcon['hazard2'] = 'Error Question 2';
     }
    
     //IF NO ERRORS WERE FOUND, CONTINUE PROCESSING

     if (!$errorFound) {
header( "Location: hazardresult.php" );
}

     }

?>
It's lazy I know, but the script is on a file called hazard2.php, is there anyway to have all of the hazard2's in the code come from the file name. So when I make hazard3, I don't have to change all the hazard2's to hazard3's

Thank you

Hello,

I'm having some issues with PHP thinking that the variables that I send it are the actual columns in my database.  First, I pull off Quadratic_Functions and introductory_problem from http://localhost:8888/algebra_book/Chapters/Quadratic_Functions/introductory_problem.php using the code below:

Code: [Select]
$chapter_page =  $_SERVER['PHP_SELF'];
$chapter_page_array = explode('/',$chapter_page);
$size =count($chapter_page_array);
$chapter = $chapter_page_array[$size-2];
$page = $chapter_page_array[$size-1];
$page_array = explode('.', $page);
$page = $page_array[0];
Based on my printing of the variables $chapter and $page I think that it's doing what I want it to do.  I then use the following function:

Code: [Select]
$supplemental_id = getSupplementalId($dbRead,$chapter,$page);
to check out if the there's a supplemental_id for the Quadratic_Function chapter and introductory_problem page name via:

Code: [Select]
function getSupplementalId($read,$user_id,$chapter,$page)
  {
  $sql = "SELECT supplemental_id
  FROM instructors_supplemental
WHERE page_name = $page
AND chapter_name='$chapter";

return $read->fetchRow($sql);
  }
If I stick in actual values, as seen below, the thing runs fine.

Code: [Select]
$sql = "SELECT supplemental_id
  FROM instructors_supplemental
WHERE page_name = 'introductory_problem'
AND chapter_name='Quadratic_Functions'";

But if I run it in the abstract version, with variables for page and chapter name (the first version), I get Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'introductory_problem' in 'where clause'' in...

It's almost as if it thinks that my variables are the names of the columns. 

Any thoughts would be appreciated....

The Code Below is for my Colony Building page for my game.
That particular code is supposed to display the number of buildings built, which it does, and also allow me to change the number of buildings built, which it doesn't.
The code is part of a loop that displays all the possible buildings of a given type, in this case Iron Mines, that can be built on the colony.
Basically what I need to know is, how do I change the name of the column that is being updated as the code loops. Currently it is setting all the forms to alter the number of Basic iron mines on a colony.
I am hoping I can somehow call the names of all the columns into an array and use the same code that picks which column value i am selecting, the $?(an array)[$b](an incrementing number to call the correct array value):
$?[$b].
Then I would replace Basic, in the column part of the UPDATE code with the array and result selector so that the first time i include() the code it creates the form and sets it to alter Basic, but the second time it sets the code to alter the value in the next column.

Code: [Select]
<?php 
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'root';
$dbname = 'aosdb';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
mysql_select_db($dbname);
$b=1;
$queryp = "SELECT * FROM IMBuilt WHERE idcol = $idcol";
$resultp = mysql_query($queryp);
$Base = mysql_fetch_row($resultp);
if(isset($_POST["built"])) {
if($_POST) {
$Badd = $Base[$b]+$_POST["built"];
$queryi="UPDATE IMBuilt SET Basic=$Badd WHERE idcol = $idcol";
mysql_query($queryi);
}
}
$queryf = "SELECT * FROM IMBuilt WHERE idcol = $idcol";
$resultf = mysql_query($queryf);
$Basic = mysql_fetch_row($resultf);
?>
<p class="bd" id="built">| Built: <?php echo $Basic[$b] ?> |</p>
<form class="bd" method="post" action="IronMineList.php"><input type="varchar" name="built"><input type="submit" value="Build"></form>
</div>

I am building a website that uses session variables extensively.  The site is getting a little complicated, and I am starting to lose track of which session variables are assigned, and what their values are.  Is there some way where I can create a piece of code that will display all of the existing session variables and their values?

I'm trying to input the results from a query into html, but I'm just getting the variable names rather than their values.  I used single quotes for the echo statement, but I think I must need to switch to double to do that.  But then I have problems with the double quotes from the class names (ex. class="SideBoxTitle"). 

Code: [Select]
<?php
// get user's videos from database
$conn = mysqli_connect($dbhost, $dbuser, $dbpass) 
or die("MySQL Error: " . mysql_error());

$query = "SELECT * FROM haas12_test.videos";

$result = mysqli_query($conn, $query)
or die ("Couldn't execute query.");

while($row = mysqli_fetch_assoc($result))
{
extract($row);

echo ' 
<div id="topBox"  class="mainVideoSideBoxes" >
    
      <div class="SideBoxTitle" ><h3> $vidtitle </h3> </div><!-- close SideBoxTitle -->
        <div class="sideBoxVidContainer"> 
            <div class="SideBoxScreenCast" > $vidurl </div><!-- close SideBoxScreenCast -->
            <div class="SideBoxDesc" ><p> $viddesc </p> </div><!-- close SideBoxDesc -->
        </div><!-- close sideBoxVidContainer -->
    
</div><!-- close mainVideoSideBoxes -->

</div><!-- close mainVideoSideBoxes -->
'; // end echo staement
}

?>

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=334315.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=348587.0

Hi,
I want to store files to variable array using glob()

like
$files[0] = xyz.txt
$files[1] = pqr.txt
.
.
.
$files[n] = nfile.txt

I know how to list files from directory using glob()

Code: [Select]
<?php
foreach (glob("*.txt") as $filename) {
    echo "$filename size " . filesize($filename) . "\n";
}
?>



How can I do that ?

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=344267.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=318312.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=344739.0

I am working to echo the results in a while or for loop... Both of my sample codes work, but the results are wrong!

The while loop ONLY echos a result IF the first record in the postings table matches the id passed (does not display a result unless the first record has a match)

The if loop displays ALL listings with the same name (counts them all) so there are no unique listings!


<?php

$posts_by_city_sql = "SELECT * FROM postings WHERE id='$_GET[id]'";
$posts_by_city_results = (mysqli_query($cxn, $posts_by_city_sql)) or die("Was not able to grab the Postings!");

/* While Loop  */
while($posts_by_city_row = mysqli_fetch_array($posts_by_city_results)) {
echo "<li><a href='posting_details.php?id=$posts_by_city_row[id]'>$posts_by_city_row[title]</a></li>";
}

/* For Loop  */
$posts_by_city_row = mysqli_fetch_array($posts_by_city_results);
 
for ($i=0; $i<sizeof($posts_by_city_row); $i++) {
echo "<li><a href='posting_details.php?id=$posts_by_city_row[id]'>$posts_by_city_row[title]</a></li>";
 }

?>

Results with for loop (there are 7 total unique book names, but it's just counting the first match on id 7 times like below):

AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners

I created a form that would display all the information that was in my database within a textbox using a while loop. The infomation is able to be displayed but when trying to update only the information in the last textbox gets updated and the other textboxes will just stay the same.

<?php include ('connection.php');
?>

<form method="post" action="update.php">
<?php
$display = mysql_query("SELECT * FROM book ORDER BY id asc") or die("Table Error");

$ID = $_POST['id'];
$Title = $_POST['title'];
$Cost = $_POST['cost'];
$Stock = $_POST['stock'];

while ($row = mysql_fetch_assoc($display))
{
echo "ID :<input type=\"text\" name=\"".id."\" value = \"". $row['id'] ."\"/readonly>";
echo "Title :<input type=\"text\" name=\"".title."\" value = \"" . $row['title'] . "\"/>";
echo "Cost :<input type=\"text\" name=\"".cost."\" value = \"" .$row['cost'] . "\"/>";
echo "Stock :<input type=\"text\" name=\"".stock."\" value = \"" . $row['stock'] . "\"/>";

mysql_query("UPDATE book SET title = '" .$Title. "', cost = '" .$Cost. "', stock = '" .$Stock. "' WHERE id = '" .$ID. "'");
}
?>
<input type="submit" name="update" value="Update" />

Im not sure why it is doing this if someone could tell me it would be a big help

Thanks

Hello

Still pretty new to php, so I need a little help with the below code  (It's not pretty, but for now I just need it to work correct )

Code: [Select]
...
while($row = mysql_fetch_array($result)){
if($row['user_group_id'] <= 2){
$multiplier = 1;
}
if($row['user_group_id'] == 6){
$multiplier = 2;
}
if($row['user_group_id'] == 7){
$multiplier = 3;
}
if($row['user_group_id'] == 8){
$multiplier = 4;
}
$totalshares = ((($row['activity_blog']*$multiplier)/2)+(($row['activity_comment']*$multiplier)/10));

$set_shares=mysql_query("UPDATE phpfox_user SET bod_shares=$totalshares WHERE profile_page_id=0");


echo " User id: ".$row['user_id']." multiplier:".$multiplier." User group:".$row['user_group_id']."
- blog:".$row['activity_blog']." - comment:".$row['activity_comment']." totalshares= ".$totalshares."";
echo "<br />";


}
?>
Problem is the UPDATE part "bod_shares=$totalshares", which just inserts "0".
How do I get it to update the row with the correct value for each row?
The echo shows the right values and calculation for $totalshares.

Hi folks... I really didn't know how to title this thread so I hope it makes sense

Here is what I am trying to do:
Create an editable list of items, price and stock using the 'while' loop - this I can easily do like this...

Quote

echo "<table width=\"100%\" cellspacing=0>";
while($row = mysql_fetch_array($result))
     {
  echo "<tr>";
  echo "<td width=40% class=item_list>$row[mbp_name]</td>";
  echo "<td align=right width=20% class=item_list>";
  echo "<input value=\"$row[mbp_price]\" size=\"2\" maxlength=\"5\" type=\"text\" name=\"mbp_price\" /></td>";
  echo "<td align=right width=20% class=item_list>";
  echo "<input value=\"$row[mbp_stock]\" size=\"2\" maxlength=\"5\" type=\"text\" name=\"mbp_stock\" /></td>";
  echo "<td align=right width=20% class=item_list>" . $row['mbp_stock']*$row['mbp_price'] . "</td>";
  echo "</tr>";
     }
echo "</tr></table>";


If I have the update outside the loop then there are only 3 fields that contain a value after the loop is completed  ie: mbp_item = the last record name of the table, mbp_price=the last record price and mbp=the last record stock.  If I have the update inside the loop the table will update each record but the user may decide to cancel - so then the data in the table is wrong.

As an extra feature, I would also be inetersted to know the best way to check that an entered value is valid before the user moves the cursor to a new field?

Does anyone have a clue what the best way to do this please?