PHP - I Need A Way To Puch Selected Data To The Beginning Of An Array.

Hey in my edit page i have 2 radio buttons in my form and i need to make sure the same value is still selected how can i do that?

thanks

I'm creating a tool for building project proposals for clients, with pricing.

I have a database with two tables: services and clients.

The services table looks like this:

Code: [Select]
| code        | name        | cost |
+-------------+-------------+------+
| logo_design | Logo design | 10   |
| web_design  | Web design  | 20   |

The clients table looks like this:

Code: [Select]
| id | client  | logo_design | web_design |
+----+---------+-------------+------------+
| 1  | Walrus  | yes         | yes        |
| 2  | Narwhal | no      | yes        |

How would I link the results from these two tables so that I only pull out the services each person wants from the database?

Here is what I have so far:

Code: [Select]
<?
$sql = "SELECT * FROM services";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

  echo $row{'name'} . ': $' . $row{'cost'} . '<br />';

} ?>

This, of course, displays all the services, with all the prices, like so:

Logo design: $10
Web design: $20

I want to add something here so that based on the selected client, we see only the services/prices they selected (ol' Narwhal's page would not show the "Logo Design" line). I've got the data from "clients" pulled in to this page as well, but don't know how to relate it to "services."

Thanks in advance! Let me know if I've left out any info that would help you to point me in the right direction.

Have a look at this image

Here is the part of the form code that makes them into arrays
$sql="select * from products";
$res=mysql_query($sql);
   
WHILE($fetch=mysql_fetch_assoc($res)){
echo "<td><input type=hidden name='desBox[]' id='desBox[]' value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td>
<td><input type=text id=quantBox[]  maxlength=6 name=quantBox[]></td>
<td><input type=text maxlength=6 id=teethBox[] name=teethBox[]></td>";
echo "</tr>";}

To generate the stockroom drop down list
 

    function einv_generateStockrmSelectDropdown($Stockrm,$field,$dropdown) {
    //connect to database
base_connectDatabase();
echo "<select id=\"stockrm\" name=\"".$field."[]\" multiple=\"multiple\" style=\"align:left\" class=\"form-control\">";
 
if (isset($Stockrm) && ($Stockrm != "")) {
$stockrmname = einv_getStockrmDetail($Stockrm);
echo "<option value=\"". $Stockrm ."\">". $stockrmname['einv_stockrm_name'] ."</option>";
} else {
$Stockrm = 0;
}
$getStockrmSQL = base_executeSQL("SELECT * FROM einv_stockroom WHERE einv_stockrm_id<>" . $Stockrm . " ORDER BY einv_stockrm_name");
while ($Stockrmdata_row = base_fetch_array($getStockrmSQL)) {
if (base_num_rows($getStockrmSQL)!= 0) {
 echo "<option value=\"".$Stockrmdata_row['einv_stockrm_id']."\">".$Stockrmdata_row['einv_stockrm_name']."</option>";
}
}
    echo "</select>";
echo "<script src=\"../terms_base/js/jquery.multiple.select.js\"></script>";
 
//Input some codes to split the dropdown and make it into the setSelects. By default, the first time = AutoSelectAll
if(isset($dropdown) && ($dropdown != "")) { //dropdown = 1;2;3
$SDDArrays = explode(";", $dropdown);
$countTrap0 = count($SDDArrays);
$drop = "$('#stockrm').multipleSelect(\"setSelects\", [";
$counting = 1;
foreach ($SDDArrays as &$value) {
if ($countTrap0 != $counting) {
$drop .= "'". $value . "',";
} else {
$drop .= "'". $value . "'";
}
$counting++;
}
$drop .= "]);\n";
} elseif (isset($dropdown)) { //dropdown=
$drop = "$('#stockrm').multipleSelect(\"uncheckAll\")";
} else { //
$drop = "$('#stockrm').multipleSelect(\"checkAll\")";
}
 
echo "<script>\n";
echo "$(function() {\n";
echo "".$drop."";
echo "});\n";
echo "$(\"#stockrm\").multipleSelect({ onClose: function() {
                document.getElementById('search').click();
            }});\n";
echo "$(\"#stockrm\").multipleSelect();\n";
echo "</script>";
 
    //close the database
    base_closeDatabase();
    }

 add stockroom function
 

    //This function is use to add new stock room
    //code = stock room code
    //name = stock room name
    //desc = stock room description
    //remark = stock room remark
    //cat = stock room category
 

 
    function einv_addStockrm($code,$name,$desc,$remark,$cat)
    {
    //connect to database
    base_connectDatabase();
    $User = base_getUserDetail($_SESSION['uID']);
 
base_executeSQL("INSERT INTO einv_stockroom (einv_stockrm_code, einv_stockrm_name, einv_stockrm_desc, einv_stockrm_remark, einv_stockrm_cat)
VALUES ('" . $code . "', '" . $name . "', '" . $desc . "', '" . $remark . "', '" . $cat . "')");
 
base_addTransactionLog('Manage Stock Room', 'Add',
"
Stock Room Code = " . $code . " ||
Stock Room Name = " . $name . " ||
Stock Room Description = " . $desc . " ||
Stock Room Remark = " . $remark . " ||
Stock Room Category = " . $cat . "
");
//go to stock room page
echo '<script type="text/javascript">' . "\n";
echo 'window.location="../einventory/stockrm_list.php";';
echo '</script>';
    //close the database
    base_closeDatabase();
    }

 
 
Edit stockroom
 

    function einv_editStockrm($srid,$code,$name,$desc,$remark,$cat)
    {
    //connect to database
    base_connectDatabase();
   
    $User = base_getUserDetail($_SESSION['uID']);
    $Stockroom = einv_getStockrmDetail($srid);
    base_executeSQL("UPDATE einv_stockroom
    SET einv_stockrm_code='" . $code . "',
    einv_stockrm_name='" . $name . "',
    einv_stockrm_desc='" . $desc . "',
    einv_stockrm_remark='" . $remark . "',
    einv_stockrm_cat = '" . $cat . "'
    WHERE einv_stockrm_id=" . $srid . "");
   
    base_addTransactionLog('Manage Stock Room', 'Edit',
    "
    Stock Room Code = " . $code . " ||
    Stock Room Name = " . $name . " ||
    Stock Room Description = " . $desc . " ||
    Stock Room Remark = " . $remark . " ||
    Stock Room Category = " . $cat . "
    ");
    //go to stock room page
    echo '<script type="text/javascript">' . "\n";
    echo 'window.location="../einventory/view_stockrm.php?id='. $srid .'";';
    echo '</script>';
   
   
   
    //close the database
    base_closeDatabase();
    }

 
     
I have a dropdown list named **Stockroom** where it displays an array of values.
 
Example:
 
**Stockroom**
 
 1. [A]
 2. [b]
 3. [C]
 
When user clicks on [A], it will display relevant data fields that [A] possess (appears below stockroom ddl). 
 
And as user clicks on [b], there is an onchange function that will then show [b] data fields (fields in A is deleted and replaced with B).
 
I am able to add the initial values however, as i want to edit and change the stockroom from [A] to [b] which will result in a whole new data to be stored, i am unable to do so. 
 
Any ideas?
 
I believe i have to amend my edit stockroom function where i require a set of coding such as
 
If the array is selected, i have to delete existing data and add new data in accordance to the selected ID.
Edited by mac_gyver, 14 January 2015 - 07:05 AM.
code tags around posted code please

The Script:

<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>">
    <input type="text" name="hashtags" />
    <input type="submit" name="submit" />

</form>
<?php

include("connect.php");

?>
<?php

if(isset($_POST['submit'])){

    $hashtags = explode(", ", $_POST['hashtags']);

    for($i= 0; $i < count($hashtags); $i++){

        $tqs = "SELECT `id` FROM `hashtags_two` WHERE `hashtags` = '" . $hashtags[$i] . "'";
        $tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));

    }

    $fetch_array = array();
    while($row = mysqli_fetch_array($tqr)){
        $fetch_array[] = $row['id'];
    }

}

Hey, sorry for these fundamental array questions lately, I am not going to ask much more when it comes to this.   The hashtags come from the submit form (separated by commas) and get stored inside an array with the "explode()" function. The script should select the ID numbers of the hashtags from the table.   With the script above only the last row gets inserted into $fetch_array inside the while loop.   When the $fetch_array variable is printed on screen then only one ID number can be seen inside the array:

Array ( [0] => 24 ) 

How can I have the other ID numbers too?

Hi, after banging my head against the wall for a while thinking this would be a simple task, I'm discovering that this is more complicated than I thought.

Basically what I have is a link table linking together source_id and subject_id.   For each subject there are multiple sources associated with each.

I had created a basic listing of sources by subject... no problem.   I now need a way of having a form to create an ordered list in a user-specified way.  In other words, I can currently order by id or alphabetically (subject name lives on a different table), but I need the option of choosing the order in which they display.  I added another row to this table called order_by.  No problem again, and I can manage all of this in the database, however I want to create a basic form where I can view sources by subject and then enter a number that I can use for sorting.

I started off looping through each of the entries and the database (with a where), and creating a foreach like so (with the subject_id being grabbed via GET from the URL on a previous script)
Code: [Select]
while($row = mysqli_fetch_array($rs)) {


//update row order
if (isset($_POST['submit']))  {

//get variables, and assign order

$subject_id = $_GET['subject_id'];
$order_by = $_POST['order_by'];
$source_id = $row['source_id'];


//echo 'Order by entered as ' . $order_by . '<br />';

foreach ($_POST['order_by'] as $order_by) {

$qorder = "UPDATE source_subject set order_by = '$order_by'
WHERE source_id = '$source_id'
AND subject_id = '$subject_id'";

mysqli_query($dbc, $qorder)
or die ('could not insert order');

// echo $subject_id . ', ' . $order_by . ', ' . $source_id;
// echo '<br />';
} 
}
else {
$subject_id = $_GET['subject_id'];
$order_by = $row['order_by'];
$source_id = $row['source_id'];

}

And have the line in the form like so:
Code: [Select]
echo '<input type="text" id="order_by" name="order_by[]" size="1" value="'. $order_by .'"/>

(yes I know I didn't escape the input field... it's all stored in an htaccess protected directory;  I will clean it up later once I get it to work)

This, of course, results in every source_id getting the same "order_by" no matter what I put into each field.

I'm thinking that I need to do some sort of foreach where I go through foreach source_id and have it update the "order_by" field for each one, but I must admit I'm not sure how to go about this (the flaws of being self-taught I suppose;  I don't have anyone to go to on this).

I'm hoping someone here can help?

Thanks a ton in advance

hi i am trying to make a payroll calculator script that takes employee info, calculates pay, displays submitted info in a table, stores info in an array, and updates the array when new info is submitted. i have most of these accomplished, i am having trouble with the "store into an array, and update the array when new info is submitted" parts of the project. i am still not very fluent in php so there may be easier ways to achieve what i have so far. any pointers would be a great help, this part has got me stumped.

Using curl_multi, I have loaded up 3 url's and then printed the array.

1) How can I also set a timestamp on output to let me know when each url was run?

2) How can I explode the array to only display the data and timestamp, excluding the text "Array ( =>", "[1] =>", "[2] =>" and " )"? Code

<?php

function multiRequest($data, $options = array()) {

  // array of curl handles
  $curly = array();
  // data to be returned
  $result = array();

  // multi handle
  $mh = curl_multi_init();

  // loop through $data and create curl handles
  // then add them to the multi-handle
  foreach ($data as $id => $d) {

    $curly[$id] = curl_init();

    $url = (is_array($d) && !empty($d['url'])) ? $d['url'] : $d;
    curl_setopt($curly[$id], CURLOPT_URL,            $url);
    curl_setopt($curly[$id], CURLOPT_HEADER,         0);
    curl_setopt($curly[$id], CURLOPT_RETURNTRANSFER, 1);

    // post?
    if (is_array($d)) {
      if (!empty($d['post'])) {
        curl_setopt($curly[$id], CURLOPT_POST,       1);
        curl_setopt($curly[$id], CURLOPT_POSTFIELDS, $d['post']);
      }
    }

    // extra options?
    if (!empty($options)) {
      curl_setopt_array($curly[$id], $options);
    }

    curl_multi_add_handle($mh, $curly[$id]);
  }

  // execute the handles
  $running = null;
  do {
    curl_multi_exec($mh, $running);
  } while($running > 0);

  // get content and remove handles
  foreach($curly as $id => $c) {
    $result[$id] = curl_multi_getcontent($c);
    curl_multi_remove_handle($mh, $c);
  }

  // all done
  curl_multi_close($mh);

  return $result;
}



$data = array(array(),array());

$data[0]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Pearl+Jam&output=json';
$data[1]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Black+Eyed+Peas&output=json';
$data[2]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Nirvana&output=json';

$r = multiRequest($data);

print_r($r);

?>

Output

Array ( => Pearl Jam [1] => Black Eyed Peas
        [2] => Nirvana )

Preferred Output

01:00:01 Pearl Jam
01:00:02 Black Eyed Peas
01:00:03 Nirvana

Hello,
I have a variable called $Price, We are getting it through Mysql Database using While loop. We getting the data from database in ordered by ID.
Now then i have requirement to store that data into Low to High form ...

Like we are receiving $price
lke unordered form ..
50
14
35
25
00
145
52

Here i just want to store it in Low to high form like 00, 14,25,35 ... and so on ..
Please suggest me the appropriate code.
While($myrow=mysql_fetch_array($result, MYSQL_ASSOC))
{ 

some codes 


return value $price.  // want to store in array 

}
$array($price) // here want to store in Low to high with key value.

I'm reading through this book which is actually not bad but, on page 286 there's a shopping_cart.php code (which I downloaded from the web site). The code that seems relevant to me is this:


<?php
$totalPrice = 0;
 
foreach ( $_SESSION["cart"] as $product) {
   
  $totalPrice += $product->getPrice(); //<<<LINE 94
?>

The error I get is

Fatal error: Call to a member function getPrice() on a non-object in C:\usr\web\shopping_cart.php on line 94

Should $product be a cast to the Product object?

class Product {
  private $productId;
  private $productName;
  private $price;

  public function __construct( $productId, $productName, $price ) {
    $this->productId = $productId;
    $this->productName = $productName;
    $this->price = $price;
  }

  public function getPrice() {
    return $this->price;
  }
 //etc.

}

The below code returns a radio list after an input box in a profile edit section.
All I want to do is add a space at the beginning of the radio list so to separate the input box and the radio list.
Where the magic happens here is on this line:

return $selhtml . '&nbsp;' . getFieldIcons( $_CB_framework->getUi(), $required, null, $fieldHandler->getFieldDescription( $field, $user, $output, $reason ), $fieldHandler->getFieldTitle( $field, $user, $output, $reason ) );


I've tried several variations of trying to use &nspb; both in the return string directly as well as creating a var for it. I've tried various ways of wrapping it in a div to simply add a margin, I've tried kicking my dog, I've tried banging my head against the wall, nothing seems to work. I either get a t var error, an unexpected something or other like . or & error depending on what I'm doing, or it tries to divide by zero using /'s.

Here's a larger view of the code:

function onFieldIcons( &$fieldHandler, &$field, &$user, $output, $reason, $tag, $type, $value, $additional, $allValues, $displayFieldIcons, $required ) {
global $_CB_framework, $ueConfig, $_CB_fieldIconDisplayed;

if ( is_object( $field->params ) ) {
$privacyLevel = $field->params->get( 'plug_cbprivacy_level' );
} else {
$privacyLevel = 0;
}

if ( $displayFieldIcons && ( $reason != 'search' ) ) {
if ( ( $privacyLevel == 1 ) && ( $field->profile != 0 ) ) {

$privacy =& moscomprofilerPrivacy::getInstance( $user, 'field', $field->fieldid );
$selected = ( $privacy ? $privacy->rule : '' );

$selectorName = $field->name . '___cbprivacy';

$connTypes = array();
if ( $this->params->get( 'conns_by_type', 0 ) ) {
if ( $ueConfig['connection_categories'] ) {
$connTypes = explode( "\n", $ueConfig['connection_categories'] );
foreach ( array_keys( $connTypes ) as $k) {
$connTypes[$k] = trim( $connTypes[$k] );
}
}
if ( $selected == 2 ) {
$type = $privacy->getParam( 'conn_cat' );
if ( $type ) {
$selected = $selected . '|*|' . $type;
}
}
}
$options = array();
$options[] = moscomprofilerHTML::makeOption( '', '' . CBTxt::T('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;') );
if ( ( $ueConfig['allow_profileviewbyGID'] == -2 ) && $this->params->get( 'prop_registered', 1 ) ) {
$options[] = moscomprofilerHTML::makeOption( '1', '' . CBTxt::T('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;' ) );
}
if ( $ueConfig['allowConnections'] ) {
$prop_connections = $this->params->get( 'prop_connections', 1 );
if ( $prop_connections ) {
$options[] = moscomprofilerHTML::makeOption( '2', '' . CBTxt::T( '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;' ) );
}
if ( count( $connTypes ) > 1 ) {
foreach ($connTypes as $type ) {
$options[] = moscomprofilerHTML::makeOption( '2|*|' . htmlspecialchars( $type ), ( $prop_connections ? '&nbsp;&nbsp;&lfloor;&nbsp;' : '' ) . '' . sprintf( CBTxt::T( 'Only for %s' ), $type ) );
}
}
if ( $this->params->get( 'prop_fofs', 1 ) ) {
$options[] = moscomprofilerHTML::makeOption( '3', '' . CBTxt::T( 'Also for friends of friends' ) );
}
}
if ( $this->params->get( 'prop_invisible', 1 ) ) {
$options[] = moscomprofilerHTML::makeOption( '99', '' . CBTxt::T( '&nbsp;' ) );
}
$selHtml = moscomprofilerHTML::radioList( $options, $selectorName, '', 'value', 'text', $selected, 2, false );
if ( isset( $_CB_fieldIconDisplayed[$field->fieldid] ) ) {
return $selHtml;
} else {
$_CB_fieldIconDisplayed[$field->fieldid] = true;
return $selHtml . '&nbsp;' . getFieldIcons( $_CB_framework->getUi(), $required, null, $fieldHandler->getFieldDescription( $field, $user, $output, $reason ), $fieldHandler->getFieldTitle( $field, $user, $output, $reason ) );
}
} else {
if ( isset( $_CB_fieldIconDisplayed[$field->fieldid] ) ) {
return null;
} else {
$_CB_fieldIconDisplayed[$field->fieldid] = true;
return getFieldIcons( $_CB_framework->getUi(), $required, $field->profile, $fieldHandler->getFieldDescription( $field, $user, $output, $reason ), $fieldHandler->getFieldTitle( $field, $user, $output, $reason ) );
}

}

} else {
return null;
} 
}


The basic layout here is this:
|inputbox||radio list|
But I want:
|inputbox|  |radio list|

$i = 0;
while($i < 10) {

   if ($i == 7) {
     //Do Function
   } else {
     $i++
    Go back to beginning of loop
  }

  //More if statements here.
}

My first post.    I am trying to import images related to a particular listing ID.  Currently, I have to enter the number of available photos into a db table, and run the following loop;   <section id="photos">   <?php $b = $row['PIX'];
for ( $a = 01;  $a <= $b;  $a++ ) {
echo "<a href=\"../imgs/{ $row[ 'ID' ] }-" . { $a } . ".jpg\" ><img src=\"../imgs/{ $row[ 'ID' ] }-" . { $a } . "_tn.jpg\"  /></a> " ; } ?> </section>   I would like to find a way to import all the images that begin with the $row[ 'ID' ], but without me having to enter/store { $b } (the number of images recorded in the db).   How can I accomplish this?     _

Hi,

I have two variables: $latest_note and $notes. Whenever I update $latest_note, I also want this (and today's date) to be added to $notes, such that $notes becomes a sort of archive of all of the latest notes, listed by date.

I tried creating a third variable called $full_notes and saying
$full_notes = $latest_note.$notes; ... then when I run my mysql update, I set notes='$full_notes' but it's not working properly.

Is there a way to simply add one variable to the beginning of another in the db directly, concatenating the two?

Thanks!

I keep getting errors that are associated with one-off and one-time occurrences.

I want to tell the script to just restart itself from the beginning if it encounters any type of error, whether it by a fatal error, or any other kind.

is there a way to do this?