|
PHP - How To Assign Variable To Items In An Array?
Running a simple query:
SELECT team, rank from table ORDER BY rank ASC returns 8 records in order from 1 to 8 I then want to a assign a new variable to each that I can use for later queries ie: team with rank 1 = $team1 team with rank 2 = $team2 team with rank 3 = $team3 etc.... Thanks in advance. Similar TutorialsHi everybody, im reading up on arrays and im still stuck... Is it possible to assign an array to a variable? I need something like... Code: [Select] &needvariable = $row->User Hopefully this makes sense... I'm new at PHP and have a problem. I have a MySql database with lists of students grouped into classrooms. A typical group is shown in the attached screenshot screenshot.docx. I want to be able to select one or more of the names by using the associated checkbox, and upgrade a student or students into a different group as defined in the radio button list also in the screenshot. I have the rudiments of the file attached, but I have absolutely no idea how I can post the array so that the records are updated. Each student has an individual record with a field name userGroup which holds a string nominated by their classroom teacher, such as "year7", "year 8" and so on while they are in one of the several classrooms, but when they leave school this is recorded in a field named noGroup with a value of 0 or 1. I can post further details as required, but it would be great if someone could help me. does anyone knows how to fill this value to a variable (code below works on the screen): Code: [Select] (str)$txt->value; echo (str)$txt->value; I need to get the value from the code above into $myvalue (code below does not work): Code: [Select] (str)$txt->value; $myvalue = (str)$txt->value; echo $myvalue; I have a page that lists out some basic information about each quiz this particular student has taken (call it "quiz summary"). I am creating another page that will have all details of a particular quiz by itself (call it "quiz detail"). If I have a link for each quiz on the "quiz summary" page, how do I tell the "quiz detail' page which link they clicked on? Or which quiz they have selected. I was thinking it would work if I assigned a session variable to each link and then the "quiz detail" page could verify which returns true still and show details for that quiz. Would this logic work? Npot sure how to do it anyone though. thanks for any help! basically, I have one calculation that relies on the value returned by an if statement, but i can;t for the life of me figure it out correctly... Here is what i am trying to accomplish: Here is the code for the IF i need to get the value of if ($loadedMiles < 500) { (500 - $loadedMiles) * .25 * $mainRate; } And here is the reason why i need it: if ($loadSize == "Full") { $loadedmiles + thevalueoftheif; } basically i will need to have a way to get the values of the functions in the IF statements if that makes any sense... thanks in advance! Why doesn't this code work... Code: [Select] // Initialize variables. $form_value = ''; $form_value = $_POST['form_value']; I get this error... Quote Notice: Undefined index: form_value Thanks, Debbie Hello All, I have two php files original.php and return.php retrun.php file returns a variable after I pass $channel_name to it Code: [Select] return $return_variable; I want to assign this return variable to a variable in original.php Something like this Code: [Select] $results = include ('return.php?channel='.$channel_name.'');I am not sure how to do the above code. When I call the return.php from a browser it works properly. Thanks for any help i have Created a Session with this code $_SESSION['USER_NAME'] = trim($_POST['username']) How can i access the $_SESSION['USER_NAME'] in other Pages ; and will this code for $var = $_SESSION[USER_NAME] can i get the SESSIOn value in " $var" variable ?? Hi, I'm trying to implement multithreading using Threadi https://github.com/danielpoe/Threadi Here is a sample code to what I'm trying to do: Code: [Select] require_once(dirname(__FILE__).'/../Loader.php'); class Worker { public function fetchAWebsite($url) { $content = file_get_contents($url); return "fetched website $url - lenght ".strlen($content).PHP_EOL; } } $worker = new Worker(); $startTime = microtime(TRUE); $thread1 = Threadi_ThreadFactory::getReturnableThread(array($worker,'fetchAWebsite')); $thread1->start('http://www.google.de'); $thread2 = Threadi_ThreadFactory::getReturnableThread(array($worker,'fetchAWebsite')); $thread2->start('http://www.aoemedia.de'); $joinPoint = new Threadi_JoinPoint($thread1, $thread2); $joinPoint->waitTillReady(); echo $thread1->getResult(); echo $thread2->getResult(); echo "Time needed in seconds: ". ( microtime(TRUE)-$startTime).PHP_EOL; The problem that I'm having is that I need to call each thread separately by name. Creating 10 or more threads makes a lot redundant code. How can I assign Threadi_ThreadFactory::getReturnableThread to an indexed variable(array) ? I tried something in this lines but with no success: Code: [Select] $hArr = array();//handle array for ($i=0;$i<THREADS;$i++) { $thread[$i] = Threadi_ThreadFactory::getReturnableThread(array($worker,'fetchAWebsite')); $thread[$i]->start($site[$i]); array_push($hArr,$thread[$i]-); } $joinPoint = new Threadi_JoinPoint($hArr); $joinPoint->waitTillReady(); What I'm doing wrong? Thanks How do I assign the entire $_POST array to a varible? This code isn't working... <?php echo 'FormHandler'; class FormHandler{ private $formValues = array(); $this->formValues = $_POST; } ?> TomTees hey everyone will you please assist. I'm getting data from a mysql database. And I want to assign the data to a single value, if possible For example, in my database I have 2 columns, name and group Lets say John, Peter and Cathy belongs to group 555, where Sally and Marcus belongs to group 777. So my sql query outputs all users in group 555 Is there a way to assign the search result to a vlue, for example $result = ??? and If I said echo $result, it should show the users who belongs to group 555 as an example. I tried to use row[Name][1]; but it doesnt work. The thing is, I can display the data the way I am familiar with, but I'm sending an automated email to myself, containing the users. So if I would used a for each statement, the mail will trigger and send a copy for every count, in this case, 3 times. And thats my huge problem. The mail must trigger only once, containing the users in my search query, in this case, group 555. Any help will be appreciated Thank you I get the following error when I try to pass a value to a methiod in a loop: Warning: Attempt to assign property of non-object in /Users/staceyschaller/Sites/dev_zone/ckwv2/classes/class.php on line 670 This one has me very baffled. It will work the first time, and seems to work every other time, so I have no clue what is wrong. Here is the code: This code is part of my "display" class: function display_partner ($type,$loc,$rand=0,$narrow=0) { $this->partners = new partner($this->cxn); $display = ' <div id="cont_info" class="partner-list"> <div> <h3 class="settings">'.ucfirst($loc).' '.ucfirst($type).last_letter($type).'s</h3> </div> <div class="settings-value" style="height:12px;padding:0;margin:0;text-align:right;padding-right:10px;"> <a href="" class="trunc">Add your organization to this list</a></p> </div> <div style="height:2px;padding:0;margin:0;"> <hr class="account" /> </div> '; $ids = $this->partners->get_partners_list($type,$loc,$rand); for ($b=0;$b<sizeof($ids->id);$b++) { $this->partnerID = $ids->id[$b]; $display .= ($narrow)? $this->card_partner_narr():$this->card_partner(); if ($b!=(sizeof($ids->id)-1)) { $display .= '<hr class="account" />'; } } if (sizeof($ids->id)==0) { $display .= '<div style="color:#999999;display:line;text-align:center;height:20px;">No Partners found for '.ucfirst($loc).' '.ucfirst($type).'</div>'; } $display .= ' </div>'; return $display; } function card_partner () { $this->partners->set_partner_id($this->partnerID); $part_info = $this->partners->get_partner_info(); if ($part_info) { $display .= ' <table class="settings"> <tr> '.$this->show_if($part_info['partLogo']['val'],'<td class="settings-value" rowspan="2"><img src="'.LOGO_FOLDER.$part_info['partLogo']['val'].'" '.resize_img(LOGO_FOLDER.$part_info['partLogo']['val'],175).'alt="'.$part_info['partName']['val'].'" /></td>').' <td class="settings-value" colspan="2"><h5>'.$part_info['partName']['val'].'</h5></td> </tr> <tr> <td class="settings-value"> <span style="color:999999;">'.$part_info['partAddress']['val'].'<br /> '.$part_info['partCity']['val'].', '.$part_info['partST']['val'].' '.$part_info['partZIP']['val'].'<br /> '.$part_info['partPhone']['val'].'</span><br /> <a href="'.$this->form->show_href($part_info['partWeb']['val']).'" target="_blank">'.$part_info['partWeb']['val'].'</a> </td> <td class="settings-value">'.$part_info['partInfo']['val'].'</td> </tr> </table> '; } return $display; } This code is part of my "partners" class: function set_partner_id($partID) { echo '<p>partID: '.$partID.' '.gettype($partID).'<br> $this->partner->id: '.$this->partner->id.'</p>'; $this->partner->id = $partID; ///*** ERROR HAPPENS HERE ***/ echo '<p>id set: '.$this->partner->id.'<br> $this->partner->id: '.$this->partner->id.'</p><hr>'; } function get_partner_id() { return $this->partner->id; } // gets user info at login function get_partner_info() { $this->partner = $this->cxn->proc_info('partner','partID',$this->partner->id);//$this->partner->id return $this->partner; } The following is the output generated: partID: 24 string $this->partner->id: id set: 24 $this->partner->id: 24 partID: 26 string $this->partner->id: Warning: Attempt to assign property of non-object in /Users/staceyschaller/Sites/dev_zone/ckwv2/classes/class.php on line 670 id set: $this->partner->id: partID: 17 string $this->partner->id: id set: 17 $this->partner->id: 17 partID: 25 string $this->partner->id: Warning: Attempt to assign property of non-object in /Users/staceyschaller/Sites/dev_zone/ckwv2/classes/class.php on line 670 id set: $this->partner->id: As you can see, the value passes to $this->set_partner_id($partID) each time. It is formatted as a string. When it assigns the value to $this->partner->id, however, sometimes it works, and sometimes it doesn't. It's probably something obvious, but I've racked my brain to see what it is. Any ideas? Hi, I'm hoping someone can help me with a simply array problem. I have a table with two columns: "ID" and "Name" and 100 Names. I also have an array called $myIDList containing 10 IDs. I want to display 10 Names from the table that correspond with the IDs from my array. Originally, I tried to implode the array, adding commas and inserted into my MySQL query using: $myQuery = "SELECT ID, Name FROM namesTable WHERE ID IN ($myImplodedIDList)"; The problem was that duplicated names (i.e. the same Name, but assiged to different IDs) would only be displayed once. So now I'm trying to use the original array to loop through a second array and display Names where the ID matches an ID from my first array. I have succesffuly listed the table like this: $myQuery = "SELECT ID, Name FROM myTable ORDER BY ID"; $myResult = mysql_query($myQuery) or die(mysql_error()); while($row=mysql_fetch_array($myResult)) { echo $row['ID']; echo $row['Name']; } But I want to do something like: while($row=mysql_fetch_array($myResult)) { while $row['ID'] = $myIDList { echo $row['Name'] } } Can someone shed some light onto this for me please? Thank you! Bryan Hello, If I have this string: $tags="baseball glove face" (this can vary from 1 to 15 different words) how would i loop through and divide these into different $tag1=baseball $tag2=glove $tag3=face .. and so on (if more words) Thanks for help I have an array of products. The array has an ID and price. I'd like to know the most efficient way of adding up all the same ID fields in the array. Code: [Select] <?php $items[] = array( 'id' => 1, 'price' => 5.99, ); $items[] = array( 'id' => 2, 'price' => 1.99, ); $items[] = array( 'id' => 3, 'price' => 2.40, ); $items[] = array( 'id' => 2, 'price' => 6.99, ); $items[] = array( 'id' => 4, 'price' => 8, ); $items[] = array( 'id' => 2, 'price' => 3, ); $items[] = array( 'id' => 3, 'price' => 1, ); function add_like_items($items) { //manipulation return $sums; } //$sums would be an array like //$sum[1] = 5.99 //$sum[2] = 11.98 //$sum[3] = 3.40 //$sum[4] = 8 ?> Anybody have suggestions on the best way to go about doing this? How can I check if an array contains two items that are the same? For example ("apples", "bananas", "oranges") returns false But ("apples", "bananas", "bananas") returns true Hi guys, I'm just working on a script to get menu items from a database, sorted by a sort column. Each item needs to be checked to see if it has a parent, then paired with the parent. Would it be best to get all of the items at once and pair them with PHP, or get the children of each item when as a separate array? id label link parent sort 1 Home index.php 0 10 2 About about.php 0 20 3 Contact Us contact.php 2 10 Hi all, I have a table that shows data from an xml response that has been converted to an array. I have successfully managed to get that to work but it's showing more items than I want. I'm trying to isolate the items by state. There are 11 or so different states, of which I only want 7. I've tried the following with a while loop but I keep getting the message "undefined index: job_status" Here's my code (partial)
$projects = array();
$xml=simplexml_load_string($response) or die("Error: Cannot create object");
foreach($xml->Jobs->Job as $item) {
$projects[] = array(
'job_no' => (string)$item->ID,
'job_name' => (string)$item->Name,
'job_due' => (string)$item->DueDate,
'job_status' => (string)$item->State,
'job_staff' => (string)$item->Assigned->Staff->Name,
);
}
usort($projects, function($a,$b) {return $a['job_due'] <=> $b['job_due']; } );
$projects = array_reverse($projects);
while ($projects['job_status'] == ('Feasibility')
&& ('Measure Up')
&& ('Model Drawing')
&& ('Concept Design')
&& ('Developed Design')
&& ('Resource Consent')
&& ('Construction Documentation')) {
foreach ($projects as $proj) {
$formatted = date('d/m/Y', strtotime($proj['job_due']));
$job_no ="{$proj['job_no']}";
$job_name ="{$proj['job_name']}";
$job_due ="$formatted";
$job_status ="{$proj['job_status']}";
$job_staff ="{$proj['job_staff']}";
Any help would be much appreciated thanks. Hi, Im wondering if there is an easy way to get items out of an array returned by a function inside a class. A code example would be: Code: [Select] class modDB { public function getPwdSalt() { $arr = array("salt", "password"); return $arr; } } ?> And what i would like to be able to do is something like: Code: [Select] $modDB = new modDB; echo $modDB->getPwdSalt()->[1]; and just get returned 'password'. Is something like that possible? Many Thanks. 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.
|
|||||||