Skip to content

Instantly share code, notes, and snippets.

@cassiompf

cassiompf/connect_mysql.php

Last active September 3, 2019 15:10
Show Gist options
  • Save cassiompf/41348d71b457c5b33f932498314df17d to your computer and use it in GitHub Desktop.
Save cassiompf/41348d71b457c5b33f932498314df17d to your computer and use it in GitHub Desktop.
Download ZIP
Sample connection and input data in mysql using Php
Raw
connect_mysql.php
<?php
$host = "localhost";
$user = "root";
$senha = "";
$db = "database";
$conexao = mysqli_connect($host, $user, $senha, $db);
$sql = "insert into produto (nome, descricao, preco) values (?, ?, ?)";
$desc = "Produto tipo HD para notebook/computadores";
$sqlprep = $conexao -> prepare($sql);
$nome = "Celular";
$descricao = "Use para fazer ligações e conversar no WhatsApp";
$preco = 1342.69;
$sqlprep -> bind_param("ssd", $nome, $descricao, $preco);
$sqlprep -> execute();
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment