Scrigroup - Documente si articole

     

HomeDocumenteUploadResurseAlte limbi doc
AccessAdobe photoshopAlgoritmiAutocadBaze de dateCC sharp
CalculatoareCorel drawDot netExcelFox proFrontpageHardware
HtmlInternetJavaLinuxMatlabMs dosPascal
PhpPower pointRetele calculatoareSqlTutorialsWebdesignWindows
WordXml

AspAutocadCDot netExcelFox proHtmlJava
LinuxMathcadPhotoshopPhpSqlVisual studioWindowsXml

Tutorial - Updating the data already in your database

php



+ Font mai mare | - Font mai mic



Tutorial - Updating the data already in your database

Well, we can now view our information, and add new information into our database. How do we change the information already there?



<html>

<body>

<?php

$db = pg_connect('dbname=friends');

$query = 'SELECT * FROM friends';

$result = pg_exec($db, $query);

if (!$result)

$numrows = pg_numrows($result);

$row=0;

printf ('<table border=1>');

printf ('<tr><td>ID</td><td>First Name</td><td>Surname</td></tr>');

do

while ($row < $numrows);

printf ('</table><br>');

pg_close();

?>

<form action='update.php' method='post'>

ID to Update : <input type='text' name='id' size='4' length='4'

value='ID'><br>

First Name : <input type='text' name='firstname' size='40' length='40'

value='First Name'><br>

Surname to update : <input type='text' name='surname' size='40' length='40'

value='Surname'><br>

<input type='submit' name='submit' value='Update It'>

<input type='reset' name='reset' value='Clear It'>

</form>

</body>

</html>

This is our form that 'updates' the information. In this example, we're updating the first name, and the surname for

the ID that we type in. *Note, we're displaying the database as well so that we can find what we want to update easily - this

isn't normally done*.

It passes what we type in the form to the 'update' script.

This is our 'update' script -

<html>

<body>

<?php

$db = pg_connect('dbname=friends');

$query = 'UPDATE friends SET firstname='$firstname', surname='$surname' where id='$id'';

$result = pg_exec($db, $query);

if (!$result)

printf ('These values were updated in the database - %s %s %s',$id, $firstname, $surname);

pg_close();

?>

</body>

</html>

Again, we'll break this down again for understanding.

$db = pg_connect('dbname=friends');

This connects to our database, as in every script we've written so far.

$query = 'UPDATE friends SET firstname='$firstname', surname='$surname' where id='$id'';

This updates the firstname and the surname for the ID number we type in.

The syntax for the command is -

UPDATE database SET table1=value1, table2=value2, table3=value3, where tableX=valueX

So, in the database 'friends', we're setting the table names with the new information we put in. As long as we keep one

value in our table the same, and have another one to refer to, it doesn't matter how many fields are in the rest of the database,

we can update them all at once. That's why we're also using an ID field at the start. If we didn't use the ID field, we would

only be able to update either the firstname or the surname each time, not both at the same time.

$result = pg_exec($db, $query);

This updates the database with our new information.

if (!$result)

If it doesn't work, it prints 'ERROR' and exits the script so nothing else happens. This will be explained in a bit

more detail in the error section of our tutorial.

printf ('These values were updated in the database - %s %s %s',$id, $firstname, $surname);

If it works, it displays the information we entered just to make sure we got it right. Normally, we'd have it display a message

such as 'successfully updated'. For our purposes, just displaying this message is sufficient.

pg_close();

?>

</body>

</html>

We have the usual end of script, to close the database connection,

end the PHP script, and finish the HTML code.

This is a very simple example of what we can do. If we ran the script that shows all of the data in the database again, we'd see

that we've updated the firstname and the surname for the ID that we put in. The data comes in at the bottom of the list.



Politica de confidentialitate | Termeni si conditii de utilizare



DISTRIBUIE DOCUMENTUL

Comentarii


Vizualizari: 760
Importanta: rank

Comenteaza documentul:

Te rugam sa te autentifici sau sa iti faci cont pentru a putea comenta

Creaza cont nou

Termeni si conditii de utilizare | Contact
© SCRIGROUP 2024 . All rights reserved