UNIDAD 8 Bases de Datos

Programacin II Unidad 8 Bases de Datos - Pgina N: 194

Escuela Superior de Comercio N 49 Cap. Gral. Justo Jos de Urquiza Carrera Analista de Sistemas de Computacin Nivel Superior

Abrir una conexin

Abrir una base de datos

Ejecutar un Update

MySQL Query in PHP



if ($result){ print "Query successful!"; } else{ die("Query failed.". mysql_error()); } print "Closing the connection"; mysql_close( $link );

?>

Recuperar registros

MySQL Fetch a Row



Cantidad de registros

Mostrar registros en tablas de HTML

Galera de Arte



contact_us.php

Request for contact



admin_art_edit.php



"VALUES ('$name', '$email', '$phone', '$bio')"; mysql_connect("localhost", "root", "password") or die(mysql_error());

mysql_select_db("test") or die(mysql_error()); mysql_query( $sql ) or die(mysql_error()); $status = "SUCCESSFULLY inserted $name"; } }

?>

Artist Insert Screen



$sql = "UPDATE Artist SET name='$name', " . "email='$email', phone='$phone', bio='$bio'" . "WHERE id='$id'";

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

$status = "SUCCESSFULLY updated $name"; } } else {

$sql = "SELECT * from Artist WHERE id='$id'"; $resultset = mysql_query( $sql ) or die(mysql_error()); $row = mysql_fetch_assoc( $resultset ); extract( $row ); } ?>

Artist Update Screen



$sql = "SELECT * from Artist WHERE id='$id'"; $resultset = mysql_query( $sql ) or die(mysql_error()); $row = mysql_fetch_assoc( $resultset ); extract( $row );

?>

Email

admin_header.php



header( "Location: admin_login.php" ); exit(); } ?> Art Gallery Administration Art Gallery Administration [HOME]

[Artist List] [New Artist] [Art List] [New Art]

footer.php

1200 9th Ave, San Francisco www.TheCanvasGallery.com Phone (415)504-0060

index.php



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

function art_for_artist( $artist_id ) { $sql = "SELECT * FROM Art WHERE artist_id='$artist_id' LIMIT 1;"; $recordset = mysql_query( $sql ) or die(mysql_error()); $recordset = mysql_query( $sql ) or die(mysql_error()); $row = mysql_fetch_assoc( $recordset); return $row['image']; }

?>

Welcome To The Canvas Gallery

Welcome to The Canvas Gallery. Please choose an artist from the list below to view the details.

admin_login.php



?> Art Gallery Administration Art Gallery Administration Please Login (Use 'admin' and 'guess' for login and password)

Login: Password:

header.php

The Canvas Gallery, San Francisco Art Gallery, Music Club, Bar, and Restaurant, Open Mic, Poetry, Film

[HOME] [Contact Us] [Administration]



admin_art_list.php

Art List

ArtArtistPrice

admin_footer.php

admin_artist_list.php



extract($_REQUEST); if( isset($action) && $action="delete" ) { $sql = "DELETE FROM Artist WHERE id='$id'"; mysql_query( $sql ) or die(mysql_error()); }

$sql = "SELECT * FROM Artist ORDER BY name"; $recordset = mysql_query( $sql ) or die(mysql_error());

?>

Artist List

ArtistPhoneEmailAction

contact.php

Contact Us



Please fill our your contact information and we will contact you within 24 hours.

Name Phone Email Message

Empleados

Ej. Emp_Add_Row.html

Formulario de Ingreso de Empleados

Introduzca los datos del empleado Cdigo



Nombre Puesto Jefe Fecha Ing. Sueldo Comisin Departamento



Ej. Emp_Add_Row.php



Alta de Empleados



echo " "; echo " "; echo " "; echo " Sueldo"; echo " "; echo " ".$Sal. ""; echo " "; echo " "; echo " "; echo " Comisin"; echo " "; echo " ".$Comm. ""; echo " "; echo " "; echo " "; echo " Departamento"; echo " "; echo " ".$Deptno. ""; echo " "; echo ""; ?>



Ej. Emp_db_browser.php

Explorador de registros de Empleados



$nro_registros = mysql_num_rows($resultadosql); print "Su consulta devuelve $nro_registros registros \n";

echo ""; echo " "; for ($i=0; $i < mysql_num_fields($resultadosql); $i++) { $longitud = mysql_field_len($resultadosql, $i); echo " ".

mysql_field_name($resultadosql,$i) ."\n"; } echo " Accin\n"; echo " \n";

while ($fila=mysql_fetch_array($resultadosql)) { echo " \n"; echo " ".$fila["EMPNO"]."\n"; echo " ".$fila["ENAME"]."\n"; echo " ".$fila["JOB"]."\n"; echo " ".$fila["MGR"]."\n"; echo " ".$fila["HIREDATE"]."\n"; echo " ".$fila["SAL"]."\n"; echo " ".$fila["COMM"]."\n"; echo " ".$fila["DEPTNO"]."\n";

echo Editar\n";

echo " \n"; } echo "\n";

mysql_close( $con );

?>



Ej. Emp_display.php

Formulario de actualizacin de empleados



$resultadosql = mysql_query($consultasql);

if($row=mysql_fetch_array($resultadosql)) { echo " "; echo " Cdigo "; echo " ". $row["EMPNO"] . " "; echo " "; echo ""; echo " "; echo " Nombre "; echo " "; echo " "; echo " "; echo ""; echo " "; echo " Puesto "; echo " "; echo " "; echo " "; echo ""; echo " "; echo " Jefe "; echo " "; echo " "; echo " "; echo ""; echo " "; echo " Fecha Ing "; echo " "; echo " "; echo " "; echo ""; echo " "; echo " Sueldo "; echo " "; echo " "; echo " "; echo ""; echo " "; echo " Comisin "; echo " ";



echo " "; echo " "; echo ""; echo " "; echo " Departamento "; echo " "; echo " "; echo " "; echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo ""; } ?>



Ej. Emp_changes.php

Modificacin de Empleados



", hiredate=\"". $Hiredate . "\", sal=" . $Sal . ", comm=" . $Comm . ", deptno=" . $Deptno . " where empno=".$Empno;

echo $consultasql . "\n"; $result = mysql_query($consultasql) or die("No es posible realizar la consulta SQL");

echo "El registro se ha actualizado con xito.";

?>



conectar.php

listado.php



for ($i=0;$i



alta.html Numero: Nombre: Localidad:



alta.php



?>

modificar.html



Numero:

modificar.php



modificar2.php



baja.html



Numero:



baja.php

UNIDAD 8 Bases de Datos

Documents

Transcript of UNIDAD 8 Bases de Datos