PHP - Slide Show Help

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";

Hi

I have made a view all albums page for my website and I want it to only show 10 records.  If there are more than 10 I would like a next or previous button to appear and for them to take you to the next 10 records or previous 10 records.  Please can somebody show me where I can learn how to do this? I know it has something to do with msql_num_rows so I have a variable called $numrows  I'll post the code I currently have here

<form name="view_all_albums_frm" id="view_all_albums_frm">
          <table width="793" border="0" cellspacing="5" id="all_albums_tbl" cellpadding="0">

            <tr>
              <th scope="col">ID</th>
              <th scope="col">Album</th>
              <th scope="col">Album Description</th>
              <th scope="col">Edit</th>
              <th scope="col">Delete</th>
            </tr>
            <tr>
              <?php
$qGetAlbums = ("SELECT * FROM albums ORDER BY `id` asc");
$rGetAlbums = mysql_query($qGetAlbums) or die(mysql_error());
$numrows = mysql_num_rows($rGetAlbums);
while($AllAlbums = mysql_fetch_assoc($rGetAlbums)) {
?>
              <th height="26" scope="col"><?php echo $AllAlbums['id']; ?></th>
              <th height="26" scope="col"><?php echo $AllAlbums['album_name']; ?></th>
              <th scope="col"><?php echo $AllAlbums['album_description']; ?></th>
              <th scope="col">&nbsp;</th>
              <th scope="col">&nbsp;</th>
            </tr>

            <?php } ?>
          </table>
        </form>

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'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.

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?

This topic has been moved to MySQL Help.

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

I apologize in advance for any misuse of terminology. I find that I am rather ignorant in such things.

I'm working on a WordPress theme. Specifically on the part that shows the "next: link-to-next-post" and "previous: link-to-prev-post" links.

Here is the code that I have:
Code: [Select]
<?php
  $nextvar=next_post_link('%link');
  $prevvar=previous_post_link('%link');
?>

<?php if (isset($nextvar)) { ?>
<h3>Next</h3>
<p><?php next_post_link('%link'); ?></p>
<? } ?>

<?php if (isset($prevvar)) { ?>
<h3>Previous</h3>
<p><?php previous_post_link('%link'); ?></p>
<? } ?>
The first part intends to check if the links exist. And this works fine.

However, the only output I'm getting are the values of $nextvar and $prevvar. The headers are nonexistent. What's wrong?

Any help is much appreciated, and I thank you in advance.

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...

Hi can any one help iv built a cms but when i had a page how easy is it to have a show or hide while making changes to the page

many thanks for any help

I have my web page in the usual document root /var/www/html folder.

Say, my root folder for my website is "mypage". That is, inside "/var/www/html/mypage", I have the index.php, and other files and folders.

Example:

/var/www/html/mypage/css/style.css

/var/www/html/mypage/members/xxx.php etc

/var/www/html/mypage/pictures/111.jpg, etc.

/var/www/html/mypage/index.php

/var/www/html/mypage/menu.php

/var/www/html/mypage/login.php

etc.

I want to show access forbidden (403) or files not found (404) errors. How do I catch when a user enters one of the existing folders directly on the URL bar and display appropriate message? 

For example:

/var/www/html/mypage/ will show /var/www/html/mypage/index.php which is desired. Good.

/var/www/html/mypage/pictures .... I don't want them to access this folder directly, so I want to show no permission error.

/var/www/html/mypage/hogehoge ... I want to show file(s) not found error.

/var/www/html/mypage/some_existing_and_valid_file.php/hogehoge  I want to show file(s) not found error.

I want to edit httpd.conf.

All I know now is how to disable directory listing and disable or enable a specific folder.  I am trying to find a generic solution.

Working environment: CentOS 7, PHP 5.6

Someone with knowledge and experience, please give me some guidance.

Thanks!

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?

Hi all

I know this contains a bit of JavaScript but it comes from some dynamically created pages using php which are causing it an issue.

Here's my scenario.  I have a DB with locations, regions, jobtitles and names in it.

My users can select from the DB a specific job title or a location.
This can produce a report of information from a couple of people, up to over 100 (who can still be filtered by any of the above DB columns)
I want to dynamically produce some JS buttons to show / hide any sections which are irrelevant to the user.

eg  I select by job title, it gives me all the managers, duty managers, staff, cleaners, etc from the DB for all locations.  I then want  5 buttons to be on the page, each with a different region on it. (this I can do)  I can dynamically label the divs around each of the user information.

The issue I have is making the buttons do what I want.  So if you press a button labelled "North West" it hides all records which are not from northwest region.

Here's what I have so far, I just can't seem to get the functionality right as I know very little about JS.

Code: [Select]
<script language=javascript type='text/javascript'>

function showdiv(pass) {
var divs = document.getElementsByTagName('div');
for(i=0;i<divs.length;i++){
if(divs[i].id.match(pass)){//if they are 'see' divs
if (document.getElementById) // DOM3 = IE5, NS6
divs[i].style.visibility="visible";// show/hide
else
if (document.layers) // Netscape 4
document.layers[divs[i]].display = 'visible';
else // IE 4
document.all.divs[i].visibility = 'visible';
} else {
if (document.getElementById)
divs[i].style.visibility="hidden";
else
if (document.layers) // Netscape 4
document.divs[i].visibility = 'hidden';
else // IE 4
document.all.divs[i].visibility = 'hidden';
}
}
}

</script>

and then one my php has processed I get a record such as.
Code: [Select]
<div id='NEREGION'>
<table border='1' >
<tr><td colspan='4'>Glasgow </td></tr>
<tr><td colspan='2' >Employee Name : **********</td><td >Employee Number : *****</td><td colspan='2'>Start Date 25th November 2002</td></tr>
<tr><td colspan='3'>&nbsp;</td><td rowspan='3'><img src='image.php?ed=2063&y2007=1&y2008=1&y2009=0&y2010=0&y2011=0&forename=1234&surname=5436' height ='400px' width='350px'></td></tr><tr><td colspan='2'>20th June 2007</td><td> NFR Petrol Delivery - Refresher Course</td></tr><tr><td colspan='2'>2nd December 2008</td><td> Incremental Sales</td></tr></table></div>

Any ideas?

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);
?>

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