Exemplos de Jaring::db_generate_id em PHP

Exemplo n.º 1

Arquivo: index.php Projeto: shuLhan/sigma

function request_create_after($data)
{
    $s = update_logo();
    if ($s === false) {
        return false;
    }
    $profile_id = $data[0]["id"];
    $user_id = $data[0]["_user_id"];
    $gid = Jaring::db_generate_id();
    // insert profile's admin
    $q = "\n\t\tinsert into _profile_admin (_profile_id, _user_id)\n\t\tvalues ({$profile_id}, {$user_id})\n\t\t";
    Jaring::db_execute($q, null, false);
    // update user profile id.
    $q = "\n\t\tupdate\t_user\n\t\tset\t\t_profile_id = ?\n\t\twhere\tid\t\t\t= ?\n\t\t";
    $qbind = array($profile_id, $user_id);
    Jaring::db_execute($q, $qbind, false);
    // add group Administrator to group.
    $q = "\n\t\tinsert into _group (_profile_id, id, pid, name, type)\n\t\tvalues ({$profile_id}, {$gid}, 0, 'Administrator', 0)\n\t\t";
    Jaring::db_execute($q, null, false);
    // add user to group Administrator.
    $id = Jaring::db_generate_id();
    $q = "\n\t\tinsert into _user_group (_profile_id, id, _user_id, _group_id)\n\t\tvalues ({$profile_id}, {$id}, {$user_id}, {$gid})\n\t\t";
    Jaring::db_execute($q, null, false);
    // add menu access.
    $q = "\n\t\tinsert into _group_menu\n\t\t\tselect\t{$gid}, _menu_id, permission\n\t\t\tfrom\t_group_menu\n\t\t\twhere\t_group_id = 1\n\t\t";
    Jaring::db_execute($q, null, false);
}

Exemplo n.º 2

Arquivo: create.php Projeto: shuLhan/sigma

<?php

/*
	Copyright 2014 - Mhd Sulhan
	Authors:
		- mhd.sulhan (m.shulhan@gmail.com)
*/
// insert into media table
$table = "_media";
$fields = ["id", "name", "extension", "size", "mime", "path"];
$fupath = Jaring::$_media_dir . sha1_file($_FILES["content"]["tmp_name"]);
Jaring::db_prepare_insert($table, $fields);
$pi = pathinfo($_FILES["content"]["name"]);
$bindv = [];
$bindv[] = Jaring::db_generate_id();
$bindv[] = $pi["filename"];
$bindv[] = $pi["extension"];
$bindv[] = $_FILES["content"]["size"];
$bindv[] = $_FILES["content"]["type"];
$bindv[] = $fupath;
Jaring::$_db_ps->execute($bindv);
Jaring::$_db_ps->closeCursor();
move_uploaded_file($_FILES["content"]["tmp_name"], APP_PATH . "/" . $fupath);
// link media id into table _media_table
$id = $bindv[0];
$table = "_media_table";
$fields = ["table_id", "_media_id"];
$bindv = [$_POST["table_id"], $id];
Jaring::db_prepare_insert($table, $fields);
Jaring::$_db_ps->execute($bindv);
Jaring::$_db_ps->closeCursor();