PHP - Noob Question About "->"

I'm a very new PHP user (as in, I just started today) and need to make a set of navigation buttons which will take the user to "next" or "previous" pages. I assume that the $_GET function is involved, but I don't know how to do it.

It needs to work like this:

If the URL looks like "http://website.com/page1.php"

I need the "next" button (a href image) to change it to "/page2.php", and while on page 2, for the "previous" button to take the user to "/page1.php" and so forth. How can I cause the page number to increment or decrease respective to the href image being clicked?

Hey guys,

I'm new to PHP and I'm currently teaching myself. I'm looking over some code and I'm confused when to use "." inside of code. Can someone please explain to me?

Here's some example code I read from a book:

<?php
$counter = 1;
while ($counter <= 12) {
      echo $counter." times 2 is ".($counter * 2). "<br />"
      $counter++;
}
?>

Thanks!

Can someone please help me with an array problem i can not figure out.

I need the array to be numbered from 1 to how ever many fields that are needed in the form and have a mysql field name and the title of the field also in the array.

1, "mysql_field_name", "Title of form field"
2, "", ""

and so on

then the form will be shown based on the array.

I have the following draft code which I am working with.

any suggestions on how i may do this array ?

Code: [Select]
<?php
$options = array(
'1'=> array('fieldtext'=>'option1', 'mysqlfield'=>'option1'),
'2'=> array('fieldtext'=>'option2', 'mysqlfield'=>'option2'),
'3'=> array('fieldtext'=>'option3', 'mysqlfield'=>'option3'),
'4'=> array('fieldtext'=>'option4', 'mysqlfield'=>'option4'),
);


// $options = array(1 => "option1", "option2", "option3", "option4");

// the line above works but i want to include the name of the mysql field as well.

$userid = 1;

?>
<div style="align: center; margin: 12px; font-family:Tahoma;">
<br><br><?php
if ($_POST['Update'] != "Update") { // check if form submitted yet, if not get data from mysql.
$res = db_query("SELECT * FROM `users` WHERE `userid` = '" . $userid . "'");
foreach($options as $key => $value) { $_POST[$key] = mysql_result($res, 0, $value); }
$ok_to_update = "no";
} elseif ($_POST['Update'] == "Update") { // check if form submitted yet, if so get POST data.
// error checking
// foreach($options as $key => $value) {
// $_POST[$i] = "";
// }
$ok_to_update = "yes";
}

if ($_POST['Update'] == "Update" && $ok_to_update == "yes") {
// $res = db_query("INSERT INTO `users` () VALUES ()"); // add user details to database.
?><p><br><br><br>Thank you for updating</p><?php
} else {
?><form name="form1" method="post" action="">
<?php foreach($options as $key => $value) {
?><p><?php echo($value); ?>:&nbsp;<input type="text" name="<?php echo($key); ?>" value="<?php echo($_POST[$key]);?>"></p>
<?php } ?>
<input name="Update" type="submit" value="Update">
</form>
<?php } ?>
</div>

Hi,

bit stuck on how to find and replace "<" and ">" with "&lt;" and  "&gt;". I basically have a database record that outputs to screen and I need the code in the <code> tags to be rendered to the screen. I therefore need it to go through the whole array variable from the db and change the symbols just inside the code tags. Please be aware that the code tags might happen more than once

here's an example below

Code: [Select]
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
<h1>hello</h1>
</code>
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
<h1>hello</h1>
</code>

the desired output would be:

<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
&lt;h1&gt;hello&lt;/h1
</code>
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
&lt;h1&gt;hello&lt;/h1
</code>

help on this would be great

Cheers

Rob

Hi all,

just to get this out of the way i have now been working on html / css / php / mysql coding for about 3 weeks.

So i dont know too much, on to the problem...

I am creating a database for asset managment in and out of our shop I have setup the db and it works with no issues.
So I am currently trying to add fluff as i put it.

The guys in the shop want the web page to have a table of information on what is in the shop and when they click on the asset number in the table they want it to open a new page where you can edit the database information of that item.

I have no clue how to emplement this after reading diffrent ideas for about 4 hours today I am just stuck and confused.
any ideas or tips would be helpfull


This first block of code is my status page.
Code: [Select]

<style>

tr
{font-size:24px;}
button
{width:120px}

</style>

<body topmargin="50px">

<?php
 session_start(); 

include("../../Connections/db_connection.php");
$table = "shop_inventory";
mysql_select_db("$db_database", $connect);
unset ($db_username, $db_password);

$currenttime = getdate();

$result = mysql_query("SELECT * FROM shop_inventory WHERE In_Shop='1'");
$test = mysql_fetch_array($result);

echo "<table border='1' align='center' style='text-align:center' cellpadding='10' width='100%'>
 <tr>
 <th>Asset number</th>
 <th>Building</th>
 <th>Room number</th>
 <th>In date</th>
 </tr>";

$_SESSION['array_row'] = $test;
 
while($row = mysql_fetch_array($result))
   {
   $style = '';
   //if ($currenttime - $row['Entered_Shop_Time'] == 0 || 1)
    $style = 'style="background-color:#00FF00"';
   
echo "<tr>";
echo "<td> <button onClick=../subpages/edititems.php>" . $row['Asset'] . "</button> </td>";
echo "<td>" . $row['Building'] . "</td>";
echo "<td>" . $row['Room_Number'] . "</td>";
echo "<td $style>" . date("F j, Y", strtotime($row['Entered_Shop_Time']))  . "</td>";
echo "</tr>";
   
   }
echo "</table>";
 
mysql_close($connect);
 
?>

</body>



This second block of code is the page where i want to dump the table info into for editing.

Code: [Select]

<?php
session_start(); 

include("../../Connections/db_connection.php");
$table = "shop_inventory";
mysql_select_db("$db_database", $connect);
unset ($db_username, $db_password);
//$Asset = $_POST['Asset'];
$Session = $_SESSION['array_row'];

//$data = mysql_query("SELECT * FROM shop_inventory WHERE Asset=$session");
//$query = mysql_query($data) or die ("Cannot select database." . mysql_error());
//$Session = mysql_fetch_array($data);

?>


<!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>Add Items</title>
</head>

    <body>
    <div style=" padding-top:5px;">
                <h1><center>Add New Items</center></h1>
        </div>
      <form name="myForm" action="afteredititems.php" method="post">
            Asset Number: <input type="text" name="Asset" value="<?php echo $Session['Asset']?>"/><br /><br />
            Manufactu <input type="text" name="Manufacture" value="<?php echo $Session['Manufacture']?>"/><br /><br />
            Model: <input type="text" name="Model" value="<?php echo $Session['Model']?>"/><br /><br />
            Serial Number: <input type="text" name="Serial_Number" value="<?php echo $Session['Serial_Number']?>"/><br /><br />
            Building: <input type="text" name="Building" value="<?php echo $Session['Building']?>"/><br /><br />
            Room Number: <input type="text" name="Room_Number" value="<?php echo $Session['Room_Number']?>"/><br /><br />
            <input type="hidden" name="In_Shop" value="1"/>
            Type of Equipment: <select name="Type" value="<?php echo $Session['Type']?>">
                                <option value="desktop">Desktop</option>
                                <option value="laptop">Laptop</option>
                                <option value="ipad">Ipad</option>
                                <option value="ipod">Ipod</option>
                                <option value="projector">Projector</option>
                                <option value="printer">Printer</option>
                               </select><br /> <br />
            <center><input type="submit" value="Add Item"/></center>
        </form>
    </body>
</html>



And lastly I have a page that redisplays the edited information.

Code: [Select]

<?php

//$Asset = $_POST['Asset'];

//$data = mysql_query("SELECT * FROM shop_inventory WHERE Asset=$Asset");
//$query = mysql_query($data) or die ("Cannot select database." . mysql_error());
//$data2 = mysql_fetch_array($data);


include("../../Connections/db_connection.php");
$table = "shop_inventory";
mysql_select_db("$db_database", $connect);
unset ($db_username, $db_password);
$Asset = $_POST['Asset'];
$Manufacture = $_POST['Manufacture'];
$Model = $_POST['Model'];
$Sn = $_POST['Serial_Number'];  //<---- possibly fubar check sn everywhere
$Building = $_POST['Building'];
$Room_Number = $_POST['Room_Number'];
$Type = $_POST['Type'];

$data = mysql_query("UPDATE `shop_inventory` SET  Manufacture='$Manufacture', Model='$Model', Serial_Number='$Sn', Building='$Building', Room_Number='$Room_Number', Type='$Type' WHERE Asset=$Asset");
//$query = mysql_query($data) or die("could not execute query.". mysql_error());

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

<!-- display changes -->
Asset: <?php echo $Asset ?><br />
Manufactu <?php echo $Manufacture ?><br />
Model: <?php echo $Model ?><br />
Serial number: <?php echo $Sn ?><br />
Building: <?php echo $Building ?><br />
Room Number: <?php echo $Room_Number ?><br />
Type: <?php echo $Type ?><br /><br />

</body>
</html>



I know there is a lot of poorly formated code and more then likely it is hard to read as I was going to do cleanup after I had all my features working.

After doing all the digging i found out about sessions and how they are used to pass data, I thought it would be a good method but I just could not figure out how to send information from the table if the table is reciving its info from an array.

any help would be appreciated thanks.