Answer the question
In order to leave comments, you need to log in
I can’t understand why it gives an error 500, and in some cases on line 67, which is not there, or rather it is empty, can you help?
<?php
//getting the dboperation class
require_once '../includes/DbOperation.php';
//function validating all the paramters are available
//we will pass the required parameters to this function
function isTheseParametersAvailable($params){
//assuming all parameters are available
$available = true;
$missingparams = "";
foreach($params as $param){
if(!isset($_POST[$param]) || strlen($_POST[$param])<=0){
$available = false;
$missingparams = $missingparams . ", " . $param;
}
}
//if parameters are missing
if(!$available){
$response = array();
$response['error'] = true;
$response['message'] = 'Parameters ' . substr($missingparams, 1, strlen($missingparams)) . ' missing';
//displaying error
echo json_encode($response);
//stopping further execution
die();
}
}
//an array to display response
$response = array();
//if it is an api call
//that means a get parameter named api call is set in the URL
//and with this parameter we are concluding that it is an api call
if(isset($_GET['apicall'])){
switch($_GET['apicall']){
//the CREATE operation
//if the api call value is 'createhero'
//we will create a record in the database
case 'createticket':
//first check the parameters required for this request are available or not
isTheseParametersAvailable(array('name','details','srochnost','fio','vremya','id_pc'));
//creating a new dboperation object
$db = new DbOperation();
//creating a new record in the database
$result = $db->createticket(
$_POST['name'],
$_POST['details'],
$_POST['srochnost'],
$_POST['fio'],
$_POST['vremya'],
$_POST['id_pc']
);
//if the record is created adding success to response
if($result){
//record is created means there is no error
$response['error'] = false;
//in message we have a success message
$response['message'] = 'Ticket addedd successfully';
//and we are getting all the heroes from the database in the response
$response['tickets'] = $db->gettickets();
}else{
//if record is not added that means there is an error
$response['error'] = true;
//and we have the error message
$response['message'] = 'Some error occurred please try again';
}
break;
//the READ operation
//if the call is getheroes
case 'gettickets':
$db = new DbOperation();
$response['error'] = false;
$response['message'] = 'Request successfully completed';
$response['tickets'] = $db->gettickets();
break;
//the UPDATE operation
case 'updatetickets':
isTheseParametersAvailable(array('name','details','srochnost','fio','vremya','id_pc'));
$db = new DbOperation();
$result = $db->updateticket(
$_POST['name'],
$_POST['details'],
$_POST['srochnost'],
$_POST['fio'],
$_POST['vremya'],
$_POST['id_pc']
);
if($result){
$response['error'] = false;
$response['message'] = 'Hero updated successfully';
$response['tickets'] = $db->gettickets();
}else{
$response['error'] = true;
$response['message'] = 'Some error occurred please try again';
}
break;
//the delete operation
case 'deletetickets':
//for the delete operation we are getting a GET parameter from the url having the id of the record to be deleted
if(isset($_GET['id'])){
$db = new DbOperation();
if($db->deleteticket($_GET['id'])){
$response['error'] = false;
$response['message'] = 'Hero deleted successfully';
$response['tickets'] = $db->gettickets();
}else{
$response['error'] = true;
$response['message'] = 'Some error occurred please try again';
}
}else{
$response['error'] = true;
$response['message'] = 'Nothing to delete, provide an id please';
}
break;
}
}else{
//if it is not api call
//pushing appropriate values to response array
$response['error'] = true;
$response['message'] = 'Invalid API Call';
}
//displaying the response in json structure
echo json_encode($response);
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question