PHP - Forms Where Displayed Option Different From Value?

At the moment i can retrieve information from a DB and display it nicely in a vertical line of boxes (some boxes with extra information as needed).

I basically need a version of this with exactly the same information, but instead of a top-down list of divs (boxes), I need them to be displayed going around a circle (starting top centre, going clockwise).

Does anyone know if this is possible?
And how easy would it be? Any scripts?

It's already taken me ages to get the list pulling the appropriate info and displaying in a straight line.

Thanks for any help/direction.


Added: The number of divs displayed will be variable depending on what's in the DB. So I can't count on their being a certain number. Therefore the 'circle' would need to re-size in some way?!

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

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 have following error when i try to enter my student info into the database.

! ) Warning: Header may not contain more than a single header, new line detected. in C:\wamp\www\Student registration\new student registration\newStudentRegistrationFormvalidation.php on line 43

newStudentRegistrationFormvalidation.php

<?php

$admission_no=$_POST['admission_no'];
$admission_date=$_POST['admission_date'];
$full_name=$_POST['full_name'];
$name_with_initial=$_POST['name_with_initial'];
$date_of_birth=$_POST['date_of_birth'];
$religion=$_POST['religion'];
$address=$_POST['address'];
$telephone=$_POST['telephone'];
$grade_on_admission=$_POST['grade_on_admission'];
$grade_ID=$_POST['grade_ID'];
$stream_ID=isset($_POST['stream_ID']) ? $_POST['stream_ID'] :'';
$class_ID=$_POST['class_ID'];
$student_house=$_POST['student_house'];
$password=$_POST['password'];
$description_about_st=$_POST['description_about_st'];
$payment=$_POST["payment"];


$currentdate=getdate(time());
$year=$currentdate["year"];

//admission number validation

$answer='';

$con=mysql_connect("localhost","root","");
mysql_select_db("student_management",$con);
$query="SELECT admission_no FROM student_info WHERE student_info.admission_no='$admission_no'";
$result=mysql_query($query);
while($row=mysql_fetch_array($result)){
   
   $answer=$row['admission_no'];}
   if($answer==0)
{

//line 43

header("location:student registrationDatabase.php?admission_no=".$admission_no."&year=".$year."&admission_date=".$admission_date."&full_name=".$full_name."&name_with_initial=".$name_with_initial."&date_of_birth=".$date_of_birth."&religion=".$religion."&address=".$address."&telephone=".$telephone."&grade_on_admission=".$grade_on_admission."&grade_ID=".$grade_ID."&stream_ID=".$stream_ID."&class_ID=".$class_ID."&student_house=".$student_house."&password=".$password."&description_about_st=".$description_about_st."&payment=".$payment);   
exit();

}else{
   
?>
<body>
<?php
 echo "Admission number".$admission_no."This student has  been alredy entered to the system ."."<BR>"."<BR>"."<BR>";
 echo "<a href='newStudentRegistrationForm.php'>GO to manage student details page</a> ";
 exit();
}?>

studentregistrationDatabase.php

<?PHP

 $admission_no=$_POST['admission_no'];
 $admission_date=$_POST['admission_date'];
 $full_name=$_POST['full_name'];
 $name_with_initials=$_POST['name_with_initial'];
 $dob=$_POST['date_of_birth'];
 $religion=$_POST['religion'];
 //$gender=$_GET['gender'];
 $address=$_POST['address'];
 $telephone=$_POST['telephone'];
 $grade_on_admission=$_POST['grade_on_admission'];
 $present_grade=$_POST['grade_ID'];
 $stream=$_POST['stream_ID'];
 $present_class=$_POST['class_ID'];
 $student_house=$_POST['student_house'];
 $password=$_POST['password'];
 $description_about_st=$_POST['description_about_st'];
 $payment=$_POST["payment"];

$current=getdate(time());
$year=$current["year"];

$today = date("Y-m-d");


$con=mysql_connect("localhost","root","");
mysql_select_db("student_management",$con);

//insert to database

$query="select count(*) from student_info where admission_no='$admission_no'";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
if($row[0]==0)
{
$query="insert into student_info values(null,'$admission_no','$admission_date','$full_name','$name_with_initials','$dob','$religion','$address','$telephone','$grade_on_admission','$password','$student_house','$description_about_st')";
$result=mysql_query($query);

if($stream!=null){
      
   $query="select class_id  from class
         where class.grade_id='$present_grade' and class.class_name='$present_class' and class.stream='$stream'";
   }else{
      
      $query="select class_id  from class
         where class.grade_id='$present_grade' and class.class_name='$present_class'";
      }
$result=mysql_query($query);
while($row=mysql_fetch_array($result)){
$class_id=$row['class_id'];
}

$query="insert into student_class values('$admission_no','$class_id','$year')";
$result=mysql_query($query);

if($payment=="2000")
{
   $query="insert into payment_amount values(null,'2000','$today')";
   $result=mysql_query($query);
   
   $query="SELECT amount_id FROM payment_amount order by amount_id DESC limit 1";
$result=mysql_query($query);
   while($row = mysql_fetch_array($result))
{
 $amount_id=$row['amount_id'];
}
   $query="insert into payment values('$admission_no','$amount_id')";
   $result=mysql_query($query);

}else{
   
   $query="insert into payment_amount values(null,'0','$today')";
   $result=mysql_query($query);

$query="SELECT amount_id FROM payment_amount order by amount_id DESC limit 1";
$result=mysql_query($query);
   while($row = mysql_fetch_array($result))
{
 $amount_id=$row['amount_id'];
}
   $query="insert into payment values('$admission_no','$amount_id')";
   $result=mysql_query($query);


}


header("location:../new student registration-parent details/studentRegistrationParentDetailsForm.php?admission_no=".$admission_no);
exit();
}

else{
   
?>

<?php

echo "Admission number".$admission_no."This student has been already entered to the system"."<BR>"."<BR>"."<BR>";
echo "<a href='student registration.php'>GO to registration page</a>";
exit();
}
?>

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?

 

Code: [Select]
function my_fav_quote_show_optin_form() {

if (!empty($_POST['my_fav_quote_email'])) {

my_fav_quote_opt_in();
}
$out2 = '';

$out = '<form action="" name="myform "method="post" id="requestQuote">';
$out .= '<table style="padding="0px" width="40px">';
$out .= '<tr><td>Name:*</td><td><input type="text" name="my_fav_quote_name" id="my_fav_quote_name"/></td></tr>';
$out .= '';
$out .= '<tr><td>Email:*</td><td><input type="text" name="my_fav_quote_email" id="my_fav_quote_email"/></td></tr>';

$out .= '';
$out .= '<tr><td>Phone:*</td><td><input type="text" name="my_fav_quote_phone" id="my_fav_quote_phone"/></td></tr>';

$out .= '';

$out .= '<tr><td>Event Date(optional):</td><td><input type="text" name="my_fav_quote_date" id="my_fav_quote_date"/></td></tr>';
$out .= '';

$out .= '<tr><td>Estimated Number of Guests(optional):</td><td><input type="text" name="my_fav_quote_guest" id="my_fav_quote_guest"/></td></tr>';
$out .= '';

$out .= '<tr><td>Desired Price Range Per Person (optional):</td><td><input type="text" name="my_fav_quote_rate" id="my_fav_quote_rate"/></td></tr>';
$out .= '';
$out .= '<tr><td style="vertical-align: middle;">Message:<br>(List your special requests, any food allergies , event description , special menu items that are not listed or any other information you think will helpful) </td><td><textarea placeholder=""  name="my_fav_quote_message" id="my_fav_quote_message"></textarea></td></tr>';
$out .= '';
$out .= '<tr><td>Security code:*</td><td><img src='.get_bloginfo('wpurl').'/wp-content/plugins/quote-cart/captcha.php?width=60&height=30&characters=5" /></td></tr>';
$out .= '';
$out .= '<tr><td>Input Above Security Code He *</td><td><input type="text" name="security_code" id="security_code" size="5"></td></tr>';
$out .= '';

$out .='<tr><td colspan="2">';
if ( function_exists( 'my_fav_quote_display' ) ){
$out .= my_fav_quote_display();
}



if ( function_exists( 'my_fav_quote_display3' ) ){
$out .= my_fav_quote_display3();
}


$out .='</td></tr>';
$out .= '<tr><td colspan=2 align=center><input type="submit" value="Request Quote" onclick="return chk_validation()" style="background-color:#000;color:#FFF;padding:5px;margin-top:10px;border:none;cursor:pointer;"/> 
<input type="button" onclick="formReset()" value="Reset form" />

</td></tr>';

$out .='</table></form>';
echo $out;
?>
<script language="javascript" type="text/javascript">
//<![CDATA[
function validate_email(field,alerttxt)
{

  apos=field.indexOf("@");
// alert(apos);
  dotpos=field.lastIndexOf(".");
   //alert(dotpos);
  if (apos<1||dotpos-apos<2)
{ return false;}
  else {return true;}
 
}
function chk_validation()
{
if(document.getElementById("my_fav_quote_name") && document.getElementById("my_fav_quote_name").value == '')
{
alert("Please Enter Name");
document.getElementById("my_fav_quote_name").focus();
return false;
}

if(document.getElementById("my_fav_quote_email").value == '')
{
alert("Please Enter Email");
document.getElementById("my_fav_quote_email").focus();
return false;
}
else
{

//alert(validate_email(document.getElementById("my_fav_quote_email").value,"Not a valid e-mail address!");
if (validate_email(document.getElementById("my_fav_quote_email").value,"Please enter valid e-mail address!")==false) {
alert("Please enter valid e-mail address!");
document.getElementById("my_fav_quote_email").focus();
return false;
}
}
if(document.getElementById("security_code").value == '')
{
alert("Please Enter Security Code");
document.getElementById("security_code").focus();
return false;
}
if(document.getElementById("quotes").value == '')
{
alert("Please add atleast one request quote");
document.getElementById("quotes").focus();
return false;
}
//return true;
}



//]]>

</script>
<?php

}

i need a form reset the actual problem is the normal reset is only reseting the fields but i need the information displayed using functions should also be reseted

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

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>

I'm trying to get a listing of my directory that shows the first letter and then all the names that start with that letter. Here is my code:
Code: [Select]
for($i = 65; $i < 91; $i++) {
foreach (glob("{".chr($i).",".chr($i+32)."}*", GLOB_BRACE|GLOB_ONLYDIR) as $directoryname) {
echo chr($i)."| ".$directoryname;
}
}
But here's my output:
Quote

P | Project Red
P | Projects
P | Pants
R | Resumes
W | Warehouse Files
W | warrior


I want it to be like:
Quote

P | Project Red
     Projects
     Pants
R | Resumes
W | Warehouse Files
      Warrior


I know I have to move the chr($i) since it loops, but I'm not sure where to go from there.

I want to search my order table by order Id.The implementation is such that all the orders are displayed on order management page by default.I have coded this part.Now on this page I want search facility to search by OrderId.I tried to implement but failed.Please suggest something.

The code is shown below(I have deleted the part I have coded for search functionality implementation).Also I have attached screenshot of UI for better understanding:


      <!-- display the list of orders-->
     <?php if(isset($_GET['index']) && ($_GET['index'] == 'List'))
    {
   ?>
   <tr>
     <td height="20">[ <a href="order.php?index=Add"><b>Add New &gt;&gt;</b></a> ]</td>
     <td height="20">&nbsp;</td>
   </tr>
   <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
   </tr>
    <tr>
            <td colspan="2"><?php if(isset($_GET['errormsg'])){?>
<div id="showerror" class="errormessage"><?php echo $_GET['errormsg'];?></div><?php } ?>
<?php if(isset($_GET['successmsg'])){?>
<div id="showsuccess"  class="message"><?php echo $_GET['successmsg'];?></div><?php } ?></td>
            </tr>
    <?php
      $selectqry   =   "select * from tblorder";
      $result      =   mysql_query($selectqry) or die(mysql_error());
      $count      =   mysql_num_rows($result);   
   ?>
        <tr>
     <td colspan="2">
     
     <table width="450" border="0" align="center" cellpadding="0" cellspacing="0" class="TableBorder">
       <tr><td>
      <table width="650" border="0" cellspacing="1" cellpadding="0">
         <tr>
            <td colspan="8" class="tblHeader">List of All Orders (<?php echo $count ; ?>)</td>
         </tr>
         
         <tr>
            <td  colspan="8" valign="bottom" align="center" class="tblHeader"><select name="cmbPage" id="cmbPage" onchange="javascript:_doPagination('product.php','index=List');">
<option value="1" selected>1</option>
<option value="2">2</option>
</select></td>
         </tr>
         
         <tr>
            <td width="20%" align="center" height="22" class="tblColHeader" style="padding-left:5px;">Order Id</td>
            <td width="15%" align="center" class="tblColHeader">Customer Email</td>
            <td width="20%" align="center" class="tblColHeader">Status</td>
            <td width="10%" align="center" class="tblColHeader">Date</td>
            <td width="10%" height="22" align="center" class="tblColHeader">Total</td>
            <td width="10%" height="22" align="center" class="tblColHeader">View</td>
                <td width="10%" height="22" align="center" class="tblColHeader">Edit</td>
                <td width="10%" height="22" align="center" class="tblColHeader">Print</td>
         </tr>
           
           
            <tr>
            <td width="20%" align="center" height="22" class="tblColHeader" style="padding-left:5px;"><input type="text" name="order_search" id="order_search" value=""></td>
           
            <td>
            <td width="15%" align="center" height="22" class="tblColHeader" style="padding-left:5px;"><input type="button" name= "filter" id="filter" value="Filter" onclick="javascript:window.document.form.action"></td>
           
           
            </tr>
              
               
                         
                <?php
            
            
                     
            while($rows = mysql_fetch_assoc($result)){
                $OrderId   =   $rows['Order_Id'];
               $Customer_Email   =   $rows['Customer_EmailId'];
               $Status = $rows['Status'];
               $Date = $rows['Date'];
               $Total = $rows['Grand_Total'];
                  
            
            ?>
            <tr height="22" class="alterClass2" onMouseOver="this.className='mouseOver'" onMouseOut="this.className='alterClass2'">
               <td align="center" style="padding-left:5px;"><?php echo $OrderId; ?></td>
               <td align="center" style="padding-left:5px;"><?php echo $Customer_Email; ?></td>
               <td align="center" style="padding-left:5px;"><?php echo $Status; ?></td>
                    <td align="center" style="padding-left:5px;"><?php echo $Date; ?></td>
                    <td align="center" style="padding-left:5px;"><?php echo $Total; ?></td>
               
               
               <td align="center">
                  <a href="order.php?index=View&Id=<?php echo $OrderId ?>"><img src="../images/bView.png" width="16" height="16" border="0" /></a>
               </td>
                   
                         <td align="center">
                  <a href="order.php?index=Edit&Id=<?php echo $OrderId ?>"><img src="../images/b_edit.png" width="16" height="16" border="0" /></a>
               </td>
               
                   
                   
                   
                   
                         <td align="center">
                  <a href="order.php?index=Print&Id=<?php echo $OrderId ?>"><img src="../images/print_icon.gif" width="16" height="16" border="0" /></a>
               </td>
                   
                    <?php } ?>
                   
                   
                   
              <!--      <td align="center">
                  <a href="product.php#TB_inline?width=350&amp;height=130&amp;inlineId=CategoryDelete<?php echo $ProductId ?>" class="thickbox" title="Confirm Delete"><img src="../images/b_drop.png" width="16" height="16" border="0" /></a>
               </td>
            </tr>
                <div id="CategoryDelete<?php echo $ProductId ?>" style="display: none;"><br />
               <p align="center">Are you sure you want to delete the product<BR>
               <b style="color: #990000;"></b><?php echo $productname ?>?</p>
               <p align="center">
                  <input type="button" name="btnDelete" value="  YES  " class="Button" onclick="javascript:window.location.href='product.php?index=List&action=Delete&Id=<?php echo $ProductId ?>';" />&nbsp;
                  <input type="button" name="btnCancelDelete" value="  NO  " onclick="javascript:tb_remove();" class="Button" /></p>
            </div>
                ->>
               
            
            
             </table>
       </td></tr>
     </table></td>
     </tr>
   <!--<tr>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
   </tr>
   <tr>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
   </tr>
         </table>
   </td>
 </tr>
 <tr>
   <td>&nbsp;</td>
   <td>&nbsp;</td>
 </tr>
 <tr>
   <td>&nbsp;</td>
   <td>&nbsp;</td>
 </tr> -->
</table></td>
  </tr>
</table>

<?php }?>
<!-- End of display function -->

I am trying to write some code to display the visits to my site each week in batches of 13 weeks (1 quarter). I am getting the Week No and the number of hits, but the actual date, which is in a separate table is not being displayed. I have tried LEFT JOIN and INNER Join and even RIGHT JOIN (this only displays the Date). I can't see where I am going wrong! Here is the code:

<?
include('connect_visits.php');
doDB7();
$limitStart = $_POST['QUARTER'] - 13;
$Visit_data="SELECT Visits.ID, Visits.WVisits, Visits.WCom, WeekNo.WNo, WeekNo.WCom
        FROM Visits 
        LEFT JOIN WeekNo
            ON Visits.ID = WeekNo.WCom
        ORDER BY Visits.ID
	 LIMIT {$limitStart}, 13";
$Visit_data_res = mysqli_query($mysqli, $Visit_data) or die(mysqli_error($mysqli));
$display_block = "
<table width=\"20%\" cellpadding=\"3\" cellspacing=\"1\" border=\"1\" BGCOLOR=\"white\" >
	<tr>
	<th>Week No</th>
	<th>Week Commencing</th>
	<th>Visits</th>
		</tr>";	
while ($C_info = mysqli_fetch_array($Visit_data_res)) {
		$Cid = $C_info['ID'];
		$Visits = ($C_info['WVisits']);
		$WeekNo = ($C_info['WCom']);
//add to display
$display_block .= "
<tr>
<td width=\"1%\" valign=\"top\">".$Cid."<br/></td>
<td width=\"8%\" valign=\"top\">".$WeekNo."<br/></td>
<td width=\"5%\" valign=\"top\">".$Visits."<br/></td>
</td></tr>";
}
mysqli_free_result($Visit_data_res);
?>

Where am I going wrong?
Edited by rocky48, 29 December 2014 - 12:53 PM.

Hi,

I am trying to get a facebook like button displayed under each of my blog post, but so far I am just getting three like buttons displayed above the blog post instead of below each one. Below is the function code to display my blog post and also where I cam currently placing the FB like button code.


<?php
include 'blogpost.php';

$connection = mysql_connect('localhost', 'username', 'pw') or die ("<p class='error'>Sorry, we were unable to connect to the database server.</p>");
$database = "DBName";
mysql_select_db($database, $connection) or die ("<p class='error'>Sorry, we were unable to connect to the database.</p>");


function GetBlogPosts($inId=null, $inTagId =null)
{
if (!empty($inId))
{
$query = mysql_query("SELECT * FROM blog_posts WHERE id = " . $inId . " ORDER BY id DESC LIMIT 2"); 
}
else if (!empty($inTagId))
{
$query = mysql_query("SELECT blog_posts.* FROM blog_post_tags LEFT JOIN (blog_posts) ON (blog_post_tags.postID = blog_posts.id) WHERE blog_post_tags.tagID =" . $tagID . " ORDER BY blog_posts.id DESC");
}
else
{
$query = mysql_query("SELECT * FROM blog_posts ORDER BY id DESC");
}

$postArray = array();
while ($row = mysql_fetch_assoc($query))
{
$myPost = new BlogPost($row["id"], $row['title'], $row['post'], $row['postfull'], $row["author_id"], $row['date_posted']);

array_push($postArray, $myPost);
echo '<script src="http://connect.facebook.net/en_US/all.js#xfbml=1"></script><fb:like show_faces="true" width="450"></fb:like>';//this is where I am currently implementing the FB Like button
}
return $postArray;
}
?>

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