Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $user='root';
- $pass='';
- try {
- //mysql:host=192.168.0.1
- $conn = new PDO('mysql:host=localhost;dbname=vpdes897_pesquisa', $user, $pass);
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $idescola= '77';
- $programa= 'Novo Programa';
- $instituicao= 'Nova Instituicao';
- $site= 'Novo Site';
- $coordenador= 'Novo Coordenador';
- $secretario= 'Novo Secretario';
- $telefone= 'Novo Telefone';
- $email= 'Novo Email';
- $esta_coordenando_desde= 'Nova Administracao';
- $query_insert = $conn->prepare('INSERT INTO escola VALUES(
- :idescola,:programa,:instituicao,:site,:coordenador,:secretario,:telefone,:email,:esta_coordenando_desde)'
- );
- $query_insert->execute(array(
- ':idescola' => $idescola,
- ':programa' => $programa,
- ':instituicao' => $instituicao,
- ':site' => $site,
- ':coordenador' => $coordenador,
- ':secretario' => $secretario,
- ':telefone' => $telefone,
- ':email' => $email,
- ':esta_coordenando_desde' => $esta_coordenando_desde,
- ));
- echo $query_insert->rowCount();
- $conn = NULL;
- } catch (PDOException $e) {
- print "Error!: " . $e->getMessage() . "<br/>";
- die();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement