PHP - Stepping Through All Array Keys On Returned $query

Search not functioning. The drop down box to search on Club_Name and Email is blank, clicking search results unchanged ... all suggestions appreciated ... newbie at php.  Thanks.

<!-- Code below is not functional, trying to query search results, search box with drop down box for two fields-->
<table width="50%">
         <tr>
            <td height="30"  align="left" bgcolor="#FFFFFF" class="form1" >
            {$letter_links}
            </td>
            <td height="30"  align="right" bgcolor="#FFFFFF" class="form1" >
            <input type=hidden name="sorter" value="{$sorter}">
               <table><tr>
               <form name="search_form" action="{$form.action}" method="post">
               <td class="form1" ><input type="text" name="search" value="{$search}"></td>
               <td class="form1" ><select name="s_type" style="">
               {section name=s loop=$types}
               <option value="{$smarty.section.s.index_next}" {if $types .sel}selected{/if}>{$types .value}</option>
               {/section}
               </select></td>
               <td class="form1"><input type="button" value="{$button.search}" class="button" onclick="javascript: document.search_form.submit();" name="search_submit"></td>
               </form>
               </tr></table>
            </td>
         </tr>
         </table>
   <!-- Code below successfully displays query results -->
     <form method="post" action="{$file_name}?sel=approve" enctype="multipart/form-data" name="form1" onsubmit="foo(); return false;">
      <table cellspacing="2" cellpadding="10" border="1">
        <tr align="center"><td>Num</td><td>Club Name</td><td>Login</td><td>Country</td><td>Region</td><td>City</td><td>Address</td><td>Web site</td><td>Email</td><td>Contact Name</td><td>Contact Phone</td><td>Swinging</td><td>Alcohol</td><td>Food</td><td>Entertainment</td><td>Fees</td><td>Approved/<br/>Rejected</td><td>Actions</td></tr>
        {foreach item=item from=$contest key=key name=foo}         
         <tr align="center"><td><input type="hidden" name="all_approves[{$item.id}]" value="{$item.id}"/>{$key+1}</td><td>{$item.name}</td><td>{$item.login}</td><td>{$item.country_name}</td><td>{$item.region_name}</td><td>{$item.city_name}</td><td>{$item.address}</td><td>{$item.web_site}</td><td>{$item.email}</td><td>{$item.contact_name}</td><td>{$item.contact_phone}</td>
<td>
{math equation="x - 1" x=$item.swinging   assign=index_pos}
{$xml_swing[$index_pos].value}</td>
<td>{math equation="x - 1" x=$item.alcohol   assign=index_pos}{$xml_alco[$index_pos].value}</td>
<td>{math equation="x - 1" x=$item.foot   assign=index_pos}{$xml_foot[$index_pos].value}</td>
<td>{math equation="x - 1" x=$item.entertainment   assign=index_pos}{$xml_entertainment[$index_pos].value}</td>
<td>{math equation="x - 1" x=$item.fees   assign=index_pos}{$xml_fees[$index_pos].value}</td><td>
         <span>  {if $item.is_approved eq '1'} Approved {else} Rejected {/if}</span></td><td align="center"><a href="{$file_name}?sel=edit&id_content={$item.id}">[&nbsp;Edit&nbsp;]</a><br/><a href="{$file_name}?sel=delete&id_content={$item.id}">[&nbsp;Delete&nbsp;]</a><br/><a href="{$file_name}?sel=approve&id_content={$item.id}">[&nbsp;Approve&nbsp;]</a><br/><a href="{$file_name}?sel=reject&id_content={$item.id}">[&nbsp;Reject&nbsp;]</a></tr>
      {/foreach}
      </table>
     </form>

Hello folks,   In trying to improve the user experience for my first WebApp I have decided to create two new tables - one a master file to contain a list of all stores, and the second a master file to contain a list of all products that are normally purchased - and I would like to use the values from these two tables as lookup values in dropdown listboxes, to which the user can also add new entries.   As it turns out, I'm stuck on the very first objective i.e. to lookup/pull-in the distinct values from the master tables.   The problem I'm having is that the query seems to return no rows at all...in spite of the fact that there a records in the table, and the exact same query (when run within the MySQL environment) returns all the rows correctly.   Is there something wrong with my code, or how can I debug to see whether or not the query is being executed?   Objective # 2, which is to allow new values to be entered into the dropdown listbox, and then inserted into the respective table is certainly waaay beyond my beginner skills, and I'll most certainly need to some help with that as well..so if I can get some code/directions in that regard it will be most appreciated.   Thank you.

<?php
   $sql = "SELECT DISTINCT store_name FROM store_master ORDER BY store_name ASC";

   $statement = $conn->prepare($sql);
   $statement->execute();

   $count = $statement->rowCount();                                    
   echo $count;

   // fetch ALL results pertaining to the query
   $result = $statement->fetchAll();

   echo "<select name=\"store_name\">";
   echo '<option value="">Please select...</option>';
   foreach($result as $row)
       {
          echo "<option value='" . $row['store_name'] . "'></option>";
       }
       echo "</select>";
?>

Say I do a query from a database that only asks for one field in return (which always has a number in it).  How do you write the PHP to take the first number returned and add it to the next number returned  (NOTE:  There may be more than two numbers returned, but for now, I'm always dealing with two)

For example, say I do a query that returns the number 27 first and then the number 10 second.  FYI, these numbers will be available in the variable $diff['result'].  So the code after the query would look something like this, but obviously i'm struggling with the part in comments...

Code: [Select]
if (!$numbers) {
die("Database query failed: " . mysql_error());
} else {
while ($diff = mysql_fetch_array($numbers)) {
//this would bring back 27 first, in the variable $diff['result'] and then on the 2nd loop through, it would bring back 10 in the $diff['result'] variable
                                                                //ultimately, i just want the difference between the numbers (which in the case would be 17).  It's just a simple addition, so Im obviously an idiot because I can't figure out the syntax for adding the first returned number to the next returned number:)



}

}

here is my code... please help

<form method="get" action="shit3.php">
<input maxlength="50" size="50" type="text" name="q"> <input type="submit" value="SEARCH">
</form>

<?php

if (@$_GET['q']) {

 $var = $_GET['q'] ;
 $trimmed = trim($var);

$limit=1;

   if ($trimmed == "")
       {
          echo "Please enter a search...";
    exit;
    }

   if (!isset($var))
       {
          echo "Container not found!";
    exit;
   }

mysql_connect("localhost", "xxx", "yyy") or die(mysql_error());
mysql_query("SET NAMES 'cp1251'");

mysql_select_db("agaexpor_container") or die("Unable to select database"); //select which database we're using

$query = "select * from containertracking where vin like \"%$trimmed%\"
 order by vin";

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

if (empty($s)) {
 $s=0;
 }

$query .= " limit $s,$limit";
 $result = mysql_query($query) or die("Couldn't execute query");

$count = 1 + $s ;

while ($row= mysql_fetch_array($result)) {
 $vin = $row["vin"];
 $container = $row["container"];

 echo "$count.) VIN: $vin <br />";
 echo "container is: $container <br />";
 
 $count++ ;
 }

}
?>

I'm hoping this is a simple question.
When I use the code below, my twitter search query appears in BOLD within the returned results. I would like to style the search term differently. I can use CSS to style the avatar, author, and other information within the returned results etc, but I can't figure out how to style the search term ($q) within the returned twitter information. Any help would be much appreciated.

<?php

class twitter_class
{    
    function twitter_class()
    {
        $this->realNamePattern = '/\((.*?)\)/';
        $this->searchURL = 'http://search.twitter.com/search.atom?lang=en&q=';
        
        $this->intervalNames   = array('second', 'minute', 'hour', 'day', 'week', 'month', 'year');
        $this->intervalSeconds = array( 1,        60,       3600,   86400, 604800, 2630880, 31570560);
        
        $this->badWords = array('somebadword', 'anotherbadword');
    }

    function getTweets($q, $limit=15)
    {
        $output = '';

        // get the search result
        $ch= curl_init($this->searchURL . urlencode($q));

        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']);
        $response = curl_exec($ch);

        if ($response !== FALSE)
        {
            $xml = simplexml_load_string($response);
    
            $output = '';
            $tweets = 0;
            
            for($i=0; $i<count($xml->entry); $i++)
            {
                $crtEntry = $xml->entry[$i];
                $account  = $crtEntry->author->uri;
                $image    = $crtEntry->link[1]->attributes()->href;
                $tweet    = $crtEntry->content;
    
                // skip tweets containing banned words
                $foundBadWord = false;
                foreach ($this->badWords as $badWord)
                {
                    if(stristr($tweet, $badWord) !== FALSE)
                    {
                        $foundBadWord = true;
                        break;
                    }
                }
                
                $tweet = str_replace('<a href=', '<a target="_blank" href=', $tweet);
                
                // skip this tweet containing a banned word
                if ($foundBadWord)
                    continue;

                // don't process any more tweets if at the limit
                if ($tweets==$limit)
                    break;
                $tweets++;
    
                // name is in this format "acountname (Real Name)"
                preg_match($this->realNamePattern, $crtEntry->author->name, $matches);
                $name = $matches[1];
    
                // get the time passed between now and the time of tweet, don't allow for negative
                // (future) values that may have occured if server time is wrong
                $time = 'just now';
                $secondsPassed = time() - strtotime($crtEntry->published);

                if ($secondsPassed>0)
                {
                    // see what interval are we in
                    for($j = count($this->intervalSeconds)-1; ($j >= 0); $j--)
                    {
                        $crtIntervalName = $this->intervalNames[$j];
                        $crtInterval = $this->intervalSeconds[$j];
                            
                        if ($secondsPassed >= $crtInterval)
                        {
                            $value = floor($secondsPassed / $crtInterval);
                            if ($value > 1)
                                $crtIntervalName .= 's';
                                
                            $time = $value . ' ' . $crtIntervalName . ' ago';
                            
                            break; 
                        }
                    }
                }
                
                $output .= '
                <div class="tweet">
                    <div class="avatar">
                        <a href="' . $account . '" target="_blank"><img src="' . $image .'"></a>
                    </div>
                    <div class="message">
                        <span class="author"><a href="' . $account . '"  target="_blank">' . $name . '</a></span>: ' . 
                        $tweet . 
                        '<span class="time"> - ' . $time . '</span>
                    </div>
                </div>';
            }
        }
        else
            $output = '<div class="tweet"><span class="error">' . curl_error($ch) . '</span></div>';
        
        curl_close($ch);
        return $output;
    }
}

?>


The HTML I have been using with this code is here
Code: [Select]
<!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>
<title>Twitter</title>
</head>
<body>
<?php
  require('twitter.class.php');
  $twitter = new twitter_class();
  echo $twitter->getTweets('example search term', 10);
?>
</body>
</html>
This is not my code. It is from a tutorial that can be accessed from here >> http://www.richnetapps.com/php-twitter-search-parser/

Is it possible to create a PHP array that contains only keys?

	array
	1
	3
	5
	6
	7
	

 

I have a query that returns row ID's that I want to put into an array to do some work.  There is no real concept of a "value" - I just need to store a list of the database table rows that i want and that's it!

 

Edited February 16 by SaranacLake

is there a way to reset the array keys? to 0,1,2,3,...

also for example that i have something like this:

$array['dog']='dog';
$array['mouse']='mouse';
$array['cat']='cat';

and i want it like this:

$array[0]='dog';
$array[1]='mouse';
$array[2]='cat';

is there a function for that already in php?

I have an array of type
Code: [Select]
Array ( [2] => Array ( [name] => Shelby Baptist Medical Ctr [city] => Alabaster ) [1] => Array ( [name] => Andalusia Regional Hospital [city] => Andalusia ) [0] => Array ( [name] => Long Term Hospital of Anniston [city] => Anniston ))
How can sort the keys of an array but there content remains the same so that they are like
Code: [Select]
Array ( [0] => Array ( [name] => Shelby Baptist Medical Ctr [city] => Alabaster ) [1] => Array ( [name] => Andalusia Regional Hospital [city] => Andalusia ) [2] => Array ( [name] => Long Term Hospital of Anniston [city] => Anniston ))
Can someone please point me if there is any func. for this

hey guys im trying to result an array key and value if it has one...the code and results are below if anyone can help with this simple problem...thanks alot

Code: [Select]
<?php

$columns = array('news_id' => 'id', 'news');

foreach ($columns as $column => $column_alias)
{
echo $column . ' ' . $column_alias;
}
?>
the result im getting is:

news_id  id
0 news

but im just after the result of just result the column name and alias (if it has one)
so im looking for the result

news_id  id
news

Hello

I am having some trouble with array_keys

I have an array for which I want to return all the keys based on value X

This is my code:

Code: [Select]

$depth = array_keys(X', $Array);

echo print_r ($depth,1);



I have checked the content of my array $Array and it contains at least 1 instance of 'X' but I am getting nothing when I do the print_r

Any suggestions would be appreciated

Thanks

Hi ..
i have an array format like (mysql result array)
$new_array=Array ( [0] => Array ( [quantity] => 5 )  [1] => Array ( [quantity] => 25 )  [2] => Array ( [quantity] => 20 ) )

I have to convert this array into the following format
$new_array['quantity'][0]=5
$new_array['quantity'][1]=25
$new_array['quantity'][2]=20


How to convert this array format using any standard array method.

The title makes it sound more complicated than it is.

I have a recurring function that searches for a specific value in a multi-dimensional array. When it finds it, it returns an array of the index.

For example, if it found the value at $array[1][4][2][0], it would return an array like this:
[0]=>1
[1]=>4
[2]=>2
[3]=>0

Here's the function.
Code: [Select]
<?php

// Other Code

/**
 * Find's the parent of an item
 * Unfortunately, it takes a bit more work than just using the loudspeaker at a grocery store
 * @param int $parent The parent to be searched for
 * @param array $array 
 * @param array $cur_index
 */
private function findParent($parent, $array, $cur_index)
{
    for($i = 0; $i < count($array); $i++) { // Search the array
        if($array[$i]['id'] == $parent) { // If the parent is found
            $cur_index[count($cur_index)] = $i;
            return array(true, $cur_index);
        }

        if(count($array[$i][1]) > 1) { // Call findParent again to search the child
            $cur_index[count($cur_index)] = $i;
            $found_in_child = $this->findParent($parent, $array[$i], $cur_index);
            if($found_in_child[0]) {
                return $found_in_child;
            }
        }
    }
    
    return array(false); // Return no matches
}
I need to be able to call that index using the keys from the key array (as we will call it). How can I do that?

Thank you in advance for your help.

I have a sequential multidimensional array with many outer rows where all the inner arrays have the same number of elements as another sequential array which represents metadata of the first array's inner arrrays.

$keys: 

["time","system1_typeA","system2_typeA","system1_typeB","system3_typeC","system2_typeB","system1_typeC"]

$arrayValues: 

[
    ["2020-06-27 07:40:06",2.16,9.25,9.44,7.76,5.43,1.12],
    ["2020-06-27 07:40:23",2.66,8.93,4.31,6.59,8.44,3.42],
    ["2020-06-27 07:41:24",8.71,2.78,8.92,6.58,3.65,4.38],
    ["2020-06-27 07:41:58",1.86,6.36,2.65,3.99,7.25,3.32],
    ["2020-06-27 07:42:33",8.71,3.66,8.82,8.54,8.22,4.51]
]

My desired output is: 

{
    "time": ["2020-06-27 07:40:06", "2020-06-27 07:40:23", "2020-06-27 07:41:24", "2020-06-27 07:41:58", "2020-06-27 07:42:33"],
    "system1": {
        "typeA": [2.16, 2.66, 8.71, 1.86, 8.71],
        "typeB": [9.44, 4.31, 8.92, 2.65, 8.82],
        "typeC": [1.12, 3.42, 4.38, 3.32, 4.51]
    },
    "system2": {
        "typeA": [9.25, 8.93, 2.78, 6.36, 3.66],
        "typeB": [5.43, 8.44, 3.65, 7.25, 8.22]
    },
    "system3": {
        "typeC": [7.76, 6.59, 6.58, 3.99, 8.54]
    }
}

Is there much faster way to do so than the following?  I would like to use a built in function like array_combine() if possible, but grouping by system and type creates an issue.

function transform(array $keys, array $arrayValues):array {
    $map=[];
    foreach ($keys as $key) {
        $map[] = explode('_',$key);
    }
    $count=count($keys);

    $newValues=[];
    foreach ($arrayValues as $i=>$arrayValue) {
        $newValues['time'][]=$arrayValue[0];
        for ($i = 1; $i < $count; $i++) {
            $newValues[$map[$i][0]][$map[$i][1]][]=$arrayValue[$i];
        }
    }
    return $newValues;
}

 

Hey guys so I've been trying to figure something out for a day now but I really don't know where to start, basically I'm trying to create some kind of function that goes through my array and checks if the keys value is less than 5, if it is then I want to unset the key removing it from the array,   I programmed this underneath as this is basically what I want to achieve however there's a syntax issue as the array_key_excists function doesn't seem to allow the if statement, if anyone knows anything about it it would be very helpful!

if (array_key_exists(($key > 5),$data))
 {
    unset($data[$key]);
 }

any help is very much appreciated,   Thanks very much in advance!

Hi guys,

I am getting data from a json source:

```

$jsondata = file_get_contents($url);
  $response = json_decode($jsondata, true)
  echo "<pre>"; print_r(array_keys($response));; echo "</pre>";

```

and this returns:

```

Array
(
    [0] => jsonapi
    [1] => data
    [2] => links
)

```

I want  to extract data from specific key in the data array (eg 'title'):

```

    [data] => Array
        (
            [0] => Array
                (
                    [type] => recipes
                    [id] => d6cd7643-6e44-4d26-9ed9-9da7196cef12
                    [attributes] => Array
                        (
                            [internalId] => 7
                            [isPublished] => 1
                            [title] => Deep mediterranean quiche
                            [createdAt] => 2019-05-07T13:34:27+0200
                            [updatedAt] => 2019-05-07T13:34:27+0200
                            [isPromoted] => 1
                            [path] => /recipes/deep-mediterranean-quiche
                            [cookingTime] => 30
                            [difficulty] => medium
                            [ingredients] => Array
                                (
                                    [0] => For the pastry:
                                    [1] => 280g plain flour
                                    [2] => 140g butter
                                    [3] => Cold water
                                    [4] => For the filling:
                                    [5] => 1 onion
                                    [6] => 2 garlic cloves
                                    [7] => Half a courgette
                                    [8] => 450ml soya milk
                                    [9] => 500g grated parmesan
                                    [10] => 2 eggs
                                    [11] => 200g sun dried tomatoes
                                    [12] => 100g feta
                                )

                            [numberOfservings] => 8
                            [preparationTime] => 40
                            [instructions] => 

```

How do I loop through the data array and select just the 'title' and 'difficulty' for example?

Edited May 12, 2019 by ludo1960