PHP - Calling Results Into New Variables

Hello,

I am trying to get a page that shows a list of parts, with their quantities, condition and type.

So parts that are identical are counted as 2, 3 etc if they are the same part, condition and type.

But if one or more parts of the same type has any one of those variables different to the rest, it/they need to come out on a new line with the correct quantity against them.

I have tried using arrays and I can get the quantities working against each part but don't know how to adapt it to achieve what I want.

Here is what I have so far:

// GET ALL THE PARTS FROM THIS **ONE SUPPLIER** AND FIND OUT THE QUANTITIES...

include("../dbconnectlocal.php") ;
$result = mysql_query("SELECT supplier, partNumber, newUsed, jobType, directIndirect, currency, vat, total FROM pourbaskets

  WHERE enquiryRef = '$enqId' AND supplier = '$sSup' ORDER BY

  partNumber DESC")or die(mysql_error()) ;
$quantity = 0 ;
$currentCount = 1 ;

$partQuantityArray = array() ; // The box for our parts against their quantities.
$partsBag = array() ; // For finding out how many unique parts there are later.
$partCount = mysql_num_rows($result) ; // How many parts in total.
while($row = mysql_fetch_assoc($result)) { // While we are going through each part found...

$part = $row['partNumber'] ;

$cond = $row['newUsed'] ;

$jtyp = $row['jobType'] ;

$curr = $row['currency'] ;

$vat  = $row['vat'] ;

$tota = $row['total'] ;

array_push($partsBag, $part) ;

if($partCount == 1) { // Just one part...

$quantity = 1 ;

array_push($partQuantityArray, $part, $quantity) ;

}

if(!$prevItem && $partCount != 1 { // Is the first item and not the only one...

$prevItem = $part ; // Set it to be the previous...

$quantity++ ; // Increase quantity (to 1 now)...

}

elseif($currentCount == $partCount && $partCount != 1) { // If it's the last one in the list and not the only one...

if($prevItem != $part) {

array_push($partQuantityArray, $prevItem, $quantity) ;

$quantity = 1 ;

array_push($partQuantityArray, $part, $quantity) ;

//$prevItem = $part ;

}

elseif($prevItem == $part) { // The final part is the same as the last one...

$quantity++ ;

array_push($partQuantityArray, $part, $quantity) ;

}

else {

array_push($partQuantityArray, $part, $quantity) ;

}

}

elseif($prevItem == $part) { // If the current item is the same as the last item...

$quantity++ ;

// Increase quantity...

}

elseif($partCount != 1) { // If it's a new item and not the only one, store the quantity of the last item, and start at 1...

array_push($partQuantityArray, $prevItem, $quantity) ;

$quantity = 1 ;

$prevItem = $part ;

}

$currentCount++ ;
}
print_r($partQuantityArray) ;exit();

//////////////////// END OF QUANTITY FINDER //////////////////////////////

I have attached what I would like it to come out as.

I'm very new to this and really could use some help. I've got a Web app that has one form that collects data from the user and puts it into a mysql database and has another form that allows the user to select critiera to find records in the database and display them on the page.  All this is working just fine, but now that my database is getting more data in it, I want to add functionality to display 10 records on a page with results page navigation links so the user can move forward and backward in the results set.  This part is not working and I've put in echo statements to figure out what the code is doing.

The problem I'm having is that when the selection critiera pulls more than 10 records from the database, the first page of results is correct per the selection criteria entered by the user on the select form.  When the 'next' link is selected to review the second page of results, the query is executed again.  But this time the form variables have been reset and the results now contains the entire contents of the db.  The start record is set to look at the 11th instance of the results set, so the second page starts with the 11th record in the database instead of the 11th record in the original results set.

The original select statement is built by determining which criteria is selected using $_POST against each form variable.  How can I retain the form variables or the original select statement  so the second execution of the select statement results in the same results set as the first? The other option that may be better is to retain the original results set and avoid re-executing the select statement altogether.  But I don't know how to do that either.  Any suggestions, code samples or adivice is much appreciated!

Hi,

I need to be able to call a class based on variables.  E.G.

I would normally do:
Code: [Select]
$action = new pattern1()
but i would like to be able to do it dynamicaly:
Code: [Select]
$patNum = 1;
$action = new pattern.$patNum.()
Im wondering if that's possible?  If so what would the correct syntax be?

Many Thanks.

does anyone know how to decode this XML variable value into string values? I also need to know the oposite way: creating variable values into xml. I've tried several code examples but they did filter the requested data.

Code: [Select]
$xml='<?xml version="1.0" encoding="utf-8"?>
<elements>
<text identifier="ed9cdd4c-ae8b-4ecb-bca7-e12a5153bc02">
  <value/>
</text>
<textarea identifier="a77f06fc-1561-453c-a429-8dd05cdc29f5">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>]]></value>
</textarea>
<textarea identifier="1a85a7a6-2aba-4480-925b-6b97d311ee6c">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy  eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed  diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.  Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor  sit amet.</p>]]></value>
</textarea>
<image identifier="ffcc1c50-8dbd-4115-b463-b43bdcd44a57">
  <file><![CDATA[images/stories/red/cars/autobedrijf.png]]></file>
  <title/>
  <link/>
  <target/>
  <rel/>
  <lightbox_image/>
  <width><![CDATA[250]]></width>
  <height><![CDATA[187]]></height>
</image>
<text identifier="4339a108-f907-4661-9aab-d6f3f00e736e">
  <value><![CDATA[Kramer 5]]></value>
</text>
<text identifier="ea0666d7-51e3-4e52-8617-25e3ad61f8b8">
  <value><![CDATA[6000 RS]]></value>
</text>
<text identifier="90a18889-884b-4d53-a302-4e6e4595efa0">
  <value><![CDATA[Eindhoven]]></value>
</text>
<text identifier="410d72e0-29b3-4a92-b7d7-f01e828b1586">
  <value><![CDATA[APK Pick up and return]]></value>
</text>
<text identifier="45b86f23-e656-4a81-bb8f-84e5ea76f71f">
  <value><![CDATA[15% korting op grote beurt]]></value>
</text>
<text identifier="3dbbe1c6-15d6-4375-9f2f-f0e7287e29f3">
  <value><![CDATA[Gratis opslag zomerbanden]]></value>
</text>
<text identifier="2e878db0-605d-4d58-9806-8e75bced67a4">
  <value><![CDATA[Gratis abonnement of grote beurt]]></value>
</text>
<text identifier="94e3e08f-e008-487b-9cbd-25d108a9705e">
  <value/>
</text>
<text identifier="73e74b73-f509-4de7-91cf-e919d14bdb0b">
  <value/>
</text>
<text identifier="b870164b-fe78-45b0-b840-8ebceb9b9cb6">
  <value><![CDATA[040 123 45 67]]></value>
</text>
<text identifier="8a91aab2-7862-4a04-bd28-07f1ff4acce5">
  <value/>
</text>
<email identifier="3f15b5e4-0dea-4114-a870-1106b85248de">
  <value/>
  <text/>
  <subject/>
  <body/>
</email>
<link identifier="0b3d983e-b2fa-4728-afa0-a0b640fa34dc">
  <value/>
  <text/>
  <target/>
  <custom_title/>
  <rel/>
</link>
<relateditems identifier="7056f1d2-5253-40b6-8efd-d289b10a8c69"/>
<rating identifier="cf6dd846-5774-47aa-8ca7-c1623c06e130">
  <votes><![CDATA[1]]></votes>
  <value><![CDATA[1.0000]]></value>
</rating>
<googlemaps identifier="160bd40a-3e0e-48de-b6cd-56cdcc9db892">
  <location><![CDATA[50.895711,5.955427]]></location>
</googlemaps>
</elements>';

Hello,

I am having some issues with a project I am working on.
I am calling a php file on another server using
Code: [Select]
<script type="text/javascript" src="http://www.website.com/test/file.php"></script>

I have the correct type header in my php file and the php outputs JS.
example
Code: [Select]
echo "document.write(\"some stuff\");";

that kind of thing happens alot

I also have it outputting a few JS functions,
example
Code: [Select]
echo 'function dostuff(){ stuff }';

the problem I am having is when I add the JS call to the page that calls the php it does nothing
I am using document.ready

I am not really sure where to go from here, I know php well enough to do anything I need but I do not know JS at all

I can not post the actual source code, I know that would be much easier to troubleshoot this but this is something I just can not do.
Also this needs to be done this way, I need to call to php files on another server so they can do some stuff and then use JS to change some things on another page on another server.

This is a content locker, a lot like CPALead and things like that.

What am I missing?

Any help is greatly appreciated

Hi. I have some code which needs to return a single variable from the function and stored as a variable within this page, so it can be echoed later on in the page. I couldn't get it to return as a variable, so i used "return compact();" to return the variable and "extract (myFunction());" to extract it to variables. However, when I turned on php's display errors and error reporting function, I got an error message saying "Warning: extract() [function.extract]: First argument should be an array in /my/web/site/index.php on line 6" (which is where my extract function is). This works fine with passing more than one variables through, is there another way pass one variable from a function to be stored as a variable on the page which called the function?

Here is the function:
Code: [Select]
<?php
//This is a list of numeric error codes against their text. this will return the error code as the variable $issue
function checkLoginIssue() {

//If there is an error code
if (isset($_GET["issue"])) {
 
  //cycle through the list until the code is reached, return the text and break the switch
    switch ($_GET["issue"]) {

      case "1":
              $issue = '<p class="warning">Please log in to view this page</p>';
              break;
  
      case "2":
              $issue = '<p class="warning">Wrong Username or Password</p>';
              break;

        case "3":
              $issue = '<p class="warning">No user found with those details</p>';
              break;

    }
 
 //return the variable in an array with a single value
 return compact('issue');
 
}
 
}
?>
And here is the code which calls the function:
Code: [Select]
<?php
extract(checkLoginIssue());
?>

I define a Javascript in the <head> section of a .php file and call it from the <body> section with the following:
echo "<script language='javascript'>function();</script>".
The function displays a confirm box with the normal Cancel and OK buttons just fine, but I want to capture the function return of true or false for which button was selected.
So far I haven't found a way to get return a value from the function. Any ideas???

i have a database which contains a table named girls with three columns ...Serial(int) name(text) hits(int)

<?php
error_reporting(E_ALL ^ E_NOTICE);
$con = mysql_connect("localhost","gaurav","");
mysql_selectdb("website",$con);
$index1 = rand(1,$count);
$sql = mysql_query("SELECT * FROM girls WHERE Serial=$index1");
$row = mysql_fetch_array($sql);
$name1 = $row['name'];
$hits1 = $row['hits'];

echo <<<ECO
<html>
<script language="javascript">
increment(){
// some php code to increase the hits in database where name = $name1
}
</script>
<input type="button" value="increment" onclick="increment();" name="button">
</html>
ECO;
?>

sorry for the code to be really haphazard..i jst started with php.....now i dont know wat code to put to increment the hits in increment function since it would also use varialble $name1 and $index1.....

I am trying to call a javascript function from a php script.  This is the approach I'm using.  I have an alert in the function, just to confirm the function executes.
Code: [Select]
echo "<script type='text/javascript' src='http://localhost/Project/JScript/File.js'>";
echo "<script type='text/javascript'>functionName();</script>";
Is this the correct approach?

Hi,

I'm currently in the process of making my first website.

The problem is that I'm trying to change the language the website will be in by pressing a button that will call the setlocale() function.
But I can't seem to get it to work. From what I read on the internet you can't use php in javascript because it's serverside. But I can't really think of an alternative way of doing this. Any sugestions?


This is my code btw for what it's worth.


  Code: [Select]
         
                <form action="SetLangEN()" >
                      <input type="image" src="../images/ENflag.jpg" alt= "EN" width="20px"
                   height="15px"  onclick="SetLangEN()" />   
                    </form>
                   
         
                    </form>
                 </div>
             
             <script type="text/javascript">             
             function SetLangEN() {
                <?php   
                 setlocale(LC_ALL, "en_US");  ?> }
             </script>

Hi, I got a little problem with calling a PHP function from a href.
I got my site all set up, and am calling the function like this:

Code: [Select]
<?php echo '<a href="'.changeRecentPosts().'" class="image">' ?>
This does indeed work, but it calls the function every time I refresh my page.. Which isn't the effect I was trying to achieve.

I tried to change it to : Code: [Select]
<?php echo '<a href="#" onClick="'.changeRecentPosts().'" class="image">' ?> But that didn't work either.

It also seems it only calls it when I refresh my page, but never when I click it (I guess because PHP is handeled before HTML or something similar?).

If you can think of any way (even in AJAX, or whatever other language...) feel free to, I think I can figure it all out.

Thank you! 

I am using simple machines forum, and by placing a link to ssi.php in the top of my php page Code: [Select]
<?php require_once('/forum/SSI.php');?>I am able to use some ssi functions. My problem is calling another function from within a function. My first function is this:
Code: [Select]
<?php

$allowed_groups = array(1,5);
$can_see = FALSE;
foreach ($allowed_groups as $allowed)
if (in_array($allowed, $user_info['groups']))
{
$can_see = TRUE;
break;
}

if ($can_see)
{
echo '
<div>
this is text that i want certain groups to see
</div>';
}
else
{
//message or section to show if they are not allowed.
echo 'this is text that i dont want certain groups to see';



}
?>
This is my second function:
Code: [Select]
<?php ssi_welcome(); ?>
I want to put the second function inside the first function, like so:
Code: [Select]
if ($can_see)
{
echo '
<div>
<?php ssi_welcome(); ?>
</div>';
this just gives me the "<?php ssi_welcome(); ?>" displayed on the actual site, it is not calling the separate function.

I have tried different approaches, e.g. $function ssi_welcome;  but all it does is display this as text as well..

Please can some one point me in the right direction. Thank you

How can I make a link that posts to a script? I using just a link but since it doesn't post I just get a URL with a variable and I can't do anything with it. 

If you need anything else then just ask

i have a constructor
  Quote

public function __construct(){
            // check if any action related to this page was generated
            if(isset($_GET['action'])){
                $this->action = ucwords($_GET['action']) . '()';
                self::{$this->maction};
                               
            }
           
            //code to generate the list of all the systems users
            $user = new userDAO;
            $this->results = $user->fetchAll();
       } 

   


if action is present in the querystring, eg. delete, it would be stored into $this->action as Delete().  Similarly, if the action was edit, it would be stored as Edit(). My intent is to call the method named Delete() or Edit() depending upon which action was generated. I have defined the methods in the same class. Once i assign the current action to the $this->action, i want to call the method without explicitly specifying the method name....

here i have tried self::$this->action....
i even tried $this->action only

but its not working? i think the string stored in the self::$this->action is not being interpolated? or....sth. i dont know. pls help out guys
       

I have a PHP config file called config.php.

inside the file is simular to this:

Quote

<?php
class JConfig {
   var $offline = '0';
   var $editor = 'tinymce';
   var $list_limit = '20';
}
?>


From another file, i have included config.php, but how do I call $editor to get "tinymce"?

Thanks