PHP - Getting Rownumbers To Show

I can't understand for the life of me - why the value for the variable:  $total_vit_k is 2 in the red box: http://content.screencast.com/users/rockstarvisible/folders/Jing/media/beafff1f-2168-47b8-91bb-950ace0722c2/2012-03-21_1437.png.

The reason why I can't understand this is because $total_vit_k is the weekly total for everything from jan 29 to feb 4 but there's no values for those dates logged in the mysql table it's pulling from.

Please help me. It should be displaying 0 Mcg in the red box but it isn't. I know it's something wrong in my code.

When I echo out all the values in the while loop like below, the browser echos out nothing for the queries from jan 29 2012 to feb 4 2012.

code below is from file 2:
Code: [Select]
while ($row = mysql_fetch_assoc($query_run)){
               
 echo "<br /><br /><b><i>" . '$sql_food ' . $sql_food."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . '$sql_total_servings ' . $sql_total_servings."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . '$sql_day ' . $sql_day."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . '$sql_month ' . $sql_month."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . '$sql_year ' . $sql_year."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . '$sql_vit_k ' . $sql_vit_k."</b></i><br /><br/ >";

echo "<br /><br /><b><i>" . ' $sql_servings ' .  $sql_servings."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . ' $total_vit_k ' .  $total_vit_k."</b></i><br /><br/ >";
  include 'inside_while.acc-over.php';
        }

full code for file2:

Code: [Select]
<?php

if(!function_exists('getWeeklyVitK') ){

function getWeeklyVitK($value, $bday, $bmonth, $byear, $eday, $emonth, $eyear){

//initialize the variables so no errors occur
$query_month =$bmonth;
$query_year =$byear;
$query_day = $bday;


//initialize variables
$total_vit_k = 0;
//$total_cal = 0;
//$total_protein = 0;
//$total_fiber = 0;
//$total_carbs = 0;
//$total_sugar = 0;
//$total_sodium = 0;
//$total_chol = 0;

if ($value==1){
    echo "Something went wrong - tell pavankat[at]gmail.";
  break;  
}

if ($value==2){
// if $value = 2
// end day >= start day
// end month = start month
// end year = start year


 $day_temp = $eday;
    
     while($bday<=$day_temp){
     $query_day = $bday;
 
    //redeclare the mysql query
    include 'acc-over-sql-queries.php';
    if ($query_run = mysql_query($query_value2)){
    
        while ($row = mysql_fetch_assoc($query_run)){
        include 'inside_while.acc-over.php';
        
        }   
    }
        $bday++;
     }      
return round($total_vit_k, 2);
}

if ($value==3){
// if $value = 3
// end day and beg day don't matter
// end month > beg month
// end year = beg year

for($bmonth; $bmonth<=$emonth; $bmonth++){

$query_month = $bmonth;

$days_in_month = date('t',mktime(0,0,0,$query_month,1,$byear));
$day_temp = $days_in_month;
    
                                    
                                echo "<br />day_temp variable:<u> ".$day_temp. "</u><br />";
                                    
while($bday<=$day_temp){
$query_day = $bday;

    //redeclare the mysql query
    include 'acc-over-sql-queries.php';
    echo "<br />".'$query_value3:' . $query_value3 . "<br />";
    
    if ($query_run = mysql_query($query_value3)){

        while ($row = mysql_fetch_assoc($query_run)){
                
 echo "<br /><br /><b><i>" . '$sql_food ' . $sql_food."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . '$sql_total_servings ' . $sql_total_servings."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . '$sql_day ' . $sql_day."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . '$sql_month ' . $sql_month."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . '$sql_year ' . $sql_year."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . '$sql_vit_k ' . $sql_vit_k."</b></i><br /><br/ >";

echo "<br /><br /><b><i>" . ' $sql_servings ' .  $sql_servings."</b></i><br /><br/ >";
echo "<br /><br /><b><i>" . ' $total_vit_k ' .  $total_vit_k."</b></i><br /><br/ >";
  include 'inside_while.acc-over.php';
        }
    
    }
    $bday++;
                                }
                                $bday = 1;
}
//return round($total_vit_k, 2);
return $total_vit_k;
}

if ($value==4){
// if $value = 4
// end day and beg day dont matter
// end month and beg month dont matter
// end year > beg year 
  
for($byear; $byear<=$eyear; $byear++){

$query_year = $byear;

$month_temp = 12;
    
        while($bmonth<=$month_temp){//while loop starts
        
        $query_month = $bmonth;
        
                                //cycle through the days
$days_in_month = date('t',mktime(0,0,0,$query_month,1,$byear));
$day_temp = $days_in_month;
    
while($bday<=$day_temp){
$query_day = $bday;
             
            //redeclare the mysql query
            include 'acc-over-sql-queries.php';
            if ($query_run = mysql_query($query_value4)){
            
                while ($row = mysql_fetch_assoc($query_run)){
                include 'inside_while.acc-over.php';
                
                }     
            }
        
         //-----------------------------------$bday++ unless stuff
if ($byear < $eyear){
$bday++;
}else if ($byear == $eyear){
    if ($bmonth < $emonth){
    $bday++;
    }else if($bmonth == $emonth){
    
    if ($bday < $eday){
$bday++;
    }else if($bday == $eday){
$bday = $day_temp+1;
    }
    
    }
      
     }
//-----------------------------------$bday++ unless stuff


}//while day loop end
$bday = 1;
        
            
                    //-----------------------------------$bmonth++ unless stuff
    if ($byear < $eyear){
    $bmonth++;
    }else if ($byear == $eyear){
if ($bmonth < $emonth){
$bmonth++;
}else if($bmonth == $emonth){
$bmonth = 13;
}
  
         }
    //-----------------------------------$bmonth++ unless stuff
        }//while loop ends
            if ($byear <= $eyear){
                $bmonth = 1;     
            }
}

return round($total_vit_k, 2);
}


}
}
                        ?>

full code for the contents of the while loop:
Code: [Select]
<?php

                $sql_food = $row["name"];
                
               
                $sql_year = $row["calendar_year"];
                
                $sql_month = $row["calendar_month"];
                $sql_day = $row["calendar_day"];
                $sql_total_servings = $row["total_servings"];
                $sql_vit_k = $row["vit_k"];
                $sql_vit_k = $sql_vit_k/$sql_total_servings;
                $sql_servings = $row["servings"];              
                if ($sql_servings == 0){
                    $total_vit_k += $sql_vit_k;
                 
                }else{
                    $total_vit_k += $sql_vit_k * $sql_servings;

                }

?>

full code for the sql query getting included in the previous file:

Code: [Select]
$query_value3 = "SELECT
foods.id, users_calendar.id, `name`, `source`,`vit_k`, `cal`,`protein`, `fiber`, `carbs`, `sugar`, `sodium`, `chol`, `total_servings`,
`calendar_month`, `calendar_day`, `calendar_year`, `servings`
 FROM `foods`
 LEFT JOIN users_calendar
 ON foods.id=users_calendar.food_id
 WHERE users_calendar.user_id =". $_SESSION['user_id']." && " . $query_day . "=calendar_day && ".$query_month."=calendar_month && ".$byear."=calendar_year
 ORDER BY users_calendar.id";

I'm going insane. whenever I select Oct, Nov, Dec from the drop down it doesn't show the corresponding month appropriately.

I do this in the code and it shows 10, 11 or 12 corresponding to oct, nov, dec but then it shows no month if it's october, january if it's november or december. Help me please.
 
echo '<br /><br /> form month var dump: ';
      var_dump($form_month);



Code: [Select]

$time = time();
$actual_month = date('m', $time);
$actual_year = date('Y', $time);
$word_month = date('M', $time);
$word_year = date('Y', $time);

  if (isset($_POST['form_month']) && isset($_POST['form_year']) && !empty($_POST['form_month']) && !empty($_POST['form_year']) )
        {
$form_month = $_POST['form_month']; //multidimensional array but it should have only one value in it at a time I think
$form_year = $_POST['form_year'];

echo '<br /><br /> form month var dump: ';
var_dump($form_month);
//echo '<br /><br />'. $form_month['1'];

$insert_month = $form_month['0']; //maybe this will work
$insert_year = $form_year;
}else{
$insert_month = $actual_month;
$insert_year = $actual_year;
}

// I don't know how to convert the number 01 to Jan - so i'm doing this:
$wtf_word_month = "";

switch ($insert_month) {
    case 1:
        $wtf_word_month = "Jan";
        break;
    case 2:
        $wtf_word_month = "Feb";
        break;
    case 3:
        $wtf_word_month = "Mar";
        break;
    case 4:
        $wtf_word_month = "Apr";
        break;
    case 5:
        $wtf_word_month = "May";
        break;
    case 6:
        $wtf_word_month = "June";
        break;
    case 7:
        $wtf_word_month = "July";
        break;
    case 8:
        $wtf_word_month = "Aug";
        break;
    case 9:
        $wtf_word_month = "Sep";
        break;
    case 10:
        $wtf_word_month = "Oct";
        break;
    case 11:
        $wtf_word_month = "Nov";
        break;
    case 12:
        $wtf_word_month = "Dec";
        break;
}


?>

<h2><?php echo $wtf_word_month ." ". $insert_year; ?></h2>

<form id="form_month_changer" action="account-overview.php" method="POST">

Choose a month: <select name="form_month">
<option value="<?php echo '$insert_month'; ?>" ><?php echo $wtf_word_month; ?></option>
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">Aug</option>
<option value="9">Sept</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select>&nbsp;&nbsp;
       
Choose a year <input type="text" name="form_year" maxlength="4" size="4" value="<?php echo $insert_year; ?>">
<input type="submit" value="Show me the calendar">
</form>
 
    <?php echo draw_calendar($insert_month,$insert_year); ?>

i am doing a little project but I get stuck on a problem. How do I show the content of my SQL database in PHP or HTML. I want it to show the title at the top, the text in the middle and maybe a price at the bottom. How do I do that?  I can't seem to find a tutorial which covers only that, and I don't have the time to search each tutorial for some usefull information right now. And a second thing I want is that it will show the database in one list on a specific webpage. So people can look trough the list and find the thing they want and than click on it so they awill get directed to that item from the database.

This topic has been moved to MySQL Help.

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

i have this code but it shows the password of the user to...
Code: [Select]
<?php
$database="dynamicg_sites";
mysql_connect ("localhost","dynamicg_sites","boom123");
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query( "SELECT * FROM sites order by votes DESC" )
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
print "<br>\n";
print "There are $num_rows News Articles";
print "<br>\n";
print "<table width=457 border=0>\n";
print "<tr>\n";
print "<td>\n";
echo "Title:";
print "</td>\n";
print "<td>\n";
echo "Description:";
print "</td>\n";
print "<td>\n";
echo "Votes:";
print "</td>\n";
print "</tr>\n";
while ($get_info = mysql_fetch_row($result)){
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td><font face=arial size=2/>$field</font></td>\n";
print "</tr>\n";
}
print "</table>\n";
print "<br />\n";
print "<br />\n";
?>i was wondering how do i make this only show certain columns...
thanks in advance...

How would I show the PHP code on the website page?

I'm not sure if this should be under PHP or HTML or what, but, like on the forums where you see the

<?php

echo 'sdfjksdf';

?>

etc. How do I make it so I can write PHP on the website?

Code: [Select]
$card1 = rand(1,3);
$card2 = rand(1,3);

/// check money win ////////
if($card1 == "1" && $card2 == "1" ){
echo "You won 100$?";
exit;
mysql_query("UPDATE card SET money='$win_money' WHERE name='$name'");
}
My code works wonderfully

prob tho
how can I show the odds of winning out of 100 to my suer?

Hello dear friends

Let say i've a huge database of 100,000 entries
Code: [Select]
my_table (id,name)
and i'd like to call all the entires to be shown by this code

Code: [Select]
$conn = mysql_connect('localhost','USER','PASS') or die(mysql_error());
mysql_select_db('my_table',$conn);

$sql = "SELECT * from my_table";
$result = mysql_query($sql,$conn);

while ($row = mysql_fetch_array($result)){

$name = $row['name'];
$id = $row['id'];

echo $name;
echo "<br>(done)<br>";

}


The problem

The problem that makes me almost gonna cry,it takes long time to load then it will showing names (remember my_table of 100,000 entries) all at once  and sometimes it sudden shows huage amount once or even sometime it hang up.

My question

Is there any way that i can call it so that it showing me results one name by one name like streaming name1 (done),name2 (done),name3 (done),name4 (done),name5 (done),......etc not showing all at once

i'm afraid it may needs some ajax idea or somehow i really don't know but this is important to me so your help is very useful to me.

so anyone please helps me cause it would really save my hosting ram otherwise they would suspend me 

I'm working on a simple ad server and would like to display the ads in order (not random).

I'm fairly certain I can do something like this:

Code: [Select]
// Get the last ad id, or becomes 0 if not available
$lastid = ($_GET['lastid'] == '') ? '0' : $_GET['lastid'];

// Get the next ad in order, or get the first one available
mysql_query("SELECT adcode FROM ads WHERE zone='$zoneid' AND id > $lastid ORDER BY id ASC LIMIT 1");

The above code would get the first ad or the next ad in order.. How do I go back to the beginning when I run out of ads to show?

The school district that I work for has been using a slide show PHP script that I designed, which uses random images from a database. I have now been asked to build in an option where they can enter text into the database and the script takes the text and either creates an image that is 1000pixels wide and 700 pixels tall with the text filled in the image or it just have the text re-sized to fit a text box with the same dimensions as above, so the students can see the text displayed from down the hall on the monitors. I would also like the script to have the ability to explode the text so the words can stay large in case of the user entering a long winded entry. Thank you in advance for any help.

Hi all

I have a pice of code that I want to only show the image if it's empty:

Code: [Select]
<?php if(!empty($node->field_img['und'][0]['filename'])); { ?>

<li><img src="http://mysite.co.uk/sites/default/files/brand-images/<?php print $node->field_img['und'][0]['filename']; ?>" style="max-width:270px; text-align:center;" /></li>

<?php } ?>

However, it shows an image placeholder (Red cross) even when it's empty?

Many thanks for your help

Pete

I found this function and take no credit for it, I'm trying to get it to show HH:MM:SS when I have the total number of seconds, but nothing is showing on the screen

  function sec2hms ($sec, $padHours = false) 
  {

    // start with a blank string
    $hms = "";
    
    // do the hours first: there are 3600 seconds in an hour, so if we divide
    // the total number of seconds by 3600 and throw away the remainder, we're
    // left with the number of hours in those seconds
    $hours = intval(intval($sec) / 3600); 

    // add hours to $hms (with a leading 0 if asked for)
    $hms .= ($padHours) 
          ? str_pad($hours, 2, "0", STR_PAD_LEFT). ":"
          : $hours. ":";
    
    // dividing the total seconds by 60 will give us the number of minutes
    // in total, but we're interested in *minutes past the hour* and to get
    // this, we have to divide by 60 again and then use the remainder
    $minutes = intval(($sec / 60) % 60); 

    // add minutes to $hms (with a leading 0 if needed)
    $hms .= str_pad($minutes, 2, "0", STR_PAD_LEFT). ":";

    // seconds past the minute are found by dividing the total number of seconds
    // by 60 and using the remainder
    $seconds = intval($sec % 60); 

    // add seconds to $hms (with a leading 0 if needed)
    $hms .= str_pad($seconds, 2, "0", STR_PAD_LEFT);

    // done!
    return $hms;
    
  }

The part of the code to show the data is below:
Code: [Select]
while ($row = mysql_fetch_array($result)) {
$sec = time() - strtotime($row['starttime']);
echo $sec; // print to screen to make sure $sec had a value
sec2hms($sec);

}
Any guidance on where I went wrong?

Why is it that only certain images come through. I made sure all extensions were there but some jpegs come through others don't some pngs not others. Any thoughts?

Code: [Select]
<?php
$hostname='yobb';
$username='ybbb';
$password='Anbbbb!';
$dbname='b29';
$usertable='bbbb;


$myconn=mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');

if ((($_FILES["file"]["type"] =="image/gif")
|| ($_FILES["file"]["type"] =="image/jpeg")
|| ($_FILES["file"]["type"] =="image/pjpeg")
|| ($_FILES["file"]["type"] == "image/png"))
&& ($_FILES["file"]["size"]< 200000))
{
if ($_FILES["file"]["error"] >0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br/>";
}
else
{
if (file_exists("uploads/" . $_FILES["file"]["name"]))
{
echo "File already exists. Choose another name.";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"], "uploads/" . $_FILES["file"]["name"]);
}
}
}
else
{
echo "Invalid file";
}
$path="uploads/" . $_FILES["file"]["name"];
$name=$_POST["name"];
$state=$_POST["state"];
if (!myconn)
{
die ('Could not connect: ' . $mysql_error());
 } 
 $db_selected=mysql_select_db('your1729',$myconn);
 if (!$db_selected) {
    die ('Can\'t use your1729 : ' . mysql_error());
} 
  mysql_query("INSERT INTO photo(name,photopath,state) VALUES ('$name','$path','$state')") or die(mysql_error()); 
  mysql_close($myconn);
?>

Hi All,

I want to be able to show selected pages of my website as PDF using a 'PDF' button much like this site does:

http://www.westmeon.org.uk/index.php?option=com_content&task=blogsection&id=8&Itemid=35

I presume that I will need to install some sort of software on my server (which runs the latest PHP, MySQL etc.) but after hours of searching online I cannot find a simple way of doing this.

Does anyone have any suggestions or pointers for how I can do this?

FYI my website is written in PHP drawing data from a MySQL database.

Regards,
Neil

I am trying to tidy up the code for my site, and I have a ton of MySQL queries and variables that have not been unset/freed.

Is there any way to view stored variables, other than session variables??? (because I know how to do that already)