PHP - Consolidating A Multilevel Array

I am having some problems getting a query correct. Basically I have two tables, one with listings and another with categories. In the listings table I have a column called shortdescription.

I am trying to pull the shortdescription from the listings table with the query

$shortdesc = array_shift(mysql_fetch_row(mysql_query("select shortdescription from links where category = '".$scat->id."' ")));

The shortdecription display properly on the pages display the listings, however I am getting the following error on any pages that only display the parent categories


Warning: array_shift() [function.array-shift]: The argument should be an array in /home/...path/file.php on line 1462

The listings id numbers begin at 75+ because the initial parent category id ends at 74. The query seems to be searching for listing ids below 75 and spitting out an error because it is not finding them.

Any ideas on how to eliminate this error and/or stop the query from looking for non-existant data?

How can i save array from inputs, witch is $igraci and it have 5 values, to mysql base, i tryed but in mysql it shows Array.
This is form:
        <form action="dodaj_klan.php" method="post" >
            <p>
            <label>Naziv klana:</label>
            <input name="naziv" type="text" size="20%" />
            <label>Web Sajt:</label>
            <input name="website" type="text" size="20%" />
            <label>E-Mail:</label>
            <input name="email" type="text" size="20%" />
            <br /><br />
            <label>Igraci klana(5):</label>
            <input name="lider" type="radio" value="1" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="2" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="3" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="4" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="5" />
            <input name="igraci[]" type="text" size="20%" />
            <label><i>(obelezi lidera klana)</i></label>
            <br /><br />
            <input class="button" type="submit" name="submit" value="Dodaj" />&nbsp;&nbsp;
            </p>
        </form>
Now i wonna save this igraci[] array in mysql, i tried like this but it doesn't work:
$igraci = $_POST['igraci'];
$query = "INSERT INTO klanovi (naziv, website, email, igraci) VALUES ('{$naziv}', '{$website}', '{$email}', '{$igraci}')";
$result = mysql_query($query, $connection);

How can i do this?
Thanks..

So I'm trying to create an Array from a comma separated string containing array{s}. How can I take a string full of comma separated hex values such as : 

<?php
    $myStr = (
        "00ffff", "00cccc", "009999", 
        "007777", "004444", "001111", 
        "01ffff", "01cccc", "019999"
    );
?>

& turn it into 3 separated arrays like : 

<?php
    $myNewArrs = [
        Array1 ( 3 ), 
        Array2 ( 3 ), 
        Array3 ( 3 ), 
    ];
?>

which REALLY looks like : 

<?php
    $myNewArrs = [
        Array ( "00ffff", "00cccc", "009999" ), 
        Array ( "007777", "004444", "001111" ), 
        Array ( "01ffff", "01cccc", "019999" ), 
    ];
?>

?

Any assistance is most-definitely appreciated!

Thank you & have a great afternoon!

 

 

Edited May 27 by AquariaXI

Hi there,

Basic question, but I can't seem to find a page in the PHP docs that answers (though I'm sure such a one exists, I just can't seem to think up the right search terms - anyway)

My question is: is there a short-hand way to use a value from an associative array as the key in another associative array?

So for example, given this array:

$the_array = array(0 => array('name': 'the_name', 'value' : 'the_value'), 1 => etc....);

then this kind of foreach loop doesn't work

Code: [Select]
$new_data = array();
foreach($the_array as $element){
$new_data[$element['name']] = $element['value'];
}

Obviously I can just save out the values, like $name = $element['name'] --- but I was just wondering if there was a more efficient way to do it?

Cheers,

PS. I tried encapsulating with {} - i.e. $new_data[{$element['name']}] --- but that also fails.

I have mysql select query shown below retrieving data from a database:

$sql = "
SELECT 
	student, sum( test_score ) as score
FROM 
	test
INNER JOIN 
	level 
ON 
	test.level_id = level.level_id
GROUP BY 
	student"
$result = $mysqli->query($sql, MYSQLI_STORE_RESULT);
if($result)
{
      while ($row = $result->fetch_array(MYSQLI_ASSOC))
       {
	    var_dump($row);
       }
}

On inspection of the retrieved array with var_dump(), i have these result below:

array (size=2)
  'John' => string 'English' (length=2)
  'Score' => string '20' (length=3)

array (size=2)
  'Mary' => string 'Math' (length=3)
  'Score' => string '35' (length=3)

array (size=2)
  'Samuel' => string 'Physics' (length=3)
  'Score' => string '5' (length=3)

 How do I get at and print out the highest score from this set of array values within this context.
 I tried this echo max($row['count']) but i understandably got this feedback:
Warning: max(): When only one parameter is given, it must be an array   Thanks.

I need a help in the following :
I have an admin page from where the admin attaches an gif image.This attached image should be shown to the user as a scrolling image.
The code for the scrolling image is done through javascript.
So my actual problem is getting the name of the attached gif image to the javascript array which is used for scrolling horizontally.

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=344127.0

Hello all,

I have yet again trouble finding a logical solution to my problem.
I'm fetching an array which can hold 1 or more values.
The problem is, I want these values to ouput in my json_encode function, but this also needs to happen dynamically depending on the amount of values.

I can't explain it further, so here's the code so far:

Code: (php) [Select]
$files = mysql_fetch_array($get_files);

$a = count($files);

$i = 1;
while ($files) {
$variablename = 'fileName' . $i;
$$variablename = $files['fileName'];
$i++;
}

$output =  array( OTHER VALUES , 'fileName1' => $fileName1, 'fileName2' => $fileName2, 'fileName3' => $fileName3, ............); // How do I add the fileNames dynamically depending on how many there are?


This got me thinking, I also need to dynamically GET the values with jQuery. How would I do that, when the above eventually works?

Thank you.

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 a for loop which extracts info from a MySQL table, chooses something then needs to push each bit into an array:

for($i = 0 ; $i < $query_report_rows ; ++$i)
{
$row= mysql_fetch_row($query_names);
if($row[6] == 0)
{
$sName = $row[1];
}
elseif($row[6] == 1)
{
$sName = $row[2];
}

$name = "$row[0], $sName";
$print = nl2br($row[7]);
    }


What i need is a multidimensional array to hold $name and $print:

$name_print = array(
   array('name'=>$name
         'print'=>$print
   )
)


How do i array push into such an array from the above for loop? (multi-dimensional array are a very weak point at the moment, so any pointers here would be very much appreciated)

I have an array $array_1
Code: [Select]
ARRAY(
[0] => info 1
[1] => info 2
[2] => info 3
)
and I have another array $array_2
Code: [Select]
ARRAY(
[0] =>thank you and welcome to what ever
[1] =>the info you added * thanks for entering your info
)
I want to loop though the first array and place the values into the [1] of the second array. But the tricky thing is I want it to insert were the * is.

Code: [Select]


foreach ($array_1  as $key =>  $val) {
    //not sure about this
    insert into ($array_2[1],after *, $val);
}
any help would be awesome.

Hi, I am very new to PHP and apologies if this question has already been answered in another thread.   I am trying to extract the information from one array into another when some search criteria is matched.   Here is an example array ($original): Array ( [ 1234567 ] => Array ( [name] => john ) [ 3456 ] => Array ( [name] => johnny ) [ 45673 ] => Array ( [name] => james ) [ 987 ] => Array ( [name] => jamie ) [ 5628721 ] => Array ( [name] => Simon ))   So if I searched for the string john, jo, joh then the new array ($filtered) should be as follows: Array ( [ 1234567 ] => Array ( [name] => john ) [ 3456 ] => Array ( [name] => johnny ))   I was trying to do this using array_search & preg_match but have been struggling.   Any help would be much appreciated!  

Currently, I am trying to make my URL shortener script able to track UTM variables from Google Analytics. I also want to provide my own (campaign/keyword/source/etc...) variables.

I am trying to sift through $_GET, pick out "approved" key/value pairs and set each key with the condition that UTM variables take higher precedence (I only want to store one value in the database).

My code is currently:

Code: [Select]
//Parse $_GET and only get the key/pairs that we need and store them in global $url_params for use through out the script
function set_url_params($allowed=NULL) { // $allowed is arg to add new values in future dev
global $url_params;

$allowed = array(
    'l', // Redirect key (e.g http://example.com?l=a1dFd7)
    'utm_campaign',
    'campaign',
    'utm_source' ,
    'source',
    'utm_medium',
    'medium',
    'utm_term',
    'term',
    'keyword',
    'kw',
    );

    $approved = array_intersect_key($_GET, array_flip($allowed));

    foreach($approved as $key => $value) {
        strip_tags(urldecode(trim($value)));
        $url_params[$key] = $value;
    }

    //Assign variables to global $url_params variable so other functions can use them.
    //NOTE: Google Analytics UTM parameters take precedence over script values.
    $url_params['l'] = isset($approved['l']) ? $approved['l'] : NULL ;
    $url_params['campaign'] = isset($approved['utm_campaign']) ? $approved['utm_campaign'] : $approved['campaign'];
    $url_params['source'] = isset($approved['utm_source']) ? $approved['utm_source'] : $approved['source'];
    $url_params['medium'] = isset($approved['utm_medium']) ? $approved['utm_medium'] : $approved['medium'];
    $url_params['term'] = isset($approved['utm_term']) ? $approved['utm_term'] : $approved['term'];
    $url_params['keyword'] = isset($approved['keyword']) ? $approved['keyword'] : $approved['kw'];
    // Just in case $url_params doesn't have a 'keyword' set, we will use 'term' instead.
    $url_params['keyword'] = isset($url_params['keyword']) ? $url_params['keyword'] : $url_params['term'];

}

I basically want to find a cleaner way of doing this without all the isset()'s. I also get NOTICE errors (running in E_ALL) for undefined variables that I would like to unset so I don't get those errors.

Any help would be appreciated. Thanks.

Hello all,

I need to make a rotating banner system for a client. They want about 5 banners to rotate with Javascript. However they want the visitor to sort of step through each one on each refresh.

So if I have 5 banners and I go to the site, I see banner 1 and then the javascript rotates through each one.

When I go back to the site, they want it to start with banner 2 and then the javascript will rotate through each one. Then on and on. Go back and see banner 3, then step through again.

I have a nice Javascript image slider I'd like to use. It basically just requires the images in order. Like:

<img src="1.jpg"/>
<img src="2.jpg"/>
<img src="3.jpg"/>
<img src="4.jpg"/>
<img src="5.jpg"/>

I've thought about it and I think the best way to do this would just be using PHP and a cookie. So when the viewer first goes to the site, PHP checks for the cookie. If it exists, it pulls the starting image #. If it doesn't, it starts at 0 and sets the cookie.

As for the images part, I figured an associate array would work well. The key would be what the cookie logic is based on, and then the image HTML would be in the array.

So you visit the site without a cookie it would be...

0 => <img src="1.jpg"/>
1 => <img src="2.jpg"/>
2 => <img src="3.jpg"/>
3 => <img src="4.jpg"/>
4 => <img src="5.jpg"/>

Then when you go back to the site, I need the array to be re-ordered like this:

0 => <img src="2.jpg"/>
1 => <img src="3.jpg"/>
2 => <img src="4.jpg"/>
3 => <img src="5.jpg"/>
4 => <img src="1.jpg"/>

What's the best way to go about this array logic? My experience with manipulating data inside arrays is rather limited. Basically I need it to say "Start with key # and then reorder array based on that"

I've used a lot of solutions from this site, however, this is my first post, so go easy on me  :-)

I've created a product form the successfully INSERTS data to a mysql table. 
I can successfully query the data so that product information can be updated.

When I click submit to UPDATE the rows, everything updates except for 2 fields that are arrays.

Here is my product form that populates data to be edited.
Code: [Select]
<?php

session_start();

require("config.php");
require("db.php");
require("functions.php");

if(isset($_SESSION['SESS_ADMINLOGGEDIN']) == FALSE)
{
header("Location: " . $config_basedir);
}

if(isset($_GET['func']) == TRUE)
{

if($_GET['func'] != "conf")
{
header("Location: " . $config_basedir);
}

$validid = pf_validate_number($_GET['id'], "redirect", $config_basedir);

header("Location: " . $config_basedir . "adminedit.php");
}

else
{
require("header.php");



$sql = "SELECT * FROM products WHERE id = " . $_GET['id'] . ";";
$query = mysql_query($sql); 

while ($prodrow = mysql_fetch_array($query)){

$id = $prodrow['id'];
$active=$prodrow['active'];
$cat_id=$prodrow['cat_id'];
$name=$prodrow['name'];
$description=$prodrow['description'];
$details=$prodrow['details'];
$price=$prodrow['price'];
$price2=$prodrow['price2'];
$price3=$prodrow['price3'];
$price4=$prodrow['price4'];
$price5=$prodrow['price5'];
$price6=$prodrow['price6'];
$minimum=$prodrow['minimum'];
$price7=$prodrow['price7'];
$price8=$prodrow['price8'];
$price9=$prodrow['price9'];
$image=$prodrow['image'];
}

?>

<form action="adminprodupdate.php" method="post">

<table width="500" border="1" cellpadding="10">

<tr>
    <td>ID:</td>
    <td><input type="hidden" value="<? echo $id; ?>" name="id" /></td>
  </tr>
 <tr>
    <td>Active:</td>
    <td><input name="active" type="radio" value="0" <?php echo ($active=='0')? 'checked':'';?> />Yes<br />
       <input name="active" type="radio" value="1" <?php echo ($active=='1')? 'checked':'';?> />No</td>
  </tr>
  <tr>
    <td>Category:</td>
    <td><input name="cat_id" type="radio" value="1" <?php echo ($cat_id=='1')? 'checked':'';?> />Hats<br />
    <input name="cat_id" type="radio" value="2" <?php echo ($cat_id=='2')? 'checked':'';?> />Shirts<br />
    <input name="cat_id" type="radio" value="3" <?php echo ($cat_id=='3')? 'checked':'';?> />Promotional Items</td>
  </tr>
 
  <tr>
    <td>Product ID: </td>
    <td><input type="text" name="name" value="<? echo $name; ?>"></td>
  </tr>
 
  <tr>
    <td>Short Description: </td>
    <td><input type="text" name="description" value="<? echo $description; ?>"></td>
  </tr>
  <tr>
    <td>Details:</td>
    <td><textarea name="details" cols="50" rows="10" ><? echo $details; ?></textarea></td>
  </tr>
  <tr>
    <td>Price for S-XL:<br />
    <br /><strong><div id="redfont">**Shirts**<br />&<br />**Hats**</div></strong></td>
    <td>1-23: &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="price" value="<? echo $price; ?>"><br><br>
    24-47: &nbsp;&nbsp;<input type="text" name="price2" value="<? echo $price2; ?>"><br><br>
        48+: &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="price3" value="<? echo $price3; ?>"><br><br>
    </td>
  </tr>
  <tr>
    <td>Price for 2XL - 5XL:<br />
    <br /><strong><div id="redfont">**Shirts ONLY!**</div></strong></td>
    <td>1-23: &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="price4" value="<? echo $price4; ?>"><br><br>
    24-47: &nbsp;&nbsp;<input type="text" name="price5" value="<? echo $price5; ?>"><br><br>
        48+: &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="price6" value="<? echo $price6; ?>"><br><br>
    </td>
  </tr>
  <tr>
    <td>Minimum QTY: </td>
    <td><input type="text" name="minimum" value="<? echo $minimum; ?>"></td>
  </tr>
 
<tr>
<td>Sizes:</td>
<td><?
echo '';

$result = mysql_query("SELECT * FROM sizes");
while ($row = mysql_fetch_assoc($result)) {
$selected = '';
$result2 = mysql_query("SELECT * FROM productoptions WHERE productid = '" . $_GET['id'] . "' AND sizeid = '" . $row['id'] . "'");
if ($row2 = mysql_fetch_assoc($result2)) {
$selected = 'checked ';
}
echo '<input type="checkbox" name="size[]" value="' . $row['id'] . '" ' . $selected . '/> ' . $row['size'] . '<br />';
}

?>
</td>
</tr>
<tr>
<td>Colors:</td>
<td><?


$result = mysql_query("SELECT * FROM colors");
while ($row = mysql_fetch_assoc($result)) {
$selected = '';
$result2 = mysql_query("SELECT * FROM productoptions WHERE productid = '" . $_GET['id'] . "' AND colorid = '" . $row['id'] . "'");
if ($row2 = mysql_fetch_assoc($result2)) {
$selected = 'checked ';
}
echo '<input type="checkbox" name="color[]" value="' . $row['id'] . '" ' . $selected . '/> ' . $row['color'] . '<br />';
}

?>
     
</td>
</tr>
   <tr>
  <td>&nbsp;</td>
  <td><input type="Submit" value="Update this product"></td>
  </tr>
</form>
</table>

<?php

}

require("footer.php");
?>
Here is my script:
Code: [Select]
<?php


include("config.php");
include("db.php");

$id=$_POST['id'];
$active=$_POST['active'];
$cat_id=$_POST['cat_id'];
$name=$_POST['name'];
$description=$_POST['description'];
$details=$_POST['details'];
$price=$_POST['price'];
$price2=$_POST['price2'];
$price3=$_POST['price3'];
$price4=$_POST['price4'];
$price5=$_POST['price5'];
$price6=$_POST['price6'];
$minimum=$_POST['minimum'];
$arrsizes = $_POST['size'];
$arrcolors = $_POST['color'];
$image=$_POST['image'];


$sql="UPDATE products SET active = '$active', cat_id = '$cat_id', name = '$name', description = '$description', details = '$details', price = '$price', price2 = '$price2', price3 = '$price3', price4 = '$price4', price5 = '$price5', price6 = '$price6', minimum = '$minimum', image = '$image' WHERE id = '$id'";



$result = mysql_query("SELECT id FROM products ORDER BY id DESC LIMIT 0,1");

if ($row = mysql_fetch_assoc($result)) {
$productid = $row['id'];
}

foreach ($arrsizes as $sizevalue) {
foreach ($arrcolors as $colorvalue) {
$sql2="UPDATE productoptions SET sizeid = '$sizevalue', colorid = '$colorvalue' WHERE productid='$id' ";

}
}

mysql_query($sql) or die ("Error: ".mysql_error());
mysql_query($sql2) or die ("Error: ".mysql_error());


echo $sql;
echo $sql2;



header("Location: " . $config_basedir . "adminhome.php");



?>

And here is what is echo'd after submit:
Code: [Select]
UPDATE products SET active = '0', cat_id = '2', name = 'Test Edit Prod', description = 'just a simple test', details = 'just a simple testjust a simple testjust a simple testjust a simple testjust a simple testjust a simple test', price = '1', price2 = '2', price3 = '3', price4 = '4', price5 = '5', price6 = '6', minimum = '127', image = '' WHERE id = '41'UPDATE productoptions SET sizeid = '6', colorid = '5' WHERE productid='41'
This part of the code:   UPDATE productoptions SET sizeid = '6', colorid = '5' WHERE productid='41'   , is supposed to be updating sizes and colors, however, it is only updating the last size/color selected in the check box.

Thanks in advance for any support!