Ejemplos de código de MySQLDateTimeToDateTimeNoTime en PHP

Ejemplo n.º 1

0

Mostrar archivo

Archivo: service.php Proyecto: solodyagin/webuseorg3_lite

 *   (добавляйте себя если что-то делали)
 * http://грибовы.рф
 */
// Запрещаем прямой вызов скрипта.
defined('WUO_ROOT') or die('Доступ запрещён');
$eqid = GetDef('eqid');
$step = GetDef('step');
if ($step == 'edit') {
    $sql = "SELECT * FROM repair WHERE id = '{$eqid}'";
    $result = $sqlcn->ExecuteSQL($sql) or die('Не получилось выбрать список ремонтов! ' . mysqli_error($sqlcn->idsqlconnection));
    while ($row = mysqli_fetch_array($result)) {
        $kntid = $row['kntid'];
        $cost = $row['cost'];
        $dtpost = MySQLDateTimeToDateTimeNoTime($row['dt']);
        echo "<script>dtpost='{$dtpost}';</script>";
        $dt = MySQLDateTimeToDateTimeNoTime($row['dtend']);
        echo "<script>dt='{$dt}';step='edit';</script>";
        $comment = $row['comment'];
        $status = $row['status'];
        $userfrom = $row['userfrom'];
        $userto = $row['userto'];
        $doc = $row['doc'];
    }
} else {
    $kntid = '-1';
    $cost = '0.0';
    $dtpost = '';
    echo "<script>dtpost='{$dtpost}';</script>";
    $dt = '';
    echo "<script>dt='{$dt}';step='add';</script>";
    $comment = '';

Ejemplo n.º 2

0

Mostrar archivo

Archivo: service.php Proyecto: Kozlov-V/webuseorg3

// подгружаем настройки из БД, получаем заполненый класс $cfg
include_once "../../../../inc/functions.php";
// загружаем функции
include_once "../../../../inc/login.php";
// логинимся
$eqid = $_GET["eqid"];
$step = $_GET["step"];
if ($step == 'edit') {
    $SQL = "SELECT * FROM repair WHERE id='{$eqid}'";
    $result = $sqlcn->ExecuteSQL($SQL) or die("Не получилось выбрать список ремонтов!" . mysqli_error($sqlcn->idsqlconnection));
    while ($row = mysqli_fetch_array($result)) {
        $kntid = $row['kntid'];
        $cost = $row['cost'];
        $dtpost = MySQLDateTimeToDateTimeNoTime($row["dt"]);
        echo "<script>dtpost='{$dtpost}'</script>";
        $dt = MySQLDateTimeToDateTimeNoTime($row["dtend"]);
        echo "<script>dt='{$dt}';step='edit';</script>";
        $comment = $row['comment'];
        $status = $row['status'];
        $userfrom = $row['userfrom'];
        $userto = $row['userto'];
        $doc = $row['doc'];
    }
} else {
    $kntid = "-1";
    $cost = "0.0";
    $dtpost = "";
    echo "<script>dtpost='{$dtpost}'</script>";
    $dt = "";
    echo "<script>dt='{$dt}';step='add';</script>";
    $comment = "";

Ejemplo n.º 3

0

Mostrar archivo

Archivo: news.php Proyecto: Kozlov-V/webuseorg3

// подгружаем настройки из БД, получаем заполненый класс $cfg
include_once "../../../../inc/functions.php";
// загружаем функции
if (isset($_GET["step"])) {
    $step = $_GET["step"];
}
if (isset($_GET["id"])) {
    $id = $_GET["id"];
}
$dtpost = "";
$title = "";
$txt = "";
if ($step == 'edit') {
    $result = $sqlcn->ExecuteSQL("SELECT * FROM news WHERE id='{$id}';");
    while ($myrow = mysqli_fetch_array($result)) {
        $dtpost = MySQLDateTimeToDateTimeNoTime($myrow["dt"]);
        $title = $myrow["title"];
        $txt = $myrow["body"];
    }
} else {
    $step = "add";
    $id = "";
}
?>
<script type="text/javascript" src="js/tinymce/jquery.tinymce.min.js"></script>
<div id="messenger"></div>    
<form ENCTYPE="multipart/form-data" action="?content_page=news&step=<?php 
echo "{$step}&newsid={$id}";
?>
" method="post" name="form1" target="_self">
    <input name=dtpost id=dtpost value="<?php

Ejemplo n.º 4

0

Mostrar archivo

Archivo: equipment.php Proyecto: Kozlov-V/webuseorg3

//$step=$_GET["step"];
//$id=$_GET["id"];
if ($user->TestRoles("1,4,5,6") == true) {
    echo "<script>orgid=''</script>";
    echo "<script>placesid=''</script>";
    echo "<script>userid=''</script>";
    echo "<script>vendorid=''</script>";
    echo "<script>groupid=''</script>";
    echo "<script>nomeid=''</script>";
    echo "<script>step='{$step}'</script>";
    if ($step == "edit") {
        $result = $sqlcn->ExecuteSQL("SELECT * FROM equipment WHERE id='{$id}';");
        while ($myrow = mysqli_fetch_array($result)) {
            $dtpost = MySQLDateTimeToDateTimeNoTime($myrow["datepost"]);
            echo "<script>dtpost='{$dtpost}'</script>";
            $dtendgar = MySQLDateTimeToDateTimeNoTime($myrow["dtendgar"]);
            echo "<script>dtendgar='{$dtendgar}'</script>";
            $orgid = $myrow["orgid"];
            echo "<script>orgid='" . $orgid . "'</script>";
            $placesid = $myrow["placesid"];
            echo "<script>placesid='" . $placesid . "'</script>";
            $userid = $myrow["usersid"];
            echo "<script>userid='" . $userid . "';</script>";
            $nomeid = $myrow["nomeid"];
            echo "<script>nomeid='" . $nomeid . "'</script>";
            $buhname = $myrow["buhname"];
            $cost = $myrow["cost"];
            $currentcost = $myrow["currentcost"];
            $sernum = $myrow["sernum"];
            $invnum = $myrow["invnum"];
            $shtrihkod = $myrow["shtrihkod"];

Ejemplo n.º 5

0

Mostrar archivo

Archivo: news.php Proyecto: solodyagin/webuseorg3_lite

 *   Грибов Павел,
 *   Сергей Солодягин (solodyagin@gmail.com)
 *   (добавляйте себя если что-то делали)
 * http://грибовы.рф
 */
// Запрещаем прямой вызов скрипта.
defined('WUO_ROOT') or die('Доступ запрещён');
$step = GetDef('step');
$id = GetDef('id');
$dtpost = '';
$title = '';
$txt = '';
if ($step == 'edit') {
    $result = $sqlcn->ExecuteSQL("SELECT * FROM news WHERE id = '{$id}'");
    while ($row = mysqli_fetch_array($result)) {
        $dtpost = MySQLDateTimeToDateTimeNoTime($row['dt']);
        $title = $row['title'];
        $txt = $row['body'];
    }
} else {
    $step = 'add';
    $id = '';
}
?>
<script src="js/tinymce/jquery.tinymce.min.js"></script>
<div id="messenger"></div>
<form enctype="multipart/form-data" action="?content_page=news&step=<?php 
echo "{$step}&newsid={$id}";
?>
" method="post" name="form1" target="_self">
	<div class="container-fluid">

Ejemplo n.º 6

0

Mostrar archivo

Archivo: equipment.php Proyecto: solodyagin/webuseorg3_lite

$step = GetDef('step', 'add');
$id = GetDef('id');
if ($user->TestRoles('1,4,5,6')) {
    echo "<script>orgid='';</script>";
    echo "<script>placesid='';</script>";
    echo "<script>userid='';</script>";
    echo "<script>vendorid='';</script>";
    echo "<script>groupid='';</script>";
    echo "<script>nomeid='';</script>";
    echo "<script>step='{$step}';</script>";
    if ($step == 'edit') {
        $result = $sqlcn->ExecuteSQL("SELECT * FROM equipment WHERE id='{$id}';");
        while ($row = mysqli_fetch_array($result)) {
            $dtpost = MySQLDateTimeToDateTimeNoTime($row['datepost']);
            echo "<script>dtpost='{$dtpost}';</script>";
            $dtendgar = MySQLDateTimeToDateTimeNoTime($row['dtendgar']);
            echo "<script>dtendgar='{$dtendgar}';</script>";
            $orgid = $row['orgid'];
            echo "<script>orgid='{$orgid}';</script>";
            $placesid = $row['placesid'];
            echo "<script>placesid='{$placesid}';</script>";
            $userid = $row['usersid'];
            echo "<script>userid='{$userid}';</script>";
            $nomeid = $row['nomeid'];
            echo "<script>nomeid='{$nomeid}';</script>";
            $buhname = $row['buhname'];
            $cost = $row['cost'];
            $currentcost = $row['currentcost'];
            $sernum = $row['sernum'];
            $invnum = $row['invnum'];
            $shtrihkod = $row['shtrihkod'];

Ejemplos de MySQLDateTimeToDateTimeNoTime en PHP