Skip to content

Instantly share code, notes, and snippets.

@asterion

asterion/conn.php

Last active October 18, 2017 15:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save asterion/453404f8ccdc0d76b912bdc646dc3c66 to your computer and use it in GitHub Desktop.
Save asterion/453404f8ccdc0d76b912bdc646dc3c66 to your computer and use it in GitHub Desktop.
Download ZIP
test_conn_sqlserver
Raw
conn.php
<?php
$conn = new PDO("dblib:version=8.0;charset=UTF-8;host=IPSERVIDOR;dbname=NOMBREDB", 'USUARIO', 'PASSWORD');
$id = rand();
$query = "INSERT INTO Emp VALUES(" . $id .", 'Smith " . $id . "', 'Carpintero', 2, 300)";
$conn->query($query)->execute();
$stmt = $conn->query("SELECT * FROM Emp");
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
var_dump($result);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment