Jump to content

decode json and add it to mysql

borden0108

By borden0108
in PHP Coding Help

Recommended Posts

borden0108 Newbie

borden0108

Posted
Posted

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

 

[
    {
        "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

Link to comment
https://forums.phpfreaks.com/topic/250361-decode-json-and-add-it-to-mysql/
Share on other sites
borden0108 Newbie

borden0108

Posted
  • Author
Posted

 

this just puts the word array into the db.

 

 

 

<?php
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

$dbname = 'php';
$username = $_POST['name'];
$name = $_POST['username'];
$jsonString = $_POST['jsonString'];
$decode= json_decode($jsonString);

$sql = "INSERT INTO `php`.`json` (`username`, `name`,`jsonString`) VALUES ('$username','$name','$decode');";

$result = mysql_query($sql);
if (!$result) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    die($message);
}
mysql_close($link);
header( 'Location: http://localhost/Projects/NestedListDemo/php/sucess.html' ) ;
?>

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.