PHP - Divs Displayed Around A Circle?

so I am a beginner and have this very beginner-level PHP doubt.

I have some basic code which is supposed to fetch the contents of a table and then display them in a table. What it's actually showing is the PHP code itself, instead of the table contents, in the browser. I'm using WAMP
When I searched the net reasons given were 1. using short tags, and 2. some configuration problem.

I haven't used short tags, and my wamp installation was done a long time back. Moreover this problem is not occuring all the time, even when I run the same code.

Many thanks if anyone can suggest anything helpful. Sorry if I posted in the wrong place (new here).

I'm teaching myself how to use php and mysql...

I created a form to insert data into a mysql database, all went well and when I returned to the form it was blank.

I then asked a friend to test it out aswell and when he loaded the form page, the data that entered before him was displayed? (it was still filled out with my info). Even after he refreshed it was still there...

Hows this possible? How would I clear the form after its been submitted if it doesnt do it automatically?

Thanks
Drew

I want to output the data and also the buttons in my php codes. But i do not know why the buttons does not output as coded. Can anyone let me know where did my codes go wrong? I've been searching it but i cant't find the problem. Thanks in advance.

<?php
   if(isset($_POST['invoice_details'])) {
          $discountsql = "INSERT INTO `invoice_price` (`order_id`) VALUES ('.$order_id.') ";
          $conn->query($discountsql);
        }
        ?>
         <?php
          $sql2 = " SELECT order_id FROM ordered_items GROUP BY order_id WHERE order_id = '".$row[order_id]."'  ";
                      $query2 = $conn -> query($sql2);
                      while ($row2 = $query2 -> fetch_assoc()) {
        
        ?>
        
    <div class="col-12 form-group">
         <p> <?php echo $row2['order_id']; ?></p>
        <p class="text-success"  pointer-events="none" style="font-weight: bold; font-size: 25px; text-align:center;  ">Your order is confirmed !</p>
      <a href="order-list.php">
        <input class="btn btn-block checkoutbtn" type="button" name="invoice_details"  value="Go to Order Page">
      </a>
    </div>
     <?php
                      }
        
        ?>

 

I have a very simple page, where I use the include statement that includes my connection string.  The connection string and a variables are not being passed to my test server - (WAMP).  My include file is below

$server = "servername";
$username = "username";
$password = "";
$database = "dbname";
$portNumber = 3308;

$link = mysqli_connect($server,$username,$password,$database,$portNumber); 

if(!$link)
{
    echo "cannot connet to the server";
}

else
{
	echo "This works";
}


echo "Hi";

 I am including this file with the following code:

 

include ("includes/connect.inc");

 

My site is not connecting to the database, and is not displaying "This works", or "Hi".   Do you have any pointers on how to get this connect?

 

Hi all,

I want to get the current page name as displayed in the URL, not neccesarily the name of the PHP script that is running.

E.g. I have a PHP file 'home.php' that contains iframes that contain other PHP files such as 'frame1.php'. What I want is a script that can be run from frame1.php but that will return 'home.php' as the current page (as displayed in the URL in the browser).

How do I do this?

Thanks!

Is there a way to have the values that are DISPLAYED by a FORM
actually result in another set of VALUES actually being returned?

For example, having arbitrary values displayed to the user to
generate another set of values?

Thanks!

when I test this script on browser.  This is all that I see.

invalid username or password


Code: [Select]
<?php

//start session
session_start();

include 'functions.php';

if (loggedin())
{
header("Location: userarea.php");
exit();

}
if ($_POST['login'])
{
//get data

$username = $_POST['username'];
$password = $_POST['password'];
$rememberme = $_POST['rememberme'];
}

if (username&&$password)
{

$login = mysql_query("SELECT * FROM users WHERE username='$username'");
while ($row = mysql_fetch_assoc($login))
{
$db_password = $row['password'];
if (md5($password)==$db_password)
$loginok =TRUE;
else
$loginok = FALSE;

if ($loginok ==TRUE);
{

if($rememberme=="on")
setcookie("username",$username, time()+7200);
else if ($rememberme=="")
$_SESSION['username']=$username;

header("Location: userarea.php");
exit();
}

}
}
else
{
die("invalid username or password");
}

?>

<form action="login.php" method="POST">
username:<br />
<input type="text" name="username" /><br />
password:<br />
<input type="password" name="password" /><br />
<input type="checkbox" name="rememberme">remember me<br />
<input type="submit" name="login" value="Log in" />
</form>

Hey All,

As of this morning our gallery has started to show the incorrect dates. Please go to: http://www.nightlifeguestlist.com/c...n/74/Carbon.htm you will see the first date is Fri, 29 October 10 this should be Sat, 30 October 10.

In the database the date is in putted as 2010-10-30.

The dates from Fri, 29 October 10 to Fri, 2 April 10 are all incorrect. These happen to be all BST times. While the dates for GMT are OK. The clocks here in the UK are now GMT and not BST. Has this anything to do with it?

The code used is as follows:

<?
$location = false;
if(isset($_GET['l'])){
    $location = $_GET['l'];
}
$venue = false;
if(isset($_GET['v'])){
    $venue = $_GET['v'];
}
$event = false;
if(isset($_GET['e'])){
    $event = $_GET['e'];
}
$page = 0;
if(isset($_GET['p'])){
    $page = $_GET['p'];
    $page--;
}
$query_events = "";

if(!$location){
    $query_events = "SELECT ec_venues.location FROM ec_venues GROUP BY ec_venues.location";
} else if($location && !$venue && !$event){
    $query_events = "SELECT ec_venues.venue_name, UNIX_TIMESTAMP(ec_events.event_date) AS event_date, ec_venues.venue_id, ec_events.event_id,ec_venues.location FROM ec_events INNER JOIN ec_venues ON ec_events.venue_id = ec_venues.venue_id WHERE ec_events.event_date IS NOT NULL  AND ec_venues.location='".$location."' ORDER BY UNIX_TIMESTAMP(ec_events.event_date) DESC LIMIT 0,1";
} else if($venue && !$event){
    $query_events = "SELECT UNIX_TIMESTAMP(ec_events.event_date) AS event_date, ec_venues.venue_name, ec_venues.venue_id, ec_events.event_id, ec_events.event_name,ec_venues.location FROM ec_events INNER JOIN ec_venues ON ec_events.venue_id = ec_venues.venue_id WHERE ec_venues.venue_id=".$venue." ORDER BY UNIX_TIMESTAMP(ec_events.event_date) DESC";
} else if($venue && $event){
    $query_events = "SELECT ec_venues.venue_name, ec_events.event_name, UNIX_TIMESTAMP(ec_events.event_date) AS event_date, ec_events.image_folder, ec_venues.images_per_page,ec_venues.location FROM ec_events INNER JOIN ec_venues ON ec_events.venue_id = ec_venues.venue_id WHERE ec_events.event_id=".$event." AND ec_venues.venue_id=".$venue."";
}
mysql_select_db($database_nightlife2 , $nightlife2 );
//    $query_events = "SELECT ec_venues.venue_name, ec_events.event_name, UNIX_TIMESTAMP(ec_events.event_date) AS event_date, ec_events.image_folder, ec_venues.images_per_page FROM ec_events INNER JOIN ec_venues ON ec_events.venue_id = ec_venues.venue_id WHERE ec_events.event_id=".$event." AND ec_venues.venue_id=".$venue."";
//echo $query_events;
$events = mysql_query($query_events, $nightlife2 ) or die(mysql_error());
$row_events = mysql_fetch_assoc($events);
$totalRows_events = mysql_num_rows($events);
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title><?=(!$location?"Elite Parties Photos":"Nightlife Guestlist @ ".$location." Club - ".$row_events['venue_name'])?></title>
<link href="http://www.nightlifeguestlist.com/wp-content/themes/NLGL/style.css" rel="stylesheet" type="text/css" />

<!--[if IE 6]>
<link rel="stylesheet" type="text/css" href="http://www.nightlifeguestlist.com/wp-content/themes/NLGL/IE-6.css" />
<![endif]-->
<!--[if IE]>
<link rel="stylesheet" type="text/css" href="http://www.nightlifeguestlist.com/wp-content/themes/NLGL/IE-8.css" />
<![endif]-->
<? if($_SERVER['HTTP_HOST']=="elite"){?>
<BASE HREF="http://elite/">
<? } else { ?>
<BASE HREF="http://www.nightlifeguestlist.com/">
<? } ?>

<SCRIPT language="JavaScript" src="/mircoFinestra.js"></script>

<script src="/AC_RunActiveContent.js" type="text/javascript"></script> 


</style>
</head>

<body>

<div class="wrapper">

<div id="head">
<div id="header">





</div>
<!-- nav -->        
<div id="nav">
<div id="nav-area">
<ul>
<li class='page_item current_page_item'><a href='http://www.nightlifeguestlist.com' title='Home'>Home</a></li><li class="page_item page-item-3"><a href="http://www.nightlifeguestlist.com/guest-lists" title="Guest Lists">Guest Lists</a></li>
<li class="page_item page-item-5"><a href="http://www.nightlifeguestlist.com/photogallery.php" title="Photo Gallery">Photo Gallery</a></li>
<li class="page_item page-item-7"><a href="http://www.nightlifeguestlist.com/video-gallery" title="Video Gallery">Video Gallery</a></li>
<li class="page_item page-item-9"><a href="http://www.nightlifeguestlist.com/jobs" title="Jobs">Jobs</a></li>
<li class="page_item page-item-11"><a href="http://www.nightlifeguestlist.com/membership" title="Mailing List">Mailing List</a></li>
<li class="page_item page-item-16"><a href="http://www.nightlifeguestlist.com/tables" title="Tables">Tables</a></li>

<li class="page_item page-item-13"><a href="http://www.nightlifeguestlist.com/event-management" title="Event Management">Event Management</a></li>
<li class="page_item page-item-538"><a href="http://www.nightlifeguestlist.com/blog" title="Blog">Gossip Blog</a></li>


        
</ul>
</div>
</div>
<!-- end nav -->


<div class="clear"></div> 
</div>

<!--/head -->
    
    <div class="narrowcolumn">


        
            <div class="entry">
              <div id="content-area">

              <!-- 1 -->
              <div id="section">
              
<? if($venue && !$event){ ?><?php
$pCount = 0;
$myNum = sprintf("%02d",$venue);
echo "<img  src='interiors/" . $myNum . "_logo.gif' vspace='2' hspace='2'>\n";
if ($handle = opendir('interiors')) {
   while (false !== ($file = readdir($handle))) {
       if (substr($file,0,6) == $myNum . "_pic") {
           echo '<img  src="interiors/' . $file . '" vspace="2" hspace="2">';
           if($pCount++ % 2 == 1) echo "";
       }
   }
   closedir($handle);
}
?>

<? } ?>

<? if(!$location){?>

              
              <!-- 2 -->
              <div id="section">
<?
do{
    $query_latest = "SELECT ec_venues.venue_name, UNIX_TIMESTAMP(ec_events.event_date) AS event_date, ec_venues.venue_id, ec_events.event_id FROM ec_events INNER JOIN ec_venues ON ec_events.venue_id = ec_venues.venue_id WHERE ((ec_events.event_date) IS NOT NULL) AND ec_venues.location='".$row_events['location']."' ORDER BY UNIX_TIMESTAMP(ec_events.event_date) DESC LIMIT 0,1";
    $latest = mysql_query($query_latest, $nightlife2 ) or die(mysql_error());
    $row_latest = mysql_fetch_assoc($latest);
    $totalRows_latest = mysql_num_rows($latest);
?>
 <a href="club_dates/<?=$row_events['location']?>/<?=$row_latest['venue_id']?>/<?=$row_latest['event_id']?>/<?=str_replace(" ","_",$row_latest['venue_name'])?>_page1.htm    "><?=$row_events['location']?> - <?php echo date("l jS F",$row_latest['event_date']); ?> @ <?php echo $row_latest['venue_name']; ?></a><br>
          <?
    } while ($row_events = mysql_fetch_assoc($events));
    mysql_free_result($latest);
?>    
              </div>
              <!-- 3 -->
              <div id="section">
              <? } else if(!$venue){ ?>
              </div>
              
               <!-- 4 -->
              <div id="section">
            Our most recent event was <strong><a style="color:#000000; font-weight:bold;" href="club_dates/<?=$row_events['location']?>/<?=$row_events['venue_id']?>/<?=$row_events['event_id']?>/<?=str_replace(" ","_",$row_events['venue_name'])?>_page1.htm    "><?php echo date("l jS F",$row_events['event_date']); ?> @ <?php echo $row_events['venue_name']; ?></a></strong>

      <? } else if($venue && !$event){?>
              </div>
              
              <!-- 5 -->
              <div id="section">
              <table width="100%" border="0" align="left" cellpadding="0" cellspacing="10">
                    <tr>
                      <td colspan="4"><? if($totalRows_events==0){ ?>
                        No photos are avaliable yet for this venue.
                        <? } else { ?>
                        Select a Date for <?php echo $row_events['venue_name']; ?>
                        <? } ?>                      </td>
                    </tr>
                    <? $count = 0; 
                         do { 
        
        if($count % 3 == 0){ echo '<tr>'; }
?>
                    <td width="713"><a style="color:#000000; font-weight:bold;" href="club_dates/<?=$location?>/<?=$venue?>/<?=$row_events['event_id']?>/<?=str_replace(" ","_",$row_events['venue_name'])?>_page1.htm"><? echo ($row_events['event_date']==""?$row_events['event_name']:date("D, j F y",$row_events['event_date'])); ?></a></td>
                      <?php 
        if($count % 3 == 2){ echo "</tr>"; }
        $count++;
        } while ($row_events = mysql_fetch_assoc($events));
        echo str_repeat("<td>&nbsp;</td>",4-($count % 4)); ?>
    </table>
              </div>
              
              <!-- 6 -->
              <div id="section">
              <? } else if($venue && $event){ ?>
              </div>
              
              <!-- 7 -->
              <div id="section">
              <table width="100%" border="0" align="left" cellpadding="0" cellspacing="0">
                      <tr>
                        <td><?
    if ($dir = @opendir("photos/".$row_events['image_folder'])){
        while (($file = readdir($dir)) !== false) {
            if(substr($file,0,4) == "page"){
                $dirlist[] = $file;
            }
        }
        sort ($dirlist); 
        reset ($dirlist); 
        closedir($dir);
    }
    if ($dir = @opendir("photos/".$row_events['image_folder']."/".$dirlist[$page])){
           while (false !== ($file = readdir($dir))) { 
            if(substr($file,-3)=="jpg"){
                $imglist[] = $file;
            }
           } 
        usort($imglist,"strnatcmp"); 
        reset ($imglist); 
        closedir($dir);
    }
$count = 0;
$paging = "";
if($page==0){ 
    $paging .= "<<&nbsp;";
} else $paging .= "<a href='/club_dates/".$location."/".$venue."/".$event."/".str_replace(" ","_",$row_events['venue_name'])."_page".($page).".htm' style='color:#000000; font-weight:bold;'><<</a>&nbsp;";
foreach($dirlist as $f){
       if($page!=$count){
        $paging .= "<a href='/club_dates/".$location."/".$venue."/".$event."/".str_replace(" ","_",$row_events['venue_name'])."_page".($count+1).".htm' style='color:#000000; font-weight:bold;'>".($count+1)."</a>&nbsp;";
    } else {
        $paging .=  ($count+1)."&nbsp;";
    }
    $count++;
}
if($page==count($dirlist)-1){ 
    $paging .= ">>&nbsp;";
} else $paging .= "<a href='/club_dates/".$location."/".$venue."/".$event."/".str_replace(" ","_",$row_events['venue_name'])."_page".($page+2).".htm' style='color:#000000; font-weight:bold;'>>></a>";
?></td>
                      </tr>
                      <tr>
                        <td><? echo "<table width='720'><tr><td>Nightlife Guestlist @ ".$row_events['venue_name'].($row_events['event_date']!="" ?" - ".date("l jS F Y", $row_events['event_date']) : "")." - ".$location."</td><td align='right'>".$paging."</td></tr></table>\n"; ?></td>
                      </tr>
                      <tr>
                        <td><?
    for($count=0;$count<count($imglist);$count++){
        echo "<a href='javascript:;'><img alt='".$imglist[$count]." @ ".$location." Club ".$row_events['venue_name'].", ".date("jS F Y", $row_events['event_date'])."' border='0' width='90px' height='60px' hspace='5px' vspace='5px' src='"."photos/".$row_events['image_folder']."/".$dirlist[$page]."/thumbs/".$imglist[$count]."' onclick='NewWindow(\"/popup.php?t=".count($imglist)."&n=".$count."&f=".$row_events['image_folder']."&p=".$dirlist[$page]."&title=".urlencode($location." Club ".$row_events['venue_name']." on ".date("jS F Y", $row_events['event_date']))."\",\"name\",\"600\",\"420\",\"no\");return false;'></a>\n";
        if($count % 7 == 6){ echo "<br>\n"; }
    } ?>
                            <? } ?></td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                      </tr>
                </table>
              </div>
              
              <div  id="section">
              <?
if(!$location){
?>
                      <?
} else {
    include("getClubLogos.php");
 }
 ?> 

(Sorry for the amount of code!)

I use the same code for another site on another server and it works fine.

I guess I need to alter the code somehow? The gallery works ok just the dates show are wrong. Any ideas on how to fix this?

The server settings/time seems are OK.

The line which prints the date is:<? echo ($row_events['event_date']==""?$row_events['event_name']:date ("D, j F y",  $row_events['event_date'])) ; ?>

When I echo the date echo date('c'); I receive 2010-10-29T23:00:00+00:00 for Fri, 29 October 10.

Thanks

I've spent the past 2 days googling and trying different methods that people have recommended other people try yet still I come up with the same problem.  I am new to coding and I am learning the basic functions so all feedback is welcome in aiding my learning endeavor.  I am using a form and all of the inputs are submitting to the database other than the text area which comes up blank.  I do not get an error when submitting the form I just get a blank value for the text area 'Comments'.   FORM   <form action="contactdb.php" method="post" form="contactdb"/>

Hi to everyone ,

I have used PHP for some basic things in my previous website design but am now venturing into another website for which I have a more complex use for PHP.

I plan on making business directory for my local area.  People will click on the area of their choice followed by the business type that they require.  Then on the results page, they will have a list of all the business types in that particular area.

What I would like to be able to do is rather than have the results displayed on the page like this :

A Plumber
xxxxx xxxxxx
Tel: xxxxx xxxxxx
Web: xxxxx xxxxxx
E-Mail: xxxxx xxxxxx

Best Plumber
xxxxx xxxxxx
Tel: xxxxx xxxxxx
Web: xxxxx xxxxxx
E-Mail: xxxxx xxxxxx

Top Plumber
xxxxx xxxxxx
Tel: xxxxx xxxxxx
Web: xxxxx xxxxxx
E-Mail: xxxxx xxxxxx


I would like it so that the same businesses are displayed on the page but either:

1) In a random order each time someone loads the page
or
2) In a random order changed every hour

The aim is so the businesses all have a shot at appearing nearer the top and aren't penalised for the 1st letter of their company name.

Any help on this would be much appreciated,

Thank You

I am working on a Contact Form in my .php file. I have always worked with loose doctypes, however, today I am using strict. I have my php above my html, and none of the code runs. Instead, it just displays some of the Echos to the page (these aren't even called yet). Also, in my form, I have the following:

<INPUT NAME="Name" SIZE="30" value="<?php echo $Name; ?>">

On the page inside the field, it is displaying: <?php echo $Name; ?>

What is going on here and how can I fix this issue?

Yes, the pages are .php
Here is the doctype:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

Any input appreciated

I have the code below:
---------------------------------------------------------------------- ------------------------------------
<div id="content">
    <table width="998" border="0" cellspacing="4" id="stuff">
        <?php do { ?>
          <tr>
            <td><?php echo $row_Recordset1['name']; ?></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
      <div id="spryTable" spry:region="ds1">
        <table align="center">
          <tr>
            <th spry:sort="name"> </th>
          </tr>
          <tr spry:repeat="ds1" spry:setrow="ds1" spry:hover="hover" spry:select="selected">
           <td height="40" align="center">{name}</td>  // green line
           <td height="40" align="center">{name}</td>  //orange line
          </tr>
          </table>
      </div>
---------------------------------------------------------------------- --------------------------------
At the moment the green line of code will display the entire record of names, and the orange line displays the entire record again in another column of the table.
The problem is, I want half the names to be printed in one column and the other half of names to be displayed in the other column.
Can someone show me how to set the php code to do this? I've been trying various things for a while now without success.
 
Thank you.

Hiya all,

 I'm currently trying to develop my own website / forum for a gaming guild. This is the first time I've used background images for <div>'s instead of just using a background color. I'm running into an issue, that I'm not quite sure how to solve. Since I am using a background image for my "page"; eventually, if there is too much text, the text just runs over the background image. I'd like to use some coding logic to figure out when my text would start to over run the image, and when that would happen instead create another copy of my background image below the first and start filling data there.

Since I plan on using this as a forum the amount of information is not going to be static. Some people might have a few lines of text, other a wall of text, so I can't really limit it to only 4 posts and than a new page. In theroy here is what I would like to happen....

Say I have 1500 pixels before I start to over run my background image.
 1) Create my first div and fill with info.
 2) Check height of div, store it in a variable.
 3) Create second div.
 4) Check height of that div, store it in the same variable.
 5) Check to make sure that my variable doesn't exceed 1500px. If it does than I need to create my second page and start filling info there...

I hope I am explaining this to where it is understandable.

Here is a link to the site I am working on: http://98.249.189.188/guildwars/forum/view_topic.php?id=9

Currently, I am pumping out each reply in this fashon:
Code: [Select]
<?php
        while($row_rply = mysql_fetch_array($results_rply))
        {
                echo "<div class=\"replies\";";
                echo "<p>".nl2br($row_rply[0])."</p>";
                echo "<p class=\"small\">By: $row_rply[1] on $row_rply[2]</p>";
                echo "</div><br />";
        }

        include('reply.php');
?>

Hello,
I have a stock page on my site and want to use the code to display a small stock area on my home page. I am not sure on how I would limit the number of records or randomize the records shown. The code is
Code: [Select]
<?php
   $coachselect=mysql_query("SELECT * FROM coaches WHERE DISPLAY = '1' ORDER BY STOCK")or die(mysql_error());
while($row = mysql_fetch_array($coachselect)){
?>
                   
                    <ul class="stock-home">
                    <li><h4><a href="details-id-<?php echo $row['ID']; ?>.html" target="_blank"></a></h4></li>
                    <li><img src="./<?php echo $row['IMAGES'] . "/" . $row['DEFAULT_IMAGE'] ; ?>" width="187" height="138" alt="lehel virage for sale"  class="fl"/></li>
                    <li><?php echo $row['NAME']; ?></h3></li><li><?php echo $row['DESC_SHORT']; ?></li>
                    <li><a href="details.php?id=<?php echo $row['ID']; ?>" target="_blank">more info...</a></li>
<li><?php echo $row['DESC_2']; ?></li>
                   
                    </ul><!--close stock home-->
   
    <?php
}
?>

I am guessing that something needs to be added here Code: [Select]
$coachselect=mysql_query("SELECT * FROM coaches WHERE DISPLAY = '1' ORDER BY STOCK")or die(mysql_error());
while($row = mysql_fetch_array($coachselect)){
?>

But am not sure how to do it? Does anyone have any advice or could point me to a tutorial?


Here is the rest of the code, from the top of the page.

Code: [Select]
$CON=mysql_connect($DB_SERVER, $DB_USER, $DB_PASS) or die(mysql_error());
$DB_SELECT=mysql_select_db($DATABASE) or die(mysql_error());

if (isset($_POST)) {
foreach ($_POST as &$value) {
    $value = trim(htmlspecialchars($value, ENT_QUOTES));
}
}

if (isset($_GET)) {
foreach ($_GET as &$value) {
    $value = trim(htmlspecialchars($value, ENT_QUOTES));
}
}

$_SERVER['PHP_SELF'] = filter_var($_SERVER['PHP_SELF'], FILTER_SANITIZE_STRING);

?>
Many Thanks

Dan