html - PHP doesn't connect with MySQL -


this code supposed information simple html form , post in mysql database:

<html>    <head>  <title>cadastro de cinema</title>  <head>    <body>  <?php  $host = "localhost";  $user = "root";  $pass = "";  $banco = "cinema";  $con = @mysqli_connect($host, $user, $pass, $db) or die(mysql_error());    ?>    <?php    $email= isset($_post['email']) ? $_post['email'] : '';  $senha= isset($_post['senha']) ? $_post['senha'] : '';  $nome= isset($_post['nome']) ? $_post['nome'] : '';  $rua= isset($_post['rua']) ? $_post['rua'] : '';  $bairro= isset($_post['bairro']) ? $_post['bairro'] : '';  $numero= isset($_post['numero']) ? $_post['numero'] : '';  $cidade= isset($_post['cidade']) ? $_post['cidade'] : '';  $sql = mysqli_query($con, "insert cinema(email, senha, nome, rua, bairro, numero, cidade)  values ('$email', '$senha', '$nome', '$rua', '$bairro', '$numero', '$cidade')");    echo "ok";  ?>  </body>    </html>

when test it, "ok" echo, info not in mysql database. be?

it better if submit database here. so, can check if table/data type supported query or not. please try this:

<html>  <head> <title>cadastro de cinema</title> <head>  <body> <?php $host = "localhost"; $user = "root"; $pass = ""; $banco = "cinema"; $con = @mysqli_connect($host, $user, $pass, $banco) or die("could not connect database. " . mysqli_connect_error()); ?>  <?php  $email= isset($_post['email']) ? $_post['email'] : ''; $senha= isset($_post['senha']) ? $_post['senha'] : ''; $nome= isset($_post['nome']) ? $_post['nome'] : ''; $rua= isset($_post['rua']) ? $_post['rua'] : ''; $bairro= isset($_post['bairro']) ? $_post['bairro'] : ''; $numero= isset($_post['numero']) ? $_post['numero'] : ''; $cidade= isset($_post['cidade']) ? $_post['cidade'] : ''; $sql = mysqli_query($con, "insert cinema(email, senha, nome, rua, bairro, numero, cidade) values ('$email', '$senha', '$nome', '$rua', '$bairro', '$numero', '$cidade')");  echo "ok"; ?> </body>  </html>

simple database table used:

create table `cinema` (   `email` varchar(50) not null,   `senha` varchar(50) not null,   `nome` varchar(50) not null,   `rua` varchar(50) not null,   `bairro` varchar(50) not null,   `numero` varchar(50) not null,   `cidade` varchar(50) not null ) engine=innodb default charset=latin1;

thank you


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more