PHP - Form To Edit Table Data

I'm creating a report page and can't figure out how to retrieve multiple rows from a table and display them in html. There are 5 data elements in each row and I'm thinking that using a form in the html might be the best way as I'm totally ignorant about tables in html. I'm a newbie to php and can't figure out how to accomplish this. Here's the code that I have so far:

<?php
$filename = NULL;
session_start();
// start of script every time.

//  setup a path for all of your canned php scripts
$php_scripts = '../php/'; // a folder above the web accessible tree
//  load the pdo connection module  
require $php_scripts . 'PDO_Connection_Select.php';

//*******************************
//   Begin the script here
// Connect to the database

if (!$con = PDOConnect("foxclone")):
{
    echo "Failed to connect to database" ;
    exit;
}
else:
{
    $sql = 'SELECT COUNT(IP_ADDRESS) FROM download WHERE FILENAME IS NOT NULL'; 

    $sql1 = 'Update  download t2, ip_lookup t1 set t2.country = t1.country, t2.area = t1.area, t2.city = t1.city where ((t2.IP_ADDRESS) = (t1.start_ip) OR (t2.IP_ADDRESS) > (t1.start_ip)) AND ((t2.IP_ADDRESS) = (t1.end_ip) OR (t2.IP_ADDRESS) < (t1.end_ip)) AND (t2.FILENAME is not null and t2.country is null)';

    $sql2 = 'SELECT (IP_ADDRESS, FILENAME, country, area, city) from download where FILENAME is not null';

// Update the table
    $stmt = $con->prepare($sql1);
    $stmt->execute();  

// Get count of rows to be displayed in table
    $stmt = $con->prepare($sql);
    $stmt->execute() ;
    $cnt = $stmt->fetch(PDO::FETCH_NUM);

// retrieve one row at a time
    $i = 1;
    while($i <= $cnt){
      $stmt = $con->prepare($sql2);
      $row->execute(array(''));  // Do I need an array here?
// from here on, I'm lost

    $i++;

I'd appreciate any guidance you can provide or understandable tutorials you can point me to.

Larry     

Hi there

I never had any php lessons. But I made a site, and now I'm kinda sorta working on a CMS so that someone else can edit the information on the site. Now I was wondering if there was a simple way of displaying all the data from a table, and editing it (not in phpmyadmin). This is my current method; it's rather sloppy but it works like a charm:

Code: [Select]
mysql_select_db('yourdatabase')or die(mysql_error());
$query = mysql_query("SELECT * FROM activiteit ORDER BY datum");
if(isset($_POST['editActiviteit'])){
$id = mysql_real_escape_string(htmlentities($_POST['id']));
}else{
$id = '';
}
echo "<table border='1'><tr><th>Begindatum</th><th>Einddatum</th><th>Titel</th><th>Omschrijving</th><th>Zichtbaar?</th><th>Aanpassen</th><th>Verwijderen</th><th>Voorbeeld</th></tr>";
while($row = mysql_fetch_array($query)){
if($id == $row['id']){
if(empty($row['einddatum'])){
$einddatum = "<input type='text' size='2' name='activiteitDagEind' placeholder='dd' />/<input type='text' size='2' maxlength='2' name='activiteitMaandEind' placeholder='mm' />/<input typ='text' size='4' maxlength='4' name='activiteitJaarEind' placeholder='jjjj' />";
}else{
$explode = explode('/',$row['einddatum']);
$einddatum = "<input type='text' size='2' name='activiteitDagEind' value='$explode[0]' />/<input type='text' size='2' maxlength='2' name='activiteitMaandEind' value='$explode[1]' />/<input typ='text' size='4' maxlength='4' name='activiteitJaarEind' value='$explode[2]' />";
}
$explode2 = explode('/',$row['datum']);
$datum = "<input type='text' size='2' name='activiteitDag' value='$explode2[0]' />/<input type='text' size='2' maxlength='2' name='activiteitMaand' value='$explode2[1]' />/<input typ='text' size='4' maxlength='4' name='activiteitJaar' value='$explode2[2]' />";
if($row['actief'] == 0){
$actief = "<select name='actief'><option value='1'>1</option><option value='0' selected='selected'>0</option></select>";
}else{
$actief = "<select name='actief'><option value='1' selected='selected'>1</option><option value='0'>0</option></select>";
}
echo "<form action='ward.php' method='post'>";
echo "<tr><td>$datum</td><td>$einddatum</td><td><input type='text' name='activiteitTitel' value='".$row['titel']."' /></td><td><textarea name='activiteitOmschrijving'>".$row['omschrijving']."</textarea></td><td>$actief</td><td><input type='hidden' value='".$row['id']."' name='id' /><input type='submit' value='Slaag op' name='saveActiviteit' /></form></td><td><form action='ward.php' method='post'><input type='hidden' value='".$row['id']."' name='id' /><input type='submit' name='verwijderActiviteit' value='verwijderen' /></form></td><td><input type='button' disabled='disabled' value='Voorbeeld' /></td></tr>";
}else{
echo "<tr><td>".$row['datum']."</td><td>".$row['einddatum']."</td><td>" . $row['titel'] . "</td><td>" . bbcode_format($row['omschrijving']) . "</td><td>" . $row['actief']."</td><td><form action='ward.php?fx=activiteit' method='post'><input type='hidden' value='".$row['id']."' name='id' /><input type='submit' value='Pas aan' name='editActiviteit' /></form></td><td><form action='ward.php' method='post'><input type='hidden' value='".$row['id']."' name='id' /><input type='submit' value='verwijderen' name='verwijderActiviteit' /></form></td><td><input type='button' value='Voorbeeld' onClick=\"parent.location='ward.php?fx=activiteit&voorbeeld=".$row['id']."'\" /></td></tr>";
}
}
echo "</table><br /><br />";
I just copy pasted all the code but I'll explain it in big lines:
First I open a table. I manually enter a row with the headers. Then every result of the query gets shown in a cell. The last cells of each row contain a delete and an edit button. The delete button deletes that row with the hidden id and reloads the page. When the edit button is clicked, it sends a form with the name of the button, here 'editActiviteit', and the id of the entry. And then the page gets reloaded. When the query is then done again, it checks if $_POST['editActiviteit'] is set, and if it is, it displays input fields with the values in the cells instead of pure text, and a save button instead of a edit button.

The system works just fine, but it's heaps of work every time I implement it, for activities, users, ...
Also I've been told that table's are not the correct way for displaying results (and they also get a little stretched). How should it be displayed?

Thanks in advance.

Hi,

I have a webpage that the super administrator log's into. Once the super administrator is logged in he/she can view his/her clients. The super admins clients also have their own clients, once the super admins clients login they can view their own clients details who register with them. What i am trying to do is have a link on that clients name (for the super admins clients) that will bring me to a new page where i can edit his/her details that is stored in the mysql database. I have used INPUT buttons for each clients row in a FORM which works......but i know this is not the right way to do it. This is the code i have used to display the clients with the input button:
<?php
$query = "SELECT ID FROM clients WHERE username = '$username'";
$result = mysql_query($query);
if(mysql_num_rows($result))
{
while($row = mysql_fetch_assoc($result)){
$userID = $row['ID'];
$query = "SELECT * FROM users WHERE userID = '$userID'";
$result = mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
<table border="0" cellspacing="3" cellpadding="3" width="100%">
<tr>
<th width="30%"><font face="Arial, Helvetica, sans-serif">Name</font></th>
<th><font face="Arial, Helvetica, sans-serif">Username</font></th>
<th><font face="Arial, Helvetica, sans-serif">Email Address</font></th>
<th>&nbsp;</th>
</tr>
<?php
$i=0;
while ($i < $num) {
$userID=mysql_result($result,$i,"userID");
$name=mysql_result($result,$i,"name");
$username=mysql_result($result,$i,"username");
$email=mysql_result($result,$i,"email");

?>
<tr>
<td width="30%"><?php echo $name; ?></td>
<td><?php echo $username; ?></td>
<td><?php echo $email; ?></td>
<td><form action="http://localhost/single-client.php?userID=<?php echo $userID; ?>&name=<?php echo $name; ?>" method="post" style="margin:0px;">
<input type="hidden" name="selectuser" id="selectuser" value="<?php echo $userID; ?>" /><input type="hidden" name="username1" id="username1" value="<?php echo $username; ?>" /><input type="hidden" name="name1" id="name1" value="<?php echo $name; ?>" /><input type="submit" name="submit" value="View Info" class="button" /></form></td>
</tr>
<?php
$i++;
}}}
?>
</table>

From the above code when i use the following code:
?userID=<?php echo $userID; ?>&name=<?php echo $name; ?>
It doesn't make a difference .... it just displays the correct userID and name in the link.

Once the INPUT button is clicked it will bring you to this page:
<?php
$query = "SELECT * FROM users WHERE userID = '".$_POST['selectuser']."' AND username = '".$_POST['username1']."'";
$result = mysql_query($query);
if(mysql_num_rows($result))
{
$userID = $_POST['selectuser'];
while($row = mysql_fetch_assoc($result)){
$name = $row['name'];
$userID = $row['userID'];
$email = $row['email'];
$username = $row['username'];
$registered = $row['registered'];
$last = $row['last'];
?>
<?php echo $brokerID; ?>
<table border="0" cellspacing="3" cellpadding="3" width="100%" summary="Client table">
<tr>
<td><form action="http://localhost/single-client.php?userID=<?php echo $userID; ?>&name=<?php echo $name; ?>" method="post" style="margin:0px;">
<input type="hidden" name="selectuser" id="selectuser" value="<?php echo $userID; ?>" /><input type="hidden" name="username1" id="username1" value="<?php echo $username; ?>" /><input type="hidden" name="name1" id="name1" value="<?php echo $name; ?>" /><input type="submit" name="submit" value="Income" class="button" /></form></td>
<td><form action="http://localhost/single-client.php?userID=<?php echo $userID; ?>&amp;name=<?php echo $name; ?>" method="post" style="margin:0px;">
<input type="hidden" name="selectuser" id="selectuser" value="<?php echo $userID; ?>" /><input type="hidden" name="username1" id="username1" value="<?php echo $username; ?>" /><input type="hidden" name="name1" id="name1" value="<?php echo $name; ?>" /><input type="submit" name="submit" value="Bills" class="button" /></form></td>
</tr>
</table>
<h2>Client Profile - <?php echo $_POST['name1']; ?></h2>
<table border="0" cellspacing="3" cellpadding="3" width="100%">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Name</font></th>
<th><font face="Arial, Helvetica, sans-serif">Username</font></th>
<th><font face="Arial, Helvetica, sans-serif">Email Address</font></th>
<th><font face="Arial, Helvetica, sans-serif">Registered</font></th>
<th><font face="Arial, Helvetica, sans-serif">Last</font></th>
</tr>
<tr>
<td><?php echo $name; ?></td>
<td><?php echo $username; ?></td>
<td><?php echo $email; ?></td>
<td><?php echo $registered; ?></td>
<td><?php echo $last; ?></td>
</tr>
</table>
<?php
}
}
else
{
   echo "<p>Error</p>";
}
?>

This page displays the correct user info. Is there a way to do it differently instead of using FORMS and INPUT buttons? and rather using links? Any help would be greatly appreciated.

Hi all, I am having difficulty getting my UPDATE script to work. Basically the info is being pulled from a form and then being UPDATED, but it doesn't actually update and I am presented with no errors. It finds the record correctly and displays in the fields in the form as it should, just no update!  Any ideas? Thanks in advance...

Code: [Select]
<?php
error_reporting (E_ALL ^ E_NOTICE);
$usr = "fdgdg";
    $pwd = "dgdg";
    $db = "dgdg";
    $host = "dgdg.ddg.dg.50dgdg

/***********************Get Record***********************/
$ref = (!empty($_GET['ref']))?trim($_GET['ref']):"";

# connect to database
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid){
echo("ERROR: " . mysql_error() . "\n");
}
$db_selected = mysql_select_db(database, $cid);

$query = sprintf("SELECT * FROM fleet where fleetref like '%s' LIMIT 1","%".mysql_real_escape_string($ref)."%");
$result = mysql_query($query) or die($query."<br>".mysql_error());  
$record = mysql_fetch_assoc($result);
if(mysql_num_rows($result) > 0)
{
echo "<strong>Updating fleet vehicle</strong>";
$fleetref=$record["ref"];
$fleetmake=$record["fleetmake"];
$fleetmodel=$record["fleetmodel"];
$fleetberth=$record["fleetberth"];
$fleetyear=$record["fleetyear"];
$fleetlength=$record["fleetlength"];
$fleetchassis=$record["fleetchassis"];
$fleetengine=$record["fleetengine"];
$fleetlayout=$record["fleetlayout"];
$fleettype=$record["fleettype"];
$fleetcomments=$record["fleetcomments"];
$pricelow=$record["pricelow"];
$pricemid=$record["pricemid"];
$pricehigh=$record["pricehigh"];
$fleetof=$record["fleetof"];

}else{
echo "<div id=\"pages\"><strong>Record not found</strong> - Edit Directory</div>";
$fleetmake="";
$fleetmodel="";
$fleetberth="";
$fleetyear="";
$fleetlength="";
$fleetchassis="";
$fleetengine="";
$fleetlayout="";
$fleettype="";
$fleetcomments="";
$pricelow="";
$pricemid="";
$pricehigh="";
$fleetof=$record["fleetof"];
}

if ($fleetof == $account) {
/***********************Save Record***********************/
# this is processed when the form is submitted
# back on to this page (POST METHOD)
if (isset($_POST['submit'])){
$fleetmake=$_POST["fleetmake"];
$fleetmodel=$_POST["fleetmodel"];
$fleetberth=$_POST["fleetberth"];
$fleetyear=$_POST["fleetyear"];
$fleetchassis=$_POST["fleetchassis"];
$fleetengine=$_POST["fleetengine"];
$fleetlayout=$_POST["fleetlayout"];
$fleetlength=$_POST["fleetlength"];
$fleettype=$_POST["fleettype"];
$fleetcomments=$_POST["fleetcomments"];
$pricelow=$_POST["pricelow"];
$pricemid=$_POST["pricemid"];
$pricehigh=$_POST["pricehigh"];

# setup SQL statement
$query = sprintf("UPDATE `fleet` SET `fleetmake` = '%s',`fleetmodel` = '%s',`fleetberth` = '%s',`fleetyear` = '%s',`fleetchassis` = '%s',`fleetengine` = '%s',`fleetlayout` = '%s',`fleetlength` = '%s',`fleettype` = '%s',`fleetcomments` = '%s',`pricelow` = '%s',`pricemid` = '%s',`pricehigh` = '%s' WHERE `fleetref` ='%s' LIMIT 1", mysql_real_escape_string($fleetmake),mysql_real_escape_string($fleetmodel),mysql_real_escape_string($fleetberth),mysql_real_escape_string($fleetyear),mysql_real_escape_string($fleetchassis),mysql_real_escape_string($fleetengine),mysql_real_escape_string($fleetlayout),mysql_real_escape_string($fleetlength),mysql_real_escape_string($fleettype),mysql_real_escape_string($fleetcomments),mysql_real_escape_string($pricelow),mysql_real_escape_string($pricemid),mysql_real_escape_string($pricehigh),mysql_real_escape_string($fleetref));

#execute SQL statement
$result = mysql_db_query($db,$query,$cid) or die($query."<br>".mysql_error());

# check for error
if (!$result){
echo("ERROR: " . mysql_error() . "\n$SQL\n");
}
echo "<P>Fleet vehicle updated</P>\n";
} }
else
{echo "Sorry, you are not authorised to edit this vehicle, please contact the system administrator for further help.";}
   
?>

Hey guys

So my question is related to the delete and edit functions in a table

When I am able to delete entries, I can't edit

When I am able to edit entries, I can't delete

Let me explain... Started with the table script first (excerpt):

Code: [Select]
echo "<form method = \"post\" action=\"{$_SERVER['PHP_SELF']}\">
<table>
<tr>
<td width=\"55\" class=\"formLabelsS2\"><input type=\"submit\" name=\"delete_mail\" value=\"Delete\" id=\"delete_mail\"></td>
</tr>
</table>";

echo "<table class=\"sortable\" id=\"query_quick2\" width=\"100%\" >\r\n";
echo "\t<tr><th class=\"sorttable_nosort\" ></th><th class=\"sorttable_nosort\" ></th>
<th class=\"sorttable_alpha\" >Promoter Locus</th>\r\n";


if($result->num_rows){
while ($row = $result->fetch_array()){
$RowCount ++;
$row_color = ($RowCount % 2) ? $color1 : $color2;
echo "\t<tr id=\"{$row['id']}\" class=\"$row_color\" >


<!--<form method = \"post\" action=\"{$_SERVER['PHP_SELF']}\">-->



<td><input type =\"hidden\" name = \"id\" value=\"{$row['id']}\"/></td>
<td><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\" value=\"{$row['id']} \"></td>
<td>{$row['pro']}</td>
<td><input type=\"submit\" name=\"edit_mail\" value = \"Edit\"/></td>



<!--</form>-->



</tr>";

}
}

echo "</table>";
echo "</form>";
Script for deleting entries (excerpt):

Code: [Select]
} elseif(isset($_SESSION['user_id']) AND isset($_POST['delete_mail'])){
//user is deleting existing queries
$connect=db_connect_2();

if($_POST['checkbox']){
{
foreach($_POST['checkbox'] as $check)
{
$delete = mysqli_query($connect, "DELETE FROM mailing_list WHERE id = '$check'");

}
$msgs[] = "Entry deletion was successful!";
$body = "account.php";
}


When "edit_mail" button is pressed:

Code: [Select]
} elseif(isset($_SESSION['user_id']) AND isset($_POST['edit_mail'])){
//user is editing existing queries
$body = "mailingList_edit.php";

}


A editing form is displayed based on the value of $id:

Code: [Select]
<?php
//retrieve user information
$conn=db_connect_2();
$id = mysqli_real_escape_string($conn, $_POST['id']);
$result = $conn->query("SELECT * FROM mailing_list WHERE id = '$id';");
$mail = $result->fetch_array();
?>

<div class="viewTitles" >Edit Your Queries:</div>
<form method = "post" action = "<? echo $_SERVER['PHP_SELF'] ?>">
<table>
<tr><td width="88" class="formLabelsS2" align="left">Promoter Locus:</td></tr>
<tr><td><input class = "basicTextField" type="text" name="pro_edit" value="<? echo $mail['pro']; ?>"></td></tr>

</table>
OK so what happens is:

I can delete entries with no problems by checking off the entries I want to delete then click delete button

But when I try to click "edit" button near a specific entry (individually), it DOES refer to a specific entry, but right after i SORT the table using sorttable.js, it would always refer to the LAST entry.

So I am suspecting there's problem with positioning of the <form></form> inside the while loop (see the table script, as I put lot of space in between these lines for emphasis)

Note that I put these <form> and </form> lines as comment so I could do what I mention above, otherwise I couldn't even delete any entries if I leave these 2 lines to be part of the while loop BUT !! I could edit specific entry even after I sort the table


I know this is long thread, so please let me know if you need more clarification

Thanks.

Hi all.
I built an online finance tracking thingy for myself and I got it to work using the following database table and PHP code. I didn't write the PHP code, rather, I edited it to suit my needs.
It works great for my needs. I have a way to enter records and view the last 180 records in a table. The thing is, while viewing the table, I would lke to be able to edit and delete records. I don't know enough to be able to do this.
Can it be done? I realize my PHP code would probably, for the most part, be totally different.
Thanks for any help with this.

Here is my DB table structu
Code: [Select]
DROP TABLE IF EXISTS `money`;
CREATE TABLE IF NOT EXISTS `money` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL,
`type` varchar(18) NOT NULL,
`checking` decimal(5,2) NOT NULL DEFAULT '0.00',
`cash` decimal(5,2) NOT NULL DEFAULT '0.00',
`description` varchar(25) NOT NULL,
`who` varchar(25) NOT NULL,
`note` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
And here is the PHP:
Code: [Select]
<?php


$result = mysql_query ('SELECT date, type, checking, cash, who, description, note'
        . ' FROM money'
        . ' ORDER BY date DESC LIMIT 0,180')
or die(mysql_error());  

echo "<table border='1' cellpadding='5'>";


echo "<tr><th>Date</th><th>Type</th><th>Checking</th><th>Cash</th><th>Who?</th><th>Description</th><th>Note</th></tr>";

while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['date'];
echo "</td><td>";
        echo $row['type'];
echo "</td><td>";  
echo $row['checking'];
echo "</td><td>"; 
        echo $row['cash'];
echo "</td><td>"; 
echo $row['who'];
echo "</td><td>"; 
        echo $row['description'];
        echo "</td><td>"; 
        echo $row['note'];
echo "</td></tr>";
} 

echo "</table>";
?>

This topic has been moved to Miscellaneous.

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

I made a table that gets the rows from a mysql table and lists them with the information on each row. What i need is an edit button at the end of the row so i can click it to change the data. What i want it to do is pop up a new window (child) that i can easily change the data by a text box, drop down menu, etc. and click submit to update it on the table. What i also need is a second button that will completely remove the data from that row in the table. I am still learning php and html and have no knowledge of javascript so any help would be appreciated!

This topic has been moved to Other Libraries and Frameworks.

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

hello all, i am trying to edit a mysql table from the browser using these codes:

edit.php:

      include"db.inc.php";//database connection

      $order = "SELECT * FROM prices";

      $result = mysql_query($order);

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

        echo ("<tr><td>$row[id_number]</td>");

        echo ("<td>$row[product]</td>");

        echo ("<td>$row[price]</td>");

        echo ("<td><a href=\"edit_form.php?id=$row[id_number]\">Edit</a></td></tr>");

      }

edit_form.php

      <table>

      <?

      include "db.inc.php";//database connection

      $order = "SELECT * FROM prices where id_number='$id'";

      $result = mysql_query($order);

      $row = mysql_fetch_array($result);

      ?>

      <form method="post" action="edit_data.php">

      <input type="hidden" name="id" value="<? echo "$row[id_number]"?>">

        <tr>       

          <td>Product</td>

          <td>

            <input type="text" name="product"

        size="20" value="<? echo "$row[product]"?>">

          </td>

        </tr>

        <tr>

          <td>Price</td>

          <td>

            <input type="text" name="price" size="40"

          value="<? echo "$row[price]"?>">

          </td>

        </tr>

        <tr>

          <td align="right">

            <input type="submit"

          name="submit value" value="Edit">

          </td>

        </tr>

      </form>

      </table>

edit_data.php

include "db.inc.php";

$order = "UPDATE prices SET product='$_POST[product]', price='$_POST[price]' WHERE id_number='$id'";

mysql_query($order);

header("location:edit.php");

the table:
CREATE TABLE IF NOT EXISTS `prices` (
  `id_number` int(3) NOT NULL,
  `product` varchar(30) DEFAULT NULL,
  `price` int(6) DEFAULT NULL,
  PRIMARY KEY (`id_number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

the data is displayed correctly but i can't change the data...

I have a form on our website that a user can fill out for custom product.  I want the form data to be 1) stored into a mysql database AND after storing said data, 2) email the same data to our sales department.

1)  The form data DOES get stored into mysql database (except for the first two fields, for some weird reason)

2) I added a "mail" section to the php file that stores the data into the database, but it is not working correctly.  I have stripped the email portion down to sending just one of the fields in the "message" to make it easier for troubleshooting

I have included here, both the form section of the html file, and the formdata.php file that processes the data for your  analysis.  I am relatively new to php so there are going to be some issues with security, but I can work on those after I get the store & email process to work correctly.  Please review my code and see if anyone can be of assistance.  I looked through the forums and couldn't find another issue that was the same as mine.  If I just overlooked, please tell me the thread post #.  Thanks

THE FORM WHICH COLLECTS THE DATA
*******************************
<form method=POST action=formdata.php>

                 
  <table width="640" border=0 align="center">
    <tr>
      <td align=right><b>First Name</b></td>
      <td><input type=text name=FName size=25></td>
      <td><div align="right"><b>Telephone</b></div></td>
      <td><input type=text name=Tel size=25></td>
    </tr>
    <tr>
      <td align=right><b>Last Name</b></td>
      <td><input type=text name=LName size=25></td>
      <td><div align="right"><b>Fax</b></div></td>
      <td><input type=text name=Fax size=25></td>
    </tr>
    <tr>
      <td align=right><b>Title</b></td>
      <td><input type=text name=Title size=25></td>
      <td><div align="right"><b>Email</b></div></td>
      <td><input type=text name=Email size=50></td>
    </tr>
    <tr>
      <td align=right><b>Company</b></td>
      <td><input type=text name=Comp size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Address</b></td>
      <td><input type=text name=Addr size=25></td>
      <td><div align="right"><b>Estimated Annual Volume</b></div></td>
      <td><input type=text name=EAV size=25></td>
    </tr>
    <tr>
      <td align=right><b>City</b></td>
      <td><input type=text name=City size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>State/Province</b></td>
      <td><input type=text name=SProv size=25></td>
      <td><div align="right"><b>Application</b></div></td>
      <td><input type=text name=Appl size=25></td>
    </tr>
    <tr>
      <td align=right><b>Country</b></td>
      <td><input type=text name=Ctry size=25></td>
      <td><div align="right"><b>Type of System</b></div></td>
      <td><input type=text name=Syst size=25></td>
    </tr>
    <tr>
      <td align=right><b>Zip/Postal Code</b></td>
      <td><input type=text name=ZPC size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td><div align="right"><strong><font color="#FFFF00" face="Arial, Helvetica, sans-serif">COIL
          DESIGN</font></strong></div></td>
      <td><font color="#FFFF00" face="Arial, Helvetica, sans-serif"><strong>PARAMETERS</strong></font></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Primary Resistance (ohms)</b></td>
      <td><input type=text name=Pres size=25></td>
      <td><div align="right"><b>Primary Inductance (mH)</b></div></td>
      <td><input type=text name=Pind size=25></td>
    </tr>
    <tr>
      <td align=right><b>Secondary Resistance (ohms)</b></td>
      <td><input type=text name=Sres size=25></td>
      <td><div align="right"><b>Secondary Inductance (H)</b></div></td>
      <td><input type=text name=Sind size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Peak Operating Current (Amps)</b></td>
      <td><input type=text name=POC size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Output Energy (mJ)</b></td>
      <td><input type=text name=Egy size=25></td>
      <td><div align="right"><b>Output Voltage (kV)</b></div></td>
      <td><input type=text name=Volt size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b># HV Towers per Coil</b></td>
      <td><input type=text name=TPC size=25></td>
      <td><div align="right"><b># of Coils per Package</b></div></td>
      <td><input type=text name=CPP size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th colspan=4><b>Please enter any additional information he </b></th>
    </tr>
    <tr>
      <th colspan=4><textarea name=Mess cols=50 rows=10 id="Message"></textarea></th>
    </tr>
  </table>
  </dl>
  <div align="center">
    <p>
      <input type=hidden name=BodyTag value="&lt;body  bgcolor=&quot;#484589&quot; text=&quot;#FFFFFF&quot; link=&quot;#FFFF00&quot; alink=&quot;#FFFFFF&quot; vlink=&quot;#FF7F00&quot;&gt;">
      <input type=hidden name=FA value=SendMail>
    </p>
    <p><font color="#FFFF00" face="Arial, Helvetica, sans-serif"><strong>PLEASE MAKE SURE ALL
      INFORMATION<br>
      IS CORRECT BEFORE SUBMITTING</strong></font></p>
    <p>
      <input type=submit value="Submit Form">
    </p>
  </div>
</form>
THE FILE THAT PROCESSES THE FORM DATA (formdata.php)
***********************************************
<?php
$con = mysql_connect("localhost","XXX","XXX");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("customform", $con);

$sql="INSERT INTO formdata (Fname, Lname, Title, Comp, Addr, City, SProv, Ctry, ZPC, Tel, Fax, Email, EAV, Appl, Syst, Pres, Pind, Sres, Sind, POC, Egy, Volt, TPC, CPP, Mess)
VALUES ('$_POST[Fname]','$_POST[Lname]','$_POST[Title]','$_POST[Comp]','$_POST[Addr]','$_POST[City]','$_POST[SProv]','$_POST[Ctry]','$_POST[ZPC]','$_POST[Tel]','$_POST[Fax]','$_POST[Email]','$_POST[EAV]','$_POST[Appl]','$_POST[Syst]','$_POST[Pres]','$_POST[Pind]','$_POST[Sres]','$_POST[Sind]','$_POST[POC]','$_POST[Egy]','$_POST[Volt]','$_POST[TPC]','$_POST[CPP]','$_POST[Mess]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Your Information Was Successfully Posted";

mysql_close($con);

$to = "recipient email address here"; 
$subject = "Custom Form"; 
$email = $_POST['Email'] ; 
$message = $_POST['Comp'] ; 
$headers = "From: $Email"; 
$sent = mail($to, $subject, $message, $headers) ; 
if($sent) 
{print "Your mail was sent successfully"; }
else 
{print "We encountered an error sending your mail"; }
?>

I HAVE TRIED looking at it  but i am new to php so i can't figure out what i did wrong  help please !!!!!!!!!!!!




Fatal error: Call to undefined method modernCMS::update_form() in C:\wamp\www\test\inc\update-content.php on line 4

----
Page that's accessing code
-----
<?php

include '../test/inc/admin/nav.php';
echo $obj->update_form($_GET['id']);

?>

------
function
------

<?php

class modernCMS {

var $host;
var $username;
var $password;
var $db;

function connect() {
$con = mysql_connect($this->host, $this->username, $this->password) or die(mysql_error());
mysql_select_db($this->db, $con) or die(mysql_error());

} //end connect

function get_content($id = '') {

if($id != ""):
$id = mysql_real_escape_string($id);
$sql = "SELECT * FROM cms_content WHERE id = '$id'";

// $return = "<p><a href=../test/inc/admin/nav.php>Go Back To Content</a></p>";

else:
$sql = "SELECT * FROM cms_content ORDER BY id DESC";
endif;

$res = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($res) != 0):
while($row = mysql_fetch_assoc($res)) {
echo '<table bgcolor="#975627" width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td height="25" background="images/menu.gif"><center><strong>' . $row['title'] . '</strong></center></td>

</tr>
<tr bgcolor="975627"><td height="0"></td></tr>

<tr>
<td bgcolor="#181818">
';
echo '<br>
<div align="center">' . $row['body'] . ' <br><br>
</td>

</tr>

<tr>
<td height="25" background="images/menu.gif">
</td>

</tr>

</table><br><br>
';
}
else:
echo '<p>Uh Oh!!! </p>';
endif;

// echo $return;


} //end get_content

function add_content($p) {
$title = mysql_real_escape_string($p['title']);
$body = mysql_real_escape_string($p['body']);

if(!$title || !$body):

if(!$title):
echo "<p>The title is required!</p>";
endif;
if(!$body):
echo "<p>The body is required!</p>";
endif;

echo '<p><a href="add-content.php">Try Again!!!</a></p>';

else:
$sql = "INSERT INTO cms_content VALUES (null, '$title', '$body')";
$res = mysql_query($sql) or die(mysql_error());
echo "Added Successfully!";
endif;
} //end add_content

function manage_content() {
$sql = "SELECT * FROM cms_content ORDER BY id DESC";
$res = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($res)):

?>

<div>
<h2 class="title"><?php echo $row['title']; ?></h2>
<span class="actions"<a href="../test/update-content.php?id=<?php echo $row['id']?>">Edit</a> | <a href="?delete=

<?php

echo $row['id']

?>

">Delete</a></span>
</div>

<?php
endwhile;
echo '</div>'; //Class Manage Div

} //end manage_content

function delete_content($id) {
if(!$id) {
return false;
}else {
$id = mysql_real_escape_string($id);
$sql = "DELETE FROM cms_content WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
echo "Content Deleted Successfully!";
}
}
} //end delete_content

function update_form($id) {
$id = mysql_real_escape_string($id);
$sql = "SELECT * FROM cms_content WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($res);

?>

<form method="post" action="./post-added.php">

<input type="hidden" name="update" value="true" />
<input type="hidden" name="id" value="<?php $row['id'] ?>" />

<div>
<label for="title">Title:</label>
<input type="text" name="title" id="title" value="<?php echo $row['title'] ?>" />
</div>

<div>
<label for="body">Body:</label>
<textarea name="body" id="body" rows="8" cols="40" /><?php echo $row['body'] ?></textarea>
</div>

<input type="submit" name="submit" value="Update Content" />

</form>
<?php

} //end update_content_form

function update_content($p) {
$title = mysql_real_escape_string($p['title']);
$body = mysql_real_escape_string($p['body']);
$id = mysql_real_escape_string($p['id']);

if(!$title || !$body):

if(!$title):
echo "<p>The title is required!</p>";
endif;
if(!$body):
echo "<p>The body is required!</p>";
endif;

echo '<p><a href="update-content.php?id=' . $id . '">Try Again!!!</a></p>';

else:
$sql = "UPDATE cms_content SET title = '$title', body = '$body' WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
echo "Updated Successfully!";
endif;
} //end update_content($p)



?>

Hello Freaks,

I am currently working on a status report web application.  A user inputs what they are planning on accomplishing that week.  Afterwords realizes that they made a mistake and need to correct it.  The way I want to go about this is sql the database and return * where the username and report date are current.

With the results of this query I insert them into the form as the value.  This yields a populated form.  From here I want the user to be able to change any line and submit the whole form.  However, the post array is only populated with one row of data.  I thought this might have to do with the names of the inputs all being the same so i tried to index those through the while loop with no luck.

Any help would be appreciated!

here's the code


Code: [Select]
<?
// renaming sess var
$UAID = $_SESSION['UAID'];
$WEND = $_SESSION['WEEK_ENDING2'];

//have we submitted our changes?
if($EDIT == TRUE){

//how many task are there this week
$results = mysql_query("Select COUNT(UAID) FROM `WPFTW` where UAID ='$UAID' and Rend = '$WEND'");
$row = mysql_fetch_row($results);

//clean $_POST
print_r($_POST);
unset($_POST['Report']);
echo "<br>";
print_r($_POST);

}
//what do we plan on editing
$results = mysql_query("Select * FROM `WPFTW` where UAID ='$UAID' and Rend = '$WEND'");

//while there are results
while($row = mysql_fetch_array($results)){

//increment for input name
$k = 1;

//date formatting
list($year,$month,$day) = explode("-",$row['Target']);
$row['Target'] = $month."-".$day."-".$year;

//empty string to uncheck checkboxes
$checked = "";

//populate checkboxes
if($row['MS'] == "on"){
$checked = "yes";
}

//select the correct drop down menu option
if(isset($row['Status'])){
        if($row['Status'] == " "){
        $selected = "selected";
        $selected1 = "";
        $selected2 = "";
        $selected3 = "";
        }

        elseif($row['Status'] == "P"){

        $selected = "";
        $selected1 = "selected";
        $selected2 = "";
        $selected3 = "";
        }

        elseif($row['Status'] == "C"){

        $selected = "";
        $selected1 = "";
  $selected2 = "selected";
        $selected3 = "";
        }

        elseif($row['Status'] == "CL"){

        $selected = "";
        $selected1 = "";
        $selected2 = "";
        $selected3 = "selected";
        }
}

//select the correct drop down menu option
if(isset($row['OT'])){
        if($row['OT'] == "Y"){
        $selected4 = "selected";
        $selected5 = "";
        }

        elseif($row['OT'] == "N"){

        $selected4 = "";
        $selected5 = "selected";
        }
}

//var to send form to self
$cani = htmlentities($_SERVER['PHP_SELF']);

//concatenate html & php for form
$test =  "<form id =\"2bigform\" action=$cani method = \"post\">" . "<tr>" .
        "<td><input id=\"hidden\" name=\"UAID$k\" type=\"hidden\" value=" . $_SESSION['UAID'] ."></td>".
        "<td width=\"7%\"> <input id=\"SR\#$k\" name=\"SR#\" type=\"text\" size=\"10%\" maxlength=\"10\" value=" . $row['SRNUM'] . "></td>" .
        "<td width=\"63%\"> <input id=\"Task$k\" name=\"Task\" type=\"textarea\" size=\"63%\"  value=" . $row['Task'] . "></td>" .
        "<td width=\"7%\"> <select id=\"Status$k\" name=\"Status\">".
                                                        " <option value=\" \" $selected></option>".
                                                        " <option value=\"P\" $selected1>P</option>".
                                                        " <option value=\"C\" $selected2>C</option>".
                                                        " <option value=\"CL\" $selected3>CL</option>".
                                                        "</select></td>".

        "<td width=\"7%\"> <input id=\"MS$k\" name=\"MS\" type=\"checkbox\" size=\"7%\"  value=" . $row['MS'] . " checked = $checked></td>".
        "<td width=\"7%\"> <select id=\"OT$k\" name=\"OT\">".
                                                        " <option value=\"Y\" $selected4>Y</option>".
                                                        " <option value=\"N\" $selected5>N</option>".
                                                        "</select></td>".

     "<td width=\"9%\"> <input id=\"Target$k\" name=\"Target\" type=\"text\" size=\"9%\"  value=" . $row['Target'] . "></td>".
        "<input id=\"hidden\" name=\"RDate$k\" type=\"hidden\" value=" . $_SESSION['WEEK_ENDING'] ."></td></tr>";
echo $test;
$k++;
echo $k;
}
echo "</table>".
     "<input id=\"Sub\" type= \"Submit\" name=\"Report\" value= \"Submit\"/>".
     "</form>".
     "</body>".
     "</html>";

//<td width="7%"> <input id="SR#" name="SR#" type="text" size="10%" maxlength="10"/></td>
//<td width="63%"> <input id="Task" name="Task"  type="textarea" size= "63%"/></td>






}
?>

hi,

I would like to know how do i modify this code if i Have more than 1 option in my dropdown list. Can someone help..Thankz


<select name="mediaList" id="mediaList">
  <option <?php echo ($rows['media_type'] =='Physical Only')?'selected="Selected"':'';?> >Physical Only</option>
</select>

Hello, freaks. I need a little help with the best way to go about this. I have a field in mysql that contains a comma separated string of values. What I need to do is get those values out of the db and list them into editable text fields so the user can update the values in a html form. So far this is my code, I left out all the in betweens - validation, results, etc - for this post...but its there .

SELECT servs FROM services WHERE id = $a_id

$services = $row['servs'];
$srvs = explode(',', $services);

Then for the form:

<?php
foreach ($srvs as $service) { 
?>

<input type="text" name="servs[]" value="<?php echo $service  ?>" />

  <?php } ?>

This gives me a text field for each value of servs, great! But the problem is, the user can enter up to 15 servs. Some currently have less than that saved in the db. I want to give them the ability to 1. edit any of the current servs value and 2. add more values if they have less than 15.

My question is, how do I echo out 15 editable text fields for servs[] no matter the number of values they currently have? And when I go to implode the values, will blank text fields screw everything up?

I can't find anything in the forums that relate to this. I believe it probably will involve $i, but I am not too familiar with counting in php yet, so I could really use some help. Thanks!

Oh - and I am not stuck on using text fields, but I couldn't figure how to make this work using a select list or checkboxes. Any suggestions either way would help.