« previous next »
Pages: [1]   Go Down

Author Topic: HTML Table MySQL id & Editing existing content  (Read 75 times)

ARKaMAN

  • New Member
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
HTML Table MySQL id & Editing existing content
« on: January 27, 2012, 08:55:01 PM »
Alright I have a HTML Table displaying Data from a MySQL Table.

PHP Code: [Select]
<html>
    <head>
    <title>Vipre Database</title>
    <meta http-equiv="content-type" content="text/html; charset=uf-8" />
    <style type="text/css">
        lable { display: block; }
    </style>
    <script src="sorttable.js"></script>
</head>
<body>
<a href="addclient.php">Add Client</a>
<?php

include_once 'resources/init.php';

$query="SELECT * FROM Client";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table class="sortable" border="1" cellspacing="5" cellpadding="5">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Firstname</font></th>
<th><font face="Arial, Helvetica, sans-serif">Lastname</font></th>
<th><font face="Arial, Helvetica, sans-serif">Email</font></th>
<th><font face="Arial, Helvetica, sans-serif">Invoice#</font></th>
<th><font face="Arial, Helvetica, sans-serif">Windows Key</font></th>
<th><font face="Arial, Helvetica, sans-serif">Windows Type</font></th>
<th><font face="Arial, Helvetica, sans-serif">VIPRE Type</font></th>
<th><font face="Arial, Helvetica, sans-serif">User Count</font></th>
<th><font face="Arial, Helvetica, sans-serif">Year Count</font></th>
<th><font face="Arial, Helvetica, sans-serif">Start Date</font></th>
<th><font face="Arial, Helvetica, sans-serif">Expire Date</font></th>
<th><font face="Arial, Helvetica, sans-serif">VIPRE Key</font></th>
<th><font face="Arial, Helvetica, sans-serif">Edit</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"firstname");
$f2=mysql_result($result,$i,"lastname");
$f3=mysql_result($result,$i,"email");
$f4=mysql_result($result,$i,"invoice");
$f5=mysql_result($result,$i,"wink");
$f6=mysql_result($result,$i,"wint");
$f7=mysql_result($result,$i,"vtype");
$f8=mysql_result($result,$i,"usera");
$f9=mysql_result($result,$i,"yeara");
$f10=mysql_result($result,$i,"sdate");
$f11=mysql_result($result,$i,"edate");
$f12=mysql_result($result,$i,"viprek");
$f13=mysql_result($result,$i,"id");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f8; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f9; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f10; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f11; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f12; ?></font></td>
<td><a href='addclient.php?id=id'>Edit</a></td>
</tr>

<?php
$i++;
}
?>
</body>
</html>

I want one of the columns to have a Edit Link  that will take the current tables id and then go to my edit form.
I am just starting to learn this stuff so I am guessing my code is bad or I just don't know what I am doing. XD
Logged

jSherz

  • Expert PHP Helper
  • Senior Member
  • *****
  • Posts: 403
  • Karma: +4/-0
    • View Profile
    • jSherz.com
Re: HTML Table MySQL id & Editing existing content
« Reply #1 on: January 28, 2012, 06:58:27 AM »
You have an error on the line:

PHP Code: [Select]
$num=mysql_numrows($result);

The function should be mysql_num_rows.

From a quick glance, the rest of the code should work OK, apart from the id=id part on your edit link. When you get the items from the database, you are putting the ID of the record into $f13, so you could just echo out $f13 where you need the ID:

PHP Code: [Select]
<td><a href='addclient.php?id=<?php echo $f13; ?>'>Edit</a></td>
Logged
Looking for PHP tutorials? View mine. Please use code or PHP tags in your posts.

ARKaMAN

  • New Member
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: HTML Table MySQL id & Editing existing content
« Reply #2 on: January 28, 2012, 10:44:29 AM »
Thanks for the help,  What is a good way to pass the id number to the next page?
Logged

ARKaMAN

  • New Member
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: HTML Table MySQL id & Editing existing content
« Reply #3 on: January 28, 2012, 03:31:56 PM »
Quote from: ARKaMAN on January 28, 2012, 10:44:29 AM
Thanks for the help,  What is a good way to pass the id number to the next page?

For some reason I can't find the edit button on this website, but here is my page that is suppose to change existing data.  I have firstname setup only just until I get it working.  It is still not working.  I don't know what I need to change.

PHP Code: [Select]
<?php

include 'init.php';
if (isset ($_POST['submit'])) {
    $q = "SELECT * FROM Client WHERE id = $_GET[id]";
    $result = mysql_query($q);
    $client = mysql_fetch_array($result);
    }
?>
    <a href="index.php">Back To List</a>
  
<form action="insert.php" method="post">
First Name: <input type="text" name="firstname" value="<?php echo $client['firstname']; ?>" />
Last Name: <input type="text" name="lastname" />
<br>
<br>
Email: <input type="text" name="email" />
<br>
<br>
Invoice #:<input type="text" name="invoice" maxlength="5" size="5" />
<br>
<br>
<br>
<br>
Windows Key:<input type="text" name="wink" maxlength="24" size="24" />
Windows Type:<input type="text" name="wint" maxlength="24" size="24" />
<br>
<br>
<br>
<br>
VIPRE Type:<input type="text" name="vtype" maxlength="3" size="3" />
User Count:<input type="text" name="usera" maxlength="3" size="3" />
Year Count:<input type="text" name="yeara" maxlength="3" size="3" />
<br>
<br>
Start Date:<input type="text" name="sdate" maxlength="10" size="10" />
Expire Date:<input type="text" name="edate" maxlength="10" size="10" />
<br>
<br>
VIPRE Key: <input type="text" name="viprek" maxlength="24" size="24" />
<br>
<br>
<br>
<input type="hidden" name="id" value="<?php echo $_GET['id']; ?>" />
<input type="submit" />
</form>
    
    <?php
    if(isset($_POST["submit"])) {
        $u = "UPDATE Client SET `firstname`='$_POST[firstname]' WHERE id = $_POST[id]";
        mysql_query($u) or die (mysql_error());
        
        echo "User has been modified!";
        header("Location: index.php");
        
    } else {

        
    }
    ?>
Logged
Pages: [1]   Go Up
« previous next »