PHP - Get Word Count Index Within Exploded Array.

How to COUNT  the number of records (pulled from a db)which  contains the word "APPROVED". This code doesn't work though.

$result1;
$result2;
$result3;

$approvedApplicants = COUNT($result1=='Approved', $result2=='Approved', $result3=='Approved')
echo ($approvedApplicants)

hello.

im trying to get some results from a db and all i keep getting is the word ARRAY ??

I want to get all the placeholders that relate to a page.

so if pageID=1 has place holder 1, place holder 2 and place holder 3 it will return 1, 2, 3  etc...

in the db i have

id     pageID    phNumber
1        1           1
2        1           2
3        1           3
etc..


this is the code i have

Code: [Select]
public function find_placeholders($pageID=0){

$sql = "SELECT phNumber FROM ".self::$table_name." WHERE pages_id=".$pageID."";
$result_array = self::find_by_sql($sql);
return $result_array;
}


and on the page i have..

Code: [Select]
<?php echo Placeholders::find_placeholders($pageID); ?>

all i get is Quote

Array



once i solve this problem i will want to use each number in the array to find the content for each.
so if i get 1,2,3

i will try and do some thing like.
foreach placeholder number echo elements

but 1 step at a time

thanks
for any help

rick

Hey i hope the title explains it enough. I'm just trying to get into classes.  I am making a function to make making mysql querys easier.

I pass the class the first string

$db->inputstring("INSERT INTO ? (?,?) VALUES ('?','?')");
$db->format('mytable','id','name','1','ben');

Can someone tell me how the format fuction would look? Im not sure how to swap arrays.

Hey guys does anyone know how i would go about generating a random word from an array?

For example:

$words = array("[apple]","[banana]","[kiwi]");

how would i have php choose one of these words and then spit it out?

Thanks!!!

I have the following array:

Code: [Select]
Array ( [item0] => Array ( [0] => name1
                                         [1] => name2
                                         [2] => name3
                                         [3] => name4
                                         [4] => name5 )etc...

Is it possible to count the number of times a name exists in the compleet array?

Thanx in advance!

Code: [Select]
$LinksText = array();
    for ($i=0; ($i < $cnt && $i < $total); $i++ ) {
                $Text = explode ('#', $Links[$i]);
                $LinksText[]=$Text[1];
        }
$count = count($LinksText);
print_r(LinksText);
        print count($LinksText);

if($count > 0){
echo "I am not zero"
}
else {
echo "I am zero"
}

Code: [Select]
output:

Array ( [0] => [1] => ) 2


Please tell me why the array count is 2.

Hi, can anyone help me with this.

I have a column in my table call "machine", I want to count the number of time each appears and return the results into an array

In the example below the number of times each printer appears in the column is returned to the array


____________
machine
____________
fb7500-1
fb7500-2
turbojet
turbojet
xl1500-1
xl1500-2
canon
roland

When I run the following I get the names as well as the values and I just want the values??

Result like this

Canon   1
FB7500-1   1
Roland   1
TurboJet   2
Vutek QS3200   1
XL1500-1   1

Code: [Select]
<?php
mysql_connect("localhost","XX","XX");
@mysql_select_db("schedule") or die( "Unable to select database");

date_default_timezone_set('Europe/London');

$query = "SELECT machine, COUNT(machine) FROM maindata GROUP BY machine"; 

 
$result = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($result)){

$array = array( 'key1' => $row[0], 'key2' => $row[1],'key3' => $row[2],'key4' => $row[3], 'key5' => $row[4],'key6' => $row[5],'key7' => $row[6]);
extract($array);
echo "$key1<br>$key2<br>$key3<br>$key4<br>$key5<br>$key6<br>$key7";

}
?>

Hi guys,

I have a simple query he

      $sql="SELECT user_id FROM $tbl_name WHERE email='$loginuseremail' AND password='$loginpassword'";
      $result=mysql_query($sql);
      $row = mysql_fetch_assoc($result);
      
//START SESSION   
      session_start();
         $_SESSION['username']=$loginuseremail;
         $_SESSION['user_id']=$row;
   
         echo $_SESSION['user_id'];   

It should obviously output an ID number but instead I just get the word 'Array'. If I remove the  mysql_fetch_assoc() I just get 'Resource ID #4'.

Can anyone point me in the right direction?

Thanks!

Is there a way to send exploded data into a database without using multiple loops just to do so? My current code, but it only inserts the name value in the database as Array.

$chicken_names = mysql_real_escape_string($_POST['names']);

$chicken_names_exp = explode(' ', $_POST['names']);

foreach($chicken_names_exp as $value)

{

mysql_query("INSERT INTO names VALUES (null, '$chicken_names_exp"', '". $_POST['type'] ."')");

}

echo "Success! You have successfully sent in your chicken names! <a href='index.php'>Home</a>";

Hello phpfreaks 

I'm a bit new to PHP, as well as this forum.

I'm learning in a fast way, but there's something I can't seem to figure out, nor find it on google.
I'm sure it's a simple and basic trick, but like I said, I'm just a beginner

So the question is: How can I store multiple words to an array, using only 1 input form field?

I guess it's with a for-loop..?

So everytime you hit the 'submit' button, a new word should be added to the array. My problem is that I'm always overwriting ONE word..

This is what I've got so far.. :

Code: [Select]
<?php
if (isset($_POST['word'])){
$word = $_POST['word'];
$word = strip_tags($word);
$word = trim($word);
$word = htmlentities($word);
}
else {
$word = "";
}
?>

<div id="arrays">
<p>Add a word to the array below:<br /><br /></p>

<form action="index.php" method="post">
<input id="word" name="word" type="text" value="<?php echo $word; ?>" />
<br /><input class="btn" type="submit" value="Submit" />
</form>

<br />

<p>
<?php 
$array = array("apple", "banana", "lemon", $word);

for ($i = 0; $i < count($array); $i++){
echo $array[$i] . " ";
}
?>
</p>
</div>


Also: I'm using PHP 5, in combination with xHTML strict 1.0.

<?php

$title = "This is an example of a sentence in a paragraph";
$title_array = explode(" ", $title);

$count = strlen($title_array[0]);
?>
what i want to do is store the count for every characters of every word in the array using a loop
e.g the count will be stored in a variable $chr_count then when i access the count for "This" it should be like this $chr_count[0]=4, $char_count[1]=2 etc.

HI - I have tried COUNT and array_count _values but they don't do what I want.

I have an array of 'quantities' relating to orders.

I want to count how many key=>value pairs have a positive value that is to say Not 0 or null or "".

So for example array ( shoes=>5, coats=> 3, ties=>0)

The answer I seek in this case would be 2 as ties is zero.

I don't want to know what the aggregate of the values are or other such info.

I have tried looping through with a foreach loop testing for $value > 0  and I failed miserably

Any ideas ?

Many Thanks !

Hello;

I would like to do the following operation;

Count duplicate (adjacent)

my code

 

        <?php  
      
$Array = array("test", "test", "hello", "test", "world", "world", "world", "hello", "test");


 for( $i= 0 ;  $i <= 6 ;$i++ ) {
$j=1;
 if ($Array[$i] === $Array[$i+1]) {
 
 $j+=$j; 

echo  $j;
}
?>

and showing something like 2,1,1,3,1,1

Thanks

Hi all

I am trying to loop through an array and output as JSON.
What I'm looking to do is create something like:

Code: [Select]
  "something": [
{"title":"Test 1"},
{"title":"Test 2"}
],

Notice that the final row has no comma.

My code is as follows:


<?php foreach($something as $thing): ?>
<?php $something_array = array('title'=>$thingt->getId()); ?>
<?php echo json_encode($something_array).','."\n"; ?>
<?php endforeach; ?>


I had to add a comma to the end of the array, or the JSON rows would not be ended with one.

How can I get it so that, no matter how many items are in the array, the last row, wil not have the comma at the end?

With the comma at the end, my JSON doesn't validate

Thanks


[/code]

Hey guys I'm having an issue trying to get my PHP to display the first url of my exploded string and non of the others. The SQL table column contains strings like this:

http://www.imgurl.com/image.jpg,http://www.imgurl.com/image2.jpg,http://www.imgurl.com/image3.jpg,http://www.imgurl.com/image4.jpg