Código PHP:
<?
$basedatos = "vertice_cuestionario";
$link = @mysql_connect("localhost","vertice_cuestion","+++++++++"); // conectar al motor de la base
if (! $link)
{
echo "<h2 align='center'>ERROR: Imposible establecer conexión con el servidor</h2>";
exit;
}
$db = mysql_list_dbs();
$num_bd = mysql_num_rows($db);
$existe = "NO" ;
for ($i=0; $i<$num_bd; $i++)
{
if (mysql_dbname($db, $i) == $basedatos)
{
$existe = "SI" ;
mysql_query("DROP DATABASE tevcol_control", $link);
echo "<h2 align='center'>La base que existia fue destruida .......<br>";
echo "vuelva a ejecutar en el script para crear la Base de Datos ... Gracias </h2>";
break;
exit;
}
}
if ($existe == "NO")
{
if (! mysql_create_db($basedatos, $link)) {
echo "<h2 align='center'>ERROR 1: Imposible crear base de datos</h2>";
exit;
}
$sql = "CREATE TABLE v_cuestionario ( ";
$sql .= "id_actual INT( 7 ) NOT NULL AUTO_INCREMENT , ";
$sql .= "p1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p4_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p4_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p4_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p4_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p4_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p4_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p4_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p4_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p4_9 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p4_10 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p8_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p8_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p8_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p8_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p8_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p8_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p8_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p8_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p9_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p9_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p9_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p9_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p9_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p9_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p9_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p9_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p9_9 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p9_10 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p10 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p11 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p12 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p13_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p13_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p13_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p13_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p13_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p13_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p13_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p13_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p14 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p15 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p16 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p17_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p17_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p17_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p17_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p17_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p17_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p17_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p17_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p17_9 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p18 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p19_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p19_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p19_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p19_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p19_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p19_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p19_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p19_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p20 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p21 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p22 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p23 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p24 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p25 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p26_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p26_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p26_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p26_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p26_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p26_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p27 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p28 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p29 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p30_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p30_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p30_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p30_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p30_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p30_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p31_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p31_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p31_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p31_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p31_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p31_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p32_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p32_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p32_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p32_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p32_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p32_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p32_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p32_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p33_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p33_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p33_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p33_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p33_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p33_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p33_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p33_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p33_9 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p33_10 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p34 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p35 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p36 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p37 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p38_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p38_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p38_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p38_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p38_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p38_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p38_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p38_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p39_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p39_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p39_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p39_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p40 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p40_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p41_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p41_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p41_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p41_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p41_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p41_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p41_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p41_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p42_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p42_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p42_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p42_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p42_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p42_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p43_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p43_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p43_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p43_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p43_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p43_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p43_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p43_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p44 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p45_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p45_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p45_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p45_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p46_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p46_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p46_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p46_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p46_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p46_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p46_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p46_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p47_1 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p47_2 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p47_3 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p47_4 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p47_5 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p47_6 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p47_7 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p47_8 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p47_9 INT( 2 ) DEFAULT '0' NOT NULL , ";
$sql .= "p48 INT( 2 ) DEFAULT '0' NOT NULL , "; //linea 211
ETC ETC.
$sql .= "p98_10 INT( 2 ) DEFAULT '0' NOT NULL , "; //linea 349
$sql .= "codigo VARCHAR( 8 ) DEFAULT '0' NOT NULL , ";
$sql .= "PRIMARY KEY ( id_actual ) ) ";
mysql_db_query($basedatos, $sql, $link);
?>