John Davidson

Message:

I am trying to use a serialized PHP array to create a table from a database using wpDataTables. I chose to use a serialized PHP array instead of an SQL query because I want to use URL parameters to choose specific data from the database to include in the table.

What I did so far is create the PHP script shown below.

However, I am not getting the expected output and I am unable to use this script to create the table on wpDataTables.

<?php



$mysqli = new mysqli("#######", "#######", "######", "######");



if(!$mysqli)

{

    die("Connection failed: " . mysqli_connect_error());

}



$par = $_GET['zipcode'];



if(!$par) {

  $zcode = 75001;

}

else {

  $zcode = $par;

}



$result = $mysqli->query("SELECT RepCompany,Product,kwh500,kwh1000 FROM plans

join zip_codes

  ON plans.area_id = zip_codes.area_id

 WHERE zip_codes.zip_code=$zcode");



echo serialize($result);



?>

---

My Answer:
Here is an example of how you can use a serialized PHP array to create a table in wpDataTables in WordPress:

php
// Serialized PHP array
$serialized_array = 'a:3:{i:0;a:2:{s:4:"name";s:5:"John";s:3:"age";i:30;}i:1;a:2:{s:4:"name";s:6:"Sarah";s:3:"age";i:25;}i:2;a:2:{s:4:"name";s:4:"Mark";s:3:"age";i:35;}}';

// Unserialize the array
$data = unserialize($serialized_array);

// Output the table
echo '';
echo '';
foreach ($data as $row) {
echo '';
echo '';
echo '';
echo '';
}
echo '

Name	Age
' . $row['name'] . '	' . $row['age'] . '

';
?>


You can place this code in a WordPress page or post using a custom HTML block. This code will unserialize the serialized PHP array, loop through the data, and output it in a table format.

If you are still facing issues with creating the table in wpDataTables, make sure that the serialized PHP array is correctly formatted and that the wpDataTables plugin is properly set up on your WordPress site. You may also need to adjust the code to match the specific requirements of wpDataTables.