PHP - Count Each Time The Function Runs

I have no idea why but no matter what the eventid is, the label always returns 20 and I"m not sure why. Is my synatx wrong?


$eventid = (int)$_GET['eventid'];
$result = mysqli_query($dbc, "SELECT count(label) FROM `events` WHERE `event_id` = '$eventid'");
$label = $result + 1;
echo $label;

How can I modify the following code to not display $hash_row['total'], but to display the sum of the counted "total" value + 1?  Is there a way that I can assign that variable in the "select query" area (for instance, "COUNT(hr.hasher_id) + 1 as total1"), and then call $hash_row['total1] in the result table?

I'm not sure if the syntax exists to add an integer value to a COUNT value and assign to a new variable...

Code: [Select]
<?php 
include "modules/dbase_connection.php";

#create MySQL connection
$sql_connection = sql_connect("blah","blah","blah","blah");

# select the Hashers and  hashes by total number<br />
$hash_query = "
SELECT
ha.*,
COUNT(hr.hasher_id) as total
FROM
hashers as ha,
hash_records as hr
WHERE
hr.hasher_id = ha.hasher_id
GROUP BY
         hr.hasher_id
ORDER BY
total DESC
";

$hash_result = mysql_query($hash_query) or die(mysql_error());

$x = 1;


while($hash_row = mysql_fetch_array($hash_result))
{
#display the table header
if($x == 1) {
echo '
<br />
<table align="left">
<br />
<tbody>
<tr><br /><td colspan="2"><strong>Potential On-Sec</strong></td><br /></tr>';

         $x++;
}

echo '<tr><br /><td>' . $hash_row['hasher_name'] . '</td><br /><td>' . $hash_row['total'] . '</td><br /><td>- ' . $hash_row['real_name'] . '</td><br /></tr>';
}
echo '</tbody></table></td><br />';

?>

I am writing a function to count the words that have been typed into a text box. I originally had it working when I first wrote it but it was counting all of the punctuation as a word so I I tried adding some code to eliminate that. Now it is not working. Could someone help me?

Here is my code
Code: [Select]
function count_words($description){
$word_count = 0;
$description = trim(preg_replace("/\s+/"," ",$description));
$word_array = explode(" ", $description);

for($i=0; $i < count($word_array); $i++){
if (preg_match("[0-9A-Za-z]", $word_array[$i])) {
$word_count++;
}
return $word_count;
}
  }

Code: [Select]
function width2($noid)
{
$getwidth =  mysql_query("SELECT * FROM block WHERE sid='$theid'",$this->connect);

while($row1 = mysql_fetch_assoc($getwidth)) {

$this->width2($noid);


}

}

how do i count how many times the function loops?

I know there has to be a better way to count how many entries I have in my mysql db than what I'm currently using. Let me just show you what I'm trying to do and it will make better sense.

http://batads.com/display.php

You see how I am echoing the number of each category on one page?

I am sure the current script I am using is insanely inefficient and as my DB grows I think it will cause me problems. Any suggestions on how to do this more efficiently?

Below is what is currently running that page.

Thank you.

Code: [Select]

<td><h4>Public Ads</h4><br>
<?php echo '<a href="browse1.php?cat=1">Bill Boards<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='1'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }?>
<?php echo '<a href="browse1.php?cat=2">Transportation<a/>';
 $query = "SELECT category, COUNT(*) FROM postlisting WHERE category='2'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }?>
<?php echo '<a href="browse1.php?cat=4">Shopping Centers<a/>';
 $query = "SELECT category, COUNT(*) FROM postlisting WHERE category='4'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=3">Posters / Signs<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='3'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }?>
        <?php echo '<a href="browse1.php?cat=5">Bus Stops<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='5'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }?>
<?php echo '<a href="browse1.php?cat=6"> Other-Public<a/>';
 $query = "SELECT category, COUNT(*) FROM postlisting WHERE category='6'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?></td>
<td><h4>Event Sponsorship</h4><br>
<?php echo '<a href="browse1.php?cat=7">Concerts<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='7'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=8">Fairs<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='8'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?>
<?php echo '<a href="browse1.php?cat=10">Sports<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='10'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } 
 ?>
<?php echo '<a href="browse1.php?cat=9">Trade Shows<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='9'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?>
<?php echo '<a href="browse1.php?cat=11">Other-Event<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='11'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?></td>

<td><h4>Online Ads</h4><br>
<?php echo '<a href="browse1.php?cat=12">Banner Space<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='12' ";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=13">Social Media<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='13' ";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=14">Email Lists<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='14'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=15">Blog Articles<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='15'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=16">Ezine Articles<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='16'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1area.php?cat=17">Other-Online<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='17'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?></td>
</tr>
<tr>
<td><h4>Print Ads</h4><br>
<?php echo '<a href="browse1.php?cat=18">Magazine<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='18'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=19">Newspaper<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='19'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=20">Brochure<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='20'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
 
        <?php echo '<a href="browse1.php?cat=21">Press Release Print<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='21'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=22">Other-Print<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='22'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?></td>
<td><h4>Broadcasting Ads</h4><br>
<?php echo '<a href="browse1.php?cat=23">TV / Commercial<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='23'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=24">Radio<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='24'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
        <?php echo '<a href="browse1.php?cat=27">Movies<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='27'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
        <?php echo '<a href="browse1.php?cat=25">Mobile Phone<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='25'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=28">Cinema<a/>'; 
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='28'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }?>
        <?php echo '<a href="browse1.php?cat=26">Press Release TV<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='26'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=29">Other-Broadcast<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='29' ";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?></td>
       
<td><h4>Commercial Space</h4><br>
<?php echo '<a href="browse1.php?cat=33">Private Property<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='33'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=34">Vehicle Wrap<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='34'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
        <?php echo '<a href="browse1.php?cat=35">Front Yard<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='35'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
        <?php echo '<a href="browse1.php?cat=36">Self Promotion<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='36'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=37">Other-Commercial<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='37'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?></td>
</tr>
<tr>
<td><h4>Business Ads</h4><br>
<?php echo '<a href="browse1.php?cat=30">Window Display<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='30'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=31">Interior Ads<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='31'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=32">Point of Sale Ads<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='32'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=41">Other-Business <a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='41'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?></td>
</td>

<td><h4>Misc</h4><br>
<?php echo '<a href="browse1.php?cat=38">Creative Advertising<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='38'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?>
        <?php echo '<a href="browse1.php?cat=39">Video Games<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='39'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?>
<?php echo '<a href="browse1.php?cat=40">Other-Misc<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='40'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?>
</td>


</tr>
</table>

I tested each variable individually and it appears that the $format variable is causing problems everytime I plug it in.  What am I doing wrong here?


//$time is pulled from the db in the timestamp format
//$tzone is a value like +1 hour, +3 hours etc.
//$format is a value like M.d.Y h:i A
function converttime($time){
return '<i>'.date($format, strtotime($time . $tzone)).'</i>';
}

Hello. I'm trying to create a function that will turn my timestamp into something like "9 hours ago", "3 days ago", ect.. so far I have the below function which seems to do the job fine. only problem is when i try to include it within a span it always places itself right before it.

I use
Code: [Select]
echo "<span class=\"smalltext\">".time_stamp($date)."</span>";
witht the following function
Code: [Select]
function time_stamp($session_time)
{
$time_difference = time() - $session_time ;

$seconds = $time_difference ;
$minutes = round($time_difference / 60 );
$hours = round($time_difference / 3600 );
$days = round($time_difference / 86400 );
$weeks = round($time_difference / 604800 );
$months = round($time_difference / 2419200 );
$years = round($time_difference / 29030400 );
// Seconds
if($seconds <= 60)
{
echo "$seconds seconds ago";
}
//Minutes
else if($minutes <=60)
{

   if($minutes==1)
  {
   echo "one minute ago";
   }
   else
   {
    echo "$minutes minutes ago";
   }

}
//Hours
else if($hours <=24)
{

   if($hours==1)
  {
   echo "one hour ago";
  }
  else
  {
   echo "$hours hours ago";
  }

}
//Days
else if($days <= 7)
{

  if($days==1)
  {
   echo "one day ago";
  }
  else
  {
   echo "$days days ago";
   }

}
//Weeks
else if($weeks <= 4)
{

   if($weeks==1)
  {
   echo "one week ago";
   }
  else
  {
   echo "$weeks weeks ago";
  }

}
//Months
else if($months <=12)
{

   if($months==1)
  {
   echo "one month ago";
   }
  else
  {
   echo "$months months ago";
   }

}
//Years
else
{

   if($years==1)
   {
    echo "one year ago";
   }
   else
  {
    echo "$years years ago";
   }

}

}
in the end I get the span tag with nothing in it and the text right before it. What am I doing wrong?

Hi guys,

I need your help. I am trying to insert the rows in the mysql database as I input the values in the url bar which it would be like this:

Code: [Select]
www.mysite.com/testupdate.php?user=tester&pass=test&user1=tester&email=me@shitmail.com&ip=myisp

However i have got a error which i don't know how to fix it.


Error: Column count doesn't match value count at row 1


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbusername');
    define('DB_PASSWORD', 'mydbpassword');
    define('DB_DATABASE', 'mydbname');

$errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {

die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
  $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    $adduser = clean($_GET['user1']);
    $email = clean($_GET['email']);
    $IP = clean($_GET['ip']);
    if($username == '') {
  $errmsg_arr[] = 'username is missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD is missing';
  $errflag = true;
    }
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
   $sql = "INSERT INTO `members` (`username`,`email`,`IP`) VALUES ('$adduser','$email','$IP')";

if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }
echo "The information have been updated.";
  }
?>


Here's the name of the columns i have got in my database:

Code: [Select]
username
email
IP


I have input the correct columns names, so I can't correct the problem I am getting.

Please can you help?

hello i got this small function i`m working on to get the date of a month something like get current date - 1 but not sure how to handle jan month can someone help me please ?



$month = date('m') - 1;
$date_startt = date('Y').'-'.$luna.'-01';
$timestamp_start = strtotime($data_start);

Hi there, what I have been trying to do is add some additional logic.. My problem is I want to stop displaying the month and day after the year 2000? I know I need to add an if and else statement but this is my first actual project and I am a little stuck.. here is the page, it's a plugin for a timeline http://www.llandover...oject-timeline/   And the file is attached below.. any help would be appreciated. The plugin code was too long to just post in here, didn't want to cause any slow loading issues for people on a slow connection.. Thanks and I appreciate any help.    Attached Files  annual_archive.php   18.15KB   5 downloads

<?php

function time_convert($l_timestamp)
  {
    $l_timestamp = $l_timestamp * 86400;
    $time = date('Y-m-d',$l_timestamp);
    echo(date('Y-m-d',$l_timestamp));          //This does
    return (date('Y-m-d',$l_timestamp));      //This does not work
    return $time;         // This does not work
    echo $time;          //This does not work
  }
  
time_convert(32155.0);
?>


Can anyone help me, I am not getting the return parameter as I want

I have a php code that call a process (a java program). The process runs in background for a so long time - from 1 minute to 2 hours. I make the process call using exec:

<?php
function execInBackground($cmd) {
    if (substr(php_uname(), 0, 7) == "Windows"){
        pclose(popen("start /B ". $cmd, "r"));
    }
    else {
        exec($cmd . "  &> /dev/null &");
    }
}
$command = "java ... ReadEmailsCmdLine 2>&1";
execInBackground($command);

echo "FINALIZADO";

Though the command runs in background it looks that the PHP code wait for the command completion to send a answer to client browser because I just see "FINALIZADO" after the java program finished its execution.

Does someone know how I can solve this problem? Or at least does have a hint/pointer for that?

Since now I thanks any comment/suggestion

This topic has been moved to MySQL Help.

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