editing MYSQL database through PHP page

mike2fast · April 8, 2011

Hi guys,

just wondering if someone can help me i am currently trying to edit a MYSQL database through PHP and just wondering if you could take a look at the code i have and tell me where i have gone wrong. I have tried to use a tutorial but have got lost and need some help. This is for my final year project for University and really needs to be done soon so i would be really greatful if someone could help me out.

Thanks

code below:

<!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 content="text/html; charset=utf-8" http-equiv="Content-Type" />
<link rel="stylesheet" type="text/css" href="style.css"/>

<title>Database Editor</title>

</head>

<body>

<div id="page">

<img src="images/banner1.jpg" alt="banner"/>

<div id="navi-container">
<ul id="navi">
<li><a href="index.php">Home</a></li>
<li><a href="news.php">News</a></li>
<li><a href="latest_products.php">Latest Products</a></li>
<li><a href="gallery.php">Gallery</a></li>
<li><a href="Admin_page.php">Administration</a></li>
</ul>
</div>

<?php  ?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
    <h1>Database Editor</h1>
    <table class="inputtable">
        <tr>
            <td class="label">Item Name:</td>
            <td class="inputtd">
                <input name="Item_Name" type="text" class="standardwidth" /></td>
        </tr>
        <tr>
            <td class="label"> Item Image:</td>
            <td class="inputtd">
                <input name="Item_Image" type="text" class="standardwidth" /></td>
        </tr>
        <tr>
            <td class="label">Item Description:</td>
            <td class="inputtd">
                <input name="Item_Description" type="text" class="standardwidth" /></td>
        </tr>
        <tr>
            <td class="label">Item Number:</td>
            <td class="inputtd">
                <input name="Item_Number" type="text" class="standardwidth" /></td>
        </tr>
    </table>
    <br />
    <table class="radbuttons">
        <tr>
            <td class="standardwidth">
                <input name="op" type="radio" checked="checked" value="rdbase" />
                Read from Database</td>
            <td><input name="op" type="radio" value="cdbase" />Change Entry
		(enter data in form)</td>
        </tr>
        <tr>
            <td class="standardwidth">
                <input name="op" type="radio" value="adbase" />Add to Database</td>
            <td><input name="op" type="radio" value="ddbase" />Delete Entry
		(enter name in form)</td>
        </tr>
    </table>
    <br />
    <input name="submit" type="submit" value="submit" />
    <input name="reset" type="reset" value="reset" />
    <br />
</form>

<?php if (count($view->peopleList) > 0) {
?>
    <table class="datatable">
        <tr>
            <th><strong>Surname</strong></th>
            <th><strong>First Name </strong></th>
            <th class="standardwidth"><strong>Address </strong></th>
            <th><strong>Phone</strong></th>
        </tr>
    <?php foreach ($view->peopleList as $person) : ?>
        <tr>
            <td>
            <?php echo $person->getSurname(); ?>
        </td>
        <td>
            <?php echo $person->getFirstname(); ?>
        </td>
        <td>
            <?php echo $person->getAddress(); ?>
        </td>
        <td>
            <?php echo $person->getPhone(); ?>
        </td>
    </tr>
    <?php endforeach;
        } ?>
    </table>
<?php  ?>

<?php

$dbc = mysql_connect ('****','***','salford*****') OR
die('Could not connect to MySQL : ' . mysql_error() );
mysql_select_db ('****') OR die('Could not select the database : ' . mysql_error() );

$query = "SELECT * FROM ****** ORDER BY Item_Number";
$result = mysql_query ($query);

?>
<body>
  <h1>Database</h1>

  <table border="1">
    <tbody>
      <tr>
        <td>Item Name</td>
        <td>Item Image</td>
        <td>Item Description</td>
        <td>Item Number</td>
      </tr>

      <?php

while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
echo "
<tr>
  <td>$row[item_Name]</td>
  <td>$row[item_Image]</td>
  <td>$row[item_Description]</td>
  <td>$row[item_Number]</td>
</tr>
";
}
mysql_close();

?>



        $sql = 'INSERT INTO murrayfp10_ipad (Item_Name, Item_Description, Item_Number)
        VALUES (:Item_Name, :Item_Description, :Item_Number)';
        $result = $this->dbh->prepare($sql);
        $result->execute(array(
            ':Item_Name' => $data['Item_Name'],
            ':Item_Description' => $data['Item_Description'],
            ':Item_Number' => $data['Item_Number']
        ));

        return $this->dbh->lastInsertId();
    }

    public function edittbl($data) {
        $sql = 'UPDATE murrayfp10_ipad
        SET Item_Name = :Item_Name,
        Item_Description = :Item_Description,
        Item_Number = :Item_Number
        WHERE Item_Name = :Item_Name';

        $result = $this->dbh->prepare($sql);
        return $result->execute(array(
            ':Item_Name' => $data['Item_Name'],
            ':Item_Description' => $data['Item_Description'],
            ':Item_Number' => $data['Item_Number'],
            ':Item_Number' => $data['Item_Number']
        ));
    }

    public function deletetbl($data) {
        $sql = 'DELETE FROM murrayfp10_ipad
        WHERE Item_Name = :Item_Name';
        $result = $this->dbh->prepare($sql);
        return $result->execute(array(
            ':Item_Name' => $data['Item_Name']
        ));
    }
        
    

<div style="text-align:center;">
Copyright © M.Murray 2011

</div>

</body>

</html>

kartul · April 8, 2011

With what you need help with?

Some error, warning, something not showing up?

dcro2 · April 8, 2011

All of this:

        $sql = 'INSERT INTO murrayfp10_ipad (Item_Name, Item_Description, Item_Number)
        VALUES (:Item_Name, :Item_Description, :Item_Number)';
        $result = $this->dbh->prepare($sql);
        $result->execute(array(
            ':Item_Name' => $data['Item_Name'],
            ':Item_Description' => $data['Item_Description'],
            ':Item_Number' => $data['Item_Number']
        ));

        return $this->dbh->lastInsertId();
    }

    public function edittbl($data) {
        $sql = 'UPDATE murrayfp10_ipad
        SET Item_Name = :Item_Name,
        Item_Description = :Item_Description,
        Item_Number = :Item_Number
        WHERE Item_Name = :Item_Name';

        $result = $this->dbh->prepare($sql);
        return $result->execute(array(
            ':Item_Name' => $data['Item_Name'],
            ':Item_Description' => $data['Item_Description'],
            ':Item_Number' => $data['Item_Number'],
            ':Item_Number' => $data['Item_Number']
        ));
    }

    public function deletetbl($data) {
        $sql = 'DELETE FROM murrayfp10_ipad
        WHERE Item_Name = :Item_Name';
        $result = $this->dbh->prepare($sql);
        return $result->execute(array(
            ':Item_Name' => $data['Item_Name']
        ));
    }

is outside <?php ?>, for starters...

mike2fast · April 9, 2011

Hi,

When i put it in PHP tags it just wont edit any of the data.

Any ideas?

Sign In

editing MYSQL database through PHP page

Recommended Posts

mike2fast

Link to comment

Share on other sites

kartul

Link to comment

Share on other sites

dcro2

Link to comment

Share on other sites

mike2fast

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information