PHP - Creating Links & Including Variables Simple Xml

I need to extract shopping cart transaction information from a database, convert it to json format and send to another DB.  Because the fields are not a direct match the calculated values are first bing put into variables.  I'm extracting the line items from the database into an array and looping through the array to get each line item which I want to then insert into another array as a sub array.  By the way, I'm new at PHP so be gentle.  The first step I've coded as:

Code: [Select]
foreach ($oit_array as $inner1) {

    //  Check type
    if (!is_array($inner1)) {$inner1 = array($inner1);}
       $lineprice+=$inner1[orderitem_price];
 
//calculate amounts required in variables

  $linepriceinc=$inner1[orderitem_price]+($inner1[orderitem_tax]/$inner1[orderitem_quantity]);
 if($inner1[orderitem_tax]==0){$linetaxrate+=0;}
  else $linetaxrate=($inner1[orderitem_final_price]-$inner1[orderitem_tax])/$inner1[orderitem_tax];
  $linetaxtotal+=$inner1[orderitem_tax];
  $orderqty+=$inner1[orderitem_quantity];
  $productname=$inner1[orderitem_name];
  $qtyshipped+=$inner1[orderitem_quantity];
 $totallineamount+=$inner1[orderitem_final_price]-$inner1[orderitem_tax];
  $totallineamountinc+=$inner1[orderitem_final_price];
  $unitofmeasure="Units";
   
             
             $linearray[] = array("LinePrice"=>$lineprice,
                                                      "LinePriceInc"=>$linepriceinc,
                                                      "LineTaxCode"=>"GST",
                                                      "LineTaxRate"=> $linetaxrate,
                                                      "LineTaxTotal"=>  $linetaxtotal,
                                                      "OrderQty"=>  $orderqty,
                                                      "ProductName"=> $productname,
                                                      "QtyShipped"=> $orderqty,
                                                      "TotalLineAmount"=> $totallineamount,
                                                      "TotalLineAmountInc"=>$totallineamountinc,
                                                      "UnitOfMeasure"=>"Units");
I then reference the array as $linearray as follows:

Code: [Select]
//Create Array
  $salesarray=
 array ("type"=> "TCashSale",
       "fields"=>array ("CustomerName"=>$customername,
               "ShipToDesc"=>$shiptodesc,
               "Lines"=> array("type"=> "TCashSaleLine",
                        "fields"=> $linearray)),
                              "SalesPayments"=>array("type"=>"TSalesPayments",
                                       "fields"=>array("Amount"=> $amount,
                                                  "PayMethod"=> $paymentmethod)));
The problem that I have is that the resulting array contains square brackets around the "linearray" data like so:

Code: [Select]
{"type":"TCashSale","fields":{"CustomerName":"Cash Customer","ShipToDesc":"Rod Farrell\n\r1234 Short St\n\r\n\rSlackville Queensland 4001","Lines":{"type":"TCashSaleLine","fields":[{"LinePrice":54.54545,"LinePriceInc":54.54545,
What am I doing wrong??

Hi there

I've been working with some code to display a single
record on page. This all works fine and I'm able to pull what I
want from the database. My problems is trying to use that
data and turning it into something else like a link.

I have a field in the database called image url which
contains rows of image urls.

So here is the problem area of the code:

Code: [Select]
<?php
//////Displaying Data/////////////
$id=$_GET['id']; // Collecting data from query string
if(!is_numeric($id)){ // Checking data it is a number or not
echo "Data Error";
exit;
}

$fetch=mysql_query("select * from productfeeds where ProductID=$id ");
$row=mysql_fetch_object($fetch);
echo mysql_error();
echo "<table>";
echo "
<tr><td><b>ProductID</b></td><td>$row->ProductID</td></tr>
<tr><td><b>ProductName</b></td><td>$row->ProductName</td></tr>
<tr><td><b>ProductPrice</b></td><td>$row->ProductPrice</td></tr>

//problem area for me
<tr><td><b>Image</b></td><td>$row->ImageURL</td></tr>
echo "</table>";
I'm trying to edit this part of the code:

<tr><td><b>Image</b></td><td>$row->ImageURL</td></tr>

I've tried this:

<tr><td><b>Image</b></td><td><a href='{$row['URL']}'> <img src='{$row['ImageURL']}'></a>

and

<tr><td><b>Image</b></td><td><a href='$row['URL']'> <img src='$row['ImageURL']'></a>  //removed brackets

but I'm just getting errors. Can you guys help please?

Thank you very much.

Hello,

I am completely new to php so please forgive me ahead of time. I am trying to create a link button on a website for a client that only directs to a certain external website on certain days and hours. Specifically, this is a web radio button that the client only wants to link to the web radio site when their live broadcast is on the air during certain hours on the weekend (i.e. Sundays 8-10 PM). Any other time, the client wants the web radio button to link to a default page since the web radio station plays unrelated music all other hours of the week. Does anyone know the best way to create such a time sensitive link for a button on a webpage?

Thanks.

ok, I'm not sure I know how to ask this question, but I've created a table that allows the user to add rows. The problem is, upon submit only the last row creates variables. How can I make sure every cell in every row sets a different variable?

This is going to be a purchase order system.

Here is my code:
Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Insert Table Row using DOM</title>
<script language="javascript">
function addRow()
{
var tbody = document.getElementById("po_table").getElementsByTagName("tbody")[0];
var row = document.createElement("TR");
var cell1 = document.createElement("TD");
var cell2 = document.createElement("TD");
var cell3 = document.createElement("TD");
var inp1 =  document.createElement("INPUT");
inp1.setAttribute("type","text");
inp1.setAttribute("name","quantity");
cell1.appendChild(inp1);
var inp2 =  document.createElement("INPUT");
inp2.setAttribute("type","text");
inp2.setAttribute("name","description");
cell2.appendChild(inp2);
var inp3 =  document.createElement("INPUT");
inp3.setAttribute("type","text");
inp3.setAttribute("name","unit_cost");
cell3.appendChild(inp3);
row.appendChild(cell1);
row.appendChild(cell2);
row.appendChild(cell3);
tbody.appendChild(row);
//alert(row.innerHTML);
}
</script>
</head>
<body>
<form method="post" action="review_po.php">
<table id="po_table" border="1">
<tbody>
<tr>
<th bgcolor="#c1c1c1">Quantity</th>
<th bgcolor="#c1c1c1">Description</th>
<th bgcolor="#c1c1c1">Unit Cost</th>
</tr>
<tr>
<td><input type=text name="quantity"></td>
<td><input type=text name="description"></td>
<td><input type=text name="unit_cost"></td>

</tr>
</tbody>
<tfoot>
<tr>
<th bgcolor="#e0e0e0">1</th>
<th bgcolor="#e0e0e0">Shipping</th>
<td><input type=text name="shipping"></td>

</tr>
<tr>
<th bgcolor="#e0e0e0">1</th>
<th bgcolor="#e0e0e0">Tax</th>
<td><input type=text name="tax"></td>

</tr>
</tfoot>
</table>
<input type="button" value="Insert Row" onClick="addRow();">
<input type="submit" value="Review" name="review_po">
</form>


</body>
</html> 
right now it goes to this page:

Code: [Select]
<?php

//convert to variables
$quantity = $_POST['quantity'];
$description = $_POST['description'];
$unit_cost = $_POST['unit_cost'];
$extended_cost = $_POST['extended_cost'];
$shipping = $_POST['shipping'];
$tax = $_POST['tax'];

?>

<?php echo $quantity; ?><br>
<?php echo $description; ?><br>
<?php echo $unit_cost; ?><br>
<?php echo $extended_cost; ?><br>
<?php echo $shipping; ?><br>
<?php echo $tax; ?><br>

here is the page:
http://po.shopphgmag.com/create_po.html

Thanks for looking

Hi Everyone,

I'm semi-new to php and trying to create a site where I have only one includes file for my navigation (main_nav.inc) and 2-3 includes files (main_template.inc) that act as templates. I then call the the nav and the template in my index.php file.

Everything was working fine until I decided I should use php have my links appear active depending on which page the user is on. Everything works totally fine if I insert the code for my nav (including both the html and php) into my main_template.inc file but when I make that code into it's own includes file (main_nav.inc), I get an error.

I believe the issue is with using both single and double quotes in my code and wrapping that code in single quotes in my main_nav.inc file.

Here is the code from my main_nav.inc file:


   <?php
   
   $main_nav = '

      <div id="mainNav"><ul id="mainNav">
<li><a href="index.php" <?php if ($page=='index.php') { ?> class="active" <?php } ?>>Welcome</a></li>
<li><a href="healthcare.php" <?php if ($page=='healthcare.php') { ?> class="active" <?php } ?>>Healthcare</a></li>
      </ul></div>

   '; // end main_nav
   
   ?>

I think that since the code is wrapped in single quotes, I can only use double quotes in my code. This is the only difference I can figure out between inserting the code into the template directly (which works perfectly fine) and inserting it as a separate inc file. When I use the main_nav.inc file I get the following error:
Parse error: syntax error, unexpected T_STRING in /home/content/k/a/l/kalilaks3/html/includes/main_nav.inc on line 11

I tried changing the quotes around ($page=='index.php') to ($page=="index.php") but that causes the browser to literally read the name of the link a class="active">Welcome

I also tried variations of escaping quotes such as ($page==\"index.php\") and even escaping the other quotes and wrapping everything in double quotes as opposed to single quotes.


Here is my code for my main_template.inc file

<?php

   $page = basename($_SERVER['SCRIPT_NAME']);
   $page_title = "Welcome";

   include_once ("includes/main_nav.inc"); // sets variable
   include_once ("home_template.inc"); // sets all variables

   ?>

And here is my index.php file:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>   
   <meta content="healthcare" name="keywords"></meta>
   <meta content="healthcare" name="description"></meta>
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
   <title><?php echo $page_title; ?></title>
   <link rel = "stylesheet" href = "_css/layout.css"></link>
   <script type="text/javascript" src="scripts/script.js"></script>
</head>
<body>   
<div id = "header"><div id = "globalHeader">
      
      <?php echo $main_nav; ?>

</div></div>
</body>
</html>


Any help or suggestions would be greatly appreciated!!! I would love to get this figured out so that I only have to create my navigation once for all my sites!

helloi'm desperately trying to create a simple chatbox for my website using php and whateverthe logged in user posts to there box then gets wrote to a sql database called km_babble and
then displayed in the room for others to read.  the max number of posts per box should be like
15 or so .. can someone assist me or lead me to docs that will help?

thanks much in advance

OK, here it is.  I have been trying to do this myself, but it has been driving me insane and I turn to professionals here for help.   I am a basic web developer for a company that I work for in other capacities. I have a reasonable understanding of HTML and that is about where my expertise ends. I am not typically a programmer, just a simple (extremely) part time designer that uses Muse and Dreamweaver when necessary.   However, recently my company has asked me to accomplish a task for their website. In plain English, they want a large database that exists currently as a CVS file made into a searchable web page.  It is 21 columns by approximately 6,700 rows.   To explain what I need a little more technically, here are my ideas and where I have gotten to so far:   1. The company uses godaddy, into which I *believe* I have successfully imported the spreadsheet. I believe it is successful because through godaddy's SQL Control Panel (phpMyAdmin console), I can do the EXACT searches that the company needs, and it spits out the EXACT results that I need.   2. The end result needs to be a .php that I can upload to the website's root folder that can be then inserted into premade pages using:

<iframe src="SMQ.php" scrolling="yes" width="950" height="800"></iframe>

3. On the .php page, I need to have a way to log in to the SQL server and a simple search box built in that will allow the user to input a very simple search string consisting of no more than 4 numbers and 3 letters at a time. No buttons, no check boxes, just a search box.   3. This query then needs to be output as a nice data table, similar to this: This in fact is a screenshot of a search I performed out of my SQL database, in phpMyAdmin using the column "Scott" for the search, and the number 226 as the search term. All column names are visible with the exception of the first column, entitled LINEID, made to be the key, and the output should not include the key but have everything else as above.   4. I can see what the simple line of php is that performed this task:

SELECT * FROM `SMQSQL` WHERE `Scott` = '226' ORDER BY `LINEID` ASC 

but I can't figure out how the hell to get this incorporated to a .php search.   To sum it up, I need a .php page written that can connect to a SQL database, perform a data based search, and spit out a clean table when it is done.   I had accomplished this in the past using an import into google docs and using it to perform a search and result display via the following code built into a php called SMQ.php:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Example of Google Spreadsheet Data Visualisation</title>
</head>

<body>

<form id="form1" method="post" action ="<?php echo $_SERVER['PHP_SELF']; ?>"> <label>
<input id="search" name="search" type="text" />
</label>
<label>
<input id="Scott #" name="Scott #" type="submit" value="Scott #" />
</label>

<img src="loading.gif" width="16" height="11" />
</form>
<p>
<?php
$search= $_REQUEST['search'];
if ($search > ''){ $search = $search;} else { $search = '';}
?>
<script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load('visualization', '1', {packages: ['table']});
</script>
<script type="text/javascript">
var visualization;
function drawVisualization() {

var query = new google.visualization.Query(
'https://docs.google.com/spreadsheet/ccc?key=0AronCwm9QPefdGpIUllscGgtLUJod2pOazc0bjU0cUE&usp=sharing');

query.setQuery('SELECT A, B, C, D, E, F, G, H, I, J, K, L, M, N, O ,P ,Q ,R ,S ,T WHERE (A) LIKE ("<?php echo $search; ?>") order by A asc label A "Scott #", B "Den", C "Color", D "Cond", E "40", F "60", G "70", H "70J", I "75", J "75J", K "80", L "80J", M "85", N "85J", O "90", P "90J", Q "95", R "95J", S "98", T "98J"');
query.send(handleQueryResponse);
}

function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + '' + response.getDetailedMessage());
return;
}

var data = response.getDataTable();

    visualization = new google.visualization.Table(document.getElementById('table'));
    visualization.draw(data, { page: 'enable', page: 16, pageSize: 16, legend: 'bottom'});
}
google.setOnLoadCallback(drawVisualization);
</script>

 <div id="table"></div>

</div>

</body>
</html>

But as you can see, this may not be the most secure thing in the world, plus we want to be able to expand it in the future and not be so simplistic, hence the need to switch to SQL.   Please let me know right away by contacting me at disead@gmail.com if this is something YOU might be able to help with. I'm sure for an experienced programmer, once you have the details from me that you need, it would take maybe 10 minutes to write. I don't have much, but I can pay a little bit for this one time job. If it ends up working out, I may be able to pay more down the line for more advanced options such as being able to do drop-down searches based on the column titled "ISSUE", as well as more things down the line as it grows.   Thank you so much, I hope to hear from someone soon!!!

Hi. I am trying to create a simple video file server. I finished the skeleton of it but when it came to creating the multitude of pages I realized that there could be an easier way to do it.   I started out basically getting the folder names in the server then printing them on the page.

<?php
$dirs = glob("*", GLOB_ONLYDIR);
echo '<ul>';
foreach($dirs as $dir)
{
	$forbidden_folders = array("not4u", "ignore", Styles);
	$filename = str_replace($forbidden_folders, '', $dir);
	if (!empty($filename))
	{
    echo '<li><a href="'.$dir.'">'.$dir.'</a></li>';
	}
}
echo '</ul>'
?>

Then I created in each of the folders with files a php file with this code:

<?php

function date_sort_desc($a, $b)
{
  preg_match('/\w+ \d{4}/', $a, $matches_a);
  preg_match('/\w+ \d{4}/', $b, $matches_b);
  $timestamp_a = strtotime($matches_a[0]);
  $timestamp_b = strtotime($matches_b[0]);
  if ($timestamp_a == $timestamp_b) return 0;
  return $timestamp_a < $timestamp_b;
}

$files = array();
$dir = opendir('.');
while(false != ($file = readdir($dir))) {
        if(($file != ".") and ($file != "..") and ($file != "index.php")) {
                $files[] = $file;
        }   
}

natsort($files);

$i = 0;
foreach($files as $file) {
$i++;
$string = str_replace("TV Show Name S1 E$i - ", '' , $file);
        echo '<div><a href="../Discriptions/'.$file.'.php">'.basename($string, '.m4v').'</a></div><br>';
}
?>

This opens up a php file with the same file name as the file to be played containing the episode's thumbnail and description. That file then contains a link pointing back to the real file. The problem here is that I'd have to make a new php file for every file in my collection. I'm wondering if there's somehow a way to simplify all of this.
Edited by chrisyroid, 11 August 2014 - 12:13 AM.

What's the best way to cache things on the server? I've found some SetEnv things but this all seems to be a single key/value.   I'd like to cache an array of things that I can access later. Right now it's cached in $_SESSION which is fine, but still there's overhead on every first-time visitor to a site. Is there a way to add something to $_SERVER or elsewhere that ALL visitors to a website will ultimately be able to access?   I guess I want something like web.config in C#, where the first time a page is visited, the "app starts", as it were, and those things are now in cache on the server.   What's the best way to do this?

I messed around with a simple pagination script I found online. I'm still diving in and breaking it down to try and understand it better but I also was planning to have a "next" and "previous" link instead of just echoing out page numbers.

I know I'll have to come up with some $pg+1 or $pg-1 function but how do I find out what $pg is currently on?

function showSubmissions(){

$max = 9; // number of news entries per page
$pg = $_GET['pg'];

if(empty($pg))
{
$pg = 1;
}

$limits = ($pg - 1) * $max; 

//view all the news articles in rows
$q = mysql_query("SELECT * FROM submissions WHERE approved='YES' ORDER BY postdate DESC LIMIT " . $limits . ", $max") or die(mysql_error());
//the total rows in the table
$totalres = mysql_result(mysql_query("SELECT COUNT(id) AS tot FROM submissions"), 0);
//the total number of pages (calculated result), math stuff...
$totalpages = ceil($totalres / $max); 



// BEGIN PAGINATION
print '
<div class="paginationList">
<ul class="pgList">
<li><img src="images/icon_prevresult.png" title="" alt="" /></li>';

for($i = 1; $i <= $totalpages; $i++)
{ 
//this is the pagination link
print '<li><a href="submissions.php?pg=' . $i . '">' . $i . ' </a></li>';
}


print '
<li><img src="images/icon_nextresult.png" title="" alt="" /></li>
</ul>
</div>';
// END PAGINATION


// PRINT RESULTS
while($row = mysql_fetch_array($q))
{
$id = $row['id'];
$name = stripslashes($row['name']);
$email = $row['email'];

print '
<div class="sub-thumb-wrapper">
<div class="sub-thumb-user">
<div class="ps-name"><p class="sub-label">NAME:</p><a href="mailto:' . $email . '">' . $name . '</a></div>
</div>
</div>' . "\n";
}
// END PRINT RESULTS

}

Sorry for my noob question, I've learned about sessions a bit and tried to make a simple "game", basically a user has to enter one of the colors of the rainbow and after they name all 7, they win. Sounds simple enough, but I'm clearly making an obvious mistake and I've googled and read and experimented, but obviously something is alluding me.

Here is the pastebin:
http://pastebin.com/XmN4YLp8


I suppose what I want to know is...how do I store the values from the form (that is, $_POST['color']) and save that information to something like an array, because whatever I'm doing now is resetting the counter ($_SESSION['left']) and if a user guesses "red" for instance, it temporarily goes from 7 to 6, but then bumps up to 7?

Hello:

I wanted to see if someone can help me figure out how to include data from my included navigation file.

Meaning:

I have this file called myNav.php (the database table storing this is "myUpcomingEvents"):
Code: [Select]
function spLeftMenu() {
$spLeftMenu =
"

<div id=\"sideEvents\">
echo \" $mySideBarData; \";
</div>

";
return $spLeftMenu;
}

I am trying to pull it into the Index.php page like this (the database table storing this is "myHome"):
Code: [Select]
<?php
include('include/myConn.php');
include('include/myNav.php');

$query=mysql_query("SELECT * FROM myHome,myUpcomingEvents") or die("Could not get data from db: ".mysql_error());
while($result=mysql_fetch_array($query))
{

  $myPageData=$result['myPageData'];
  
  $mySideBarPageData=$result['mySideBarPageData'];
}

?>

<!DOCTYPE HTML>

<html>

<head></head>

<body>

<div id="siteContainer">


<div id="leftColumn">
<?php echo spLeftMenu(); ?>
</div>

<div id="mainContent">
<?php echo $myPageData; ?>
</div>


</div>

</body>

</html>

Can't get it to work. It just writes out:
Code: [Select]
echo " ; ";

Anyone know how I can get this to work?

Thanks.

Hi everyone.... I have a simple search.php And I want to include that in my html output page.  I tried using

<?php
   include ('search.php');
?> 

Below is my HTML code which is part of a php file...what am I doing wrong here?

Code: [Select]
// Final Output


echo <<<__HTML_END
 
<html>

<head>

<title>Photography</title>

</head>

<body>

<table width='100%' border='0' align='center' style='width: 100%;'>

$result_final 

<?php include("search.php");?>

</table>

</body>

</html>

__HTML_END;

Hey all,

I've a problem with including of my pages.
When I do choose lotto on index.php , I do get the page and also can choose how many roster I want.
But I can't see my lotto results, because it does refresh to the index.php again.
How can I fix this problem ?

this is the code of index.php:
Code: [Select]
<?php
        echo '<table class="achtergrond" border="1">';
        echo '<tr><td colspan="3">';
        /* Keuzelijst tonen */
        echo '<center><form action="'.$_SERVER['php_self'].'" method="POST"><select name="test">';
        echo '<option selected>Kies een formulier</option></center>';
        echo '<option value="1">Lotto</option>';
        echo '<option value="2">Euromillions</option>';
        echo '</select>';
        echo '<button type="submit" name="knop">OK</button>';
        echo '</form>';
        echo '</td></tr>';
            /* Als er op de knop gedrukt is , voer het lottoformulier uit*/
           if(isset($_POST['knop']))
           {
                  echo '<tr><td>';
                  echo $waarde;
                  /* variabel $waarde een waarde insteken via keuzelijst  */
                  switch($_POST['test'])
                  {
                      case 1;
                          include('formulieren/lotto.php');
                      case 2;
                          include('formulieren/euromillions.php');
                  }
                  echo '</td></tr>';
                  echo '</table>';

           }          
        ?>

and this is the code of lotto.php:
Code: [Select]
<?php
    echo '<table class="achtergrond">';
    echo '<tr><td colspan="3">';
    /* Keuzelijst tonen */
        echo '<center><form action="'.$_SERVER['php_self'].'" method="POST"><select name="lotto">';
        echo '<option selected>Kies aantal rooster</option></center>';
        echo '<option value="1">2 roosters</option>';
        echo '<option value="2">4 roosters</option>';
        echo '<option value="3">6 roosters</option>';
        echo '<option value="4">8 roosters</option>';
        echo '<option value="5">10 roosters</option>';
        echo '<option value="6">12 roosters</option>';
        echo '</select>';
        echo '<button type="submit" name="knop1">OK</button>';
        echo '</form>';
    echo '</td></tr>';
    /* Als er op de knop gedrukt is , voer het lottoformulier uit*/
   if(isset($_POST['knop1']))
   {
          /* variabel $waarde een waarde insteken via keuzelijst  */
          switch($_POST['lotto'])
          {
                case 0;
                   $waarde2 = 0;
                   break;
                case 1;
                   $waarde2 = 1;
                   break;
                case 2;
                   $waarde2 = 2;
                   break;
                case 3;
                   $waarde2 = 3;
                   break;
                case 4;
                   $waarde2 = 4;
                   break;
                case 5;
                   $waarde2 = 5;
                   break;
                case 6;
                   $waarde2 = 6;
                   break;
          }...

Okay so we all know

Code: [Select]
<?php

include "theme.html";

print: "Hello";

?>
Would output the theme and output hello at the bottom of the page, my question is, how do you position hello to go on the current theme? Thanks.