File: class/students.fn.php

Recommend this page to a friend!
  Classes of Jesus Tovar  >  Simple Students CRUD  >  class/students.fn.php  >  Download  
File: class/students.fn.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Simple Students CRUD
Perform CRUD operations on a students MySQL table
Author: By
Last change:
Date: 4 years ago
Size: 3,115 bytes
 

 

Contents

Class file image Download
<?php
include_once ('students.core.php');
/**
 * student fn
 *
 * @package crud
 * @author tovarj4
 * @copyright 2016
 * @version $Id$
 * @access public
 */
$_student = new student();
if (isset(
$_POST['action']))
{
    if (
$_POST['action'] == 0)
    {
//All Students
       
$arrStudents = $_student->getAll();
       
$len = count($arrStudents);
       
$tr = "";

        for (
$i = 0; $i < $len; $i++)
        {

            if (
$i % 2 == 0)
            {
               
$tr .= "<tr class='active'>";
            } else
            {
               
$tr .= "<tr class='success'>";
            }

           
$tr .= "<td>" . $arrStudents[$i]['id_student'] . "</td>";
           
$tr .= "<td>" . $arrStudents[$i]['student_name'] . "</td>";
           
$tr .= "<td>" . $arrStudents[$i]['student_age'] . "</td>";
           
$tr .= "<td><a href='javascript:student.loadToEdit(" . $arrStudents[$i]['id_student'] .
               
")' class='btn btn-warning'>Edit/Delete</a></td>";
           
$tr .= "</tr>";
        }

        if (
$_student->error)
        {
            echo
$tr;
        } else
        {
            echo
" Error al consultar" . $_student->qry;
        }
    }

    if (
$_POST['action'] == 1)
    {
//add Student


       
$student_name = $_POST['name'];
       
$student_age = $_POST['age'];

       
$_student->add($student_name, $student_age);

        if (
$_student->error)
        {
           
$arrJson = array("error" => 'true');
        } else
        {
           
$arrJson = array("error" => 'false');
        }
        echo
json_encode($arrJson);

    }
    if (
$_POST['action'] == 2)
    {
//edit Student

       
$id_student = $_POST['id'];
       
$student_name = $_POST['name'];
       
$student_age = $_POST['age'];

       
$_student->update($id_student, $student_name, $student_age);

        if (
$_student->error == 'true')
        {
           
$arrJson = array("error" => 'true');
        } else
        {
           
$arrJson = array("error" => 'false');
        }
        echo
json_encode($arrJson);


    }
    if (
$_POST['action'] == 3)
    {
//delete Student

       
$id_student = $_POST['id'];

       
$_student->delete($id_student);

        if (
$_student->error == 'true')
        {
           
$arrJson = array("error" => 'true', "errDesc" => $_student->qry);

        } else
        {
           
$arrJson = array("error" => 'false', "errDesc" => "");
        }
        echo
json_encode($arrJson);


    }
    if (
$_POST['action'] == 4)
    {
//get single student

       
$id_student = $_POST['id'];

       
$student = $_student->getSingle($id_student);

        if (
$_student->error == 'true')
        {
            echo
json_encode(array("error" => $_student->error, "qry" => $_student->qry));
        } else
        {

            echo
json_encode($student);
        }


    }
}

/* if ($_GET['action']==4) { //get single student

$id_student = $_GET['id'];

$student = $_student->getSingle($id_student);


if($_student->error=='true'){
echo json_encode( array("error"=>$_student->error,"qry"=>$_student->qry));
} else {

echo json_encode($student);
}
}*/

?>


For more information send a message to info at phpclasses dot org.