PHP - Getting Data From Mysql And Then Converting It To Json With Php

<?php
ini_set('display_errors', 0);
function escapeArray($array)
{
        foreach ($array as $key => $val)
        {
			if(is_array($val)){
				$array[$key]=escapeArray($val);
			}
			else{
				$array[$key]=addslashes($val);
			}
        }

        return $array;
		
}





$request_type=$_SERVER['REQUEST_METHOD'];
$api_key=$_SERVER['HTTP_X_API_KEY'];
$res=array();
if($api_key!=="643256432"){
	$res['msg']="Failu Invalid API KEY";
	echo json_encode($res);
	die;
}
// Connects to the orcl service (i.e. database) on the "localhost" machine
//$conn = oci_connect('SCOTT', 'admin123', 'localhost/orcl');

$conn = oci_connect('test', 'test', '192.168.10.43/test.test.com');

if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

$request=file_get_contents("php://input");
$request=escapeArray(json_decode($request,true));

 print_r($request);
// die;
if($request_type=="POST"){//for creation of invoice


echo	$CONTACT_ID=isset($request['CONTACT_ID'])?$request['CONTACT_ID']:"";
	$INV_SERIAL_NO=isset($request['INV_SERIAL_NO'])?$request['INV_SERIAL_NO']:"";
	$NAME=isset($request['NAME'])?$request['NAME']:"";
	$INV_DATE=isset($request['INV_DATE'])?$request['INV_DATE']:"";
	$DUE_DATE=isset($request['DUE_DATE'])?$request['DUE_DATE']:"";
	$CURRENCY=isset($request['CURRENCY'])?$request['CURRENCY']:"";
	$SUBTOTAL=isset($request['SUBTOTAL'])?$request['SUBTOTAL']:"";
	$TAX_TOTAL=isset($request['TAX_TOTAL'])?$request['TAX_TOTAL']:"";

echo $SHIP_SERIAL_NO=isset($request['SHIP_SERIAL_NO'])?$request['SHIP_SERIAL_NO']:"";
	$MASTER_NO=isset($request['MASTER_NO'])?$request['MASTER_NO']:"";
	$HOUSE_NO=isset($request['HOUSE_NO'])?$request['HOUSE_NO']:"";
	$shipment_data=isset($request['shipment_data'])?$request['shipment_data']:"";

	if($CONTACT_ID==""){
		$res['msg']="CONTACT_ID is required";
	}
	else if($INV_SERIAL_NO==""){
		$res['msg']="INV_SERIAL_NO is required";
	}
	else if($NAME==""){
		$res['msg']="NAME is required";
	}
	else if($INV_DATE==""){
		$res['msg']="INV_DATE is required";
	}
	else if($DUE_DATE==""){
		$res['msg']="DUE_DATE is required";
	}
	else if($CURRENCY==""){
		$res['msg']="CURRENCY is required";
	}
	else if($SUBTOTAL==""){
		$res['msg']="SUBTOTAL is required";
	}
	else if($TAX_TOTAL==""){
		$res['msg']="TAX_TOTAL is required";
	}

	
	else if($MASTER_NO==""){
		$res['msg']="MASTER_NO is required";
	}
	else if($HOUSE_NO==""){
		$res['msg']="HOUSE_NO is required";
	}
	else if($SHIP_SERIAL_NO==""){
		$res['msg']="SHIP_SERIAL_NO is required";
	}



	

	else{
		$stid = oci_parse($conn, "Select * from FL_HDR_INVOICE where CONTACT_ID='$CONTACT_ID'");
		(oci_execute($stid));
		oci_fetch_all($stid, $out);
		
		

		if(count($out['CONTACT_ID'])==0){

			$stid = oci_parse($conn, "Insert into FL_HDR_INVOICE (CONTACT_ID,INV_SERIAL_NO,NAME,INV_DATE,DUE_DATE,CURRENCY,SUBTOTAL,TAX_TOTAL) Values ('$CONTACT_ID','$INV_SERIAL_NO','$NAME',TO_DATE('$INV_DATE','YYYY-MM-DD'),TO_DATE('$DUE_DATE','YYYY-MM-DD'),'$CURRENCY','$SUBTOTAL','$TAX_TOTAL')");
			oci_execute($stid);

			$stid_2 = oci_parse($conn, "Insert into FL_SHIPMENT_DATA (CONTACT_ID,INV_SERIAL_NO,SHIP_SERIAL_NO,MASTER_NO,HOUSE_NO) Values ('$CONTACT_ID','$INV_SERIAL_NO','$SHIP_SERIAL_NO','$MASTER_NO','$HOUSE_NO')");
			oci_execute($stid_2);



			if(oci_num_rows($stid)>0){
				$res['msg']="Invoice created successfully against this contact_id:".$CONTACT_ID;
			}
			else{
				$res['msg']="Something going wrong please try again later";
				
			}
		}
		else{
			$res['msg']="contact_id must be unique";
		}
	}
	echo json_encode($res);
	die;
}

I need to read json data inside an array. Please help correct my code.. i am trying to do an API.

Hi-
I have to post to a URL, grab one field our of the JSON output/response and format nicely to the user. I've tried a few things with some help but none seem to be working. So any help or direction would be greatly appreciate it!!

Attempt 1 (works but not formatted nicely)
if I post using the browser, it works. the data is sent to the URL (web service) and I can see in the web service logs that the entry has been recorded. the problem is that since i have the URL in "action", i'm taken to that page and the user gets to see the JSON output

Code: [Select]
//here's the HTML form in offer.php
<form action="http://somewebservice.com/<?php echo $PrizeID;?>" method="post" name="myform">
<input name="account" id="account" type="hidden" value="<?php echo $account;?>"/>
<input name="dob" id="dob" type="hidden"  value="<?php echo $dob;?>"/>
<input name="site" id="site" type="hidden"  value="<?php echo $site;?>"/>
<input id="submit" type="submit" value="submit"/>
</form>

//here's the output (JSON) after clicking submit
{"Prize":"XXXXXX","ConfirmationCode":"######","Error":false,"ErrorMsg":null}


Attempt 2 (doens't work)
i tried using php but after submit, the page refreshes and no entry is recorded in the web service log

Code: [Select]
//here's the HTML form in offer.php
<form name="myform">
<input name="account" id="account" type="hidden" value="<?php echo $account;?>"/>
<input name="dob" id="dob" type="hidden"  value="<?php echo $dob;?>"/>
<input name="site" id="site" type="hidden"  value="<?php echo $site;?>"/>
<input id="submit" type="submit" value="submit"/>

//here's the php in offer.php
<?php 
if(isset($_POST['submit'])){
$options = array(
            'http'=>array(
                'method'=>"POST",
                'content'=>http_build_query(array(
                        'account' => $account,
                        'dob' =>   $dob,
                        'site' => $site
                    ))
            ));

        $context = stream_context_create($options);
        $result =  file_get_contents("http://somewebservice.com/{$PrizeID}",NULL,$context);
        var_dump($result);
}
?>

Last attempt (doesn't work)
i tried using php & curl so that i can process in the back and show only the ConfirmationCode to the user in a nice format but it doesn't work. after submit, i'm taken to process.php where i see nothing and no entry is recorded in the web service log

Code: [Select]
//here's the HTML form in offer.php
<form action="process.php" method="post" name="myform">
<input name="account" id="account" type="hidden" value="<?php echo $account;?>"/>
<input name="dob" id="dob" type="hidden"  value="<?php echo $dob;?>"/>
<input name="site" id="site" type="hidden"  value="<?php echo $site;?>"/>
<input id="submit" type="submit" value="submit"/>
</form>

//here's the PHP in process.php
<?php 
$postvars=file_get_contents("php://input");
$curl=curl_init("http://somewebservice.com/{$PrizeID}");
curl_setopt($curl,CURLOPT_POSTFIELDS,$postvars);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); 
$result=curl_exec($curl);
$decodedresult=json_decode($result,true);
?>


i haven't gotten to the point where i grab the ConfirmationCode I want because i want to get this fixed first and also because i can't get that to work but will focus on that once i fix this.
Thanks.

I am retrieving Google Books info in JSON format and displaying it inside a div. I would like to send the contents of this div (name, title, description) to my database using Ajax.   Currently only the ISBN field sends because I have it declared as a variable. However my question is, how do I send the other fields (name, title, author). How do I declare these also, I'm not sure what format they need to be in etc.   My JS

$(document).ready(function() {
$('#submit').click(function(ev) {
ev.preventDefault();
var isbn = $('#isbn_search').val(); //get isbn direct from input
var url='https://www.googleapis.com/books/v1/volumes?q='+isbn;
$.getJSON(url,function(data){
$.each(data.items, function(entryIndex, entry){
var html = '<div class="results well">'; 
html += '<h3>' + entry.volumeInfo.title + '</h3>';
html += '<div class="author">' + entry.volumeInfo.authors + '</div>';
html += '<div class="description">' + entry.volumeInfo.description + '</div>';
}); 
});
});
});

My Ajax;

        $.ajax({
             type: 'POST',
             url: 'addIsbnScript.php',
             data: {
                 'isbn' : isbn,
                 'title' : title
                 'subtitle' : subtitle,
                 'authors' : authors,
                 'description' : description
             },
             success: function () { 
            $.growl({
            message: " Record added"
});      
}
});

Note, if i manually set the vars like below they all do successfully send to my database, so I know my query is working ok

var title = "some text",
var author = "some text",
Var description = "some text"

Thanks in advance for any help, newbie here (incase it wasn't obvious!).   J  

I am retrieving data from a third party's API using AJAX method. I would like to do two things.

1. Display the data records on a page.

2. Create a pagination on the page to display records more efficiently. I am expecting to retrieve possibly hundreds of records. I can normally do this using PHP but since I am retrieving the records using AJAX, the pagination is gonna be a challenge. 

First things first is to display the records. Here is my AJAX code.

It displays the log data fine. But it doesn't display any data in the "output" div. And it gives this error in the console.

Uncaught SyntaxError: Unexpected token o in JSON at position 1
at JSON.parse (<anonymous>)
at Object.success

<div class="output"></div>

<script>
  $.ajax ({
    type: 'GET',
    url: "https://3rdpartywebsite.com/api/GetCustomers",
    dataType: 'json',
    processData: false,
    contentType: false,
    success: function(data) {
      console.log(data)

      $newData = JSON.parse(data);
      $.each($newData, function(i, v) {
         $('.output').append(v.LastName);
         $('.output').append(v.FirstName);
      });
    }
  });
</script>

 

What am I doing wrong?

Edited November 14, 2020 by imgrooot

I want to print data from response json? I was debug with firebug and show this :

{"umumu":"","levelu":1,"nameu":""}

How to echo data array just levelu. But i don't know how to make it? thanks

Hello (I think I could have posted this in the wrong PHP area! - so posting it here),   I'm pretty new at building websites using php (and mysql) and was most recently given the task to create a database image gallery, which was to be accessed through a php website.  I made a full site which allowed me to upload said images  & it worked perfectly. However after doing my last checks I have been told that mysql is deprecated and that I need to use mysqli.   I've had a look at some tutorials on websites to help direct me but it's simply confusing me more and more each time I look at it.  Is it possible I am over thinking this and there is an easier way to approach it?   Thank you kindly. This is my php code:    

help required for noobie(no hair left)
all i want to be able to do is use the individual elements of the array in javascript eg companyname or companyimage
but just getting my head in my hand.

mysql_select_db("herefordinfo") or die(mysql_error());
echo "Connected to Database";

$dbQuery = 'SELECT * FROM  companies';
$dbResult = mysql_query($dbQuery) or die ("Could not read data because " . mysql_error());
$RowCount = mysql_numrows($dbResult);

while ($pubs = mysql_fetch_assoc($dbResult))
{
 $array[] = "{  {$pubs['id']}, {$pubs['companyname']}, {$pubs['companyinfo']},  {$pubs['companyimage']} }";
 
}
echo 'var pub = [' . implode(', ', $array) . '];'; // this

?>
<html>
<head>

<script type="text/javascript">
 var jsArray = <?php echo json_encode($array); ?>; 
 document.write(jsArray); //this
</script>
</head>
<boby></body>
</html>

both php and javescritp output the results below
{ 1, lichfield vaults, 10 church street hereford , lich.jpg },{ 2, Black Lion, bridge street, blacklion.jpg },{ 3, Saracens Head, st martins street, saracens.jpg }

This is more of a database architect question.   I am building a CMS for website development. I am ready to use it for the first time on one of my clients. Now, my issue is is how to set up some or one of my table(s) for some areas that my client wants to be able to change in the admin section.   In their website on the front page, I put together this nice block slider. Its 6 blocks with text, a background image and nice effects. At first it was always going to be static, which was no issue at all, but later they came to me and asked if they could be able to change words in the boxes themselves in the admin section..   Of course this can be easily done by creating a table that is associated with this home page block thing and each row in the table will correspond to one of the blocks on the home page.   But I believe there might be an easier way to store this type of data without having to create another table for every feature the client wants to edit, for example they also want to be able to edit a slider on another page.   The WordPress database then came into my mind and how they store most of their data as JSON. So I was then thinking of creating a table named 'modules' for examples with three columns (id, title, data). Then inside the data column store the editable fields as a JSON string object.   For example a row could like like :   1, "Front Page Box Slider", {"slider-home" : [ {"data" : "value", "img_1", "value1"}, {"data" : "value", "img_2", "value2"} ]}   I've been doing a bit of research on this and people have just been saying, never do this if you do want your data to be searched through, which I don't.   Can anyone tell me why or why not I should do this, or maybe a better solution to my problem?   Thank you
Edited by carlosmoreeira, 17 September 2014 - 07:37 PM.

I'm a beginner here and i am learning the basic in converting from MySQL to MySQLi. I am currently working on this registration page which I would want to convert to MySQLi. Please advise me how to modify this script, I would prefer the procedural style. The MySQLi coding is not working because it would notg insert into the database like the MySQL coding would, would appreciate if your can help me. MYSQL

<?php
error_reporting(1);
$submit = $_POST['submit'];
//form data
$name = mysql_real_escape_string($_POST['name']);
$name2 = mysql_real_escape_string($_POST['name2']);
$email = mysql_real_escape_string($_POST['email']);
$password = mysql_real_escape_string($_POST['password']);
$password2 = mysql_real_escape_string($_POST['password2']);
$email2 = mysql_real_escape_string($_POST['email2']);
$address = mysql_real_escape_string($_POST['address']);
$address2 = mysql_real_escape_string($_POST['address2']);
$address3 = mysql_real_escape_string($_POST['address3']);
$address4 = mysql_real_escape_string($_POST['address4']);
$error = array();
if ($submit) {
    //open database
    $connect = mysql_connect("localhost", "root", "Passw0rd") or die("Connection Error");
    //select database
    mysql_select_db("logindb") or die("Selection Error");
    //namecheck
    $namecheck = mysql_query("SELECT * FROM users WHERE email='{$email}'");
    $count = mysql_num_rows($namecheck);
    if($count==0) {
    }
    else
    {
        if($count==1) {
            $error[] = "<p><b>User ID taken. Try another?</b></p>";
        }
    }
    //check for existance
    if($name&&$name2&&$email&&$password&&$password2&&$email2&&$address&&$address2&&$address3&&$address4) {
        if(strlen($password)<8) {
            $error[] = "<p><b>Password must be least 8 characters</b></p>";
        }
        if(!preg_match("#[A-Z]+#",$password)) {
            $error[] = "<p><b>Password must have at least 1 upper case characters</b></p>";
        }
        if(!preg_match("#[0-9]+#",$password)) {
            $error[] = "<p><b>Password must have at least 1 number</b></p>";
        }
        if(!preg_match("#[\W]+#",$password)) {
            $error[] = "<p><b>Password must have at least 1 symbol</b></p>";
        }
        //encrypt password
        $password = sha1($password);
        $password2 = sha1($password2);
        if($_POST['password'] != $_POST['password2']) {
            $error[] = "<p><b>Password does not match</b></p>";
        }
        //rescue email match check
        if($_POST['email2'] == $_POST['email']) {
            $error[] = "<p><b>Rescue Email must not be the same as User ID</b></p>";
        }
        //generate random code
        $random = rand(11111111,99999999);
        //check for error messages
        if(isset($error)&&!empty($error)) {
            implode($error);
        }
        else
        {
            //Registering to database
            $queryreg = mysql_query("INSERT INTO users VALUES ('','$name','$name2','$email','$password','$password2','$email2','$address','$address2','$address3','$address4','$random','0')");
            $lastid = mysql_insert_id();
            echo "<meta http-equiv='refresh' content='0; url=Activate.php?id=$lastid&code=$random'>";
            die ();
        }
    }
}
?>

MYSQLi (NOT WORKING AFTER CONVERTING)

<?php
error_reporting(1);
$submit = $_POST['submit'];
//form data
$name = mysqli_real_escape_string($connect, $_POST['name']);
$name2 = mysqli_real_escape_string($connect, $_POST['name2']);
$email = mysqli_real_escape_string($connect, $_POST['email']);
$password = mysqli_real_escape_string($connect, $_POST['password']);
$password2 = mysqli_real_escape_string($connect, $_POST['password2']);
$email2 = mysqli_real_escape_string($connect, $_POST['email2']);
$address = mysqli_real_escape_string($connect, $_POST['address']);
$address2 = mysqli_real_escape_string($connect, $_POST['address2']);
$address3 = mysqli_real_escape_string($connect, $_POST['address3']);
$address4 = mysqli_real_escape_string($connect, $_POST['address4']);
$error = array();
if ($submit) {
    //open database
    $connect = mysqli_connect("localhost", "root", "Passw0rd", "logindb") or die("Connection Error");
    //namecheck
    $namecheck = mysqli_query($connect, "SELECT * FROM users WHERE email='{$email}'");
    $count = mysqli_num_rows($namecheck);
    if($count==0) {
    }
    else
    {
        if($count==1) {
            $error[] = "<p><b>User ID taken. Try another?</b></p>";
        }
    }
    //check for existance
    if($name&&$name2&&$email&&$password&&$password2&&$email2&&$address&&$address2&&$address3&&$address4) {
        if(strlen($password)<8) {
            $error[] = "<p><b>Password must be least 8 characters</b></p>";
        }
        if(!preg_match("#[A-Z]+#",$password)) {
            $error[] = "<p><b>Password must have at least 1 upper case characters</b></p>";
        }
        if(!preg_match("#[0-9]+#",$password)) {
            $error[] = "<p><b>Password must have at least 1 number</b></p>";
        }
        if(!preg_match("#[\W]+#",$password)) {
            $error[] = "<p><b>Password must have at least 1 symbol</b></p>";
        }
        //encrypt password
        $password = sha1($password);
        $password2 = sha1($password2);
        if($_POST['password'] != $_POST['password2']) {
            $error[] = "<p><b>Password does not match</b></p>";
        }
        //rescue email match check
        if($_POST['email2'] == $_POST['email']) {
            $error[] = "<p><b>Rescue Email must not be the same as User ID</b></p>";
        }
        //generate random code
        $random = rand(11111111,99999999);
        //check for error messages
        if(isset($error)&&!empty($error)) {
            implode($error);
        }
        else
        {
            //Registering to database
            $queryreg = mysqli_query($connect, "INSERT INTO users VALUES ('','$name','$name2','$email','$password','$password2','$email2','$address','$address2','$address3','$address4','$random','0')");
            $lastid = mysqli_insert_id();
            echo "<meta http-equiv='refresh' content='0; url=Activate.php?id=$lastid&code=$random'>";
            die ();
        }
    }
}
?>

hi all

i have some json that i want to decode and add to mysql could you give me some help?

i need to add each of these as a row

here is the json

Code: [Select]
[
    {
        "DayNumber": 1,
        "PeriodNumber": 1,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 1,
        "DefinitionTimeFrom": "8:50:00 AM",
        "DefinitionTimeTo": "9:45:00 AM",
        "ClassCode": "10EWB2",
        "ClassDescription": "Writing Workshop 1",
        "StaffID": 619597,
        "Room": "T22"
    },
    {
        "DayNumber": 1,
        "PeriodNumber": 3,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 3,
        "DefinitionTimeFrom": "10:55:00 AM",
        "DefinitionTimeTo": "11:50:00 AM",
        "ClassCode": "10CBP1",
        "ClassDescription": "Programming ",
        "StaffID": 607388,
        "Room": "CY17"
    },
    {
        "DayNumber": 1,
        "PeriodNumber": 4,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 4,
        "DefinitionTimeFrom": "11:50:00 AM",
        "DefinitionTimeTo": "12:40:00 PM",
        "ClassCode": "10CWA1",
        "ClassDescription": "Web Authoring",
        "StaffID": 607388,
        "Room": "CY34"
    },
    {
        "DayNumber": 1,
        "PeriodNumber": 5,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 5,
        "DefinitionTimeFrom": "1:30:00 PM",
        "DefinitionTimeTo": "2:25:00 PM",
        "ClassCode": "10M9B5",
        "ClassDescription": "Mainstream Mathematics 2",
        "StaffID": 625461,
        "Room": "A4"
    },
    {
        "DayNumber": 1,
        "PeriodNumber": 6,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 6,
        "DefinitionTimeFrom": "2:25:00 PM",
        "DefinitionTimeTo": "3:15:00 PM",
        "ClassCode": "10APX4",
        "ClassDescription": "Photography",
        "StaffID": 620143,
        "Room": "CY14"
    },
    {
        "DayNumber": 2,
        "PeriodNumber": 1,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 1,
        "DefinitionTimeFrom": "8:50:00 AM",
        "DefinitionTimeTo": "9:45:00 AM",
        "ClassCode": "10GHZ6",
        "ClassDescription": "Hazard Geography",
        "StaffID": 608055,
        "Room": "S22"
    },
    {
        "DayNumber": 2,
        "PeriodNumber": 2,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 2,
        "DefinitionTimeFrom": "9:45:00 AM",
        "DefinitionTimeTo": "10:35:00 AM",
        "ClassCode": "10GHZ6",
        "ClassDescription": "Hazard Geography",
        "StaffID": 608055,
        "Room": "S22"
    },
    {
        "DayNumber": 2,
        "PeriodNumber": 3,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 3,
        "DefinitionTimeFrom": "10:55:00 AM",
        "DefinitionTimeTo": "11:50:00 AM",
        "ClassCode": "10M9B5",
        "ClassDescription": "Mainstream Mathematics 2",
        "StaffID": 625461,
        "Room": "A4"
    },
    {
        "DayNumber": 2,
        "PeriodNumber": 4,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 4,
        "DefinitionTimeFrom": "11:50:00 AM",
        "DefinitionTimeTo": "12:40:00 PM",
        "ClassCode": "10M9B5",
        "ClassDescription": "Mainstream Mathematics 2",
        "StaffID": 625461,
        "Room": "A4"
    },
    {
        "DayNumber": 2,
        "PeriodNumber": 5,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 5,
        "DefinitionTimeFrom": "1:30:00 PM",
        "DefinitionTimeTo": "2:25:00 PM",
        "ClassCode": "10AMS2",
        "ClassDescription": "Media Studies",
        "StaffID": 622915,
        "Room": "CY14"
    },
    {
        "DayNumber": 2,
        "PeriodNumber": 6,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 6,
        "DefinitionTimeFrom": "2:25:00 PM",
        "DefinitionTimeTo": "3:15:00 PM",
        "ClassCode": "10P9D6",
        "ClassDescription": "Physical Development",
        "StaffID": 83,
        "Room": "G3"
    },
    {
        "DayNumber": 3,
        "PeriodNumber": 1,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 1,
        "DefinitionTimeFrom": "8:30:00 AM",
        "DefinitionTimeTo": "9:25:00 AM",
        "ClassCode": "10P9D6",
        "ClassDescription": "Physical Development",
        "StaffID": 1455,
        "Room": "G3"
    },
    {
        "DayNumber": 3,
        "PeriodNumber": 2,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 2,
        "DefinitionTimeFrom": "9:25:00 AM",
        "DefinitionTimeTo": "10:15:00 AM",
        "ClassCode": "10EWB2",
        "ClassDescription": "Writing Workshop 1",
        "StaffID": 619597,
        "Room": "T22"
    },
    {
        "DayNumber": 3,
        "PeriodNumber": 3,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 3,
        "DefinitionTimeFrom": "10:35:00 AM",
        "DefinitionTimeTo": "11:30:00 AM",
        "ClassCode": "10APX4",
        "ClassDescription": "Photography",
        "StaffID": 620143,
        "Room": "CY14"
    },
    {
        "DayNumber": 3,
        "PeriodNumber": 4,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 4,
        "DefinitionTimeFrom": "11:30:00 AM",
        "DefinitionTimeTo": "12:15:00 PM",
        "ClassCode": "10CBP1",
        "ClassDescription": "Programming ",
        "StaffID": 607388,
        "Room": "CY17"
    },
    {
        "DayNumber": 3,
        "PeriodNumber": 5,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 5,
        "DefinitionTimeFrom": "1:30:00 PM",
        "DefinitionTimeTo": "2:25:00 PM",
        "ClassCode": "10C9H1",
        "ClassDescription": "Chapel",
        "StaffID": 1071,
        "Room": "C1"
    },
    {
        "DayNumber": 3,
        "PeriodNumber": 6,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 6,
        "DefinitionTimeFrom": "2:25:00 PM",
        "DefinitionTimeTo": "3:15:00 PM",
        "ClassCode": "10EWB2",
        "ClassDescription": "Writing Workshop 1",
        "StaffID": 619597,
        "Room": "A3"
    },
    {
        "DayNumber": 4,
        "PeriodNumber": 1,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 1,
        "DefinitionTimeFrom": "8:50:00 AM",
        "DefinitionTimeTo": "9:45:00 AM",
        "ClassCode": "10QCS5",
        "ClassDescription": "Literacy - Curriculum Support2",
        "StaffID": 601807,
        "Room": "A1"
    },
    {
        "DayNumber": 4,
        "PeriodNumber": 2,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 2,
        "DefinitionTimeFrom": "9:45:00 AM",
        "DefinitionTimeTo": "10:35:00 AM",
        "ClassCode": "10QCS5",
        "ClassDescription": "Literacy - Curriculum Support2",
        "StaffID": 601807,
        "Room": "A1"
    },
    {
        "DayNumber": 4,
        "PeriodNumber": 3,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 3,
        "DefinitionTimeFrom": "10:55:00 AM",
        "DefinitionTimeTo": "11:50:00 AM",
        "ClassCode": "10AMS2",
        "ClassDescription": "Media Studies",
        "StaffID": 622915,
        "Room": "CY14"
    },
    {
        "DayNumber": 4,
        "PeriodNumber": 4,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 4,
        "DefinitionTimeFrom": "11:50:00 AM",
        "DefinitionTimeTo": "12:40:00 PM",
        "ClassCode": "10AMS2",
        "ClassDescription": "Media Studies",
        "StaffID": 622915,
        "Room": "CY14"
    },
    {
        "DayNumber": 4,
        "PeriodNumber": 6,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 6,
        "DefinitionTimeFrom": "2:25:00 PM",
        "DefinitionTimeTo": "3:15:00 PM",
        "ClassCode": "10M9B5",
        "ClassDescription": "Mainstream Mathematics 2",
        "StaffID": 625461,
        "Room": "A4"
    },
    {
        "DayNumber": 5,
        "PeriodNumber": 1,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 1,
        "DefinitionTimeFrom": "8:50:00 AM",
        "DefinitionTimeTo": "9:45:00 AM",
        "ClassCode": "10M9B5",
        "ClassDescription": "Mainstream Mathematics 2",
        "StaffID": 625461,
        "Room": "A4"
    },
    {
        "DayNumber": 5,
        "PeriodNumber": 2,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 2,
        "DefinitionTimeFrom": "9:45:00 AM",
        "DefinitionTimeTo": "10:35:00 AM",
        "ClassCode": "10CWA1",
        "ClassDescription": "Web Authoring",
        "StaffID": 607388,
        "Room": "CY34"
    },
    {
        "DayNumber": 5,
        "PeriodNumber": 4,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 4,
        "DefinitionTimeFrom": "11:50:00 AM",
        "DefinitionTimeTo": "12:40:00 PM",
        "ClassCode": "10GHZ6",
        "ClassDescription": "Hazard Geography",
        "StaffID": 608055,
        "Room": "S22"
    },
    {
        "DayNumber": 5,
        "PeriodNumber": 5,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 5,
        "DefinitionTimeFrom": "1:30:00 PM",
        "DefinitionTimeTo": "2:25:00 PM",
        "ClassCode": "10EWB2",
        "ClassDescription": "Writing Workshop 1",
        "StaffID": 619597,
        "Room": "T22"
    },
    {
        "DayNumber": 5,
        "PeriodNumber": 6,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 6,
        "DefinitionTimeFrom": "2:25:00 PM",
        "DefinitionTimeTo": "3:15:00 PM",
        "ClassCode": "10QCS5",
        "ClassDescription": "Literacy - Curriculum Support2",
        "StaffID": 601807,
        "Room": "A1"
    },
    {
        "DayNumber": 6,
        "PeriodNumber": 1,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 1,
        "DefinitionTimeFrom": "8:50:00 AM",
        "DefinitionTimeTo": "9:45:00 AM",
        "ClassCode": "10M9B5",
        "ClassDescription": "Mainstream Mathematics 2",
        "StaffID": 625461,
        "Room": "A4"
    },
    {
        "DayNumber": 6,
        "PeriodNumber": 2,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 2,
        "DefinitionTimeFrom": "9:45:00 AM",
        "DefinitionTimeTo": "10:35:00 AM",
        "ClassCode": "10CBP1",
        "ClassDescription": "Programming ",
        "StaffID": 607388,
        "Room": "CY17"
    },
    {
        "DayNumber": 6,
        "PeriodNumber": 3,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 3,
        "DefinitionTimeFrom": "10:55:00 AM",
        "DefinitionTimeTo": "11:50:00 AM",
        "ClassCode": "10C9H1",
        "ClassDescription": "Chapel",
        "StaffID": 1071,
        "Room": "C1"
    },
    {
        "DayNumber": 6,
        "PeriodNumber": 4,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 4,
        "DefinitionTimeFrom": "11:50:00 AM",
        "DefinitionTimeTo": "12:40:00 PM",
        "ClassCode": "10CWA1",
        "ClassDescription": "Web Authoring",
        "StaffID": 607388,
        "Room": "CY34"
    },
    {
        "DayNumber": 6,
        "PeriodNumber": 5,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 5,
        "DefinitionTimeFrom": "1:30:00 PM",
        "DefinitionTimeTo": "2:25:00 PM",
        "ClassCode": "10APX4",
        "ClassDescription": "Photography",
        "StaffID": 620143,
        "Room": "CY14"
    },
    {
        "DayNumber": 6,
        "PeriodNumber": 6,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 6,
        "DefinitionTimeFrom": "2:25:00 PM",
        "DefinitionTimeTo": "3:15:00 PM",
        "ClassCode": "10EWB2",
        "ClassDescription": "Writing Workshop 1",
        "StaffID": 619597,
        "Room": "T22"
    },
    {
        "DayNumber": 7,
        "PeriodNumber": 3,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 3,
        "DefinitionTimeFrom": "10:55:00 AM",
        "DefinitionTimeTo": "11:50:00 AM",
        "ClassCode": "10CWA1",
        "ClassDescription": "Web Authoring",
        "StaffID": 607388,
        "Room": "CY34"
    },
    {
        "DayNumber": 7,
        "PeriodNumber": 4,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 4,
        "DefinitionTimeFrom": "11:50:00 AM",
        "DefinitionTimeTo": "12:40:00 PM",
        "ClassCode": "10CWA1",
        "ClassDescription": "Web Authoring",
        "StaffID": 607388,
        "Room": "CY34"
    },
    {
        "DayNumber": 7,
        "PeriodNumber": 5,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 5,
        "DefinitionTimeFrom": "1:30:00 PM",
        "DefinitionTimeTo": "2:25:00 PM",
        "ClassCode": "10P9D6",
        "ClassDescription": "Physical Development",
        "StaffID": 1455,
        "Room": "G3"
    },
    {
        "DayNumber": 7,
        "PeriodNumber": 6,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 6,
        "DefinitionTimeFrom": "2:25:00 PM",
        "DefinitionTimeTo": "3:15:00 PM",
        "ClassCode": "10GHZ6",
        "ClassDescription": "Hazard Geography",
        "StaffID": 608055,
        "Room": "S22"
    },
    {
        "DayNumber": 8,
        "PeriodNumber": 1,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 1,
        "DefinitionTimeFrom": "8:30:00 AM",
        "DefinitionTimeTo": "9:25:00 AM",
        "ClassCode": "10M9B5",
        "ClassDescription": "Mainstream Mathematics 2",
        "StaffID": 625461,
        "Room": "S21"
    },
    {
        "DayNumber": 8,
        "PeriodNumber": 2,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 2,
        "DefinitionTimeFrom": "9:25:00 AM",
        "DefinitionTimeTo": "10:15:00 AM",
        "ClassCode": "10M9B5",
        "ClassDescription": "Mainstream Mathematics 2",
        "StaffID": 625461,
        "Room": "S21"
    },
    {
        "DayNumber": 8,
        "PeriodNumber": 3,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 3,
        "DefinitionTimeFrom": "10:35:00 AM",
        "DefinitionTimeTo": "11:30:00 AM",
        "ClassCode": "10APX4",
        "ClassDescription": "Photography",
        "StaffID": 620143,
        "Room": "CY14"
    },
    {
        "DayNumber": 8,
        "PeriodNumber": 4,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 4,
        "DefinitionTimeFrom": "11:30:00 AM",
        "DefinitionTimeTo": "12:15:00 PM",
        "ClassCode": "10APX4",
        "ClassDescription": "Photography",
        "StaffID": 620143,
        "Room": "CY14"
    },
    {
        "DayNumber": 8,
        "PeriodNumber": 5,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 5,
        "DefinitionTimeFrom": "1:30:00 PM",
        "DefinitionTimeTo": "2:25:00 PM",
        "ClassCode": "10QCS5",
        "ClassDescription": "Literacy - Curriculum Support2",
        "StaffID": 601807,
        "Room": "A1"
    },
    {
        "DayNumber": 8,
        "PeriodNumber": 6,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 6,
        "DefinitionTimeFrom": "2:25:00 PM",
        "DefinitionTimeTo": "3:15:00 PM",
        "ClassCode": "10AMS2",
        "ClassDescription": "Media Studies",
        "StaffID": 622915,
        "Room": "CY14"
    },
    {
        "DayNumber": 9,
        "PeriodNumber": 1,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 1,
        "DefinitionTimeFrom": "8:50:00 AM",
        "DefinitionTimeTo": "9:45:00 AM",
        "ClassCode": "10P9D6",
        "ClassDescription": "Physical Development",
        "StaffID": 83,
        "Room": "G3"
    },
    {
        "DayNumber": 9,
        "PeriodNumber": 2,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 2,
        "DefinitionTimeFrom": "9:45:00 AM",
        "DefinitionTimeTo": "10:35:00 AM",
        "ClassCode": "10EWB2",
        "ClassDescription": "Writing Workshop 1",
        "StaffID": 619597,
        "Room": "T22"
    },
    {
        "DayNumber": 9,
        "PeriodNumber": 3,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 3,
        "DefinitionTimeFrom": "10:55:00 AM",
        "DefinitionTimeTo": "11:50:00 AM",
        "ClassCode": "10CBP1",
        "ClassDescription": "Programming ",
        "StaffID": 607388,
        "Room": "CY17"
    },
    {
        "DayNumber": 9,
        "PeriodNumber": 4,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 4,
        "DefinitionTimeFrom": "11:50:00 AM",
        "DefinitionTimeTo": "12:40:00 PM",
        "ClassCode": "10CBP1",
        "ClassDescription": "Programming ",
        "StaffID": 607388,
        "Room": "CY17"
    },
    {
        "DayNumber": 9,
        "PeriodNumber": 5,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 5,
        "DefinitionTimeFrom": "1:30:00 PM",
        "DefinitionTimeTo": "2:25:00 PM",
        "ClassCode": "10M9B5",
        "ClassDescription": "Mainstream Mathematics 2",
        "StaffID": 625461,
        "Room": "A4"
    },
    {
        "DayNumber": 9,
        "PeriodNumber": 6,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 6,
        "DefinitionTimeFrom": "2:25:00 PM",
        "DefinitionTimeTo": "3:15:00 PM",
        "ClassCode": "10EWB2",
        "ClassDescription": "Writing Workshop 1",
        "StaffID": 619597,
        "Room": "S23"
    },
    {
        "DayNumber": 10,
        "PeriodNumber": 1,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 1,
        "DefinitionTimeFrom": "8:50:00 AM",
        "DefinitionTimeTo": "9:45:00 AM",
        "ClassCode": "10GHZ6",
        "ClassDescription": "Hazard Geography",
        "StaffID": 608055,
        "Room": "S22"
    },
    {
        "DayNumber": 10,
        "PeriodNumber": 2,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 2,
        "DefinitionTimeFrom": "9:45:00 AM",
        "DefinitionTimeTo": "10:35:00 AM",
        "ClassCode": "10F9M1",
        "ClassDescription": "Form Period",
        "StaffID": 615792,
        "Room": "T11"
    },
    {
        "DayNumber": 10,
        "PeriodNumber": 3,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 3,
        "DefinitionTimeFrom": "10:55:00 AM",
        "DefinitionTimeTo": "11:50:00 AM",
        "ClassCode": "10M9B5",
        "ClassDescription": "Mainstream Mathematics 2",
        "StaffID": 625461,
        "Room": "A4"
    },
    {
        "DayNumber": 10,
        "PeriodNumber": 4,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 4,
        "DefinitionTimeFrom": "11:50:00 AM",
        "DefinitionTimeTo": "12:40:00 PM",
        "ClassCode": "10AMS2",
        "ClassDescription": "Media Studies",
        "StaffID": 622915,
        "Room": "CY14"
    },
    {
        "DayNumber": 10,
        "PeriodNumber": 5,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 5,
        "DefinitionTimeFrom": "1:30:00 PM",
        "DefinitionTimeTo": "2:25:00 PM",
        "ClassCode": "10QCS5",
        "ClassDescription": "Literacy - Curriculum Support2",
        "StaffID": 601807,
        "Room": "A1"
    },
    {
        "DayNumber": 10,
        "PeriodNumber": 6,
        "PeriodNumberSeq": 1,
        "DefinitionPeriodNumber": 6,
        "DefinitionTimeFrom": "2:25:00 PM",
        "DefinitionTimeTo": "3:15:00 PM",
        "ClassCode": "10EWB2",
        "ClassDescription": "Writing Workshop 1",
        "StaffID": 619597,
        "Room": "T22"
    }
]

thanks Matt

good evening folks, i have a question regarding the foreach syntax when needing to access something say 3 levels deep into the json architecture here's the example I'm trying to accomplish but when echoing it's not returning the value i need from 3 levels deep. I believe i just don't understand the correct syntax so here's the example any help would he sincerely appreciated.
https://pastebin.com/mEBiMUW5

Hi,

I have the following code that takes a list from a mySQL db and puts it into an array that shows 'gig date, venue, city' per entry: -

 
Code: [Select]
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{

$array[] = ($row['date'].', '.$row['gl_venue'].', '.$row['gl_city']);
}

$output = json_encode($array);
this outputs JSON like so:
Code: [Select]
["06-05-2011, O'neills, Southend","07-05-2011, Power League, Peterborough","14-05-2011, Queen Victoria hall, Oundle",.......]
how do I add keys into the array so I get something like:
Code: [Select]

{"gigs":[
 { "gig": "date, venue, city",}
]}
 
at least I think so anyway!?!

What I want to do is eventually be able to parse a JSON listing into Objective-C and be able to call key/pairs into various different parts of an app.

I'm pretty new to this so any advice would be great.

I have a simple ajax that passes data to a php script using jquery serialize. This is working good but where I am getting stuck is trying to pass json array into mysql. The json is outputting the correct data, but when I insert into db, it just says Array in the field. How can I convert(if that is the right term) json array to use in mysql. In the code I have posted, $box is an array from jquery which I normally use foreach to loop through array. What I need to do is convert $box after is has been encoded. Thanks

Code: [Select]
$box = $_POST['BRVbrtrv_boxnumber'];

$list = array("activity" => $activity, "mobile" => $mobile, "company" =>
$company, "authorised" => $authorised, "service" => $service, "department" =>
$department, "address" => $address, "boxcount" => $boxcount, "box" => $box);

$c = json_encode($list);

echo $c;

I implemented the Content-Security-Policy (CSP). I also included the report-uri so it sends a POST request to myserver.com/csp-report.php
test.php

<?php
header("Content-Security-Policy: default-src 'self'; report-uri http://127.0.0.1/csp-report.php");
?>

I attempted to run these two inline scripts in my test.php file.
 

<img src="http://evil.example.com/image.png">
<script>alert('XSS');</script>

nothing is saved in the report-uri file! However, using Firebug, the policy is working as it should.   Kindly advise if I have the report-uri synthax wrongly.   Thank you
Edited by terungwa, 20 October 2014 - 09:06 AM.

Hello - I am connecting to MySql and running a query.  If I use a foreach loop, I can iterate over the results and have them print to screen.  However, when I try the below everything is null!

 

How can I add the results of my MySql query to a php array?

 

	<?php
$con=mysqli_connect("site", "user", "psasswr=ord", "db");
	if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
	$sql="SELECT * FROM test LIMIT 10";
$result = mysqli_query($con,$sql);
	echo json_encode($result);
	mysqli_free_result($result);
	mysqli_close($con);
?>
	

 

but what this prints is:

{"current_field":null,"field_count":null,"lengths":null,"num_rows":null,"type":null}