<?php
//connect to MySQL
require 'config.php';
$connect = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS, SQL_DB) or die('No se puedo conectar a MySql.' . mysql_error());
function MostrarTablas2($z)
{
echo "<table border='1'>\n";
while ($rows = mysql_fetch_assoc($z)) {
echo "<tr>\n";
foreach ($rows as $value) {
echo "<td>\n";
echo $value;
echo "</td>\n";
}
echo "</tr><br>\n";
}
echo "</table>\n";
}
$s = "show create table wiley2.movie";
$results = mysql_query($s) or die(mysql_error());
MostrarTablas2($results);
$drop = "ALTER TABLE wiley2.movie \n\t\tDROP FOREIGN KEY fk_movietype_movie,\n\t\tDROP FOREIGN KEY fk_leadactor_movie,\n\t\tDROP FOREIGN KEY fk_director_movie";
mysql_query($drop) or die(mysql_error());
$s2 = "show create table wiley2.movie";
$results2 = mysql_query($s2) or die(mysql_error());
MostrarTablas2($results2);
<?php
//connect to MySQL
require 'config.php';
$connect = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS, SQL_DB) or die('No se puedo conectar a MySql.' . mysql_error());
//make sure we're using the right database
//mysql_select_db ("wiley");
$query = "SELECT *\n FROM wiley2.movie\n ORDER BY movie_id";
$results = mysql_query($query) or die(mysql_error());
$query2 = "SELECT *\n FROM wiley2.movietype\n ORDER BY movietype_id";
$results2 = mysql_query($query2) or die(mysql_error());
$query3 = "SELECT *\n FROM wiley2.people\n ORDER BY people_id";
$results3 = mysql_query($query3) or die(mysql_error());
function MostrarTablas2($z)
{
echo "<table border='1'>\n";
while ($rows = mysql_fetch_assoc($z)) {
echo "<tr>\n";
foreach ($rows as $value) {
echo "<td>\n";
echo $value;
echo "</td>\n";
}
echo "</tr><br>\n";
}
echo "</table>\n";
}
MostrarTablas2($results);
MostrarTablas2($results2);
MostrarTablas2($results3);
