Jump to content

editing MYSQL database through PHP page

mike2fast

By mike2fast
in PHP Coding Help

 Share

Recommended Posts

mike2fast Newbie

mike2fast

Posted
Posted

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>

Link to comment
https://forums.phpfreaks.com/topic/233119-editing-mysql-database-through-php-page/
Share on other sites
dcro2 Newbie

dcro2

Posted
Posted

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...

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.