PHP - Result Streak

at the moment i have my page:

addevent.php

i have written:
Code: [Select]
   $q = "SELECT username "
       ."FROM ".TBL_USERS." ORDER BY ASC";
   $result = $database->query($q);

on the database.php page here is what query looks like:
Quote

   /**
    * query - Performs the given query on the database and
    * returns the result, which may be false, true or a
    * resource identifier.
    */
   function query($query){
      return mysql_query($query, $this->connection);
   }



then i want to display $result in a drop down menu so i wrote back on addevent.php:

Code: [Select]
<select name="Select1">
<option value="<? echo("$result"); ?>"><? echo("$result"); ?></option>
</select>

I'm writing an admin panel for my site (to manage users, etc)


I selected the user-rights from the DB, but how can I check it the user-rights is equal to 3, and if it is allow access?

Basically I want this to do do is:

if (there is no result found in the query){
 echo "nothing for this brand";
}else{
echo this link;
}

this is my code...im just confused on what i want the if statement to to ask for.

any help would be greatly appreciated

Code: [Select]
<?php
$mypro = mysql_query("SELECT * FROM Sheet1 WHERE pro_catagory LIKE '%People%' ORDER BY pro_id DESC");
while($row=mysql_fetch_array($mypro)) {
if(Not sure what to put here){
echo "There are no listings for the brand right now";
}else{
 print "-&nbsp;<a href='proList.php?proNumber=".$row['pro_id']."'>".$row['pro_name']."</a><br />";
 }
}
?>

Hey Everyone,

I am posting today because I have a site I am working on which uses the xzero classifieds and having a small problem accomplishing something with it. I am trying to relocate the ad count number (of the city the user is currently browsing) to a box in my sidebar which has various site statistics like the following

Online Users: XX
Ads in this city: 0

But my code keeps giving me a 0 (even after I posted some test ads)

Anywho, heres what I have so far but cant seem to make it work

<?php
$country_adcounts = array();
$city_adcounts = array();
$sql = "SELECT ct.cityid, c.countryid, COUNT(*) as adcnt
FROM $t_ads a
INNER JOIN $t_cities ct ON ct.cityid = a.cityid AND ($visibility_condn)
INNER JOIN $t_countries c ON ct.countryid = c.countryid
WHERE ct.enabled = '1' AND c.enabled = '1'
GROUP BY ct.cityid";

$res = mysql_query($sql) or die(mysql_error().$sql);

while($row=mysql_fetch_array($res))
{
$country_adcounts[$row['countryid']] += $row['adcnt'];
$city_adcounts[$row['cityid']] += $row['adcnt'];
}

$adcount = 0+$city_adcounts[$city['cityid']];
?>

and this is the code which should recall the adcount

<?php echo $adcount; ?>

What am I doing wrong? I'm placing the first code on my sidebar and attempting to call the ad count through an echo. So ya, if anyone could tell me why this isn't working or lend a hand in helping me fix it please know I'll greatly appreciate it. 

Thanks.

Good Day,

I'm struggling to get strtotime() to return anything.

I have the following code..
$fields['birth']['day'] = 9;
        $fields['birth']['month'] = 7;
        $fields['birth']['year'] = 1982;
        $dob = $fields['birth']['day'].' '.$fields['birth']['month'].' '.$fields['birth']['year']; // Returns: 9 7 1982
        $dob = strtotime($dob); 
        die($dob);

No matter what I do $dob isn't returning anything once strtotime() is used. I've tried matching my day/month/year 's with examples in the manual on the strtotime() page but using date() on the fields, but it still doesn't want to return anything.

I feel I'm missing something simple here.

Any help is appreciated.

Regards,
Ace

Hello, everyone. I am having some trouble figuring this out. I am trying to create a paging bar(so to speak) to display results by page number.
Trying to get the paging bar to go as follows...
Requested Page     The resulting paging bar
Page 1                     1 2 3 4 5
Page 2                     1 2 3 4 5
Page 3                     1 2 3 4 5
Page 4                     1 2 3 4 5
Page 5                     4 5 6 7 8
Page 6                     4 5 6 7 8
Page 7                     4 5 6 7 8
Page 8                     7 8 9 10 11
......
This is what I have right now that I am trying to get to work. I have changed this so many times and been working on it for 2 days. I think I'm just confusing my self. This can't be that hard.. 
Code: [Select]
<?php
echo '<html>';
//---these values changed based on query----
$Page=$_GET["page"]; //the page number requested
$AvailablePages=5; //number of pages available after the page requested

//---calculations---
$StartPage=round($Page/5)*5;
$EndPage=ceil($StartPage/5)*5 ; //the last page number to be displayed in paging
if($StartPage<5) {$StartPage=1;}

//just looking at variables
echo 'page is: ' . $Page . '<br>';
echo '<br>Starting @: ' . $StartPage;
echo '<br>Ending @: ' . $EndPage . '<br>';

//--create the paging bar--
$PagingBar='';
while($StartPage<=$EndPage)
{
if($Page==$StartPage) {
$PagingBar=$PagingBar . $StartPage . '';
}
else {
$PagingBar=$PagingBar . '
<a href="test.php?page=' . $StartPage . '">' . $StartPage . '</a>
';
}
$StartPage++;
}

//---show the paging bar--
echo $PagingBar;
echo '</html>';
?>

Hello all,

I'm struggling adding a count result to this script.  I want each result to be an id so I can place x amountof images in one position and the remaining in another position.  Each user might have different awards so just using the award_id is no good as there will be empty space so I need the actual result to display a id number.

Code: [Select]

$res = mysql_query("SELECT award, image FROM awards WHERE active = '1'");


$codes = array();
while ($row = mysql_fetch_assoc($res)){
   $codes[$row['award']] = $row['image'];
}


$userid = '1';


$res = mysql_query("SELECT * FROM user_awards WHERE user_id = '$userid'");


$row = mysql_fetch_assoc($res);
foreach ($codes as $award => $image){
   if ($row[$award] == 1){
      echo "<img src=../$image><br/>";
   }
}

Hi guys,   Here's my code:

<?php
$servername="127.0.0.1";
$username="root";
$password="";
$dbname="testdb";
$connection = new mysqli($servername,$username,$password,$dbname);
$sql = "SELECT Wages FROM w WHERE \"Country\"=\"".$_POST["blah"]."\"";
$r = $connection->query($sql);
$result = $r->fetch_all(MYSQLI_ASSOC);
echo $result;
?>

  When I go to the page I get the following message: Notice: Undefined index: w in C:\xampp\htdocs\test\processing.php on line 13
  Does anyone know what problem I'm having here? /stuck   Cheers, B

Hey everybody, i'm building a website for the softball league i play in.... so far the website is pretty good... with all the stats and profiles.... i'm having a little problem with the ORDER of the leaders in the categories i have to calculate the result...

for example... avg. is the result of the total hits divided by the total number of at bats... both numbers are coming from the database... the problem comes when i have to order the leaders from first to last...

this is my php:

Code: [Select]
$sql = "select profile_id, SUM(total_hits) AS hitstotal, SUM(ab) AS abtotal from batters WHERE year = '2010' GROUP BY profile_id";

$cons = mysql_query($sql);
while ($result = mysql_fetch_array($cons)) {
$sumaab = $resultad['abtotal'];
$sumahits = $resultad['hitstotal'];
$p_id = $resultad['profile_id'];
$prom = round(($sumahits."") / ($sumaab.""),3);

that gives me all the batting averages for the players.

and here is my question:
how can i order that $prom result from first to last?

hello, anybody able to help me with why this is only returning the first staff member's hours?

Code: [Select]
<?php

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

$y3=$_POST['y'];
$m3=$_POST['m'];
$d3=$_POST['d'];

$pdate=$y3."-".$m3. "-".$d3;
$pdate1 = date( 'D M j', strtotime($pdate) );
} else {


$pdate =  date('Y-m-d', strtotime("-1 day") );
$pdate1 = date( 'D M j', strtotime($pdate) );


}
echo "<table border='1' style='border-collapse: collapse' bordercolorlight='#000000' bordercolordark='#000000' width='98%' align='center'>";
echo "<tr><td width='100%' colspan='9' align='center'><b>Timesheets For $pdate1</b></td></tr>";


$result = mysql_query("SELECT * FROM staff ORDER BY name");
while($row = mysql_fetch_array($result))
{
$eid=$row['eid'];
$name=$row['name'];

  echo "<tr>";
  echo "<td align='left' colspan='9'><b>" . $name . "</b></td>";
  echo "</tr>";
 
 echo "<tr>
<th align='center'>Date</th>
<th align='center'>Job Number</th>
<th align='center' width='30%'>Service Report</th>
<th align='center'>Sign In Time</th>
<th align='center'>Sign Out Time</th>
<th align='center'>Lunch</th>
<th align='center'>Time Billed</th>
<th align='center'>Estimated</th>

</tr>";
 
 
$result3 = mysql_query("SELECT * FROM timesheet WHERE date = '$pdate' AND eid = '$eid'");
$talltime = 0;
while($row3 = mysql_fetch_array($result3))
{

  $tid=$row3['id'];
  $tdate=$row3['date'];
  $tjobnumber=$row3['jobnumber'];
  $teid=$row3['eid'];
  $tdescription=$row3['description'];
  $tsignin=$row3['start'];
  $tfinish=$row3['finish'];
  $tlunch=$row3['lunch'];
  $tkms=$row3['kms'];
  $tschednum=$row3['schednum'];

 
  
  $tdate1 = date( 'M j, Y', strtotime($tdate) );
  
    $tsignin1 = date( 'g:i a', strtotime($tsignin) );
$tfinish1 = date( 'g:i a', strtotime($tfinish) );

if( empty($tfinish) ) {
 $tfinish2="<i>In Progress";
} else {
 $tfinish2="$tfinish1";
}

$shortid=substr($tjobnumber, 5, -1); //remove the first 5 characters and minus the last character

$result = mysql_query("SELECT * FROM jobs WHERE id = '$shortid'");
while($row = mysql_fetch_array($result))
{
$jstatus=$row['status'];
 
}


$result4 = mysql_query("SELECT * FROM schedule WHERE id = '$tschednum'");
while($row4 = mysql_fetch_array($result4))
{

  $sid=$row4['id'];
  $sdate=$row4['date'];
  $seid=$row4['eid'];
  $sjobnumber=$row4['jobnumber'];
  $sstarttime=$row4['starttime'];
  $sstatus=$row4['status'];
  $setime=$row4['etime'];
  
}

$log_in_time_string = strtotime($tsignin);
$log_out_time_string = strtotime($tfinish);
$difference_in_seconds = ($log_out_time_string - $log_in_time_string);
$tbilled = ($difference_in_seconds / 3600);
  
  
  if($tbilled < 0)
{
    $tbilled1 = $tbilled + 24;
} else {
    $tbilled1=$tbilled;
}
  
  $tbilled2 = number_format(round($tbilled*4)/4,2);
  $tbilled3 = $tbilled2 - $tlunch ;
  $talltime += $tbilled3;
  
  
  echo "<tr>";
  echo "<td align='center'>" . $tdate1 . "</td>";
  echo "<td align='center'>" . $tjobnumber . "</td>";
  echo "<td align='center'>" . $tdescription . "</td>";
  echo "<td align='center'>" . $tsignin1 . "</td>";  
echo "<td align='center'>" . $tfinish2 . "</td>";
echo "<td align='center'>" . $tlunch . " hour</td>";
echo "<td align='center'>";
     if ($tbilled3 > $setime ) {
 echo "<font color='red'><b>*** " . $tbilled3 . " hours ***</b></font>";
 } else {
 echo "" . $tbilled3 . " hours";
 }
echo "</td>";
echo "<td align='center'>" . $setime . " hours</td>";


  echo "</tr>";

} 
   echo "<tr>";
 
  echo "<td colspan='6' align='right'><b>Totals :</td>";
  echo "<td align='center' colspan='2'>";
     if ($talltime > "8" ) {
 echo "<font color='red'><b>*** " . $talltime . " hours ***</b></font>";
 } elseif ($talltime < "0" ) {
 echo "<font color='red'><b>Not Signed Out</b></font>";
 } else {
 echo "" . $talltime . " hours";
 }
echo "</td>";

  echo "</tr>";

   echo "<tr>";
 echo "<td align='center' colspan='8' bgcolor='#D9FFD9'><hr></td>";
  echo "</tr>";

}
    
echo "</table>";







include 'close.php';

?>

I'm self-studying PHP and put to myself to a task. But I can't figure this out. It's about putting a database result into array.

There is this database called books with columns: isbn, author,title, price. The DB has records. I want to output certain records of certain columns:for example echo $books['title"];. I also to use functions.

I used the following code to titles listing for example:

function db_connect() {
   $result = new mysqli('localhost', 'root', 'password', 'books');
   if (!$result) {
      return false;
   }
   $result->autocommit(TRUE);
   return $result;
}
function get_book_details($isbn) {
  // query database for all details for a particular book
  if ((!$isbn) || ($isbn=='')) {
     return false;
  }
  $conn = db_connect();
  $query = "select * from books where isbn='".$isbn."'";
  $result = @$conn->query($query);
  if (!$result) {
     return false;
  }
  $result = @$result->fetch_assoc();
  return $result;
}
$book = get_book_details($isbn);
foreach($book as $isbn => $qty){
echo $book['title'];
}


I have this error: Warning: Invalid argument supplied for foreach() in ..\foreach.php on line 41
I'm guessing that $book is not array that's why I get this error message. But the big problem is as you can see in the function
function get_book_details($isbn)
inside the function it already gets the result into array
$result = @$result->fetch_assoc();

i have it set up so the user picks the year and session and then the database shows all the games in that specific year and session and then displays them with a link to their photo galleria and also shows the record(wins - losses - ties) but the way i have it know its not displaying the first result here is the code
Code: [Select]
<?php
 //declares $y as year played and $s as session
 $y = ' ';
 $s = ' '; 
 
 //handles submition of form for picking year and session
 if (isset($_POST['submit'])) {
 $data = mysql_real_escape_string($_POST['session']);
 $exploeded = explode(",", $data);
 $y = $exploeded[0];
 $s = $exploeded[1];
 }

  //Query for the selection menu
    $squery = "SELECT DISTINCT(Year_Played), Sessions FROM pinkpanther_games";
    $sresults = mysql_query($squery) or die("squery failed ($squery) - " . mysql_error());
   
    //checks $y and $s to see if their is a vaule
    if ($y == ' '){$y = '20112012';}
    if ($s == ' '){$s = '2';}
   
    //Query for getting record and for getting all the appropriate info for displaying the games
    $query = " SELECT (SELECT COUNT(id) FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s AND Win_Loss = 'Tie' ) AS 'Tie', 
         (SELECT COUNT(id) FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s AND Win_Loss = 'Win') AS 'Win',
         (SELECT COUNT(id) FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s AND Win_Loss = 'Loss') AS 'Lose',
         Opponent AS Opponent, Score AS Score, Gallery_no AS Gal, Win_Loss AS Record FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s";
    $results = mysql_query($query)  or die("Query failed ($query) - " . mysql_error());
    $row_a = mysql_fetch_assoc($results);   
    //Set record variables
    $wins = $row_a['Win'];
    $loss = $row_a['Lose'];
    $tie = $row_a['Tie'];

    //creates from and selection menu for year and session
echo "<tr><td colspan='2'><form method='post' action=''><select name='session' class='txtbox2'>";
while ($srow = mysql_fetch_assoc($sresults)){
echo "<option value='" . $srow['Year_Played'] . "," . $srow['Sessions'] . "'>" . $srow['Year_Played'] . " Session " . $srow['Sessions'] . "</option>";
}
echo "</select><input type='submit' name='submit' value='Go'  class='txtbox2' /></form></td></tr>";
//displays  record
echo "<tr><td colspan='2'>" .$wins . " - " . $loss . " - " . $tie . "</td></tr>";
echo "<tr></tr>";
//displays games and scores in appropriate year and session
while ($row = mysql_fetch_assoc($results)){
$opp = $row['Opponent'];
$score = $row['Score'];
$gal = $row['Gal'];
$wlt = $row['Record'];
//styles games acording to if win lose or tie
if ($wlt == 'Win'){
echo "<tr><td class='win'>";
echo "<a  href='galleries.php?g=$gal'" . $gal . " >" . $opp . "</a>";
echo "</td><td class='win'>";
echo   $score . "";
echo "</td></tr>";
}
if ($wlt == 'Loss'){
echo "<tr><td class='loss'>";
echo "<a  href='galleries.php?g=$gal'" . $gal . " >" . $opp . "</a>";
echo "</td><td class='loss'>";
echo   $score . "";
echo "</td></tr>";
}
if ($wlt == 'Tie'){
echo "<tr><td class='tie'>";
echo "<a  href='galleries.php?g=$gal'" . $gal . " >" . $opp . "</a>";
echo "</td><td class='tie'>";
echo   $score . "";
echo "</td></tr>";
}
}
?>

Basically the following code works fine, exepct when it comes to the last result it inserts it twice, example:

(3,17),(4,17),(5,17),(5,17)

Any clues as to why? Thanks

Code: [Select]
if(count($addIDs_ary) > 0)
{
$str = "";
foreach($addIDs_ary as $val)
{
$str .= "({$val},{$playerID}),";
if(end($addIDs_ary) == $val)
{
$str .= "({$val},{$playerID})";
}
}
echo $str; // (val,val), (val,val), (val,val) etc..
$query = "INSERT INTO hitlist
(hit_id,player_id) values $str";

$name = $name . "<option value=". $row['name'] . ">" .$row['name'] . "</option>";

but the name is "Mr. Robert",it does have dot symbol...how to overcome? please help

i have two tables, and i want to display data from the most recent entry of the two(i.e. display just one entry). i'm joining together 2 tables so that i can get this entry.Both tables contain the date, so i'm ordering the results of the query so that the most recent comes first.
My tables a
TOPIC
topic_id
topic _name
section_sub_id
date

POST
post_id
post_name
section_sub_id
date

I'm using the following code to get the last result, but nothing is being echoed
$join =mysql_query("SELECT topic.*, post.* FROM topic LEFT JOIN post ON topic.section_sub_id=post.section_sub_id WHERE post.section_sub_id = " .$row2['section_sub_id']. " ORDER BY topic.date") or die("Select Error :" . mysql_error());
$latest= mysql_fetch_row($join);
echo $latest['post.date'];
i'm not sure if there is something wrong with the sql, or with the php. ANy help would be great