public function create() { dbCreate($this->db)->run($this->conn); \r\db($this->db)->tableCreate('t1')->run($this->conn); \r\db($this->db)->tableCreate('t2')->run($this->conn); \r\db($this->db)->table('t1')->indexCreate('other')->run($this->conn); \r\db($this->db)->table('t2')->indexCreate('other')->run($this->conn); }
<?php dbCreate(_BBDD); function getCabecera($nombre, $desc, $showButtons, $IDcurso, $IDtema) { $OUT = ''; $OUT .= '<div class="jumbotron">'; $OUT .= '<div class="container">'; $OUT .= '<h1>' . $nombre . '</h1>'; $OUT .= '<p class="lead">' . $desc . '</p>'; if ($showButtons == 1) { $OUT .= '<div class="btn-group pull-right">'; $OUT .= '<a class="btn btn-default" href="' . _PORTALROOT . '">Volver al listado de cursos</a>'; if ($IDcurso != '') { $OUT .= '<a class="btn btn-default" href="?IDcurso=' . $IDcurso . '">Volver al curso</a>'; } if ($IDtema != '') { $OUT .= '<a class="btn btn-default" href="?IDcurso=' . $IDcurso . '&IDtema=' . $IDtema . '">Volver al tema</a>'; } $OUT .= '</div>'; } $OUT .= '</div>'; $OUT .= '</div>'; echo $OUT; }
if ($create_table) { //Connect to the MySQL database $conn = dbConnect($dbHost, $dbUser, $dbPass); //Create table (and database) dbCreate($conn); //Close the MySQL connection mysqli_close($conn); //Finish return; } else { //Process the CSV file - loading, capitalization, email validation etc $lines = csvProcessing($filename); //Connect to the MySQL database $conn = dbConnect($dbHost, $dbUser, $dbPass); //Create table (and database) dbCreate($conn); //Insert the CSV data into the table insertData($lines, $conn); //Close the MySQL connection mysqli_close($conn); //Finish return; } } } //Process the CSV file - loading, capitalization, email validation etc function csvProcessing($filename) { //Open the CSV file $file = fopen($filename, "r"); //Create an empty array to put the csv file into