Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const.php
- <?php
- $TABLE = 'imenik';
- create.php
- <?php
- require_once('db.php');
- require_once('const.php');
- #---------------------------------------------------------------------------
- $data = Array();
- if (!empty($_POST)) {
- $result = insertIntoTable($link, $TABLE, $_POST);
- if ($result) {
- $id = $link->insert_id;
- $_POST['id'] = $id;
- $json = json_encode($_POST);
- echo $json;
- }
- }
- $link->close();
- #---------------------------------------------------------------------------
- function insertIntoTable($link, $table, $data) {
- $sql = "INSERT INTO $table";
- $sql .= " (`".implode("`, `", array_keys($data))."`)";
- $sql .= " VALUES ('".implode("', '", $data)."') ";
- $sql .= ';';
- $result = $link->query($sql);
- return $result;
- }
- db.php
- <?php
- $ERRORS = array(
- 'CONNECT_MYSQL' => 'Error connectiong to mysql ',
- 'SELECT_DB' => 'Error connectiong to db ',
- 'QUERRY' => 'Querry error '
- );
- $HOST = 'localhost';
- $USER = 'root';
- $PASSWORD = '';
- $DATABASE = 'telefonski_imenik';
- $link = connectToMysqlDb($HOST, $USER, $PASSWORD, $DATABASE);
- #$db = selectDb($DATABASE, $link);
- #---------------------------------------------------------------------------
- function connectToMysqlDb($host, $user, $password, $database) {
- $link = mysqli_connect($host, $user, $password, $database);
- if (!$link){
- die($ERRORS['CONNECT_MYSQL'] . mysqli_error());
- }
- return $link;
- }
- #---------------------------------------------------------------------------
- #---------------------------------------------------------------------------
- function selectDb($database, $link) {
- $db = mysqli_select_db($database, $link);
- if (!$db){
- die($ERRORS['SELECT_DB'] . mysqli_error());
- }
- return $db;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement