Uncaught Error: Call to undefined function mysql_connect () [duplicate]

Question

Uncaught Error: Call to undefined function mysql_connect () [duplicate]

Navigation

#1 by (0 votes)

0

Uncaught Error: Call to undefined function mysql_connect ()

the code looks like this:

html:

<label>Nome</label><br />
    <input type="text" name="nome" /><br />
<label>Idade</label><br />
    <input type="number" name="idade" /><br />
<label>Telefone</label><br />
    <input type="text" name="telefone" /><br />
<p>
    <input type="submit" value="Cadastrar" />
</p>

connection.php

$con = mysql_connect("localhost", "root", ""); $db = 
mysql_select_db("videoaula", $con);

if(!$con) {     die("Não foi possível conectar ao banco de dados; " . mysql_error()); }

mysql_query("SET NAMES 'utf-8'"); mysql_query('SET character_set_connecton=utf-8'); mysql_query('SET character_set_client=utf-8'); mysql_query('SET character_set_results=utf-8');

recib.php:

require_once("connection/conexao.php");


$nome = $_POST["nome"];
$idade = $_POST["idade"];
$telefone = $_POST["telefone"];


$sql = "INSERT INTO 'clientes' ('nome', 'idade', 'telefone') VALUES ('$nome', '$idade', '$telefone')";

if(!$sql) {
    echo("Houve um erro na inserção do banco de dados");
        } else 
    {
        echo("Dados inseridos com sucesso");
    }

thank you from ja

php mysql html

asked by anonymous 20.08.2017 / 16:48

1 answer

Related posts by categories son Input of numbers on the same line in python [closed]

score 0 · Accepted Answer

The mysql_connect() function was deprecated in PHP 5.5.0 and mysql_ * functions were removed in PHP7!

PHP offers the mysqli and PDO APIs to connect to a MySQL server.

With MySQLi the connection can be made as follows:

$servername = "localhost";
$username = "USUARIO";
$password = "SENHA";
$dbname = "videoaula";

$con = new mysqli($servername, $username, $password, $dbname);

if (!$con) {
    die("Não foi possível conectar ao banco de dados" . mysqli_connect_error());
}

And you have to change too:

$sql = "INSERT INTO 'clientes' ('nome', 'idade', 'telefone') VALUES ('$nome', '$idade', '$telefone')";

$result = mysqli_query($con,$sql);

mysqli_query("SET NAMES 'utf-8'"); 
mysqli_query('SET character_set_connecton=utf-8'); 
mysqli_query('SET character_set_client=utf-8'); 
mysqli_query('SET character_set_results=utf-8');