PHP - Remove All Button Won't Work Properly

Hello,  I have one search form and when I search something the result is whole records from the database not only the search term. Any help is appreciated. I will post only the part where is calculating the rows from db but if need I will post whole pagination script. 

$searchTerm = trim($_POST['term']);
$adjacents = 3;

$sql1 = mysql_query("SELECT * FROM images ORDER BY id ASC");
$nr = mysql_num_rows($sql1);
$limit = 6;
$targetpage = "search.php";
$page = $_GET['page'];
if($page)
    $start = ($page - 1) * $limit;
else
    $start = 0;

if ($page == 0) $page = 1;
$prev = $page - 1;	 // $prev = $page - 1
$next = $page + 1;	 // $next = $page + 1
$lastpage = ceil($nr/$limit);   //lastpage = total pages / items per page.
$lpm1 = $lastpage - 1;
$pagination = "";
....
....
// pagination
...
...
// while loop for the results
$sql = "SELECT id, name, caption FROM images WHERE caption LIKE '%".$searchTerm."%' ORDER BY id DESC LIMIT $start, $limit";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
    $output.= "<div class=\"container_image\">";
    $output.= "<a href=\"/pic-".$row['id'].".html\"><img src=\"/upload/".$row['name']."\" width=\"210\" height=\"150\"/></a>";
    $output.= "</div>";
}

Edited by vinsb, 21 July 2014 - 06:58 AM.

I'm able to get the image file name in the database, the image to the right place BUT the problem is the image is totally black and after it's uploaded, a whole bunch of warnings appear.  Here are the warnings:

Warning: getimagesize(image_files/image-16.jpg) [function.getimagesize]: failed to open stream: No such file or directory in C:\Desktop\xampp\htdocs\image-crop-demo.php on line 37

Warning: Division by zero in C:\Desktop\xampp\htdocs\image-crop-demo.php on line 54

Warning: Division by zero in C:\Users\Samantha\Desktop\xampp\htdocs\image-crop-demo.php on line 71

Warning: imagecreatetruecolor() [function.imagecreatetruecolor]: Invalid image dimensions in C:\Desktop\xampp\htdocs\image-crop-demo.php on line 78

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in C:\Desktop\xampp\htdocs\image-crop-demo.php on line 86

Warning: imagecopy() expects parameter 2 to be resource, boolean given in C:\Desktop\xampp\htdocs\image-crop-demo.php on line 102

Here is the form:
<form action="image-crop-demo.php?username=<?php echo $username ?>" method="post" enctype="multipart/form-data">
  Upload an image for processing<br>
  <input type="file" name="Image1"><br>
  <input type="submit" value="Upload">
</form>

And here is the form action file:

 
$username = $_GET['username'];

 define( 'DESIRED_IMAGE_WIDTH', 150 );
  define( 'DESIRED_IMAGE_HEIGHT', 150 );

  $source_path = $_FILES[ 'Image1' ][ 'name' ];  

$sql="UPDATE thumbnail SET Image1='$source_path' WHERE username = '$username'";

 if (!mysql_query($sql))

  {

  die('Error: ' . mysql_error());

  } 
else {

  //
  // Add file validation code here
  //

  list( $source_width, $source_height, $source_type ) = getimagesize( $source_path );

  switch ( $source_type )
  {
    case IMAGETYPE_GIF:
      $source_gdim = imagecreatefromgif( $source_path );
      break;

    case IMAGETYPE_JPEG:
      $source_gdim = imagecreatefromjpeg( $source_path );
      break;

    case IMAGETYPE_PNG:
      $source_gdim = imagecreatefrompng( $source_path );
      break;
  }

  $source_aspect_ratio = $source_width / $source_height;
  $desired_aspect_ratio = DESIRED_IMAGE_WIDTH / DESIRED_IMAGE_HEIGHT;

  if ( $source_aspect_ratio > $desired_aspect_ratio )
  {
    //
    // Triggered when source image is wider
    //
    $temp_height = DESIRED_IMAGE_HEIGHT;
    $temp_width = ( int ) ( DESIRED_IMAGE_HEIGHT * $source_aspect_ratio );
  }
  else
  {
    //
    // Triggered otherwise (i.e. source image is similar or taller)
    //
    $temp_width = DESIRED_IMAGE_WIDTH;
    $temp_height = ( int ) ( DESIRED_IMAGE_WIDTH / $source_aspect_ratio );
  }

  //
  // Resize the image into a temporary GD image
  //

  $temp_gdim = imagecreatetruecolor( $temp_width, $temp_height );
  imagecopyresampled(
    $temp_gdim,
    $source_gdim,
    0, 0,
    0, 0,
    $temp_width, $temp_height,
    $source_width, $source_height
  );

  //
  // Copy cropped region from temporary image into the desired GD image
  //

  $x0 = ( $temp_width - DESIRED_IMAGE_WIDTH ) / 2;
  $y0 = ( $temp_height - DESIRED_IMAGE_HEIGHT ) / 2;

  $desired_gdim = imagecreatetruecolor( DESIRED_IMAGE_WIDTH, DESIRED_IMAGE_HEIGHT );
  imagecopy(
    $desired_gdim,
    $temp_gdim,
    0, 0,
    $x0, $y0,
    DESIRED_IMAGE_WIDTH, DESIRED_IMAGE_HEIGHT
  );

  //
  // Render the image
  // Alternatively, you can save the image in file-system or database

$remote_file = "image_files/".$_FILES["Image1"]["name"];
imagejpeg($desired_gdim,$remote_file);

}//

I'm trying to use checkbox to choose multiple data and submit(button 'Send SMS') them and direct them to another page, which will send text SMS to the numbers chosen. But when I try to click on one checkbox, it automatically directs me to the next page, without having to click on the 'Send SMS' button. I tried to see which part is the problem, but I can't determine which one is wrong.  Please help! Thank you.

<script type="text/javascript">
function checkedAll (frm1) {var aa= document.getElementById('frm1'); if (checked == false)
{
checked = true
}
else
{
checked = false
}for (var i =0; i < aa.elements.length; i++){ aa.elements[i].checked = checked;}
}
</script>

<TABLE width="1106" border="1" align="center" cellpadding="5" cellspacing="2" >

       <tr>

       <td colspan="9"> 
         <form id ="frm1" action="sms_latecomers.php">

       <input type='checkbox' name='checkall' onclick='checkedAll(frm1);' value="">

       <input type="submit" name="Submit" id="button" value="SMS Reminder" style="background:#FFCC33"/>


   </td>
 </tr>

       <TR bgcolor="#996699">
        <?php 
       $count=0;
       ?>
       <TH width="32"></TH>
           <TH width="37"> <span class="style1">
         <div align="center">No. </div></span></TH>
         <th width="101"><span class="style1">SUPERVISOR ID</span></th>
         <th width="101"><span class="style1">EMPLOYEE ID</span></th>
         <th width="153"><span class="style1">EMPLOYEE NAME</span></th>
         <th width="124"><span class="style1">DATE</span></th>
         <th width="153"><span class="style1">LATE CHECK IN</span></th>




       </TR>
       <?php 
       while($row = mysql_fetch_array($result, MYSQL_ASSOC))
       {
       ?>
       <TR>
           <TD><input type="checkbox" name="chk1" value="<?php echo $row['supervisor_telno']; ?>" onClick="window.open('sms_latecomers.php?employee_id=<?php echo $row['employee_id'];  ?>&supervisor_telno=<?php echo $row['supervisor_telno']; ?>');"></TD>

           <TD height="66">[bad html removed]<input type="checkbox" name="chk1" >--> <?php $count=$count+1; print($count);?></TD>
           <TD><div align="center"><?php echo $row['supervisor_id']; ?></div></TD>
           <TD><div align="center"><?php echo $row['employee_id']; ?></div></TD>
           <TD><div align="center"><?php echo $row['employee_name']; ?></div></TD>
           <TD><div align="center"><?php echo $row['DATE']; ?></div></TD>
           <TD><div align="center"><?php echo $row['TIME']; ?></div></TD>



       </TR>
       <?php 
       }
       ?>[bad html removed]</form>-->
   </TABLE>

HI,
according to my knowledge session_destroy() function would destroy all session variables and mysql_close() would close connection with the database.
   i make a simply logoff.php file and close myssql connection and destroy session. but i still get values from the database and session variables. and doesnt work properly

here is the code
Code: [Select]
<?php
session_start();
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
require_once '../database/db_connecting.php';
$dbname="sahansevena";//set database name
 $con=  setConnections();//make connections use implemented methode in db_connectiong.php
 mysql_select_db($dbname, $con);
//update the time and date of the admin table
 $update_time="update admin set last_logged_date =CURDATE(), last_log_time=CURTIME() where username='$uname'limit 3,4";
 //my admin table contain 5 colums they are id, username,password, last_logged_date, last_log_time
 $link= mysql_query($update_time);
 // mysql_select_db($dbname, $link);
//$con=mysql_connect('localhost', 'root','ijts');

       $result="select * from admin where username='a'";

        $result=mysql_query($result);
mysql_close($con);
//here i just check after closing data baseconnection whether i do get reselts but i do, why?
echo "after the cnnection was closed";
  echo "<html>";
echo "<table border='1' cellspacing='1' cellpadding='2' align='center'>";
      echo "<thead>";
           echo"<tr>";
                   echo "<th>";
                   echo ID;
                   echo"</th>";
                   echo" <th>";echo Username; echo"</th>";
                    echo"<th>";echo Password; echo"</th>";
                    echo"<th>";echo Last_logged_date; echo "</th>";
                   echo "<th>";echo Last_logged_time;  echo "</th>";
               echo" </tr>";
           echo" </thead>";
           echo" <tbody>";
while($row= mysql_fetch_array($result,MYSQL_BOTH)){
             echo "<tr>";
              echo "<td>";
              echo $row[0];
               echo "</td>";
                   echo "<td>";
              echo $row[1];
              echo "</td>";
                  echo "<td>";
              echo $row[2];
               echo "</td>";
                   echo "<td>";
                echo $row[3];
              echo "</td>";
                  echo "<td>";
              echo $row[4];
               echo "</td>";
            echo "</tr>";
     }
         echo" </tbody>";
         echo "</table>";
         echo "</html>";
     session_destroy();
session_commit();

echo "session and database are closed but i still get values".$_SESSION['admin'];
?>

I am currently creating a multi-user login system, and I have created the database in MySQL, but the problem is that my PHP script is not working as expected. I would like it so that if the user enters in a correct username + password combination, then they are redirected to a webpage called "congrats.php" for example. However, with my current PHP code, if I include a redirection instruction based on the correct input, then when I run the script, then the user is instantly taken to the congrats.php page without filling in any login details. I'm quite sure that the database has been connected to, as due to the layout of my script at the moment, the text that reads "You did it!" appears 4 times, the same number of rows in my MySQL database. My PHP coding for this is:

Code: [Select]
<html><head><title>Multi-User Log In Form</title></head>
<body>
<?php
$self = $_SERVER['PHP_SELF'];
$username = $_POST['username'];
$password = $_POST['password'];
?>
<form action = "<?php echo $self; ?>" method = "post">
Username <input type = "text" name = "username" size = "8">
Password <input type = "password" name = "password" size = "8">
<input type = "submit" value="Submit">
</form>
<?php
$conn = @mysql_connect("localhost", "root", "") or die ("Err: Conn");
$rs = @mysql_select_db("test3", $conn) or die ("Err: Db");
$sql = "select * from users";
$rs = mysql_query($sql, $conn);
while ($row = mysql_fetch_array($rs)) {

$name = $row["uname"];
$pass = $row["pword"];
if ($username = $name && $password = $pass)
{
//CODE FOR REDIRECTION SHOULD GO HERE
//header("location:congrats.php");
echo "You did it!";
}
else
{
echo "Invalid username and password combination";
}
}
?></body>
</html>

Any help in trying to get it so that my PHP script will redirect only if a correct username + password combination is entered would be greatly appreciated

I'm trying to show my data under the toggle button according to the order_id. But i do not know why when i click on my toggle button it does not work. I do not know what is wrong with it. Any advice will be appreciated. 

  <?php
                   $dsql = "SELECT  o.order_id , o.purchase_price , o.order_datetime,  u.id, u.user_fullname ,  p.id, p.product_title , c.id , c.category, s.id , s.seller_fullname FROM ordered_items o INNER JOIN users u ON o.user_id = u.id INNER JOIN sellers s ON o.seller_id = s.id 
                      INNER JOIN products p ON o.product_id = p.id CROSS JOIN category c ON p.product_category = c.id WHERE category = '".$category."' ORDER BY o.order_id DESC";
                      $dquery = $conn->query($dsql);
                      $tot_orders = mysqli_num_rows($dquery);
                      if (!mysqli_num_rows($dquery)) {
                        echo '
                          <div class="col-12">
                            <div class="badge badge-danger">No Orders Found</div>
                          </div>
                        ';
                      } else {
                        while ($drow = $dquery->fetch_assoc()) {
                          ?>
                                <tr>
                                  <td>
                                    #<?php echo $drow['order_id']; ?>
                                  </td>
                                  <td>
                                    <?php echo $drow['user_fullname']; ?>
                                  </td>
                                  <td>
                                    RM<?php echo  number_format($drow['purchase_price'],2); ?>
                                  </td>
                                 
                                  <td class="text-center">  
                                  <a style="text-decoration: none;color: #000;" title="View Details" data-toggle="collapse" data-target="#products-details<?php echo $drow['order_id']; ?>">
                                  <i class="nc-icon nc-minimal-down" onclick="changeToggleIcon(this)"></i>
                              </a>  
                        </td>        
                                  </td>
                                </tr>
          
                             
                                

                        <?php   
                           $p_sql = "SELECT  o.order_id , o.purchase_price , o.order_datetime , o.quantity , o.quantity_unit, u.id, u.user_fullname ,  p.id, p.product_title , p.product_photo , c.id , c.category, s.id , s.seller_fullname FROM ordered_items o INNER JOIN users u ON o.user_id = u.id INNER JOIN sellers s ON o.seller_id = s.id 
                      INNER JOIN products p ON o.product_id = p.id CROSS JOIN category c ON p.product_category = c.id WHERE category = '".$category."'" ;
                        $p_query = $conn->query($p_sql);
                        while ($p_row = $p_query->fetch_assoc()) {
                      ?>      
                        <tr class="collapse" id="products-details<?php echo $drow['order_id']; ?>" >
                           <td style="border-top: none; font-size: 10px;">
                          <img src="https://dev.gopasar.today/images/product-main/<?php echo $p_row['product_photo']; ?>" style="height: 50px; width: 50px;">
                        </td>
                          <th style="border-top: none; font-size: 10px;">
                            
                            <?php echo $p_row['product_title']; ?>
                          </th>
                          <th style="border-top: none; font-size: 10px;">
                            Order Quantity :<?php echo $p_row['quantity']; ?><?php echo $p_row['quantity_unit']; ?>
                          </th>
                          <th style="border-top: none; font-size: 10px;">
                              RM   <?php echo $p_row['purchase_price'];?>
                             
                          </th>

                        </tr>
                        

                     
                    </div>
          
            </div>
          </div>
<?php
}
}
}

?>

 

Code: [Select]
<?php
    include('../../header.php');
?>

<from method="post" action="">
    <input type="checkbox" name="confirmation" value="yes" /> I do confirm to get my password reseted.<br />
    <input type="submit" name="submit_confirmation" value="Confirm" />
</from>

<?php

if (isset($_POST['submit_confirmation']))
    $submit_confirmation = $_POST['submit_confirmation'];
if (isset($_POST['confirmation'])) {
    $confirmation_checkbox = $_POST['confirmation'];
}





if (isset($submit_confirmation)) {
        echo "works";
}



// Check if the user has confirmed the resetting.

if (isset($submit_confirmation) && isset($confirmation_checkbox) && $confirmation_checkbox == 'yes') {


This is a password resetting script, this script in example occurs after confirmation to have the password reset, the problem I am experiencing is that the script does not get executed and seems that the submit button does not even work to execute the script.

I tried to test the submit button by printing out a message stating "works" when pressing the submit button, but that one does not work either.

The execution of the whole script does not go path the conditional if statement check in the bottom area, and the statement "works" does not become printed out.

Any ideas what is going on here?


Here is the whole php file:

Code: [Select]
<?php
    include('../../header.php');
?>

<from method="post" action="">
    <input type="checkbox" name="confirmation" value="yes" /> I do confirm to get my password reseted.<br />
    <input type="submit" name="submit_confirmation" value="Confirm" />
</from>

<?php

if (isset($_POST['submit_confirmation']))
    $submit_confirmation = $_POST['submit_confirmation'];
if (isset($_POST['confirmation'])) {
    $confirmation_checkbox = $_POST['confirmation'];
}





if (isset($submit_confirmation)) {
        echo "works";
}



// Check if the user has confirmed the resetting.

if (isset($submit_confirmation) && isset($confirmation_checkbox) && $confirmation_checkbox == 'yes') {
    

    
    
    // Reset the password of the user
    
    $random_password = random(111111, 999999);

    $query_get = "UPDATE user SET password = '$random_password' WHERE user_id = '{$_GET['id']}' and random = '{$_GET['code']}'";

    $query_run = mysqli_query($dbc, $query_get);
    
    
    
    
    
    // Get the email address and user name of the user
    
    $query_get = "SELECT nickname, email FROM user WHERE user_id = '{$_GET['id']}'";
    
    $query_run = mysqli_query($dbc, $query_get);
    
    $assoc = mysqli_fetch_assoc($query_run);
    
    
    
    
    $to = $assoc['email'];
    $subject = "Your Reseted Password";
    $sender = 'From: rochoven@googlemail.com';
    $body = '
    Hello' .$assoc['nickname']. ', \n\n
    
    you requested and confirmed to have your password reseted, here is your new password, please use it to
    log in and change it to your desired password. \n\n
    
    New Reseted Password:' .$random_password. '\n\n
    
    Greetings!


    ';
 
    mail($to, $subject, $body, $sender);
    
    mysqli_close($dbc);
    
    
    header('Location:'.$password_reset_success);
        

}
?>




<?php
    include('../../footer.php');

?>

I have made a website with a custom scroll bar and a back to top button.  For some reason the back to top button doesn't show up.  Code is below:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <title>Adding a dynamic "Back To Top" floating button with smooth scroll</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/2.0.0/jquery.min.js"></script>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link href="css/bootstrap.min.css" rel="stylesheet" media="screen">

	
	
	<style>
/* For the "inset" look only */
html {
    overflow: auto;
}
body {
    position: absolute;
    top: 8px;
    left: 8px;
    bottom: 8px;
    right: 1px;
    padding: 10px; 
    overflow-y: scroll;
    overflow-x: hidden;
}

/* Width of bar */
::-webkit-scrollbar {
    width: 8px;
}
 
/* Track */
::-webkit-scrollbar-track {
    -webkit-box-shadow: inset 0 0 6px rgba(0,0,0,0.3); 
    -webkit-border-radius: 10px;
    border-radius: 10px;
}
 
/* Handle */
::-webkit-scrollbar-thumb {
    -webkit-border-radius: 10px;
    border-radius: 10px;
    background: rgba(255,0,0,0.8); 
    -webkit-box-shadow: inset 0 0 6px rgba(0,0,0,0.5); 
}
::-webkit-scrollbar-thumb:window-inactive {
	background: rgba(255,0,0,0.4); 
}
</style>
<style>
		div#page {
			max-width: 900px;
			margin-left: auto;
			margin-right: auto;
			padding: 20px;
		}
		
		.back-to-top {
			position: fixed;
			bottom: 1em;
			right: 0.5em;
			text-decoration: none;
			color: #000000;
			background-color: rgba(235, 235, 235, 0.80);
			font-size: 12px;
			padding: 0.8em;
			display: none;
		}

		.back-to-top:hover {	
			background-color: rgba(135, 135, 135, 0.50);
		}
	</style>
</head>
<body>
    <div id="page">
        <!-- [banner] -->
        <header id="banner">
            <hgroup>
                <h1>Adding a dynamic "Back To Top" floating button with smooth scroll</h1>
            </hgroup>
        </header>
        <!-- [content] -->
        <section id="content">
			<h1>The first heading</h1>
            <p>
                Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut nec felis sed velit auctor luctus id quis arcu. Ut dui augue, euismod nec justo a, pretium consequat nisi. Vivamus dictum nec quam in sollicitudin. Nullam non augue at risus condimentum consequat eu ut sem. Ut quis tortor quam. Nulla ullamcorper in metus egestas sagittis. In rhoncus feugiat sagittis. Cras eu arcu dui. Nulla non urna varius, facilisis sapien quis, tristique urna.
	
            </p>
			<h2>The first sub-heading</h2>
            <p>
                Duis tincidunt eleifend felis ac porttitor. Aenean facilisis elit eget orci vulputate scelerisque. Nulla justo sem, fringilla nec gravida vel, sollicitudin vitae libero. Donec vitae consequat lorem. Cras eros nunc, varius id dictum sit amet, posuere quis augue. Vivamus quis ipsum eget lectus porta vestibulum. Sed malesuada id orci eu rhoncus. Proin eleifend lacus non libero facilisis interdum.
	
            </p>
			<h2>The second sub-heading</h2>
            <p>
                Nulla luctus lorem et justo posuere, vitae ornare elit accumsan. Donec semper tincidunt lacus ut sagittis. Donec nec adipiscing nunc, quis rutrum tortor. Vivamus aliquam orci nulla, non ornare mauris eleifend et. Aliquam erat volutpat. Phasellus id nunc sapien. Suspendisse luctus pharetra lorem, quis scelerisque eros ultricies in. Vivamus hendrerit fermentum justo eget sagittis. Pellentesque cursus at turpis id cursus. Pellentesque sed rhoncus enim. Nam et ante feugiat, luctus enim in, tincidunt lectus. In feugiat neque quam. Curabitur mi ante, dictum non aliquam placerat, suscipit sed sem. Integer dictum, nulla vitae accumsan dignissim, augue justo laoreet diam, quis semper lectus orci vel mi.
	
            </p>
			<h3>The first sub-sub-heading</h3>
            <p>
                Vestibulum mollis elementum libero a blandit. Fusce placerat odio quis euismod elementum. Maecenas rhoncus quam viverra odio fringilla blandit. Curabitur erat mi, malesuada ac tempor eu, tincidunt vitae erat. Nunc consequat faucibus feugiat. Integer ornare dui metus, sed consectetur erat vulputate a. Sed porttitor eu magna in aliquet. Cras quis tempus lacus, ac fermentum lorem.
	
            </p>
			<h1>The second heading</h1>
            <p>
                Nullam dignissim nibh ac eros iaculis, quis aliquam nibh lacinia. Donec et ullamcorper nunc. Sed convallis aliquet ullamcorper. Donec non leo enim. Ut orci ante, viverra fringilla lorem nec, pretium volutpat lorem. Phasellus elit arcu, posuere at nibh at, facilisis adipiscing dolor. Duis hendrerit metus at turpis congue ornare. Aliquam orci nisi, malesuada at adipiscing non, pharetra a lectus. Mauris in rhoncus ipsum, et sagittis nulla. Duis laoreet luctus lorem, at malesuada sem bibendum at. Pellentesque ultrices massa eget lacus tempus, id ornare lacus fermentum. Sed id fermentum tellus. Suspendisse tincidunt posuere arcu quis fermentum.
	
            </p>
			<h2>The third sub-heading</h2>
            <p>
                Phasellus vitae lacinia sapien. Nam eget congue lorem. Donec viverra tortor eget tellus iaculis interdum. Vivamus sollicitudin egestas auctor. Vivamus sit amet justo sit amet eros sodales egestas. Nulla nec pharetra metus. Integer rutrum, ipsum in dignissim scelerisque, arcu est adipiscing tortor, nec varius eros mauris vel augue. In condimentum lobortis eros, sed facilisis neque imperdiet vel. Nullam ut commodo lectus, a luctus mi. Aliquam varius quis tortor a interdum. Aliquam erat volutpat. Nam pellentesque augue enim, eget posuere mi ultrices sodales. Vivamus vel varius quam. Donec sed ante placerat sapien consequat facilisis. Fusce vestibulum ipsum urna, nec tincidunt lacus hendrerit quis. Donec ornare dignissim risus.
	
            </p>
			<h2>The fourth sub-heading</h2>
            <p>
                Ut mauris mauris, porta bibendum dictum id, porttitor eu odio. Nam posuere in dui vitae pellentesque. Praesent commodo eros mattis posuere hendrerit. Suspendisse felis tellus, laoreet vitae erat non, laoreet gravida quam. Phasellus a augue non leo venenatis tempus. Curabitur ornare purus a mollis vulputate. Quisque vulputate euismod enim sed elementum. Duis id urna iaculis felis consequat vulputate. Mauris sollicitudin, leo eu sollicitudin porttitor, purus lacus sodales ipsum, vitae lobortis velit libero at libero.
	
            </p>
			<h1>The third heading</h1>
            <p>
                Quisque iaculis magna ac risus posuere ultricies. Sed tincidunt, sem ac pellentesque fringilla, sapien purus sagittis odio, eget aliquam ante lorem ac risus. In euismod dignissim leo ut eleifend. Proin accumsan velit quam. Phasellus sollicitudin nulla ligula, sit amet mollis lectus pellentesque consectetur. Nunc non dictum ante, fringilla lobortis nulla. Nullam ullamcorper volutpat velit, ut laoreet justo pellentesque ornare. Praesent aliquet eros eu magna sodales, ac pharetra erat dignissim. Nulla pulvinar neque at fermentum eleifend.
	
            </p>
			<h2>The fifth sub-heading</h2>
            <p>
                Praesent dictum interdum condimentum. Suspendisse in tortor blandit, lobortis libero eu, cursus libero. Donec vulputate ligula sit amet arcu porta imperdiet. Nam sodales, justo eu eleifend placerat, dui eros suscipit mi, quis congue dolor velit vitae nisi. Pellentesque mollis felis est. Etiam vitae justo laoreet, rutrum felis sed, porttitor dui. Sed cursus tincidunt turpis. Maecenas gravida commodo urna eget hendrerit. Ut suscipit mi sit amet turpis euismod, luctus suscipit turpis egestas.
	
            </p>
			<h1>The fourth heading</h1>
            <p>
                Mauris malesuada eros ac nisl pretium, at vehicula sem porttitor. Vestibulum porta erat leo, nec posuere enim pellentesque vel. Praesent libero est, laoreet quis scelerisque nec, egestas vel enim. Vivamus quis vulputate sapien. Interdum et malesuada fames ac ante ipsum primis in faucibus. Vivamus consequat ligula lectus, sed fermentum elit auctor vitae. Duis iaculis sagittis est sit amet semper. Morbi rutrum fermentum vulputate. Proin tincidunt elementum sem, a faucibus dui malesuada sit amet. Vivamus vel enim laoreet, iaculis nunc ac, tristique nisl. Nulla consequat arcu et dolor porta, non ullamcorper augue pharetra. Interdum et malesuada fames ac ante ipsum primis in faucibus. Integer sed nibh lectus. Sed pulvinar nunc magna, eget placerat mi pharetra ac. Vestibulum hendrerit, nulla nec vestibulum aliquam, arcu tortor blandit ipsum, eget sollicitudin nulla tellus quis libero. Duis sodales fringilla lacus vel auctor.
	
            </p>
			<h2>The sixth sub-heading</h2>
            <p>
                Vivamus erat turpis, condimentum vitae neque sit amet, tincidunt malesuada odio. Mauris mollis ante vitae quam condimentum lobortis. Integer sodales odio sit amet metus tempus, vel dignissim libero sagittis. Suspendisse ornare libero elit, quis sollicitudin leo pellentesque id. Sed pharetra mattis sapien nec condimentum. Mauris convallis arcu eget massa fringilla, nec pellentesque dolor semper. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vestibulum vitae odio a sem iaculis tempor. Fusce placerat viverra lorem mollis fermentum. Sed porta sit amet sapien eu venenatis.
	
            </p>
			<h3>The second sub-sub-heading</h3>
            <p>
                Aenean ut ipsum ultrices, sollicitudin massa quis, bibendum magna. Sed id porttitor diam, et vestibulum tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Phasellus vel magna dolor. Etiam cursus nibh ligula, id vestibulum metus varius feugiat. Etiam vitae dolor ligula. Aliquam eu consectetur lorem. Quisque nulla nulla, facilisis semper laoreet non, eleifend in dolor.
	
            </p>
			<a href="#" class="back-to-top"><span class="glyphicon glyphicon-chevron-up"></span></a>
        </section>

        <script>            
			jQuery(document).ready(function() {
				var offset = 220;
				var duration = 500;
				jQuery(window).scroll(function() {
					if (jQuery(this).scrollTop() > offset) {
						jQuery('.back-to-top').fadeIn(duration);
					} else {
						jQuery('.back-to-top').fadeOut(duration);
					}
				});
				
				jQuery('.back-to-top').click(function(event) {
					event.preventDefault();
					jQuery('html, body').animate({scrollTop: 0}, duration);
					return false;
				})
			});
		</script>
    </div>
    <!-- [/page] -->
    <script src="//code.jquery.com/jquery.js"></script>
    <script src="js/bootstrap.min.js"></script>
</body>
</html>

First problem fixed.
My second problem is if the result is 0X.XX,0 or 0X.XX,1 I would like to remove the first 0
The X.XX are numbers, but the 0 is not always there.

Can anyone help please
Thanks

Hi..,
I use below method to export data to excel.

header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename=abc.xls');

if I run the script from the server. (http://localhost/export.php) it is work. (pop-up window if i want save or open the file)

but if i run the script from the client (http://192.168.1.5/export.php) it is not work. (nothing happen)

any idea how to solve this?

This one requires lots of up front information:

I have a page, for this example that I will call page.php. It takes get parameters, and for this example I'll call the parameter "step". So I have a URL like this: page.php?step=1 This page has a form with an action of page.php?step=1. The code on the page validates the posting information. If the information is bad, it returns the user to page.php?step=1; if it is good, it takes the user to page.php?step=2 via header( "location:page.php?step=2" ). So redirection is done by relative path, not full URLs.
This all works as expected.

Now what I've done is set .htaccess to be HTTPS for this page, via this code:

# Turn SSL on for payments
RewriteCond %{HTTPS} off
RewriteCond %{SCRIPT_FILENAME} \/page\.php [NC]
RewriteRule ^(.*)$ https://%{HTTP_HOST}/$1 [R=301,L]

This works (initially). However, once you try to post the form, it just redirects back to the step=1 version of the page. I really don't know how or why that would be.

I'm not sure how else I can explain this or what other information you may have. But it's frustrating to not get a page working in HTTPS that works in HTTP. Very odd. Any suggestions? (I don't even really know the best location to figure out when/why it's redirecting back to the original page.)

Friends
  I am new to php and i have to submit my coursework in php by 3rd dec, I stuck at one place where i have to upload multiple photo and one can see all the photo he has uploaded and can edit or delete that photo so i have done uploading now i am showing those pics in table by running loop and generating tr and td but now i have two buttons with each row edit and delete now when i clicked on one delete or edit that pic should be delete or give text box to edit description of pic, Please help me how to do that.......

require_once 'includes/upload.class.php';
$upload = new uploads();
$details = $upload->getFileInformation($id);

<?php echo $details['upload_desc']; ?>

then here the class.

require_once 'db.class.php';



class uploads extends database

{

   private $uploadData;

   function uploadFile() {

   public function getFileInformation($id)

   {

      $this->uploadData = $this->readData("uploadfiles", "upload_id", $id);

      return $this->uploadData;

   }


But it wont work!
      

Some of you may have seen one of my many posts about email issues.  Some users don't get them, and I have determined it is probably because we are marked as spam.   We are a service that grades sales team members on their phone skills.  Listening to pre-recorded calls, grading and uploading them to our site, and then another part of our business looks them over and sometimes leaves a message that then get's forwarded to this persons work email.   I have determined there is ways to get marked as spam as default by not having an opt out link.  This is not an option, these sales members employer has opted in, and the emails are going to work related accounts hosted at that employer.  Also, if one of these staff members is not so bright, or disgruntled they may mark us as spam anyways.  The bottom line is that we have very little control over whether we are or are not marked as spam.   So we want to start looking into sending text messages and this is where I start to question how good of an idea this is.   First off, if it was me, and the messages where being sent to a device that my employer did not provide, I would in no way want work related text messages coming to me.  Unless there is a vested interest in getting them.  IE, I'm the boss at this place and am always on the clock.  What if you are on the bottom?  It's just a job for you.   What if it is a pre-paid device, text messages cost money.  What then?  What if they don't even have, or want a cell phone?   The short of it is this.  If I'm at a job that is just another job, and this employer tells me that I have to get these messages.  I'm going to look for another job.  I see the organizations having continuous issues and complaints from their employees.  Thus us as a business having issues keeping clients.   What am I getting into here?  What are your opinions on this matter?  What are your recommendations as to alerting users of something on our site that we can rest assured are being received 100% of the time?   Thanks!   Nick