PHP - Why Does It Show Jan When I Select Nov Or Dec?

Hi,

I would like to do the following but not sure how.

If the you/user is on index.php of http://www.domain.com/ show one page
If not show another

How would I do this?

Thanks

I have 2 queries that I want to join together to make one row  

Dear All,

I wish to have 2 drop down boxes, Country Select Box and Locality Select Box. The locality select box will be affected by the value chosen in the country select box.

All is working fine except that the locality select box is not being populated.
I know that the problem is in the sql statement

WHERE country_id='$co'

because i am having an error that $co is an undefined variable.

All the rest works fine because i have replaced the $co variable directly with a number (say 98) for a particular country id and it worked fine. In what way can i define this variable $co so that it is accepted by my sql statement?

Thank you for your help in advance.

MySQL Tables indicated below:

CREATE TABLE countries(
country_id INT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
country_name VARCHAR(30) NOT NULL,
PRIMARY KEY(country_id),
UNIQUE KEY(country_name),
INDEX(country_id),
INDEX(country_name))
ENGINE=MyISAM;

CREATE TABLE localities(
locality_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
country_id INT(3) UNSIGNED NOT NULL,
locality_name VARCHAR(50),
PRIMARY KEY (locality_id),
INDEX (country_id),
INDEX (locality_name))
ENGINE=MyISAM;

Extract PHP script included below:

// connect to database
require_once(MYSQL);

if(isset($_POST['submitted']))

{

// trim the incoming data

/* this line runs every element in $_POST through the trim() function, and assigns the returned result to the new $trimmed array */
$trimmed=array_map('trim',$_POST);

// clean the data

$co=mysqli_real_escape_string($dbc,$trimmed['country']);

$lc=mysqli_real_escape_string($dbc,$trimmed['locality']);

}

?>

<form action="form.php" method="post">

<p>Country
<select name="country">
<option>Select Country</option>

<?php

$q="SELECT country_id, country_name
FROM countries";

$r=mysqli_query($dbc,$q) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($r))

{

$country_id=$row[0];
$country_name=$row[1];
echo '<option value="' . $country_id . '"';
if(isset($trimmed['country']) && ($trimmed['country']==$country_id))
echo 'selected="selected"';
echo '>' . $country_name . '</option>\n';

}

?>

</select>
</p>

<p>Locality
<select name="locality">
<option>Select Locality</option>

<?php

$ql="SELECT locality_id, country_id, locality_name
FROM localities
WHERE country_id='$co'
ORDER BY locality_name";

$rl=mysqli_query($dbc,$ql) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($rl))

{

$locality_id=$row[0];
$country_id=$row[1];
$locality_name=$row[2];
echo '<option value="' . $locality_id . '"';
if(isset($trimmed['locality']) && ($trimmed['locality']==$locality_id))
echo 'selected="selected"';
echo '>' . $locality_name . '</option>\n';

}

// close database connection
mysqli_close($dbc);

?>

</select>
</p>

<p><input type="submit" name="submit" value="Submit" /></p>

<input type="hidden" name="submitted" value="TRUE" />

</form>

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>

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

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?

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

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

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

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.