AllSeoHelp.com
Search the Entire Site
  • PHP
  • JavaScript
  • CSS
  • HTML
Learn VBA & Macros in 1 Week!

PHP - Unable To Display Items Located In Another Table
Full Excel VBA Course - Beginner to Expert

Unable To Display Items Located In Another Table

 View Content
I'm working on creating a Realtors website.
Currently mysql DB has 4 tables. 3 of them are needed in this script to show up as 1 item.
Table called Listings has 2 fields that call on 2 other tables. one is MLS which calls on the Images Table the other agent calls on the Agents table.
I'm trying to see why I can't While loop all 3 tables together? How can I connect all 3?


<?php

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}


//mysql_select_db($database_CarneyRealty, $CarneyRealty);
//$query_Update1 = "SELECT * FROM listings";
//$Update1 = mysql_query($query_Update1, $CarneyRealty) or die(mysql_error());
//$rrows = mysql_fetch_assoc($Update1);
//$totalRows_Update1 = mysql_num_rows($Update1);
 
include 'dbc.php';
page_protect();

$err = array();
$msg = array();

$page_limit =4; //CHANGE FOR THE NUMBER OF LISTINGS PER PAGE!
$page_num_limit =10;

$ret = $_SERVER['HTTP_REFERER'];


$host  = $_SERVER['HTTP_HOST'];
$host_upper = strtoupper($host);
$login_path = @ereg_replace('admin','',dirname($_SERVER['PHP_SELF']));
$path   = rtrim($login_path, '/\\');

// filter GET values
foreach($_GET as $key => $value) {
$get[$key] = filter($value);
}

foreach($_POST as $key => $value) {
$post[$key] = filter($value);
}


$rs_all = mysql_query("select count(*) as total_all from listings") or die(mysql_error());
$rs_active = mysql_query("select count(*) as total_active from listings where status='ACTIVE'") or die(mysql_error());
$rs_total_contingent = mysql_query("select count(*) as tot2 from listings where status='CONTINGENT'");
$rs_total_pending = mysql_query("select count(*) as tot from listings where status='PENDING'");    
$rs_total_sold = mysql_query("select count(*) as tot1 from listings where status='SOLD'");
$rs_resall = mysql_query("select count(*) as res from listings where class='Resident'") or die(mysql_error());
$rs_comall = mysql_query("select count(*) as com from listings where class='Commerical'");
$rs_farmall = mysql_query("select count(*) as farm from listings where class='Farmland'");    
$rs_otherall = mysql_query("select count(*) as other from listings where class='Other'");

list($all) = mysql_fetch_row($rs_all);
list($active) = mysql_fetch_row($rs_active);
list($total_contingent) = mysql_fetch_row($rs_total_contingent);
list($total_pending) = mysql_fetch_row($rs_total_pending);
list($total_sold) = mysql_fetch_row($rs_total_sold);

list($resall) = mysql_fetch_row($rs_resall);
list($comall) = mysql_fetch_row($rs_comall);
list($farmall) = mysql_fetch_row($rs_farmall);
list($otherall) = mysql_fetch_row($rs_otherall);

///////////////////////////////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////////////////////////////////////////
$sqlagents = mysql_query("select * from agents where id='$_SESSION'");
//$agentname= mysql_query($sqlagents) or die(mysql_error());
$sqllistings = mysql_query("select * from listings where id='$_SESSION'"); 
$sqlimages = mysql_query("select * from images where id='$_SESSION'");
////////////////////////////////////////////////////////////////////////////////////////////////////////
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
  <head>
  <title>Search CarneyRealty Listings</title>
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  <link rel="stylesheet" href="../css/mm_brochure.css" type="text/css">
  <style type="text/css">
<!--
body {
background-image: url(http://www.carneyrealty.com/newsite/images/IMG_0161a.jpg);
}
.style1 {
font-size: 16px
}
.style2 {
font-family: Geneva, Arial, Helvetica, sans-serif
}
.style10 {
font-size: 13px;
font-weight: bold;
color: #FF0000;
}
.style7 {
color: #FF0000;
font-weight: bold;
}
.style8 {
color: #0000FF;
font-weight: bold;
}
-->
</style>
  </head>
  <body bgcolor="#bcbc85" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<div align="center">
    <table width="81%" border="0" cellspacing="0" cellpadding="0">
    <tr bgcolor="#999966">
        <td width="25" nowrap="nowrap"><center>
        <img src="../images/mm_spacer.gif" alt="" width="15" height="1" border="0" /></td>
        <td height="60" colspan="3" class="logo" nowrap="nowrap"><div align="center"><img src="images/Carney_Logo1_000.jpg" width="630" height="158" /><br />
          </div></td>
        <td width="4"></td>
      </tr>
    <tr bgcolor="#797947">
        <td width="25" nowrap="nowrap"></td>
        <td colspan="3" valign="top"><div align="center">
            <table width="460" border="0" cellpadding="0" cellspacing="0" id="navigation">
            <tr>
                <td width="59" align="center" nowrap="nowrap"><div align="center"><a href="../index.htm" class="style1"><strong>HOME</a></div></td>
                <td width="127" align="center" nowrap="nowrap"><div align="center"><strong><a href="../SearchCarneyRealtyListings.php" class="style5">LISTINGSEARCH</a></strong></div></td>
                <td width="94" align="center" nowrap="nowrap"><div align="center"><strong><a href="../Aboutus.html" class="style5">ABOUT US</a></strong></div></td>
                <td width="10" align="center" nowrap="nowrap"><div align="center"></div></td>
                <td width="95" align="center" nowrap="nowrap"><div align="center"><strong><a href="../Community.htm" class="style5">COMMUNITY </a></strong></div></td>
                <td width="81" align="center" nowrap="nowrap"><div align="center"><strong><a href="../Login.php" class="style5">LOGIN</a></strong></div></td>
              </tr>
          </table>
            <table width="307" border="0" cellpadding="0" cellspacing="0" id="navigation">
            <tr>
                <td width="84" align="center" nowrap="nowrap"><div align="center"><a href="http://www.carneyrealty.com/newsite/listingsearch.php?doSearch=MLS+Search&q=Resident" class="style1">Residential</a></div></td>
                <td width="103" align="center" nowrap="nowrap"><div align="center"><strong><a href="http://www.carneyrealty.com/newsite/listingsearch.php?doSearch=MLS+Search&q=Commerical" class="style5">Commercial</a></strong></div></td>
                <td width="102" align="center" nowrap="nowrap"><div align="center"><strong><a href="http://www.carneyrealty.com/newsite/listingsearch.php?doSearch=MLS+Search&q=Farmland" class="style5">Farms &amp; Land</a></strong></div></td>
                <td width="18" align="center" nowrap="nowrap"><div align="center"></div></td>
              </tr>
          </table>
            <table width="573" border="0" cellpadding="0" cellspacing="0" id="navigation">
            <tr>
                <td width="72" align="center" nowrap="nowrap"><div align="center"><a href="residental0-60.php" class="style1">$0-$60K</a></div></td>
                <td width="80" align="center" nowrap="nowrap"><div align="center"><strong><a href="residental61-85.php" class="style5">$61K-$85K</a></strong></div></td>
                <td width="87" align="center" nowrap="nowrap"><div align="center"><strong><a href="residental86-115.php" class="style5">$86K-$115K</a></strong></div></td>
                <td width="1" align="center" nowrap="nowrap"><div align="center"></div></td>
                <td width="103" align="center" nowrap="nowrap"><div align="center"><strong><a href="residental116-160.php" class="style5">$116K-$160K</a></strong></div></td>
                <td width="93" align="center" nowrap="nowrap"><div align="center"><strong><a href="residental161-230.php" class="style5">$161K-230K</a></strong></div></td>
                <td width="126" align="center" nowrap="nowrap"><div align="center"><strong><a href="residential231up.php" class="style5">$231K-And Up</a></strong></div></td>
                <td width="11" align="center" nowrap="nowrap">&nbsp;</td>
              </tr>
          </table>
          </div></td>
      </tr>
    
        <td width="25" valign="top"><?php 
/*********************** MY MLS MENU ****************************
This code shows MLS account menu only to logged in users. 
Copy this code till END and place it in a new html or php where
you want to show myaccount options. This is only visible to logged in users
*******************************************************************/
?>
        <?php 
  if(!empty($msg)) {
  echo $msg[0];
  }
  ?>
        <? //$row_settings1=mysql_fetch_array($sqllistings1);?>
        <?php while ($row_settings1 = mysql_fetch_array($sqllistings)){
$row_settings2=mysql_fetch_array($sqlimages);
$row_settings3=mysql_fetch_array($sqlagents);
?>
        <?php } ?>
  </table>
    <table width="81%" border="0" align="center" cellpadding="10" cellspacing="0" style="background-color: #FF9933;padding: 2px 5px;border: 1px solid #F90;" >
    <tr>
        <td height="44" align="center"><form name="form1" method="get" action="listingsearch.php">
            <p>
            <input name="doSearch" type="submit" id="doSearch2" value="MLS Search" />
            <input name="q" type="text" id="q" size="40">
            <strong> S CARNEY&amp; ASSOCIATES INC 800-757-5783</strong> <br>
          </p>
          </form></td>
      </tr>
  </table>
    </td>
    </tr>
    </table>
  </div>
<p>
    <?php if ($get['doSearch'] == 'MLS Search') {
  $cond = '';
  if($get['qoption'] == 'active') {
  $cond = "where `status`='ACTIVE' order by date desc";
  }
  if($get['qoption'] == 'contingent') {
  $cond = "where `status`='CONTINGENT' order by date desc";
  }
  if($get['qoption'] == 'pending') {
  $cond = "where `status`='PENDING' order by date desc";
  }
  if($get['qoption'] == 'sold') {
  $cond = "where `status`='SOLD' order by date desc";
  }
  if($get['qoption'] == 'resident') {
  $cond = "where `class`='Resident' order by price desc";
  }
  if($get['qoption'] == 'farmland') {
  $cond = "where `class`='Farmland' order by price desc";
  }
  if($get['qoption'] == 'commerical') {
  $cond = "where `class`='Commerical' order by price desc";
  }
  if($get['qoption'] == 'other') {
  $cond = "where `class`='Other' order by price desc";
  }
   //if($get['qoption'] == '') {
   if($get['q'] == '') { 
$sql = "select * from listings order by price asc";
 // $sql = "select * from listings $cond"; 
 // } 
  } 
  else { 
  $sql = "select * from listings where `price` = '$_REQUEST[q]' or `mls`='$_REQUEST[q]' or `seller`='$_REQUEST[q]' or `class`='$_REQUEST[q]' or `status`='$_REQUEST[q]' order by `price` asc";
//$sql1="select * from images where `mls`='$sql'";
//$sql2="select * from agents where `tag`='$sql'";
//  $sql = "select * from listings where `mls`='$_REQUEST[q]' or `price`='$_REQUEST[q]'";
  }

  //$rs_total1=mysql_query($sql1) or die(mysql_error());
  $rs_total = mysql_query($sql) or die(mysql_error());
  $total = mysql_num_rows($rs_total);
 // $total1=mysql_num_rows($rs_total1);
  if (!isset($_GET['page']) )
{ $start=0; } else
{ $start = ($_GET['page'] - 1) * $page_limit; }
  
  $rs_results = mysql_query($sql . " limit $start,$page_limit") or die(mysql_error());
  $total_pages = ceil($total/$page_limit);
 // $rs_results1 = mysql_query($sql1 ."limit $start,$page_limit") or die (mysql_error());
  ?>
    <?php 
  
  // outputting the pages
if ($total > $page_num_limit)
{
echo "<table width='81%' border='0' align='center' cellpadding='2' cellspacing='0' background='#fcfcdd'><span class='subHeader'><center>Pages: ";
$i = 0;
while ($i < $page_num_limit)
{


$page_no = $i+1;
$qstr = ereg_replace("&page=[0-9]+","",$_SERVER['QUERY_STRING']);
echo "<a href=\"listingsearch.php?$qstr&page=$page_no\">$page_no</a> ";
$i++;
}
echo "</span></td></table>";
}  ?>
    <? 
//while ($rrows3 = mysql_fetch_array($rrows3)){

?>
  <form name "searchform" action="listingsearch.php" method="post">
  </form>
</table>
<?php
//////////////////////////////////////////////////////////////////////////////
 while ($rrows = mysql_fetch_array($rs_results)) {
 $rrows2=mysql_fetch_array($sqlimages);
$rrows3=mysql_fetch_array($sqlagents);

///////////////////////////////////////////////////////////////////////////////
//$imagenamevar=($rrows['mls']=$rrows2['mls']);
//echo $rrows3['id'];
//$agentpicvar=($rrows['seller']=$rrow3['tag']);

?>
<tr>
    <table width="81%" border="0" align="center" cellpadding="2" cellspacing="0" background="#fcfcdd">
    <?  echo $rrows['agents'.'seller_id'];?>
    
        <td width="161" height="211" align="center" valign="top" bgcolor="#fcfcdd"><div align="center"><img src="http://www.carneyrealty.com/newsite/uploads/<?php echo $rrows['mls'];?>/<? echo $mainimagevar; ?> width="214" height="160" />
            </p>
          </div>
        <p class="tagline">Click for Additional Pictures</p></td>
        <td width="568" align="center" valign="top" bgcolor="#fcfcdd" class="calendarText"><div align="left">
            <table width="592" height="180" border="1">
            <tr valign="top">
                <td width="74" height="27" bgcolor="#fcfcdd" class="tagline">Location </td>
                <td width="249" bgcolor="#fcfcdd"><strong><?php echo $rrows['location'];?> <br>
                  <?  echo $rrows['location1'];?>
                  <br>
                  <? echo $rrows3['tag'];?> </strong></td>
                <td width="180" rowspan="2" bgcolor="#fcfcdd" class="tagline"><div align="center">
                    <table width="180" height="62" border="1">
                    <tr valign="top">
                        <td width="70" rowspan="2" class="tagline"><a href="http://www.carneyrealty.com/newsite/upload/<?php echo $rrows['mls'];?>/<? echo "SD_disp.pdf";?>"><img align="absbottom" src="http://www.carneyrealty.com/newsite/Listing_pages/images/datasheet_018.jpg" width="58" height="50" /></a></td>
                        <td width="50" class="tagline"><div align="left">Status </div></td>
                        <td width="68"><div align="right" class="subHeader"><?php echo $rrows['status']; ?></div></td>
                      </tr>
                    <tr valign="top">
                        <td height="24" class="tagline"><div align="left">PRICE</div></td>
                        <td align="center" valign="top"><div align="right"><strong class="subHeader"><?php echo $rrows['price']; ?></strong></div></td>
                      </tr>
                  </table>
                    <span style="color: #fcfcdd"><strong><a href="mailto:<? echo $rrows['selleremail'];?>"><img src="http://www.carneyrealty.com/newsite/Listing_pages/images/mail_004.gif" width="14" height="15" /><? echo $rrows['seller'];?></a></strong></span></div></td>
                <td width="61" rowspan="2" bgcolor="#fcfcdd" class="tagline"><div align="right"></div>
                <span style="color: #fcfcdd"><img src="<? 
    
/////////////////////////////////////////////////////////////

while ($rrows3=($rrows['seller']=$rrows3['seller_id'])){
   echo $rrows3['agentimage'];
   }
   //////////////////////////////////////////////////////////////
   ?>" width="60" height="91" /></a></span></td>
              </tr>
            <tr valign="top">
                <td height="64" bgcolor="#fcfcdd" class="tagline">Specs</td>
                <td bgcolor="#fcfcdd"><strong><?php echo $rrows['specs']; ?></strong></td>
              </tr>
            <tr valign="top">
                <td height="77" bgcolor="#fcfcdd"  class="tagline">Description</td>
                <td colspan="3" bgcolor="#fcfcdd" ><strong>MLS #<?php echo $rrows['mls'];?><br>
                  <? echo $rrows['description'];?></strong>
                <p><strong>Call <? echo $rrows['seller'];?> at <? echo agentnumbervar;?> to view   or for more information.</strong></p></td>
              </tr>
          </table>
            
            <tr>
                <td height="18" colspan="2" align="center" valign="top" bgcolor="#FF9933"><span class="bodyText style2" style="color: #fcfcdd"></span><span class="bodyText style2">S   Carney &amp; Associates Real Estate Brokerage 800 757 5783&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></td>
              </tr>
        </div></td>
      </tr>
      </span>
    
    <? } ?>
    
        <td height="4"></td>
    </table>
    <? } ?>
    <? //} ?>
  </tr>
<?php 
  

  
  // outputting the pages
if ($total > $page_limit)
{
echo "<table width='81%' border='0' align='center' cellpadding='2' cellspacing='0' background='#fcfcdd'><span class='subHeader'><center>Pages: ";
$i = 0;
while ($i < $page_num_limit)
{


$page_no = $i+1;
$qstr = ereg_replace("&page=[0-9]+","",$_SERVER['QUERY_STRING']);
echo "<a href=\"listings.php?$qstr&page=$page_no\">$page_no</a> ";
$i++;
}
echo "</span></td></table>";
}  ?>
</td>
</tr>
<tr>
    <td height="22" class="bodyText"><?
 include 'footer1.shtml';
  ?>
</td>
</tr>
<tr>
    <td height="194" class="bodyText"><div align="center">
        <table width="513" border="0">
        <tr valign="top">
            <th width="94" scope="col"><div align="center"><a href="http://www.realtor.org/technology/crt_secure/home?opendocument"><img src="images/index.1.gif" width="43" height="42" border="0" /></a></div></th>
            <th width="46" scope="col"><div align="center"></div></th>
            <th width="100" valign="middle" scope="col"><div align="center" class="style7">
                <div align="center"><a href="http://www.nacogdochesmls.com/nag/passwd.php"><img src="images/MLS_a_94-50.gif" width="92" height="51" alt="Multiple Listing Service" /></a></div>
              </div></th>
            <th width="119" scope="col"><div align="center"><a href="http://www.hud.gov/offices/fheo/FHLaws/"><img src="http://www.habitatwhitley.org/equal_housing_logo.jpg" alt="Equal Housing Opportunity" width="60" height="62" border="0" /></a></div></th>
            <th width="129" scope="col"><div align="center"></div></th>
          </tr>
        <tr valign="top">
            <td height="32"><div align="center" class="style8"><a href="http://www.realtor.org/technology/crt_secure/home?opendocument">REALTOR.ORG</a></div></td>
            <td><div align="center"></div></td>
            <td valign="middle"><div align="center"><span class="style10"><a href="http://www.nacogdochesmls.com/nag/passwd.php">Multiple Listing System</a></span></div></td>
            <td><div align="center"><strong><a href="http://www.hud.gov/offices/fheo/FHLaws/">Equal Housing Opportunity</a></strong></div></td>
            <td><div align="center"><a href="http://www.bbb.org/">BETTER BUSINESS BUREAU</a></div></td>
          </tr>
      </table>
      </div></td>
  </tr>
</table>
<div align="left">&nbsp;<br />
  </div>
</div>
</td>
<td valign="top"><div align="left"></div></td>
<td width="4"><div align="left"></div></td>
</tr>
<tr>
    <td width="15">&nbsp;</td>
    <td width="35">&nbsp;</td>
    <td width="698"><div align="center">
    <?php
  include 'footer.shtml';
  ?>
  </div>
  </td>
  <td width="1"><div align="center"></div></td>
  <td width="4">&nbsp;</td>
  </tr>
  </table>
  </table>
  </table>
  </div>
  </body>
  </html>





 
 


Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Display Table Items
Display Images From Different Sub-folders Located In One Folder
Unable To Display My Images
Unable To Display Single Row
Unable To Display Textbox Contents
Help !! My Database Detail Unable To Display
Unable To Display Image On Web Page
Display Ads After Every 4 Items
Moved: Unable To Display Running Time On Webpage
Display Text If One Of These Items Is Present
Unable To Display Output Properly Using Php "echo" And Html Tags
Unable To Print Distinct Dates And Display In A Specific Format..
Unable To Create Temp Table In Proc.
Unable To Input Value Into Database Table Using Php Code
Unable To Insert Into Table Value From Dropdown List
Moved: Wordpress Guru? I Need To Know Where This Sql Is Located.
Timeout Data Located In Cookie Files
Trying To Require A File In A Laterally Located Directory Using Relative Paths
How To Display 20 Single Column Ul(un-ordered List) Values Into Row Wise. Single Row 4 Items And 5 Columns
Need A Php Code To Delete Selected Items Of Database Items Using Checkbox


Learn VBA & Macros for Excel in 1 Week!


Display Table Items

 Similar Tutorials View Content
How to display items like bottom table?   And here is the code 
<?

print"
<table style=\"width:100%\" class=\"tableList\">
	<tr>
		<th style=\"width:35%\">Prize Name</th> 
		<th style=\"width:12%\">Amount</th>
		<th style=\"width:12%\">Points</th>
		<th style=\"width:12%\">Available</th>
		<th style=\"width:12%\">Redeemed</th>
		<th style=\"width:17%\">Action</th>
	</tr>";

	$giftCardQuery = 'SELECT currency, amount, pointsPrice, instant_gift_cards.id, instant_gift_cards.giftCardName, instant_gift_cards.giftCardImage FROM instant_gift_card_codes INNER JOIN instant_gift_cards ON (instant_gift_card_codes.giftCardId = instant_gift_cards.id) WHERE instant_gift_cards.status = :cardStatus ORDER BY instant_gift_cards.dateCreated DESC';
	$giftCard = $db->prepare($giftCardQuery);
	$giftCard->bindValue(':cardStatus', 'Enabled', PDO::PARAM_STR);
	$giftCard->execute();
	
	if($giftCard->rowCount() > '0'){
	
		while($giftCardRow = $giftCard->fetch(PDO::FETCH_ASSOC)){
			
			$giftCardsAvailableQuery = 'SELECT count(*) FROM instant_gift_card_codes WHERE currency = :currency AND amount = :amount AND pointsPrice = :pointsPrice AND giftCardId = :id AND status = :status';
			$giftCardsAvailable = $db->prepare($giftCardsAvailableQuery);
			$giftCardsAvailable->bindParam(':currency', $giftCardRow['currency'], PDO::PARAM_STR);
			$giftCardsAvailable->bindParam(':amount', $giftCardRow['amount'], PDO::PARAM_STR);
			$giftCardsAvailable->bindParam(':pointsPrice', $giftCardRow['pointsPrice'], PDO::PARAM_STR);
			$giftCardsAvailable->bindParam(':id', $giftCardRow['id'], PDO::PARAM_INT);
			$giftCardsAvailable->bindValue(':status', 'Available', PDO::PARAM_STR);
			$giftCardsAvailable->execute();
			$gCardsAvailable = $giftCardsAvailable->fetch(PDO::FETCH_COLUMN);
			
			$giftCardsRedeemedQuery = 'SELECT count(*) FROM instant_gift_card_codes WHERE currency = :currency AND amount = :amount AND pointsPrice = :pointsPrice AND giftCardId = :id AND status = :status';
			$giftCardsRedeemed = $db->prepare($giftCardsRedeemedQuery);
			$giftCardsRedeemed->bindParam(':currency', $giftCardRow['currency'], PDO::PARAM_STR);
			$giftCardsRedeemed->bindParam(':amount', $giftCardRow['amount'], PDO::PARAM_STR);
			$giftCardsRedeemed->bindParam(':pointsPrice', $giftCardRow['pointsPrice'], PDO::PARAM_STR);
			$giftCardsRedeemed->bindParam(':id', $giftCardRow['id'], PDO::PARAM_INT);
			$giftCardsRedeemed->bindValue(':status', 'Redeemed', PDO::PARAM_STR);
			$giftCardsRedeemed->execute();
			$gCardsRedeemed = $giftCardsRedeemed->fetch(PDO::FETCH_COLUMN);
			
			if($giftCardRow['giftCardImage']){
				$nameOrImage = '<img src="./images/giftcardrewards/'.$giftCardRow['giftCardImage'].'" alt="'.$giftCardRow['giftCardName'].'" title="'.$giftCardRow['giftCardName'].'">';
			}else{
				$nameOrImage = $giftCardRow['giftCardName'];
			}
			
			if($gCardsAvailable == '0'){
				$redeemAction = 'Out of Stock';
			}
			elseif($userInfo['currentPoints'] < $giftCardRow['pointsPrice']){
				$needed = $giftCardRow['pointsPrice'] - $userInfo['currentPoints'];
				$redeemAction = 'You need '.$needed.' point(s)';
			}
			elseif($userInfo['currentPoints'] >= $giftCardRow['pointsPrice']){
				$redeemAction = '<input type="button" value="Redeem" onclick="if(confirm(\'Are you sure to redeem this prize?\')){location.href=\'index.php?do=instantGiftCards&action=redeem&cardId='.$giftCardRow['id'].'&amount='.$giftCardRow['amount'].'\';}">';
			}
			
			print"
	<tr>
		<td>".$nameOrImage."</td>
		<td style=\"text-align:center\">".$giftCardRow['currency'].$giftCardRow['amount']."</td>
		<td style=\"text-align:center\">".$giftCardRow['pointsPrice']."</td>
		<td style=\"text-align:center\">".$gCardsAvailable."</td>
		<td style=\"text-align:center\">".$gCardsRedeemed."</td>
		<td style=\"text-align:center\">".$redeemAction."</td>
	</tr>";
		
		}
		
	}else{
		
		print"
	<tr>
		<td colspan=\"4\" style=\"text-align:center;color:#2B1B17;padding:15px 0\">No prizes added.</td>
	</tr>";
		
	}
	
print"
</table>";
	
?>

Display Images From Different Sub-folders Located In One Folder

 Similar Tutorials View Content

Unable To Display My Images

 Similar Tutorials View Content
Hi all,

Newbie here, i am having a problem to get my images to show which are stored in mysql database as a mediumblob. I get id number to print in table ut am just getting empty square with red cross in where my image should be. Is my code incorrect or is it something else?
Appreciate your help with this.
I have included both of the pages codes i am using.

Thanks
Tony

image2.php

<?php
include("common.php");
error_reporting(E_ALL);
$link = mysql_connect(host,username,password) or die("Could not connect: " . mysql_error());
mysql_select_db(db) or die(mysql_error());
$sql = "SELECT id FROM photos";
$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
?>
<table border="1"><tr><td>id</td><td>image</td></tr>
<?php
while($row=mysql_fetch_assoc($result)){
print '<tr><td>'.$row['id'].'</td><td>';
print '<img src="image1.php?id='.$row['id'].'height="75" width="100"">';
}
echo '</td></tr></table>'
?>

image1.php

<?php
ob_start();
include("common.php");    
   mysql_connect(host,username,password) or die(mysql_error());
   mysql_select_db(db) or die(mysql_error()); 

$query = mysql_query("SELECT imgage FROM photos WHERE id={$_GET['image_id']}";
$row = mysql_fetch_array($query);
$content = $row['image']; 
header('Content-type: image/jpg');
     echo $content;
 }
 ob_end_flush();
?>




Unable To Display Single Row

 Similar Tutorials View Content
==> MySQL version    5.0.91-community

So once upon a time I was working on a CMS.
I worked on it for 3 months, had to wipe my computer - but didn't worry about it because I backed up the files on a flash drive... which got smushed by some boxes when I moved <.< awesome -.-
Anyway, a year later (ie: today), I've decided to start again from scratch.

For me - for whatever reason - the simplest things always seem to give me the most trouble.

I decided to start with a "user" table - naturally - and began working on the first page: user_view.php and added an include file that connects to the database (connectDB.php). Since I started today, everything is simple - no design elements yet - just good 'ol code.

The View Users Page is simply a page that grabs all the rows from Table: users and prints the information to the screen, as if you were viewing a Members page on a forum.  This Page works fine. No complaints, does everything I need it to, prints all the rows and cols from Table Users.

Then I created the Edit User Page. When I did this a year ago, and I wanted to print out all the data from the table, I used the while loop. When I wanted to only grab certain variables from a table, I just created a new set of variables, as show below. Using the same method from a year ago, I started working on printing various data to the screen (such as "Welcome $username"). 5 minutes of typing... refresh page... nada.
So I stripped away just about every tag but the essentials and it still wouldn't work

Code: [Select]
<?php
...
$userID = 3;
$sql = "SELECT * FROM users WHERE userID='$userID'";
$result = mysql_query($sql);
$rows = mysql_fetch_row($result);

echo $rows['username'];
...
?>
Normally, this would just grab the username from a row in Table users where the userID = 3
But instead - it does nothing. I just see a blank page. It's a simple 5 lines of code and it's like "im just gonna do w.e the fk i wanna do mmmk thxforplaying"

 

PS: Keep in mind there is nothing wrong with the connection to the database, and as already stated I'm able to print ALL values from the Users Table using this same method: Code: [Select]
<?php
...
$user_sql = "SELECT * FROM users ORDER BY username ASC";
$user_result = mysql_query($user_sql);
while ( $user_rows = mysql_fetch_array($user_result) )
...
?>





Unable To Display Textbox Contents

 Similar Tutorials View Content
I am doing simple program to display text entered by user..

Following is my code but its display 'error msg' instate of txtbox contents

<html>
<head><title>Date</title></head>
<body>
<form action="" enctype="multipart/form-data">
Enter Date:
<input type="text" name="txtdate"/>
<input type="submit" value="Display"/>
</form>
</body>
</html>

<?php
if(isset($_POST['txtdate']))
{
   $display =$_POST['txtdate'];
echo 'You have entered'.$display;
}
else
{
echo 'Error msg';
}
?>





Help !! My Database Detail Unable To Display

 Similar Tutorials View Content
This is my code is display my database (member_details) after user sign up but when a user register first name = <script>window.location="google.com"</script>  This error occur=(The requested URL /yy2/html/google.com was not found on this server)

Code: [Select]
<?php
  session_start();
  include ('includes/database_connection.inc.php');
$conn = connectDatabase();

  if($_SESSION['uid'] == ''){
    // redirect unauthenticate user to login page.
  header('Location: login.php');
  }

  if($_GET['task'] == 'delete' && $_GET['id'] != ''){
      // delete function here
     $sql="DELETE FROM Newest Where ID='".mysql_real_escape_string($_GET['id'])."'";
     
     mysql_query($sql,$conn);
     header('Location: member_list.php');
  }

  if($_POST['Logout']){
     session_destroy();
   header('Location: login.php');
}

?>

<html><head><title>Member Details</title>
</head>
<body>
<div style=" margin: 350px ">
<?php 


      $sql="SELECT * FROM Newest";
      $rs = mysql_query($sql,$conn)
        or die( mysql_error() );

   
   $list = "<table border=\"1\" cellpadding= \"2\">";
   $list .= "<tr><th>First Name</th>";
   $list .="<th>Last Name</th>";
   $list .= "<th>User Name</th>";
   $list .= "<th>Email</th>";
   $list .= "<th>Edit User</th>";
   $list .= "<th>Delete User</th>";
    $list .= "<th>Change Password</th>";
   

While( $row = mysql_fetch_array($rs) ) {
   
    $list .= "<tr>";
    $list .= "<td>".$row["name"]."</td>";
     $list .= "<td>".$row["last"]."</td>";
    $list .= "<td>".$row["user"]."</td>";
    $list .= "<td>".$row["email"]."</td>";
    $list .= "<td><a href='member_details.php?id=".$row['ID']."'>Edit</a></td>";
    $list .= "<td><a onclick='return confirm(\"Are you sure to delete ".$row["name"]." \")' href='member_list.php?id=".$row["ID"]."&task=delete'>Delete</a></td>";
     $list .= "<td><a  href='Password.php?id=".$row['ID']."'>Click Here</a></td>
     </tr>";
   
} 
   $list .= "</table>";
   echo ( $list );
   
?>
   <form method="post" action="member_list.php"><br>
   <div style="margin : 0px 600px">
   <style type="text/css">
body {background:#F5F5F5 url('http://images.apple.com/downloads/dashboard/travel/images/traveltodolist_20070724165034.jpg') no-repeat top;;
     
       }</style>
   
         
         <input type="submit" name="Logout" value="logout" />
         
      </form>
</body>
</html>

MOD EDIT: [code] . . . [/code] BBCode tags added.


Unable To Display Image On Web Page

 Similar Tutorials View Content
Hi,
I am a newbie to this forum and php as well.  I have a script which inserts data and image file into mysql database.  Now I want to display this image on web  page but unable to do it.  I tried a lot but couldn't find out any solution.  I would appreciate your help.
<?php

$con = mysql_connect("localhost", "root", "xx");
if(!$con)
{
 die('Could not connect:' .mysql_error());
}
mysql_select_db("yyy",$con);

$memberid = '$_POST[memberid]';
$fname = '$_POST[fname]';
$lname = '$_POST[lname]';
$gender= '$_POST[gender]';
$add1 = '$_POST[add1]';
$add2 = '$_POST[add2]';
$city = '$_POST[city]';
$state = '$_POST[state]';
$zip = '$_POST[zip]';
$country = '$_POST[country]';

$photo1 = '$_FILES[image][name]';
echo "$photo1";

//if ($memberid= $_GET['memberid']){
$query="select memberid,fname,lname,gender,add1,add2,city,state,zip,country,photo1 from vadhuvar_member where memberid =(select max(memberid)from vadhuvar_member)";

$result=mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_assoc($result))
{
$memberid = $row['memberid'];
$fname = $row['fname'];
$lname = $row['lname'];
$gender = $row['gender'];
$add1 = $row['add1'];
$add2 = $row['add2'];
$city = $row['city'];
$state = $row['state'];
$zip = $row['zip'];
$country = $row['country'];
//$photo1=chunk_split(base64_encode($photo1));
$photo1 = $row['photo1'];

//echo base64_encode($photo1);


echo "Name:$fname $lname<br>";
//echo "Name:$_POST[fname]$_POST[lname]<br>";
echo "Gender:$gender<br>";
echo "Address:$add1 $add2<br>";
echo "$city $state $zip<br>";
echo "$country<br>";
//echo "<img src=".upload/$photo1 ." alt="" width="200" height="300" /><br />";


    }
//}
?>


<!--img src="<?php echo '.upload/$_FILES[image][name]?memberid=$row[memberid]'?>"alt="" width="200" height="300"/-->;
<?php echo "<img src=". upload/$row[photo1]" alt="" width="200" height="300">";?>
<!--img src="<?php echo ".\upload\$photo1" ?>" alt=""  width="200" height="300"/-->;

<? set_magic_quotes_runtime(1); // turn back on ?>
Thanks
Smita


Display Ads After Every 4 Items

 Similar Tutorials View Content
Guys,
i want to display ads after 4 items to be displayed.

Iam fetching item using mysql database & iam showing 8 items per page.

I used below code but its not working because i used the item id to specify the first number but the items is not listed as correct order

Code: [Select]
<?php
// first number
$first = $row['id'];
// second number
$second = 4;

//checking if the first number is muliple of second. If true then display ads.
If($first % $second == "0") {
echo 'ads to display';
}

It will work if i list items in correct order. Please let me know correct solution.
Thanks in advance !


Moved: Unable To Display Running Time On Webpage

 Similar Tutorials View Content
This topic has been moved to JavaScript Help.

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


Display Text If One Of These Items Is Present

 Similar Tutorials View Content

Hi,

I have the following code in a WordPress theme which displays a companies website, Twitter and Facebook links.

What I am trying to do is display the text "Useful Links:" if one of the links exists, and hide the text if all are not present. 

<p>Useful Links:</p>
<?php if ( $website = get_the_company_website() ) : ?>

                            <a class="company-website" href="<?php echo esc_url( $website ); ?>" itemprop="url" target="_blank" rel="nofollow"><?php _e('Website', 'jobseek'); ?></a>

                        <?php endif; ?>

                        <?php if ( get_the_company_twitter() ) : ?>

                            <a class="company-twitter" href="http://twitter.com/<?php echo get_the_company_twitter(); ?>"  target="_blank"><?php _e('Twitter', 'jobseek'); ?></a>

                        <?php endif; ?>

                        <?php
                        $facebook_link = get_post_meta( get_the_ID(), '_facebook_link', true );
                        if ( ! empty($facebook_link) ) : ?>
                            <a class="company-facebook" href="<?php echo $facebook_link; ?>"  target="_blank">Facebook</a>
   <?php endif; ?>

What would be the best way to show/hide the text depending on if the items are present or not?

Thanks


Unable To Display Output Properly Using Php "echo" And Html Tags

 Similar Tutorials View Content
hi there, the code below is suppose to display something like the attachement "code2" but instead it displays something like attachement "code1" please assist in find what is wrong with my echo lines. 
<?php 
                        $counter = 2;
			$sqlq="select * from state WHERE status = 0 ";
			$categorysqlq = mysql_query($sqlq);
			$varq = mysql_num_rows($categorysqlq);

			while($catfetchq = mysql_fetch_array($categorysqlq))
			{
 $cnty =  $catfetchq[0];

		 $sqllq="select * from vehicle WHERE country = '$cnty' ";
			$categorysqllq = mysql_query($sqllq);
		
			
			$numsql = "select * from branchaddr WHERE state = '$cnty' ";
			$numquery = mysql_query($numsql);
$varqa = mysql_num_rows($numquery);
$cntyfetchq= mysql_fetch_array($numquery);	
if($varq != 0){
					if($counter == 2){
                                            	echo "<tr><td><a href=\"transport2.php?id=".$cntyfetchq['state'].">".$catfetchq[1]."(<span style=\"color:red\">".$varqa."</span>)</a></td>";                                                                              
						$counter--;
					}
					else{						
						echo "<td><a href=\"transport2.php?id=".$cntyfetchq['state'].">".$catfetchq[1]."(<span style=\"color:red\">".$varqa."</span>)</a></td></tr>";                                          
						$counter = 2;
					}
				}
			}	
?>
Attached Files  code1.png   12.65KB   0 downloads  code2.png   25.34KB   0 downloads

Unable To Print Distinct Dates And Display In A Specific Format..

 Similar Tutorials View Content
Hi I have been trying to populate my data from 3 tables and display like this:

                  DATE             $acronym1                        $acronym2
POSTS   1/9/2011          10 (this is no of posts)                  3
POSTS   31/8/2011         20                                                10
and so on. the threads and user table will be similar as well.
 I am not able to populate the distinct dates since the dateline contains time as well. So when I try to print out the just dates(without time) , it prints  with the dates repeated. it prints something like this:
1/9/2011 1
1/9/2011 1
and so on..
How can populate and print the the date and number of posts in the above format. Here is my complete code below:


Code: [Select]
<?php
error_reporting(-1);
//ini_set('display_errors',1);
include("db.php");
//$thirty_days_ago = strtotime("-30 days");
$limit = strtotime("-1 month");
$sql=mysql_query(("SELECT * from new_site"),$con) or die(mysql_error());
while($row=mysql_fetch_assoc($sql))
{
   $include=$row['include'];
   $forumurl=$row['forumurl'];
   $url=$row['url'];
   $acronym=$row['acronym'];
   include("$include");
   //echo $include."<br>";
   $configdbname=$config['Database']['dbname'];
   $configdbconport=$config['MasterServer']['servername'].":".$config['MasterServer']['port'];
   $configusername=$config['MasterServer']['username'];
   $configpassword=$config['MasterServer']['password'];
   $configprefix=$config['Database']['tableprefix'];
   /* Connect to the required database */
   $con2=mysql_connect($configdbconport, $configusername, $configpassword);
   if (!$con2)
   {
       die('Could not connect: ' . mysql_error());
   }
   mysql_select_db($configdbname, $con2);
   $postdate=mysql_query("SELECT DISTINCT dateline,postid from post WHERE dateline >='$limit' ORDER by dateline DESC") or die(mysql_error());
   while($postdate_results=mysql_fetch_assoc($postdate))
   {
      $postdate_record=$postdate_results['dateline'];
     // echo $postdate."<br>";
      $postdate_formatted=date('M dS  Y ',$postdate_results['dateline']);
      $post_count=mysql_query("SELECT * from post WHERE dateline >='$postdate_record'");
      while($post_count_results=mysql_fetch_assoc($post_count))
      {
         //$postdate_formatted=date('M dS  Y ',$post_dateline_results['dateline']);
         $posts=mysql_num_rows($post_count) or die(mysql_error());
         //echo $acronym.":POSTS:".$posts."<br>";
         echo '<table border="1">';
         echo "<tr>";
         echo "<th>Category</th>";
         echo "<th>".$acronym."</th>";
         echo "</tr>";
         echo "<tr>";
         echo "<td>POSTS:DATE:".$postdate_formatted."</td>";
         echo "<td>".$posts."</td>";
   echo "</tr>";
      }
     
   $threaddate=mysql_query("SELECT * from thread WHERE dateline >='$limit' ORDER by dateline DESC") or die(mysql_error());
   while($threaddate_results=mysql_fetch_assoc($threaddate))
   {
      $threaddate_record=$threaddate_results['dateline'];
            $threaddate_formatted=date('M dS  Y ',$threaddate_results['dateline']);
            $thread_count=mysql_query("SELECT * from thread WHERE dateline='$threaddate_record'");
           while($thread_count_results=mysql_fetch_assoc($thread_count))
           {
              $threads=mysql_num_rows($thread_count) or die(mysql_error());
             //echo $acronym.":THREADS:".$threads."<br>";
             echo "<tr>";
             echo "<td>THREADS:DATE:".$threaddate_formatted."</td>";
             echo "<td>".$threads."</td>";
             echo "</tr>";
             $userdate=mysql_query("SELECT * from user WHERE joindate >='$limit' ORDER by joindate DESC") or die(mysql_error());
             while($userdate_results=mysql_fetch_assoc($userdate))
    {
        $userdate_record=$userdate_results['joindate'];
        $userdate_formatted=date('M dS  Y ',$userdate_results['joindate']);
                 $user_count=mysql_query("SELECT * from user WHERE joindate='$userdate_record'");
                 while($user_count_results=mysql_fetch_assoc($user_count))
                 {
                    $users=mysql_num_rows($user_count) or die(mysql_error());
                  //echo $acronym.":USERS REGISTERED:".$users."<br>";
                    echo "<tr>";
                    echo "<td>REGISTERED USERS::DATE:".$userdate_formatted."</td>";
                    echo "<td>".$users."</td>";
                   echo "</tr>";
       }
              }

            }
         }
  
       }
     }

echo "</table>";
?>


Unable To Create Temp Table In Proc.

 Similar Tutorials View Content
Have any of you ever run into this one. Can't quite figure this one out.   Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE cUserID INT;  DECLARE done INT DEFAULT FALSE;  DECLARE CUR1 CURSOR FOR  ' at line 9  

Unable To Input Value Into Database Table Using Php Code

 Similar Tutorials View Content
Hi,

I need some help here, the one which I have highlighted in red, 'dob' and 'gender', are not inputting any values into my database table. I'm just wondering did I miss out something important, or should I change the 'type' in my database table? Thanks



<?php

$dob = $_POST['dob'];
$gender = $_POST['gender'];

/**INSERT into tutor_profile table**/
   $query2 = "INSERT INTO tutor_profile (name, nric, dob, gender, race) VALUES ('$name', '$nric', '$dob', '$gender', '$race')";
   
   $results2 = mysqli_query($dbc, $query2)
   or die(mysqli_error());

?>

<html>
<div>
         <label for="dob" class="label">Date Of Birth</label>
         <input name="dob" type="text" id="dob"/>
      </div>
</html>

<!--Race-->
      <div>
         <label for="race" class="label">Race</label>
      
         <?php
         echo '<select name="race" id="race">
         <option value="">--Please select one--</option>';
   
         $dbc = mysqli_connect('localhost', '111', '111', '111')
         or die(mysqli_error());
         $query = ("SELECT * FROM race ORDER BY race_id ASC");
         $sql = mysqli_query($dbc, $query)
         or die(mysqli_error());
      
            while($data = mysqli_fetch_array($sql)) {
               echo'<option value="'.$data['race_id'].'">'.$data['race_name'].'</option>';
            }
         echo '</select><br/>';
   
         mysqli_close($dbc);    ?>
      
      </div>


Unable To Insert Into Table Value From Dropdown List

 Similar Tutorials View Content
Hello everyone !!!

I am sorry if my vocabulary is not exact because english is not my first language. Also i am a newbie at PHP. I am doing this project for myself and if it work might be able to use it at work. But i am doing this to learn. I have been stuck on this problem for 2 weeks and i can t figure it out on my own. Ihave spend many hours searching forums but no success. Oh yeah i almost forgot some part of code are from me, some are scripts from internet i adapted.

I have a form with a dropdown menu and when i submit the form the value selected in the dropdown would be inserted in a table. The problem i have is that whatever the value i select it always inserts the last value of the dropdown in the table???

The form is made with the dropdown as an include. It is populated with values from an another table.
Here is the code for the dropdown list:
Code: [Select]
<form>
   <select name="nom_pcu_form" method="post">
<?php
$SQL = "SELECT * FROM pcu ORDER BY nom_pcu";
$res = mysql_query($SQL);
while($val=mysql_fetch_array($res)) 
{
$nom=$val["nom_pcu"];
$prenom=$val["prenom_pcu"];
$nom_complet = $prenom . $nom;
echo "<option>".$val["nom_pcu"].", ".$val["prenom_pcu"]."</option>\n";

$nom_pcu_form="".$val["nom_pcu"].", ".$val["prenom_pcu"].""; 
}
?>
</select>
</form>

Here is the part of the form wich calls the dropdown:

Code: [Select]
<form name="form2" method="post" action="Grille ecoute Permanent.php">
             
                <p>Nom :
                 <?php include 'liste_deroulante_pcu.php' ;?>
<p>no carte appel
                <input name="no_carte_appel" type="text" id="no_carte_appel">
                </p>
<?php  echo date("Y/m/d"); ?>

</form>

And this is the part where it is inserted in the table:

Code: [Select]
<?php
  if($_POST['doSubmit'] == 'Create')


  
  
  
mysql_query("INSERT INTO grille_ecoute_pcu_permanent (`user_name`,`nom_pcu`,`no_carte_appel`,`question_1`,`question_2`,`question_3`,`question_4`,
`question_5`,`question_6`,`question_7`,`question_8`,`question_9`,`question_10`,`question_11`,`question_12`,`question_13`,`question_14`,`question_15`,
`question_16`,`question_17`,`question_18`,`question_19`,`question_20`,`question_21`,`question_22`,`question_23`,`question_24`,`question_25`,`question_26`,
`question_27`,`question_28`,`question_29`)
 VALUES ('$user_name','$nom_pcu_form','$no_carte_appel','$question_1','$question_2','$question_3','$question_4','$question_5','$question_6',
 '$question_7','$question_8','$question_9','$question_10','$question_11','$question_12','$question_13','$question_14','$question_15','$question_16','$question_17',
 '$question_18','$question_19','$question_20','$question_21','$question_22','$question_23','$question_24','$question_25','$question_26','$question_27','$question_28',
 '$question_29')
 ") or die(mysql_error()); 
Note:$user_name and all $question are inserted correctly in the table.
$nom_pcu_form is the dropdown and it only records the last value of the dropdown even if it s not the value selected.
$no_carte_appel are not recorded at all

thanks for your time




Moved: Wordpress Guru? I Need To Know Where This Sql Is Located.

 Similar Tutorials View Content
This topic has been moved to PHP Applications.

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


Timeout Data Located In Cookie Files

 Similar Tutorials View Content

can anyone tell me how to modify a timeout for a web app when logged in? Here are the known specs:

=> there is no session hash in the URL when logging in.
=> default timeout for no transacting activity is 5 minutes.

I really have no way to know if the timeout is located in the local cookie or stored in the web app [session] itself. It's a large PHP application that I'm referring to.  and before anyone asks, no it's not a hacking attempt.  This is simply an attempt by me to stop this little annoyance.  I realize that a lot of people do this sort of thing for security reasons.  Also, every transaction on the website (moving from page to page, clicking buttons) results in more than one file with a hash-based name being put in firefox's cache.

Thanks.

Adam


Trying To Require A File In A Laterally Located Directory Using Relative Paths

 Similar Tutorials View Content
I was under the impression this was a simple thing to do and I'm fairly certain I've done it before, but it isn't working for some reason.

Under the root directory of my project I have two subfolders called "inc" and "lib". lib contains third-party scripts for use in my project. The one in question is phpmailer (lib/class.phpmailer.php). Now, in inc I have a file that needs to include PHPMailer.

Inside my script in inc I have this:
require_once('../lib/class.phpmailer.php');

It errors out saying it can't find it. I thought that was supposed to go down one directory then back up into lib. The file does indeed exist.

What am I doing wrong? This seems like a stupidly simple thing...


How To Display 20 Single Column Ul(un-ordered List) Values Into Row Wise. Single Row 4 Items And 5 Columns

 Similar Tutorials View Content

PHP script return 20 UL LIST values like,

< ul >

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T

< /ul >

How to display UL LIST into row wise 5 columns like

A B C D
E F G H
I J K L
M N O P
Q R S T (20 ITEMS)

Edited December 7, 2019 by aveeva

Need A Php Code To Delete Selected Items Of Database Items Using Checkbox

 Similar Tutorials View Content
I have a webpage where all the database items are displyes in a table format.The table also has a check box.Upon clicking the delete button i need to delete all the items whish has the checkbox checked.
How will i do that
Privacy