PHP - Show If Not Empty

Man, I'm having a rough week with questions--if you're following at home.  Basically matching a Coach's first and last name to another table, which if matched will yield information about that coach's team. 

Code: [Select]
// or get user by username
$current_user = wp_get_current_user();
$current_first = $current_user->user_firstname;
$current_last = $current_user->user_lastname;
$current_id = $current_user->ID;


echo '<div class="contact_form">';

    echo  $current_first . ' ' . $current_last .' :: ';


$query = "SELECT * FROM schools WHERE coachFirst='".$current_first."' AND coachLast='".$current_last."'";
$result = mysql_query ($query);

if(!$result) {
echo 'There is not a match for your name.';
}
else
{
while($school= mysql_fetch_array($result)) {


echo $school['school'] . ' ' .  $school['id'];

include(ABSPATH ."wp-content/plugins/my-team/form.php");

}




echo '</div>';


echo '<div class="roster">';

include(ABSPATH ."wp-content/plugins/my-team/roster.php");

echo '</div>';
}

I want to show a cookie of a referral's username on a sign up page. The link is like this, www.mysite.com/signup?ref=johnsmith.

The cookie doesn't show if I go to that url page. But it does show up once I reload the page.  So I'm wondering if it's possible to show the cookie the first time around, instead of reloading the page?

Here is my code.

// This is in the header
$url_ref_name = (!empty($_GET['ref']) ? $_GET['ref'] : null);

if(!empty($url_ref_name)) {

  $number_of_days = 365;
  $date_of_expiry = time() + 60 * 60 * 24 * $number_of_days;
  setcookie( "ref", $url_ref_name, $date_of_expiry,"/");

} else if(empty($url_ref_name)) {
  if(isset($_COOKIE['ref'])) {
    $user_cookie = $_COOKIE['ref'];
  }
} else {}

// This is for the sign up form
if(isset($_COOKIE['ref'])) {
  $user_cookie = $_COOKIE['ref'];
  ?>
  <fieldset>
    <label>Referred By</label>
    <div id="ref-one"><span><?php if(!empty($user_cookie)){echo $user_cookie;} ?></span></div>
    <input type="hidden" name="ref" value="<?php if(!empty($user_cookie)){echo $user_cookie;} ?>" maxlength="20" placeholder="Referrer's username" readonly onfocus="this.removeAttribute('readonly');" />
  </fieldset>
  <?php
}

 

I am displaying rows from a database onto a page using:

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

echo $row['name'];

}

I need to figure out how to limit the rows shown to the page to 100. And if there are 100 rows on the page, a link will be displayed at the bottom, that says "Next 100". Then this will display the next 100 rows.
Can you give an example how to do this please?

Thanks

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

Hi ,

I know my code sucks but i'm learning fast!! I'm trying to show a form if the qty value in a database == 10 or a different form if the value ==20.  I tried but failed.  Any help really appreciated.

Code: [Select]

<?php require_once('Connections/book.php'); ?>
<?php
$colname_cardpayment = "-1";
if (isset($_GET['orderid'])) {
  $colname_cardpayment = (get_magic_quotes_gpc()) ? $_GET['orderid'] : addslashes($_GET['orderid']);
}
mysql_select_db($database_book, $book);
$query_cardpayment = sprintf("SELECT * FROM cards WHERE orderid = '%s' ORDER BY qty ASC", $colname_cardpayment);
$cardpayment = mysql_query($query_cardpayment, $book) or die(mysql_error());
$row_cardpayment = mysql_fetch_assoc($cardpayment);
$totalRows_cardpayment = mysql_num_rows($cardpayment);

 // Database connect
$con = mysql_connect("mysql1.myhost.ie","admin_book","root123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("book_test", $con);


//Parse Values from Coupon.php Form
$orderid = mysql_real_escape_string(trim($_POST['orderid']));
$name  = mysql_real_escape_string(trim($_POST['name']));
$surname  = mysql_real_escape_string(trim($_POST['surname']));
$add1 = mysql_real_escape_string(trim($_POST['add1']));
$add2 = mysql_real_escape_string(trim($_POST['add2']));
$town = mysql_real_escape_string(trim($_POST['town']));
$county = mysql_real_escape_string(trim($_POST['county']));
$postcode = mysql_real_escape_string(trim($_POST['postcode']));
$phone = mysql_real_escape_string(trim($_POST['phone']));
$email = mysql_real_escape_string(trim($_POST['email']));
$letterstyle = mysql_real_escape_string(trim($_POST['letterstyle']));


$sql="INSERT INTO custdetails (orderid, name, surname, add1, add2, town, county, postcode, phone, email, letterstyle)
VALUES
('$orderid','$name','$surname','$add1','$add2','$town','$county','$postcode','phone','$email','$letterstyle')";

if (!mysql_query($sql))
  {
  die('Error: ' . mysql_error());
  }
?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Digital Scribe Books</title>
<link href="style.css" rel="stylesheet" type="text/css" />

<script type="text/javascript">
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>


</head>

<body onload="MM_preloadImages('images/buttons/home_over.png','images/buttons/books_over.png','images/buttons/cards_over.png','images/buttons/letters_over.png')">


<div id="snow">
<div id="wrapper">


<div id="header">

<div id="logo"><img src="images/digital_scripe.png" width="218" height="91" /></div>


<div id="menu"><a href="index.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Home','','images/buttons/home_over.png',1)"><img src="images/buttons/home_act.png" name="Home" width="131" height="132" border="0" id="Home" /></a><a href="books.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Books','','images/buttons/books_over.png',1)"><img src="images/buttons/books_act.png" name="Books" width="131" height="132" border="0" id="Books" /></a><a href="cards.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Cards','','images/buttons/cards_over.png',1)"><img src="images/buttons/cards_act.png" name="Cards" width="131" height="132" border="0" id="Cards" /></a><a href="letters.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Letters','','images/buttons/letters_over.png',1)"><img src="images/buttons/letters_act.png" name="Letters" width="131" height="132" border="0" id="Letters" /></a></div>
 </div>
 
 
 
 
<div id="content">



<?php 
echo 'Order ID is :  '. $orderid . '.<br />';

if ($row2['qty'] == 10)
    echo "<div>

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="accounts@agraphics.ie">
<input type="hidden" name="lc" value="IE">
<input type="hidden" name="item_name" value="10 Christmas Cards">
<input type="hidden" name="item_number" value="<? echo $orderid; ?>">
<input type="hidden" name="amount" value="12.99">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="button_subtype" value="services">
<input type="hidden" name="shipping" value="2.99">
<input type="hidden" name="return" value="http://www.digitalscribe/thanks.php">
<input type="hidden" name="bn" value="PP-BuyNowBF:btn_buynowCC_LG.gif:NonHosted">
<input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>
</div>";

if ($row2['qty'] == 20)
    echo "<div>

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="accounts@agraphics.ie">
<input type="hidden" name="lc" value="IE">
<input type="hidden" name="item_name" value="20 Christmas Cards">
<input type="hidden" name="item_number" value="<? echo $orderid; ?>">
<input type="hidden" name="amount" value="21.99">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="button_subtype" value="services">
<input type="hidden" name="shipping" value="2.99">
<input type="hidden" name="return" value="http://www.digitalscribe/thanks.php">
<input type="hidden" name="bn" value="PP-BuyNowBF:btn_buynowCC_LG.gif:NonHosted">
<input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>
</div>";


?>

</div>


<div id="footer" class="clear"><div id="sign"><div id="sign_text">Personalised<br />
Books</div>
</div></div>

</div></div>






</body>
</html>
<?php
mysql_free_result($cardpayment);
?>

i have made query and i want replace with no data N/A i have tryed with swich but no luck

Code: [Select]
if (($row['name']) = empty)
  {
    echo('n/a');
}

Hi everyone!  I'm new to PHP and needed from you.  I have the following code that I can't figure out why it doesn't work on the last elseif.   If I comment out the first elseif (line 19-39), it does go through the last elseif. 

Can someone here help?  Thank you!!!

The content of Instructors.txt as follow:
ID#|fName lName|email_address|course1:course2:course3
ID#|fName lName|email_address|course1:course3
ID#|fName lName|email_address|course1:course2:course4
ID#|fName lName|email_address|course2:course3:course5:course6

<?php
  //If we submitted the form
  if(empty($_POST['Location'])) {
    $FH = fopen("Locations.txt", "rb");
    print "<FORM name=\"myForm\" action=\"test4.php\" method=\"POST\">\n";
    print "<P>    Location:\n";
    print "<select name=\"Location\">\n";
    print "<option value=\"\">-- Select --\n";
    while (!feof($FH)){
      $line_of_text = fgets($FH);
      $line = explode('|', $line_of_text);
      print "<option value=$line[1]>$line[1]";
    }
    fclose($FH);

    print "<input type=\"submit\" value=\" Next 1 \">\n";
    exit();
  }
  elseif(empty($_POST['Instructor'])) {

    $location = ($_POST['Location']);
    $FH = fopen("Instructors.txt", "rb");
    print "<FORM name=\"myForm\" action=\"test4.php\" method=\"POST\">\n";
    print "<P>    Location: <input type=text value=$location>\n";
    print "<P>  Instructor: \n";
    print "<select name=\"Instructor\">\n";
    print "<option value=\"\">-- Select --\n";
    while (!feof($FH)){
      $line_of_text = fgets($FH);
      $line = explode('|', $line_of_text);
      if ($line[0] == "$location") {
        print "<option value=\"$line[1]\">$line[1]\n";
      }
    }
    fclose($FH);
    print "<input type=\"submit\" value=\" Next 2 \">\n";
    exit();

  }
  elseif(empty($_POST['Course'])) {
    $location = ($_POST['Location']);
    $instructor = ($_POST['Instructor']);

    $FH = fopen("Instructors.txt", "rb");
    print "<FORM name=\"myForm\" action=\"test4.php\" method=\"POST\">\n";
    print "<P>    Location: <input type=text value=$location>\n";
    print "<P>  Instructor: <input type=text value=\"$instructor\">\n";
    print "<P>      Course: \n";
    print "<select name=\"Course\">\n";
    print "<option value=\"\">-- Select --\n";
    while (!feof($FH)){
      $line_of_text = fgets($FH);
      $line = explode('|', $line_of_text);
      if ($line[1] == "Bert Vandenber") {
        $course = explode(':', $line[3]);
        for ($i=0; $i<count($course); $i++) {
          print "<option value=\"$course[$i]\">$course[$i]\n";
        }
      }
    }
    fclose($FH);
    print "<input type=\"submit\" value=\" Next 3 \">\n";
    exit();
  }
?>

I have search page in the form of search.php?q=query, as the php script calls for other files and a long process. When visiting search.php directly, the value of q is indeed null, and it makes a long loop and use lots of cpu.

How to kill the script or redirect to the main page when visiting search.php?

I don't get the logic behind the construct.  I can't ever see myself using this because it doesn't make sense when I code it. 

I understand isset($var) and why I should use it sometimes to avoid undefined messages.

But with empty() it makes more sense to always test the variable directly because if the value is NULL, 0, '', or false then it evaluates as TRUE.  Is there any situation where empty should be used always?

I have this line in my code

$result2 = mysqli_query($link, 'Select * from categories where cat_loc ='.$nav['id']);

how do I say "if $result2 is empty or false"? (basically if it didn't find any cat_loc = to $nav['id'])

 to echo '</li>';

how would I make it so that the option 'Remove (make blank)' would post an empty value?

Quote

<form action="/new/newrotastaffprocess.php" Method="POST">

<select name="username">
<?php
$result = mysql_query("SELECT * FROM members")
or die(mysql_error());
while($row = mysql_fetch_array( $result )) {

echo "<option value=\"" . htmlentities($row["username"]) . "\">" . htmlentities($row["username"]) . "</option>";
}
echo "<option value='empty'>Remove (make blank)</option>";
?>
</select>
</div>
<div style="position:absolute; top:397px; left:570px;">
<form action="/new/newrotastaffprocess.php" METHOD="POST">
<input type = "hidden" value="<?php echo $wkbeg;?>" name="wkbeg">
<input type = "hidden" value="<?php echo $staffno;?>" name="staffno">
<input type = "submit" value="New!">
</form>

I was just wondering what the best way to identify an empty set is.  At the moment I have this but this doesn't seem to work so I was wondering what the best way is.  Thanks. 


$article_rs = mysql_query($article_sql, $mysql_conn);

if (!$article_rs) {
$_SESSION['no_articles'] = "<p>Sorry but there are no articles that match your search.</p>";
}

Im trying to echo certain code if the array returned is empty.  I know for certain the array is empty and it works when its not empty. here is my code

<?php while ($club = mysql_fetch_assoc($qclubs)) {

if (empty($club)) {echo "<option value='None'>None</option>";}

else{

echo"
                                <option value='{$club['groupID']}'>{$club['group']}</option>";

}}?>


Can someone please point out the error of my ways?

  
Am trying to get user input then compare it with the value in database then return an output in form of echo. It shows a blank page of whick i cant figure out the error. This is what i have tried so far.

This is a file called t12.php   

<?php

  include 'db.php';
  error_reporting(E_ALL | 
   E_WARNING | E_NOTICE);
    
  ini_set('display_errors', 
  TRUE);

     if (session_status() 
    == PHP_SESSION_NONE) 
    {
    session_start();
    }


  if(!isset($_SESSION['login']))
    {
         echo (" 
   <script>location.href='../clogin/'</script>");
    die();

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

     {

     $username = 
    $_SESSION['login'];

     $transAmount = 
    $_POST['transAmount'];

     $totalTrans = 
    $transAmount + 30;

    $sql = "SELECT * FROM 
   customer WHERE username = ?";
    $stmt = $connection->prepare($sql); 
    $stmt->bind_param('s', $username);
    $stmt->execute();
    $result = $stmt->get_result();
    $count =  $result->num_rows;
      if($count == 1) 
     {  
 
    while ($row = $result->fetch_assoc())
     {
 
        if($totalTrans > $row['transLimit']) 
    {
    
    echo 'you have exceeded limit';

    exit(); 
    }
     else
     {
      echo"limit passed";
      }

      }//while loop
      }//count

       }//submit
       }//session
       ?>

                     
The html form is this...

   

<form action="t12.php" method="post">
          <input type="number" name="transAmount" placeholder="Enter Amount"> 
   </input><br>
    <button type="submit" name="transfer">Proceed</button></form>

 

 

 

Have tried lot of stuffs but doesnt work out. I would appreciate if you can take your time to check for me and point out the errors. Also please be nice with your comments. Thanks in advance

Hello:

I have this bit of code in the works (which does not work):
Code: [Select]
<?php if ( $mySubHeader; != "" ) { echo " 

<h2>
<?php echo $mySubHeader; ?>

</h2>

"; }

What I am trying to do is to show the H2 tag only if it has a value from the database.

Otherwise, I do not want to show it.

What is the correct way to do this?

Thanks.