Tiny File Manager

Back Back Up Advanced Editor

<!DOCTYPE html> 
<html>

<body> 
	<div class="container box"> 
		<h3 align="center"> 
			Geeks for Geeks Import JSON 
			data into database 
		</h3><br /> 
		
		<?php 
		
			// Server name => localhost 
			// Username => root 
			// Password => empty 
			// Database name => test 
			// Passing these 4 parameters 
//			$connect = mysqli_connect("localhost", "root", "", "test"); 
			
			$query = ''; 
			$table_data = ''; 
			
			// json file name 
			$filename = "file.json"; 
			
			// Read the JSON file in PHP 
			$data = file_get_contents($filename); 
			
			// Convert the JSON String into PHP Array 
			$array = json_decode($data, true); 
			
			echo "<pre>";
			print_r($array);
			echo "</pre>";

// Extracting row by row 
			/*foreach($array as $row) 
			{

// Database query to insert data 
				// into database Make Multiple 
				// Insert Query 
				$query .= 
				"INSERT INTO student VALUES 
				('".$row["name"]."', '".$row["gender"]."', 
				'".$row["subject"]."'); "; 
			
				$table_data .= ' 
				<tr> 
					<td>'.$row["name"].'</td> 
					<td>'.$row["gender"].'</td> 
					<td>'.$row["subject"].'</td> 
				</tr> 
				'; // Data for display on Web page 
			} */

/*if(mysqli_multi_query($connect, $query)) 
			{ 
				echo '<h3>Inserted JSON Data</h3><br />'; 
				echo ' 
				<table class="table table-bordered"> 
				<tr> 
					<th width="45%">Name</th> 
					<th width="10%">Gender</th> 
					<th width="45%">Subject</th> 
				</tr> 
				'; 
				echo $table_data; 
				echo '</table>'; 
			} */
		?> 
		<br /> 
	</div> 
</body>

</html>