Ejemplos de código de getById en PHP

Ejemplo n.º 1

0

Mostrar archivo

Archivo: Salesperson_Details.php Proyecto: bryan-615/sunwindwater

<?php

header('Content-type: application/json');
include_once 'Connect.php';
include_once 'UtilFunctions.php';
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'VAL') {
    $Id = strtoupper($_REQUEST['ID']);
    if (isset($_REQUEST["ID"]) && getById('SalesPerson', 'ID', $Id)) {
        getErrorResponse("ID already exists!");
    } else {
        getSuccessCreateResponse('', $Id);
    }
} else {
    if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'ADD') {
        $Id = strtoupper($_REQUEST['ID']);
        $Name = strtoupper($_REQUEST['Name']);
        $query = "insert SalesPerson (ID, Name) values ('" . $Id . "','" . $Name . "')";
        $result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
        if ($result == true) {
            getSuccessCreateResponse('Updated Successfully', $Id);
        } else {
            getErrorResponse("Add Failed!");
        }
    } else {
        if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'UPD') {
            $Id = strtoupper($_REQUEST['ID']);
            $Name = strtoupper($_REQUEST['Name']);
            $query = "update SalesPerson set Name = '" . $Name . "' where ID = '" . $Id . "'";
            $result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
            if ($result == true) {
                getSuccessCreateResponse('Updated Successfully', $Id);

Ejemplo n.º 2

0

Mostrar archivo

Archivo: Quiz_Details.php Proyecto: bryan-615/sunwindwater

<?php

header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: POST, GET, PUT, DELETE');
header('Content-type: application/json');
include_once 'Connect.php';
include_once 'UtilFunctions.php';
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'VAL') {
    $Id = strtoupper($_REQUEST['ID']);
    if (isset($_REQUEST["ID"]) && getById('Aim', 'ID', $Id)) {
        getErrorResponse("ID already exists!");
    } else {
        getSuccessCreateResponse('', $Id);
    }
} else {
    if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'ADD') {
        $Product_ID = $_REQUEST['Product_ID'];
        $Question = $_REQUEST['Question'];
        $Answer_1 = $_REQUEST['Answer_1'];
        $Answer_2 = $_REQUEST['Answer_2'];
        $Answer_3 = $_REQUEST['Answer_3'];
        $Answer_4 = $_REQUEST['Answer_4'];
        $Correct_Answer = $_REQUEST['Correct_Answer'];
        $Question_Order = $_REQUEST['Question_Order'];
        $Supporting_Documentation = $_REQUEST['Supporting_Documentation'];
        $query = "insert Questions (Product_ID, Question, Answer_1, Answer_2, Answer_3, Answer_4, Supporting_Documentation, Question_Order, Correct_Answer) values (" . $Product_ID . ", '" . $Question . "','" . $Answer_1 . "','" . $Answer_2 . "','" . $Answer_3 . "','" . $Answer_4 . "','" . $Supporting_Documentation . "'," . $Question_Order . "," . $Correct_Answer . ")";
        //echo $query;
        $result = $mysqli->query($query);
        if ($result == true) {
            getSuccessCreateResponse('Updated Successfully', $Id);
        } else {

Ejemplo n.º 3

0

Mostrar archivo

Archivo: Expertise_Details.php Proyecto: bryan-615/sunwindwater

<?php

header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: POST, GET, PUT, DELETE');
header('Content-type: application/json');
global $mysqli;
include_once 'Connect.php';
include_once 'UtilFunctions.php';
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'VAL') {
    $Id = strtoupper($_REQUEST['ID']);
    if (isset($_REQUEST["ID"]) && getById('Expertise_Categories', 'ID', $Id)) {
        getErrorResponse("ID already exists!");
    } else {
        getSuccessCreateResponse('', $Id);
    }
} else {
    if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'ADD') {
        $Expertise = strtoupper($_REQUEST['Expertise']);
        $query = "insert Expertise_Categories (Expertise) values ('" . $Expertise . "')";
        $result = $mysqli->query($query);
        if ($result == true) {
            getSuccessCreateResponse('Updated Successfully', $Id);
        } else {
            getErrorResponse("Add Failed!");
        }
    } else {
        if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'UPD') {
            $Id = $_REQUEST['ID'];
            $Expertise = $_REQUEST['Expertise'];
            $query = "update Expertise_Categories set Expertise = '" . $Expertise . "' where ID = '" . $Id . "'";
            $result = $mysqli->query($query);

Ejemplo n.º 4

0

Mostrar archivo

Archivo: index.php Proyecto: richardneish/data-api

<?php

require_once 'vendor/autoload.php';
// Composer autoload
\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim();
$app->contentType('application/json');
$db = new PDO('sqlite:data/database.sqlite');
// Routes
$resource = 'electricity_meter_reading';
$app->get("/{$resource}", function () use($resource, $db, $app) {
    $results = getAll($resource, $db);
    echo json_encode($results);
});
$app->get("/{$resource}/:id", function ($id) use($db, $app) {
    $results = getById($resource, $id, $db);
    echo json_encode($results);
});
$app->run();
function getAll($resource, $db)
{
    $sth = $db->query("SELECT * FROM {$resource};");
    return $sth->fetchAll(PDO::FETCH_CLASS);
}
function getById($resource, $id, $db)
{
    $sth = $db->prepare("SELECT * FROM {$resource} WHERE id = ? LIMIT 1;");
    $sth->execute([intval($id)]);
    $sth->fetchAll(PDO::FETCH_CLASS)[0];
}

Ejemplo n.º 5

0

Mostrar archivo

Archivo: Product_Questions.php Proyecto: bryan-615/sunwindwater

<?php

header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: POST, GET, PUT, DELETE');
header('Content-type: application/json');
include_once 'Connect.php';
include_once 'UtilFunctions.php';
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'VAL') {
    $Id = strtoupper($_REQUEST['ID']);
    if (isset($_REQUEST["ID"]) && getById('Followup_Types', 'ID', $Id)) {
        getErrorResponse("ID already exists!");
    } else {
        getSuccessCreateResponse('', $Id);
    }
} else {
    if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'ADD') {
        $Product_ID = $_REQUEST['Product_ID'];
        $User_ID = $_REQUEST['User_ID'];
        $Question = $_REQUEST['Question'];
        $query = "insert into Product_Questions (Product_ID, Adviser_ID, Question, Question_Date) values (" . $Product_ID . ",'" . $User_ID . "','" . $Question . "',now())";
        $result = $mysqli->query($query);
        if ($result == true) {
            getSuccessCreateResponse('Added Successfully', $Id);
        } else {
            getErrorResponse($query);
        }
    } else {
        if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'UPD') {
            $ID = $_REQUEST['ID'];
            $Issuer_ID = $_REQUEST['Issuer_ID'];
            $Name = $_REQUEST['Name'];

Ejemplo n.º 6

0

Mostrar archivo

Archivo: Alert_Details.php Proyecto: bryan-615/sunwindwater

<?php

header('Content-type: application/json');
include_once 'Connect.php';
include_once 'UtilFunctions.php';
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'VAL') {
    $Id = strtoupper($_REQUEST['ID']);
    if (isset($_REQUEST["ID"]) && getById('Alert_Details', 'ID', $Id)) {
        getErrorResponse("ID already exists!");
    } else {
        getSuccessCreateResponse('', $Id);
    }
} else {
    if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'ADD') {
        $Description = $_REQUEST['Description'];
        $query = "insert Alert_Details (Description) values ('" . $Description . "')";
        $result = $mysqli->query($query);
        if ($result == true) {
            getSuccessCreateResponse('Updated Successfully', $Id);
        } else {
            getErrorResponse("Add Failed!");
        }
    } else {
        if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'UPD') {
            $Id = $_REQUEST['ID'];
            $Description = $_REQUEST['Description'];
            $query = "update Alert_Details set Name = '" . $Name . "', Points = " . $Points . " where ID = '" . $Id . "'";
            $result = $mysqli->query($query);
            if ($result == true) {
                getSuccessCreateResponse('Updated Successfully', $Id);
            } else {

Ejemplo n.º 7

0

Mostrar archivo

Archivo: testing.php Proyecto: Mapsred/ORM-LAMP

        select();
        break;
    case 1:
        insert();
        break;
    case 2:
        update();
        break;
    case 3:
        delete();
        break;
    case 4:
        setById();
        break;
    case 5:
        getById();
        break;
    case 6:
        deleteById();
        break;
    default:
        hello();
}
function select()
{
    /**Select Request**/
    $orm = new ORM();
    $sql = new MysqlConnect($orm->getDatabase());
    $fields = array("*");
    $condition = array('where' => array('id !=' => 1));
    $order = array("id" => "DESC", "ok" => "ASC");

Ejemplo n.º 8

0

Mostrar archivo

Archivo: form-altera-usuario.php Proyecto: Gibran123/comunidade

<?php

session_start();
if (!isset($_SESSION['email'])) {
    header("Location: index.php");
    die;
}
include_once 'cabecalho.php';
include_once 'menu.php';
include_once "controller/bancoUsuario.php";
$usuario = getById();
?>

<form class="form" id="validate" action="atualizar-usuario.php" method="post">
			<fieldset>
				<legend>Alterar dados do usuário</legend>
	<table class="table branco">
				<tr>
					<td><label for="nome-usuario">Nome:</label></td>
					<td><input type="text" name="nome-usuario" class="form-control"
						required="required" value="<?php 
echo $usuario['nome'];
?>
">
					</td>
				</tr>
					<tr>
						<td><label for="email-usuario">Email:</label></td>
						<td>
							<input type="email" name="email-usuario" value="<?php 
echo $usuario['email'];

Ejemplo n.º 9

0

Mostrar archivo

Archivo: profile.php Proyecto: whaangbuu/kiki

<?php

namespace App\DB;

session_start();
require 'db.php';
date_default_timezone_set('Asia/Manila');
$conn = connect($config);
if (!isset($_SESSION['id'])) {
    header("location: /kiki/");
} else {
    if (isset($_GET['id'])) {
        $user = getById((int) $_GET['id'], 'faculties', $conn);
        $now = time();
    }
    $activities = join((int) $_GET['id'], 'logs', 'faculty_id', $conn);
}
?>

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title><?php 
echo $user[0]['first_name'] . " " . $user[0]['last_name'];
?>
</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />

    <link rel="stylesheet" type="text/css" href="views/bootstrap/css/bootstrap.min.css" />
    <link rel="stylesheet" type="text/css" href="views/font-awesome/css/font-awesome.min.css" />

Ejemplo n.º 10

0

Mostrar archivo

Archivo: form-altera-ministerio.php Proyecto: Gibran123/comunidade

<?php

session_start();
if (!isset($_SESSION['email'])) {
    header("Location: index.php");
    die;
}
include_once 'cabecalho.php';
include_once 'menu.php';
include_once 'controller/bancoMinisterio.php';
$id = $_POST['id'];
$ministerio = getById($id);
?>

<form class="form" action="atualizar-ministerio.php" method="post">
			<fieldset>
	<table class="table branco">
				<legend>Atualizar Ministério</legend>
				<tr>
					<td><label for="ministerio">Nome:</label></td>
					<td><input type="text" name="ministerio" class="form-control"
						required="required" value="<?php 
echo $ministerio['nome'];
?>
">
						<input type="hidden" name="id" value="<?php 
echo $ministerio['id'];
?>
">
					</td>
				</tr>

Ejemplo n.º 11

0

Mostrar archivo

Archivo: form-altera-fase.php Proyecto: Gibran123/comunidade

<?php

session_start();
if (!isset($_SESSION['email'])) {
    header("Location: index.php");
    die;
}
include_once 'cabecalho.php';
include_once 'menu.php';
include_once 'controller/bancoFase.php';
$id = $_POST['id'];
$fase = getById($id);
?>

<form class="form" action="atualizar-fase.php" method="post">
			<fieldset>
	<table class="table branco">
				<legend>Atualizar Fase</legend>
				<tr>
					<td><label for="fase">Nome:</label></td>
					<td><input type="text" name="fase" class="form-control"
						required="required" value="<?php 
echo $fase['nome'];
?>
">
						<input type="hidden" name="id" value="<?php 
echo $fase['id'];
?>
">
					</td>
				</tr>

Ejemplo n.º 12

0

Mostrar archivo

Archivo: Instructor_Details.php Proyecto: bryan-615/sunwindwater

<?php

header('Content-type: application/json');
include_once 'Connect.php';
include_once 'UtilFunctions.php';
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'VAL') {
    $Id = strtoupper($_REQUEST['ID']);
    if (isset($_REQUEST["ID"]) && getById('Instructor', 'ID', $Id)) {
        getErrorResponse("ID already exists!");
    } else {
        getSuccessCreateResponse('', $Id);
    }
} else {
    if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'ADD') {
        $Id = strtoupper($_REQUEST['ID']);
        $Name = strtoupper($_REQUEST['Name']);
        $query = "insert Instructor (ID, Name) values ('" . $Id . "','" . $Name . "')";
        $result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
        if ($result == true) {
            getSuccessCreateResponse('Updated Successfully', $Id);
        } else {
            getErrorResponse("Add Failed!");
        }
    } else {
        if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'UPD') {
            $Id = strtoupper($_REQUEST['ID']);
            $Name = strtoupper($_REQUEST['Name']);
            $query = "update Instructor set Name = '" . $Name . "' where ID = '" . $Id . "'";
            $result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
            if ($result == true) {
                getSuccessCreateResponse('Updated Successfully', $Id);

Ejemplo n.º 13

0

Mostrar archivo

Archivo: Product_Category.php Proyecto: bryan-615/sunwindwater

<?php

header('Content-type: application/json');
include_once 'Connect.php';
include_once 'UtilFunctions.php';
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'VAL') {
    $Id = strtoupper($_REQUEST['ID']);
    if (isset($_REQUEST["ID"]) && getById('Source', 'ID', $Id)) {
        getErrorResponse("ID already exists!");
    } else {
        getSuccessCreateResponse('', $Id);
    }
} else {
    if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'ADD') {
        $Description = strtoupper($_REQUEST['Description']);
        $query = "insert Product_Categories (Description) values ('" . $Description . "')";
        $result = $mysqli->query($query);
        if ($result == true) {
            getSuccessCreateResponse('Updated Successfully', $Id);
        } else {
            getErrorResponse("Add Failed!");
        }
    } else {
        if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'UPD') {
            $Id = $_REQUEST['ID'];
            $Description = strtoupper($_REQUEST['Source_Desc']);
            $query = "update Product_Categories set Description = '" . $Description . "' where ID = '" . $Id . "'";
            $result = $mysqli->query($sql);
            if ($result == true) {
                getSuccessCreateResponse('Updated Successfully', $Id);
            } else {

Ejemplo n.º 14

0

Mostrar archivo

Archivo: Boat_Details.php Proyecto: bryan-615/sunwindwater

<?php

header('Content-type: application/json');
include_once 'Connect.php';
include_once 'UtilFunctions.php';
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'VAL') {
    $Id = strtoupper($_REQUEST['ID']);
    if (isset($_REQUEST["ID"]) && getById('Boats', 'ID', $Id)) {
        getErrorResponse("ID already exists!");
    } else {
        getSuccessCreateResponse('', $Id);
    }
} else {
    if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'ADD') {
        $Id = strtoupper($_REQUEST['ID']);
        $Name = strtoupper($_REQUEST['Name']);
        $query = "insert Boats (ID, Name) values ('" . $Id . "','" . $Name . "')";
        $result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
        if ($result == true) {
            getSuccessCreateResponse('Updated Successfully', $Id);
        } else {
            getErrorResponse("Add Failed!");
        }
    } else {
        if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'UPD') {
            $Id = strtoupper($_REQUEST['ID']);
            $Name = strtoupper($_REQUEST['Name']);
            $query = "update Boats set Name = '" . $Name . "' where ID = '" . $Id . "'";
            $result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
            if ($result == true) {
                getSuccessCreateResponse('Updated Successfully', $Id);

Ejemplo n.º 15

0

Mostrar archivo

Archivo: Email_Content.php Proyecto: bryan-615/sunwindwater

<?php

header('Content-type: application/json');
include_once 'Connect.php';
include_once 'UtilFunctions.php';
include_once 'class.phpmailer.php';
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'VAL') {
    $Id = strtoupper($_REQUEST['ID']);
    if (isset($_REQUEST["ID"]) && getById('Email_Content', 'ID', $Id)) {
        getErrorResponse("ID already exists!");
    } else {
        getSuccessCreateResponse('', $Id);
    }
} else {
    if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'ADD') {
        $Id = strtoupper($_REQUEST['ID']);
        $Description = strtoupper($_REQUEST['Description']);
        $Content = $_REQUEST['Content'];
        $query = "insert Email_Content (ID, Description, Content) values ('" . $Id . "','" . $Description . "', '" . $Content . "')";
        $result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
        if ($result == true) {
            getSuccessCreateResponse('Updated Successfully', $Id);
        } else {
            getErrorResponse("Add Failed!");
        }
    } else {
        if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'UPD') {
            $Id = strtoupper($_REQUEST['ID']);
            $Description = strtoupper($_REQUEST['Description']);
            $Content = $_REQUEST['Content'];
            $query = "update Email_Content set Description = '" . $Description . "', Content = '" . $Content . "' where ID = '" . $Id . "'";

Ejemplo n.º 16

0

Mostrar archivo

Archivo: dom-manage.php Proyecto: ZeitZumSterben/website-cms

function getNav()
{
    return getById("nav");
}

Ejemplo n.º 17

0

Mostrar archivo

Archivo: Payments.php Proyecto: bryan-615/sunwindwater

<?php

header('Content-type: application/json');
include_once 'Connect.php';
include_once 'UtilFunctions.php';
include_once 'class.phpmailer.php';
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'VAL') {
    $Id = strtoupper($_REQUEST['ID']);
    if (isset($_REQUEST["ID"]) && getById('Course_Details', 'ID', $Id)) {
        getErrorResponse("ID already exists!");
    } else {
        getSuccessCreateResponse('', $Id);
    }
} else {
    if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'ADD') {
        $Receipt_No = $_REQUEST['Receipt_No'];
        $StudentNo = $_REQUEST['StudentNo'];
        $Date_Due = new DateTime($_REQUEST['Date_Due']);
        $Date_Due->setTimezone(new DateTimeZone('UTC'));
        $Date_Due = $Date_Due->format('Y-m-d');
        $How_Paid = $_REQUEST['How_Paid'];
        $Transaction_ID = $_REQUEST['Transaction_ID'];
        $Receipt_Details = $_REQUEST['Receipt_Details'];
        $Reference = $_REQUEST['Reference'];
        $Amount = $_REQUEST['Amount'];
        $Amount = getCredit_Debit($Transaction_ID, $Amount);
        $GST_Amt = 0;
        $Student_Cost = $Amount;
        $query = 'insert into Payments (StudentNo, Receipt_No, Receipt_Date, Receipt_Details, Reference, Date_Due, ';
        if ($Amount > 0) {
            $query .= 'Debit_Amt,';

Ejemplo n.º 18

0

Mostrar archivo

Archivo: get.php Proyecto: reflash/product_web_app

<?php

include "db_facade.php";
if ($_SERVER['REQUEST_METHOD'] === 'GET') {
    if (array_key_exists('id', $_GET)) {
        $productList = getById($_GET['id']);
        if ($productList == false) {
            failWithError('Id not found', '500 Internal Server Error');
        } else {
            echo $productList;
        }
    } else {
        failWithError('Invalid input data', '400 Bad Request');
    }
}

Ejemplos de getById en PHP