|
PHP - Adding Variables From Foreach Into New Array Structure For Phpexcel Format
I'm currently looping on an array with this structu
Categories{
CategoryName
CategoryCode
CategoryDescription
Products{
product_info{
product_code
product_type{
CountNumber
ProductDescription
}
}
prices{
"wholesale":"250",
"retail":"400"
}
}
}
I'm looping on the above array at each level, and I've declared an array so that I can put all my needed values into it
$priceResult = array();
foreach($prices->categories as $category){
$categoryName = $category->category_name;
$categoryCode = $category->category_code;
$categoryDescription = $category->category_desc;
foreach($category->products as $product){
foreach($product->product_info as $info){
$product_code = $info->product_code;
foreach($info->product_type as $type){
$CountNumber = $type->CountNumber;
$ProductDescription = $type->ProductDescription;
}
}
foreach ($product->prices as $price => $amount) {
$price_amount = $amount;
}
}
}
The problem I'm having is I don't know how to properly push into that new ```$priceResult``` array so that I can use PHPExcel to put it into a format with a subheader. The format I would want from the above example would be something like this
Test Category 1 | 123 | Category for Testing
Test Category 2 | 321 | New Category for Testing So basically I want to call PHPExcel on my $priceResult array in order to get that format where I can list my category info, and for each product within that category, I'd have a product row. Everything would be grouped by the category main header
$build = Excel::create($name, function ($excel) use ($priceResult) {
$excel->setTitle('Test Products');
UPDATE:
CategoryCode : 123
CategoryName : TestCategory
CategoryDescription: For Testing
Products{
0{
Product_code : 123,
CountNumber : 12,
ProductDescription: Test Product,
price_amount : 150.00
},
1{
Product_code : 112,
CountNumber : 32,
ProductDescription: Test Product 2,
price_amount : 250.00
}
}
Similar TutorialsHi... I tried to use foreach in displaying my table header, but I encountered problem when I tried to display data on the first row , my query only display the last Sum for the last Comp. here is my code: <html> <head> <title>Half Shell</title> <link rel="stylesheet" type="text/css" href="kanban.css" /> <?php error_reporting(E_ALL ^ E_NOTICE); date_default_timezone_set("Asia/Singapore"); //set the time zone $con = mysql_connect('localhost', 'root',''); if (!$con) { echo 'failed'; die(); } mysql_select_db("mes", $con); ?> <body> <form name="param" action="" method="post" onSubmit="return false"> <div id="fieldset_PS"> <?php echo "<table>"; $sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp"; $res_comp = mysql_query($sql, $con); while($row_comp = mysql_fetch_assoc($res_comp)){ $Comp[] = $row_comp['Comp']; } echo "<th> </th>"; foreach($Comp AS $Comp){ echo "<th>$Comp</th>"; } echo "<tr> <td>Total Kg/Compound</td>"; $sql_sec = "SELECT SUM(TotalKg) AS TotalKg FROM sales_order WHERE Comp = '$Comp' ORDER BY Comp"; $res_sec = mysql_query($sql_sec, $con); while($row_sec = mysql_fetch_assoc($res_sec)){ $TotalKg[] = $row_sec['TotalKg']; } foreach($TotalKg AS $TotalKg){ echo "<td>$TotalKg</td> </tr>"; } ?> I also attach the correct output that should be and the result from my code. Thank you I'm not sure if the title explains it very well, but here is an image of it. I am trying to figure out how to access the option selected (equal, not equal, etc.), along with its input box, for each column (the checkboxes on the right) selected. The purpose of this is to allow a non-programming administrator user to create a custom query to access information. I can find out which checkboxes are selected no problem, but finding the accompanying drop-down option and input box is difficult for me. How do I do this? If you have a suggestion on how to change it, I'm very open. Thank you in advance! Code: [Select] if(!isset($_POST['submit'])) { echo " <form method='post'> <table> <tr> <td valign='top'>SELECT</td> <td valign='top'> <table>"; // LIST ALL COLUMNS IN A TABLE $result = mysql_query("SELECT * FROM table_name") or die(mysql_error()); $rowcount=mysql_num_rows($result); $y=mysql_num_fields($result); for ($x=0; $x<$y; $x++) { echo " <tr> <td> <input type='checkbox' name='fields[]' value='".mysql_field_name($result, $x)."'>".mysql_field_name($result, $x)." </td> </tr>"; } echo " </table> </td> <td valign='top'>FROM allocations</td> <td valign='top'>WHERE</td> <td> <table>"; // LIST ALL COLUMNS IN A TABLE $result = mysql_query("SELECT * FROM table_name") or die(mysql_error()); $rowcount=mysql_num_rows($result); $y=mysql_num_fields($result); for ($x=0; $x<$y; $x++) { echo " <tr> <td> <input type='checkbox' name='column[]' value='".mysql_field_name($result, $x)."'>".mysql_field_name($result, $x)." </td> <td> <select name='operator[]'> <option value='='>equals</option> <option value='<>'>does not equal</option> <option value='>'>greater than</option> <option value='<'>less than</option> <option value='>='>greater than or equal to</option> <option value='<='>less than or equal to</option> <option value='LIKE'>is like</option> </select> </td> <td><input type='text' name='criteria[]'></td> </tr>"; } echo " </table> </td> <td valign='top'><input type='submit' value='Process Query' name='submit' class='submit'></td> </tr> </table> </form>"; } else { echo "<b>Fields to edit:</b> "; foreach ($_POST['fields'] as $fields) { echo $fields,", "; } echo "<br><br>"; echo "<b>Columns to query:</b> "; foreach ($_POST['column'] as $columns) { echo $columns," HERE IS THE SPOT, "; } } I guess I'll rephrase since my wording wasn't very clear. Why don't echo "<p>\n"; if (!empty($locations) && is_array($locations)) { foreach ($locations as $field => $val) { if ($field == "City") { echo $field . ' : ' . $val . "<br />\n"; $val = $cityvar; } if ($field == "ZipPostalCode") { echo $field . ' : ' . $val . "<br />\n"; $val = $zipvar; } if ($field == "CountryName") { echo $field . ' : ' . $val . "<br />\n"; $val = $countryvar; } } } echo "</p>\n"; Hi all, I have a long script that processes only one image at the moment. What I am trying to do is put all the script in to a 'foreach' section so that I can process more than just one image. Could someone show me how to do this, putting all the uploaded images in to an array (i guess is the best option) and tell me what the form input names need to be below. The script I was trying to make in principle was: <?php $reg = "G-BAAA"; $count-number-of-files-being-uploaded = x ; // NUMBER OF FILES?? $number = 0; foreach $_FILES { // THIS IS WHERE THE IMAGES ARE UPLOADED AND THUMBNAILS CREATED. THE NAMES OF THE FILES ARE $reg.$number."."$ext; $number++; } ?> <form name="newad" method="post" enctype="multipart/form-data" action=""> <table> <tr><td><input type="file" name="image[]" ></td></tr> <tr><td><input type="file" name="image[]" ></td></tr> <tr><td><input name="Submit" type="submit" value="Upload image"></td></tr> </table> </form> I am stuck on inserting the data into mysql via php. Its a foreach method and I am just stuck Code: [Select] include '../Database/take_an_exam.php'; $intNum = 1; $intnumber = 1; while( $info = mysql_fetch_array( $sqll )){ echo "<input type='hidden' name=\"Que_ID\" value=\"{$info['Que_ID']}\" /> "; echo " $intNum, {$info['Que_Question']} <br />\n"; $intNum++; for ($i =1; $i < 5; $i++) { echo "<input type=\"checkbox\" name=\"choice[{$info['Que_ID']}.$i][]\" />{$info['Que_Choice'.$i]}<br />\n"; $intnumber++; } } ?> <input type="submit" value="submit" name="submit"> This is my form that can output the Question and its choices. I am echoing this on to the next page, the code is shown below Code: [Select] <?PHP session_start(); $name= $_SESSION['username1']; echo "User ID: $name <br/>"; $gender = $_POST["choice"]; $que_ID = $_POST["Que_ID"]; foreach ($gender as $key => $array) { if($array) { $val=1; } ///echo "Question ID and the choice ID:$key. Value is:.$val <br />\n"; $well = array(floor($key), substr(strstr($key, '.'), 1)); //$well = array(floor($key), $key - floor($key)); echo "Question ID: $well[0], "; echo "Choice: $well[1]. value: $val<br/>"; } //}break; ?> Now, instead of echoing. I just want to add this to mysql. The layout of my sql is Que_ID, Ans_Choice1, Ans_Choice2, Ans_Choice3, Ans_Choice4, Use_ID When I echo my php my outcome is Quote User ID: 2 Question ID= 1 Choice 1 Question ID= 2 Choice 3 Question ID= 3 Choice 4 Question ID= 4 Choice 1 Afternoon Freaks, I'm trying to add up certain variables inside an array, and keep going around in circles. The array is the result of a mysql SELECT query. I select the contents of a database table, then extract them in php using the following code: Code: [Select] while ( $row = mysql_fetch_assoc($result)) { extract($row); } var_dump($row) outputs the following: Quote Array ( [var1] => 1193 [var2] => 799 [var3] => 805 [var4] => 0.992547 [var5] => 2010-12-20 [var6] => 20 ) Array ( [var1] => 1193 [var2] => 725 [var3] => 725 [var4] => 1 [var5] => 2010-12-20 [var6] => 20 ) Array ( [var1] => 1193 [var2] => 818 [var3] => 850 [var4] => 0.962353 [var5] => 2010-12-20 [var6] => 20 ) Array ( [var1] => 1194 [var2] => 819 [var3] => 860 [var4] => 0.952326 [var5] => 2010-12-20 [var6] => 21 ) Array ( [var1] => 1194 [var2] => 829 [var3] => 870 [var4] => 0.952874 [var5] => 2010-12-20 [var6] => 21 ) Array ( [var1] => 1194 [var2] => 831 [var3] => 870 [var4] => 0.952874 [var5] => 2010-12-20 [var6] => 21 ) What I want is to add up all the var2 values for each var1. e.g., in the case of var1=1193, this would be 799 + 725+ 818. Of course, there are nearly 2,000 var1s (each one with multiple var2s), and I want my computer to do all the work. So I'm trying to isolate each var1 so I can figure out some loop to do this operation. I've tried a bunch of funny little tricks with min(), but keep going in circles. Any ideas? I am an ASP.NET developer and I have to call a soap methed written in PBP that takes an argument required an associative array such as $prices = array( 'Tires'=>'test1', 'Spark Plugs'=>'test2' ); can yoiu tell me what the internal representation is of the above I have a php search page that takes form data to create its queries, then reload the original search page. The form is long, so there are numerous $_POST's to convert to variables for use in the query. I've looked at "extract" and a few other code snippets. But it's a form and I don't want any security issues. I'm hoping there's a "foreach" solution, but I'm a beginner. What's a proper way to to simplify this: $s1 = $_POST["s1"]; $s2 = $_POST["s2"]; $s3 = $_POST["s3"]; $s4 = $_POST["s4"]; $s5 = $_POST["s5"]; $s6 = $_POST["s6"]; $s7 = $_POST["s7"]; $s8 = $_POST["s8"]; $s9 = $_POST["s9"]; $s10 = $_POST["s10"]; $s11 = $_POST["s11"]; $s12 = $_POST["s12"]; I have this array of items in my php file.
$items = array(
array("id" => 100,"categorypath" => "level1/powders", "product" => "Mens powder"),
array("id" => 200,"categorypath" => "level1/oils/sunflower", "product" => "XYZ oil"),
array("id" => 300,"categorypath" => "level1/eatable/vegetables", "product" => "carrot"),
array("id" => 400,"categorypath" => "level1/oils/sunflower", "product" => "ABC oil"),
array("id" => 500,"categorypath" => "level1/eatable/fruits", "product" => "mango"),
array("id" => 600,"categorypath" => "level1/eatable/vegetables", "product" => "spinach"),
array("id" => 700,"categorypath" => "level2/baby items/toys", "product" => "puzzle block"),
array("id" => 800,"categorypath" => "level2/baby items/toys", "product" => "trucks and cars"),
array("id" => 900,"categorypath" => "level2/baby items/clothes", "product" => "shirts"),
array("id" => 1000,"categorypath" => "level1/powders", "product" => "Womens powder"),
array("id" => 1100,"categorypath" => "level1/oils/groundnut", "product" => "GN oil"),
);
Using the above array I am trying to generate a JSON file that will have the following structu
{
"category":[
{
"categoryName":"level1",
"category":[
{
"categoryName":"powders",
"products":[
{
"id":"100",
"path":"level1/powders",
"prodname":"Mens powder"
},
{
"id":"1000",
"path":"level1/powders",
"prodname":"Womens powder"
}
]
},
{
"categoryName":"oils",
"category":[
{
"categoryName":"sunflower",
"products":[
{
"id":"200",
"path":"level1/oils/sunflower",
"prodname":"XYZ oil"
},
{
"id":"400",
"path":"level1/oils/sunflower",
"prodname":"ABC oil"
}
]
},
{
"categoryName":"groundnut",
"products":[
{
"id":"1100",
"path":"level1/oils/groundnut",
"prodname":"GN oil"
}
]
}
]
},
{
"categoryName":"eatable",
"category":[
{
"categoryName":"vegetables",
"products":[
{
"id":"300",
"path":"level1/eatable/vegetables",
"prodname":"carrot"
},
{
"id":"600",
"path":"level1/eatable/vegetables",
"prodname":"spinach"
}
]
},
{
"categoryName":"fruits",
"products":[
{
"id":"500",
"path":"level1/eatable/fruits",
"prodname":"mango"
}
]
}
]
}
},
{
"categoryName":"level2",
"category":[
{
"categoryName":"baby items",
"category":[
{
"categoryName":"toys",
"products":[
{
"id":"700",
"path":"level2/baby items/toys",
"prodname":"puzzle blocks"
},
{
"id":"800",
"path":"level2/baby items/toys",
"prodname":"trucks and cars"
}
]
},
{
"categoryName":"clothes",
"products":[
{
"id":"900",
"path":"level2/baby items/clothes",
"prodname":"shirts"
}
]
}
]
}
]
}
Not being an expert in php, I have somehow managed to reach thus far in my code, but can not quite arrive at the correct logic. Having trouble with handling associative arrays and objects in php. (Javascripting is much easier I feel) So far I have managed to fix all the errors/warning in my code. Here is my full php code:
$items = array(
array("id" => 100,"categorypath" => "level1/powders", "product" => "Mens powder"),
array("id" => 200,"categorypath" => "level1/oils/sunflower", "product" => "XYZ oil"),
array("id" => 300,"categorypath" => "level1/eatable/vegetables", "product" => "carrot"),
array("id" => 400,"categorypath" => "level1/oils/sunflower", "product" => "ABC oil"),
array("id" => 500,"categorypath" => "level1/eatable/fruits", "product" => "mango"),
array("id" => 600,"categorypath" => "level1/eatable/vegetables", "product" => "spinach"),
array("id" => 700,"categorypath" => "level2/baby items/toys", "product" => "puzzle block"),
array("id" => 800,"categorypath" => "level2/baby items/toys", "product" => "trucks and cars"),
array("id" => 900,"categorypath" => "level2/baby items/clothes", "product" => "shirts"),
array("id" => 1000,"categorypath" => "level1/powders", "product" => "Womens powder"),
array("id" => 1100,"categorypath" => "level1/oils/groundnut", "product" => "GN oil"),
);
$jsonStruct = array();
function jsonCreateStruct(){
GLOBAL $items;
for($c=0; $c<count($items); $c++){
$categ = $items[$c]["categorypath"];
insertJson($categ, $items[$c]);
}
}
function insertJson($catg, $itm){
GLOBAL $jsonStruct;
$exp = explode("/",$catg);
print_r("\n\n\n $catg \n");
if(count($exp) == 1){
print_r("Level 1 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["products"] = array($itm);
print_r("\nCreated:: $exp[0]");
}else{
$notFound = true;
for($j=0; $j<count($jsonStruct); $j++){
$catgName = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName");
if($catgName == $exp[0]){
$notFound = false;
if($jsonStruct[$j]["products"]){
array_push($jsonStruct[$j]["products"],array($itm));
}else{
$jsonStruct[$j]["products"] = array();
array_push($jsonStruct[$j]["products"],array($itm));
}
}
}
if($notFound){
print_r("\nNotFound\n");
array_push($jsonStruct,array("categoryName"=> $exp[0], "products" => array($itm)));
}
}
}
if(count($exp) == 2){
print_r("Level 2 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["categorypath"] = array("categoryName" => $exp[1], "products" => array($itm));
print_r("\nCreated:: $exp[0] / $exp[1]");
}else{
$notFound1 = true;
$notFound2 = true;
$indexLevel = null;
for($j=0; $j<count($jsonStruct); $j++){
$catgName1 = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName1");
if($catgName1 == $exp[0]){
$notFound1 = false;
$indexLevel = $j;
if(isset($jsonStruct[$j]["categorypath"])){
$level1 = $jsonStruct[$j]["categorypath"];
for($m=0; $m<count($level1); $m++){
if(isset($level1[$m]["categoryName"])){
$catgName2 = $level1[$m]["categoryName"];
print_r("\nFound: $catgName2");
if($catgName2 == $exp[1]){
$notFound2 = false;
if($level1[$m]["products"]){
array_push($jsonStruct[$j]["categorypath"][$m]["products"],array($itm));
}else{
$jsonStruct[$j]["categorypath"][$m]["products"] = array();
array_push($jsonStruct[$j]["categorypath"][$m]["products"],array($itm));
}
}
}
}
}
}
}
if($notFound1){
print_r("\nNotFound1\n");
array_push($jsonStruct,array("categoryName"=> $exp[0], "categorypath" => array("categoryName" => $exp[1],"products" => array($itm))));
}else if($notFound2){
print_r("\nNotFound2\n");
// $jsonStruct[$indexLevel]["categorypath"] = array("categoryName"=> $exp[1], "products" => array($itm));
$jsonStruct[$indexLevel]["categorypath"] = array();
array_push($jsonStruct[$indexLevel]["categorypath"], array("categoryName"=> $exp[1], "products" => array($itm)));
}
}
}
if(count($exp) == 3){
print_r("Level 3 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["categorypath"] = array("categoryName" => $exp[1], "categorypath" => array("categoryName" => $exp[2], "products" => array($itm)));
print_r("\nCreated:: $exp[0] / $exp[1] / $exp[2]");
}else{
$notFound1 = true;
$notFound2 = true;
$notFound3 = true;
$indexLevel1 = null;
$indexLevel2 = null;
for($j=0; $j<count($jsonStruct); $j++){
$catgName1 = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName1");
if($catgName1 == $exp[0]){
$notFound1 = false;
$indexLevel1 = $j;
if(isset($jsonStruct[$j]["categorypath"])){
$level2 = $jsonStruct[$j]["categorypath"];
for($m=0; $m<count($level2); $m++){
if(isset($level2[$m]["categoryName"])){
$catgName2 = $level2[$m]["categoryName"];
print_r("\nFound: $catgName2");
if($catgName2 == $exp[1]){
$notFound2 = false;
$indexLevel2 = $m;
if(isset($level2[$m]["categorypath"])){
$level3 = $level2[$m]["categorypath"];
for($n=0; $n<count($level3); $n++){
//print_r($level3["categoryName"]);
if(isset($level3["categoryName"])){
$catgName3 = $level3["categoryName"];
print_r("\ncatgName3: ". $catgName3);
if($catgName3 == $exp[2]){
$notFound3 = false;
if($level3["products"]){
print_r("\npushing into array\n");
array_push($jsonStruct[$j]["categorypath"][$m]["categorypath"]["products"],array($itm));
}else{
print_r("\ncreate new and pushing into array\n");
$jsonStruct[$j]["categorypath"][$m]["categorypath"][$n]["products"] = array();
array_push($jsonStruct[$j]["categorypath"][$m]["categorypath"]["products"],array($itm));
}
}
}
}
}
}
}
}
}
}
}
if($notFound1){
print_r("\nNotFound1\n");
array_push($jsonStruct, array("categoryName"=> $exp[0], "categorypath" => array("categoryName" => $exp[1],"products" => array($itm))));
}else if($notFound2){
print_r("\nNotFound2\n");
if(!$jsonStruct[$indexLevel1]["categorypath"]){
$jsonStruct[$indexLevel1]["categorypath"] = array();
}
array_push($jsonStruct[$indexLevel1]["categorypath"], array("categoryName"=> $exp[1], "categorypath" => array("categoryName" => $exp[2], "products" => array($itm))));
}else if($notFound3){
print_r("\nNotFound3\n");
//$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"] = array("categoryName"=> $exp[2], "products" => array($itm));
if(!$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"]){
$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"] = array();
}
array_push($jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"], array("categoryName"=> $exp[2], "products" => array($itm)));
}
}
}
}
jsonCreateStruct();
print_r("----------------------------------------");
print_r($jsonStruct);
// echo json_encode($jsonStruct);
I have now reached a point where I desperately need help from experts.
I have this code Code: [Select] $nArr = array('A', 'B', 'C', 'D', 'E', 'F'); $counter = 3; while ($counter > 0) { $chunkedValues[$counter][0] = 1; for ($j = 0 ; $j < $counter ; $j++) { $chunkedValues[$counter][$j + 1] = $nArr[$j]; } $nArr = array_slice($nArr, $counter--); } var_dump($chunkedValues); that outputs: Code: [Select] array 3 => array 0 => int 1 1 => string 'A' (length=1) 2 => string 'B' (length=1) 3 => string 'C' (length=1) 2 => array 0 => int 1 1 => string 'D' (length=1) 2 => string 'E' (length=1) 1 => array 0 => int 1 1 => string 'F' (length=1) But i need this index structu Code: [Select] array 0 => array 0 => int 1 1 => string 'A' (length=1) 2 => string 'B' (length=1) 3 => string 'C' (length=1) 1 => array 1 => int 1 2 => string 'D' (length=1) 3 => string 'E' (length=1) 2 => array 2 => int 1 3 => string 'F' (length=1) I want to avoid loops with ceil. Any idea? thanks for your time. Hi I have an array of items that I am currently displaying a foreach loop What I'm looking to do, is add a string, to all of items, a part from the last 4: foreach ($pager->getResults() as $items => $item) { echo $item->getName(); //need to add a string to this for the all but the last 4 } Thanks This topic has been moved to Other Libraries and Frameworks. http://www.phpfreaks.com/forums/index.php?topic=354411.0 When having different levels of directories, using relative paths will not work anymore, for example: controller - authentication File 1: include('../../model/header.php') model File 2: header.php view File 3. style.css The header.php file includes the css file with a relative path, but the problem is it includes it as follows: ../view/style.css When now the header.php file gets included into File 1 in the folder "authentication", then the css file will not be accessible anymore, for it to be accessible you would have to go two directories up. In this sense my question is, what would be the proper path structure for a folder structure with multiple levels? Should I rather use absolute paths, I am not so prone of absolute path. What if the folders changes a bit, or the domain changes, or the location changes? I'm having an issue with a server I inherited. I have two files. The first file queries a mysql database and returns a table to the user. The second file uses phpexcel and php html dom parser to read the table and export the results to excel. I have it working with a small test page i created to test my code, but when I try to incorporate it into the inherited pages, it doesn't work. I think it's because of issues with validating the session or something of that nature, but I'm not sure, and I'm not sure how to fix it. The following are the two pages that I'm trying to get working together. View Tables Code: [Select] <?php session_start(); //Start the session. //if no session value is present, redirect the user: if(!isset($_SESSION['idUser'])) { require_once('includes/login_functions.inc.php');//Need the functions to create an absolute URL: $url = absolute_url(); header("Location: $url"); exit(); //Quit the script. } //******************************************************* $page_title = 'View Tickets'; include ('includes/header.html'); include ('includes/tdformatting_functions.inc.php'); require_once('mysqli_connect.php'); include ('includes/calstyle.css'); ... code to generate table via mysql/php ... //when clicked this link should open OutputToXL.php and create an Excel file with contents from current page. echo '<td><a href="../Test/OutputToXL.php?host='.$_SERVER['HTTP_HOST'].'&page='.$_SERVER['PHP_SELF'].'" target="_blank"><img src="images/exexcel.png" width="80" height="17" title="Export to Excel."></a></td>'; ?> Output to Excel Code: [Select] <?php session_start(); //Start the session. //if no session value is present, redirect the user: if(!isset($_SESSION['idUser'])) { require_once('includes/login_functions.inc.php');//Need the functions to create an absolute URL: $url = absolute_url(); header("Location: $url"); exit(); //Quit the script. } $page_title = 'New Excel'; include ('includes/header.html');//This Header comes out correctly, so I believe the authentication is working at this point include ('includes/tdformatting_functions.inc.php'); require_once('mysqli_connect.php'); include ('includes/calstyle.css'); /** Include path **/ ini_set('include_path', ini_get('include_path').'../Utility/File/Excel/Classes/'); /** PHP Simple HTML DOM Parser */ include ('../Test/simplehtmldom/simple_html_dom.php'); /** PHPExcel */ include ('../Utility/File/Excel/Classes/PHPExcel.php'); /** PHPExcel_Writer_Excel2003 */ include ('../Utility/File/Excel/Classes/PHPExcel/Writer/Excel5.php'); //Create new PHPExcel object echo date('H:i:s') . " Create new PHPExcel object <br>\n"; $objPHPExcel = new PHPExcel(); // Set properties echo date('H:i:s') . " Set properties <br>\n"; $objPHPExcel->getProperties()->setCreator("Roy Jacob"); $objPHPExcel->getProperties()->setLastModifiedBy("Roy Jacob"); $objPHPExcel->getProperties()->setTitle("Office 2003 XLS Test Document"); $objPHPExcel->getProperties()->setSubject("Office 2003 XLS Test Document"); $objPHPExcel->getProperties()->setDescription("Test document for Office 2003 XLS, generated using PHP classes."); //Thes variables are passed from the page I want to export $host = $_GET['host']; $page = $_GET['page']; $urlfile = 'http://' . $host . $page; echo $urlfile . '<br>'; $html = file_get_html($urlfile); //this is a test echo which I find a problem with. The page that is put into $html is not the same one that is being processed below. Below it's processing login.php instead of the passed page above. foreach($html->find('a') as $element) echo $element->href . '<br>'; // Add some data echo "<br>" . date('H:i:s') . " Adding Table data <br>\n"; $objPHPExcel->setActiveSheetIndex(0); //Parse Entire Table into Rows echo "<br>" . date('H:i:s') . " Parsing Table <br>\n"; //$tablematch = preg_match_all('/<tr(\s*?)(.*?)(\s*?)(.*?)(\s*?)<\/tr>/',$stringresults,$trs); $nextrow = 1; $nextcol = 0; foreach($html->find('table#results') as $resultstable) { foreach($resultstable->find('tr') as $row) { foreach($row->find('th') as $header) { $hcell = $header->plaintext; echo $hcell . ": " . $nextrow . ", " . $nextcol . "<br>\n"; $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($nextcol,$nextrow, ($hcell)); $nextcol++; } $nextcol = 0; foreach($row->find('td') as $Cells) { $dcell = $Cells->plaintext; echo $dcell . ": " . $nextrow . ", " . $nextcol . "<br>\n"; $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($nextcol,$nextrow, ($dcell)); $nextcol++; } $nextrow++; } } // Rename sheet echo date('H:i:s') . " Rename sheet <br>\n"; $objPHPExcel->getActiveSheet()->setTitle('HTMLTableOutput'); // redirect output to client browser echo date('H:i:s') . " Write to Excel2003 format <br>\n"; header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="Output.xls"'); header('Cache-Control: max-age=0'); $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); $objWriter->save(str_replace('.php', '.xls', __FILE__)); //$objWriter->save('php://output'); // Echo done echo date('H:i:s') . " Done writing file. <br>\r\n"; //} ?> I don't know where the problem is originating, but I'm assuming the function is being redirected to the log in page of the site instead of the referring page. Anyone know how to fix this? Hi, A piece of software I'm using an array is made that looks like the following: Code: [Select] [["Select","Vehicle",0.142933,[0.15,0.4,0.05,0.01]]] How would I be best parsing it so: Square brackets currently showing an array becomes an array within PHP Text strings surrounded by "quotations" lose the quotation mark when stored in the PHP array Numbers remain as values in the PHP array The arrays can become quite large, so which would be the best way to go about it? Regards, Jason I have my array like so Code: [Select] $inaque = array("'$dir'"=>"'$company'"); When I run Code: [Select] print_r($inaque); It shows like Code: [Select] Array ( ['share_what_you_want'] => 'Share What You Want' ) How can I get this array to print out like Code: [Select] array ( 'share_what_you_want' => 'Share What You Want' ) Without the [ ] This is the format that is needed for this code that has already been written by somebody else. Thanks in advance What is the name for this Array Format... Code: [Select] $resultsArray[] = array('questionID' => $questionID, 'question' => $question, 'answer' => $new_answer, 'DB_answer' => $old_answer, 'message' => $message[$q]); And does this have anything to do with Object-Oriented Programming?! Thanks, Debbie What I' trying to do is take my array Code: [Select] $stores = array("name"=>"$MktName","address"=>"$address"); And for each each value, insert it into my db Code: [Select] foreach($stores as $k => $v){ mysql_query("INSERT INTO stores (name, address) VALUES('$k', '$v' ) ") or die(mysql_error()); } Now, I'm just learning more about arrays, and this is obviously wrong How do I go about getting the value of "name"? It pulls the value for "address". Thanks in advance Hi, I have an array: Code: [Select] Array ( [0] => index.php [1] => Home [2] => page.php?id=23 [3] => Page ) How would I loop through it so I can link the previous value to the next value within the array e.g.: Code: [Select] <a href="index.php">Home</a> <a href="page.php?id=23">Page</a> I have the following foreach statement that gets the error msg's from the array called errors. However for the last key in the array, i would not like the <br /> to be echo'd out. How can I achieve that? Code: [Select] foreach ($errors as $msg) { echo $msg; echo "<br />"; } |
|||||||