PHP - Parse Errors On Search Script

Hi Ive made a database with the option to kick someone for a certain amount of time but seems like I'm doing something wrong somewhere can anybody please assist   My full script is    (Admin panel)

<?
include "./emoticon_replace1.php";


  if ($_POST["DeletePost"]) {
    $id = $_POST["id"];
    $query = "DELETE FROM ".$dbTable." WHERE id='".$id."'"; 
    mysql_query($query);
    echo "ID removed from system: ".$id;
  }
  if ($_POST["BanIP"]) {
    $IP_To_Add = $_POST["ip"];
    if(eregi("^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$", $IP_To_Add))
    {
      $sql = "INSERT INTO ".$IPBanTable." (ip) VALUES (\"$IP_To_Add\")";
      $result = mysql_query($sql);
    } else {
      echo "Error: Not a valid IP: ".$IP_To_Add;
    }
  }
  if ($_POST["purge"]) {
    $query = "TRUNCATE TABLE ".$dbTable; 
    mysql_query($query);
    echo "StringyChat purged";
  }
  if(!$_POST["update"] || !$_POST["StringyChat_name"] || !$_POST["StringyChat_message"]) {
  } else {
    $id = $_POST["id"];
    $name = $_POST["StringyChat_name"];
    $message = $_POST["StringyChat_message"];


    include("emoticon_replace.php");


    $query = "UPDATE ".$dbTable." SET StringyChat_name='$name', StringyChat_message='$message' WHERE id='".$id."'";
    $result = mysql_query($query, $db) or die("Invalid query: " . mysql_error());
  }
  if ($_POST["EditPost"]) {
    $id = $_POST["id"];
    $result = mysql_query("SELECT * FROM ".$dbTable." WHERE id='".$id."'", $db); 
    $myrow = mysql_fetch_array($result);
?>
    <form name="StringyChat_form" method="POST" action="?mode=postman">
      Name:<br>
      <input name="StringyChat_name" class="StringyChatFrm" type="text" size="20" maxlength="<? echo $name_size; ?>" value="<? echo $myrow["StringyChat_name"]?>">
      <br>
      Message:<br>
      <textarea name="StringyChat_message" class="StringyChatFrm" cols="20" rows="4"><? echo $myrow["StringyChat_message"]?></textarea>
      <br>
      <input type="hidden" name="id" value="<? echo $id ?>">
      <input name="update" class="StringyChatFrm" type="submit" value="Update">
    </form>


<?
  }
?>


  <a href="<? echo $_SERVER['REQUEST_URI']; ?>&m=purge">Purge StringyChat</a><br>
    <br>


  <?
  // Load up the last few posts.  The number to load is defined by the "ShowPostNum" variable.
  $result = mysql_query("SELECT * FROM ".$dbTable." ORDER BY StringyChat_time DESC",$db);


  while ($myrow = mysql_fetch_array($result)) {
    $msg = $myrow["StringyChat_message"];


    $msg = strip_tags($msg);
    $msg = eregi_replace("im#([a-z]{3})", "<img src=\"/stringychat/images/\\1.gif\" alt=\"emoticon\">",$msg);


printf("<div class=\"StringyChatItem\"><h4>%s<br>\n", $myrow["StringyChat_name"]);
printf("%s<p>\n",$myrow["StringyChat_ip"],"%s</p>\n");
    printf("%s</h4>\n", date("H:i - d/m/y", $myrow["StringyChat_time"]));
    printf("%s</div>\n", $msg);




if ($_POST["1h"]) {
    $mxitid1= $_POST["1h"];
    if(eregi("^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$", $IP_To_Add))
    {
      $sql1 = "UPDATE ".$dbTable." SET unban_time = DATE_ADD(NOW(), INTERVAL 1 DAY) WHERE mxit_id = $mxitid1)";
      $result1 = mysql_query($sq1l);
    } else {
      echo "Error: Cannot Kick: ".$IP_To_Add;
    }
  }
function checkban($mxitid) 
    { 
        // querys database 
        $q = mysql_query("SELECT 1 FROM ".$dbTable." WHERE unban_time > NOW() AND mxit_id = '$mxitid'",$db); 
        $get = mysql_num_rows($q); 
        // if found 
        if ($get == "1") 
            {  
                // deny user access 
                $r=mysql_fetch_array($q); 
                die("You have been banned from this website until $r[legnth]. If you feel this is in error, please contact the webmaster at ."); 
            } 
    }








?>
    <form name="form<? echo $myrow["id"];?>" method="post" action="?mode=postman">
      <input name="id" type="hidden" value="<? echo $myrow["id"];?>">
      <input name="ip" type="hidden" value="<? echo $myrow["StringyChat_ip"];?>">
      <input name="EditPost" type="submit" id="EditPost" value="Edit">
      <input name="DeletePost" type="submit" id="DeletePost" value="Delete">
      <input name="BanIP" type="submit" id="BanIP" value="Ban <? echo $myrow["StringyChat_ip"];?>">
<input name="1h" type="submit" id="1" value="Kick <? echo $myrow["mxit_id"];?>">
<input name="1d" type="submit" id="1d" value="Kick <? echo $myrow["StringyChat_ip"];?> for 24 hours ">
<input name="7d" type="submit" id="7d" value="Kick <? echo $myrow["StringyChat_ip"];?> for 7 days ">
    </form>
  <?
  }   
?>

The part I added to the above script which is giving me pain is   

if ($_POST["1h"]) {
    $mxitid1= $_POST["1h"];
    if(eregi("^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$", $IP_To_Add))
    {
      $sql1 = "UPDATE ".$dbTable." SET unban_time = DATE_ADD(NOW(), INTERVAL 1 DAY) WHERE mxit_id = $mxitid1)";
      $result1 = mysql_query($sq1l);
    } else {
      echo "Error: Cannot Kick: ".$IP_To_Add;
    }
  }
function checkban($mxitid) 
    { 
        // querys database 
        $q = mysql_query("SELECT 1 FROM ".$dbTable." WHERE unban_time > NOW() AND mxit_id = '$mxitid'",$db); 
        $get = mysql_num_rows($q); 
        // if found 
        if ($get == "1") 
            {  
                // deny user access 
                $r=mysql_fetch_array($q); 
                die("You have been banned from this website until $r[legnth]. If you feel this is in error, please contact the webmaster at ."); 
            } 
    }

What I'm trying to do is to ban the person for 1 day. And by banning the person I want them to be blocked from my Index page from submitting a form (sending a message) which is stored as tik.php on my index page     index.php

<?php
require_once('common.php');


include "ip-ban-time-limit.php";
checkban($_SERVER['HTTP_X_MXIT_USERID_R']);






checkUser();
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
<html>
<head>
   <title>Galaxy Universe Chat</title>
   <link href="style/style.css" rel="stylesheet" type="text/css" />
</head>
<body><br>
    <div id="main">
      <div class="caption">Galaxy Universe Chat</div>
      <div id="icon">&nbsp;</div>
      <div id="result">
Hello <?php echo $_SESSION['userName']; ?> ! <br/>
<div style="color:red"><b><p>Please keep it clean and in English or you will be banned!</p></b></div>
<br>
<?PHP


include "./stringychat.inc.php";
require_once ( 'tik.php' );


?>


<br>




<p><a href="index1.php">Refresh</a> | <a href="logout.php">Log Out</a></p>
 </div> 
 <div id="source">Galaxy Wars chat @ cobusbo</div>
    </div>
</body>   

Seems like I've been doing something wrong with my queries...

I need PHP script that will parse XML-based (.xspf format) live stream playlist stored on web server, retrieve track data and print it on my web page. Print inside div as scrolling text (one line). The track data on page need be refreshed synchronously to show current track info.

XSPF playlist example:
Code: [Select]
<?xml version="1.0" encoding="UTF-8"?>
<playlist xmlns="http://xspf.org/ns/0/" version="1">
  <title/>
  <creator/>
  <trackList>
    <track>
      <location>http://geodesid5.streams.audioveduct.com:80/di_ambient7</location>
      <title>Bruno Sanfilippo - Piano Textures 2 II</title>
      <annotation>Stream Title: Ambient - DIGITALLY IMPORTED - a blend of ambient, downtempo, and chillout

Content Type:audio/mpeg
Current Listeners: 0
Peak Listeners: 0
Stream Gen Electronic Ambient Downtempo</annotation>
      <info>http://www.di.fm</info>
    </track>
  </trackList>
</playlist>

I need get data from fields 'title' and 'annotation' (only text between Stream Title and Content Type). Also, after these two, I want scroll small custom text, when required. I searched some close example, but didn't find yet.
Will be DOMDocument method suitable for this task? Can someone show me the right method to do this?

Hello, I am very new to both PHP and MYSQL but I am eager to learn.

What I want to do is write a PHP script that will parse an XML file and insert the results into a MYSQL database. I've read a bunch of guides online and I think I have the parser structure down. I created a parser using xml_parser_create(). As I understand it, I need to create functions to handle each of the three events, startTag, endTag, and contents. This is where I am not sure what to do. What do I need to tell these functions to do when these events are triggered? I know I need to connect to the MYSQL database at some point but I do not know when.

If anyone could point me in the right direction, I'd appreciate it.

He,

I am builing some kind of quiz script.
I got 10 images people see and they have to say if they agree or not.
Simply by clicking yes / no. First i used a submit button, but now i want it to submit whem people click yes/no.
tried some stuff already but cant find the correct way.

Please help

here is the code:

<?php

session_start();

$thispage = 'test.php';
$img = array( '1','2','3','4','5','6','7','8','9','10' );

function getQuestion( $q ) {
    global $img;
    $curImg = $img[$q];
    return "Do you agree? <br> <img src=\"images/{$curImg}.jpg\">";
}

 
if ( isset( $_GET['reset'] ) ) {
    unset( $_SESSION['q'] );
    unset( $_SESSION['answer'] );
    header("Location: {$thispage}");
}

if ( !isset( $_SESSION['q'] ) ) {
    $_SESSION['q'] = 0;
}
if ( !isset( $_SESSION['answer'] ) ) {
    $_SESSION['answer'] = array();
}


if ( isset( $_POST['answer'] ) ) {
    $answer = $_POST['submit'];
    if ( $answer == '1' || $answer == '2' ) {
        $next =  $_SESSION['q'] + 1 ;
        if ( array_key_exists( $next,$img ) ) {
            $_SESSION['answer'][$_SESSION['q']] = $answer;
        }
        $_SESSION['q'] = $next ;
    }
}

if ( $_SESSION['q'] >= count( $img ) ) {
    $html = '';
    foreach( $_SESSION['answer'] as $q => $value ) {
        $html .= getQuestion( $q ) . " Answer: {$value}<br />";
    }
    $html .= "<br /><br /><a href=\"{$thispage}?reset=Y\">Reset Quiz</a>";
}
else {
    $question = getQuestion( $_SESSION['q'] );
    $html =<<<HTML

<html>
<body>
<h1>{$question}</h1>
    <input type="submit" value="Yes" name="answer"  />Yes<br />
    <input type="submit" value="No" name="answer"  />No<br />
</form>
</body>
</html>
HTML;
}

echo $html;


?>

I have noticed 2 script errors on my site within the .php files but can't see why they're occurring. The first appears at the bottom of my wordpress admin page: Notice: Array to string conversion in /home/orkwine/public_html/test/wp-includes/class.wp-scripts.php on line 123 This is the area in that file: `$srce = apply_filters( 'script_loader_src', $src, $handle );
if ( $this->in_default_dir($srce) ) {
$this->print_code .= $this->print_extra_script( $handle, false );
$this->concat .= "$handle,";
$this->concat_version .= "$handle$ver";
return true;
} else {
$this->ext_handles .= "$handle,";
$this->ext_version .= "$handle$ver";
}
}`
Line 123 is: $this->ext_version .= "$handle$ver";
The other error i am getting is: Notice: Undefined index: prettyPhoto in /home/orkwine/public_html/test/wp-includes/class.wp-scripts.php on line 185 Notice: Trying to get property of non-object in /home/orkwine/public_html/test/wp-includes/class.wp-scripts.php on line 185 These are lines 183-194 in that file:` function set_group( $handle, $recursion, $group = false ) { if ( $this->registered[$handle]->args === 1 )
$grp = 1;
else
$grp = (int) $this->get_data( $handle, 'group' ); if ( false !== $group && $grp > $group )
$grp = $group; return parent::set_group( $handle, $recursion, $grp );
}`
Line 185 is: if ( $this->registered[$handle]->args === 1 )
Can anyone help solve these errors? The full file can be seen he
http://pastebin.com/spBAhuHf   Here is a link to one of the pages in the website which shows the second error. http://test.orkneywi...-borealis-35cl/ Can anyone help with this?

Hi,

I recently attempted to install a refer-a-friend script into my website but I really don't use PHP at all and even my html is very sloppy so it didn't get installed as planned.
It currently cuts out the bottom half of my website like so: http://www.returntherake.com/refer.php
Basically everything before the script is called is fine but everything after doesn't work. Heres the code from the point its installed till the end of my website.

Any help would be great. Thank you so much.

Quote

<script language="php">

// Number of friend feilds to put on the page
$tellnumber = "3";

// Subject of email
$subject = "Great Poker Rakeback Site";

// Message sent in the email
$message = "Look at this great site I found. I think you'll like it. It will boost your profits while playing online poker
by getting you some of your rake back.
http://www.ReturnTheRake.com/
When signing up with a website remember to say $_POST[name] referred you in the proper section. As you will recieve a 25% bonus on your first $20 rakeback recieved.";

// Url to redirect user to once they click submit
$thankyouurl = "http://www.returntherake.com/thankyou_refer.html";




//////////////////////////////////////////////////////////////////////////////////
// DO NOT EDIT ANYTHING BELOW THIS LINE                                         //
//////////////////////////////////////////////////////////////////////////////////


if($_POST[submitform] == "Submit") {

$error = "";
$num=0;

while($num < $tellnumber) {
$num++;
$temail = "femail"."$num";
$tname = "fname"."$num";

if($_POST[$tname] OR $_POST[$temail]) {
if(!$_POST[$tname]) {
$error .= "Missing Friends Name,  Friend $num<BR>";
}
if(!$_POST[$temail]) {
$error .= "Missing Friends Email,  Friend $num<BR>";
}
}

if($_POST[$temail]) {
if(!ereg("@",$_POST[$temail])) { $error .= "Invalid Email Address, Friend $num<BR>"; }
if(!ereg("\.",$_POST[$temail])) { $error .= "Invalid Email Address, Friend $num<BR>"; }
}

}

if(!$_POST["name"]) {
$error .= "Missing your name<BR>";
}
if(!ereg("@",$_POST[email])) { $error .= "Invalid Email Address<BR>"; }
if(!ereg("\.",$_POST[email])) { $error .= "Invalid Email Address<BR>"; }

if($error) {
?>

<BODY BGCOLOR="#ffffff">
<P><CENTER><TABLE BORDER="0" CELLSPACING="0" CELLPADDING="0">
  <TR>
    <TD WIDTH="100%" BGCOLOR="#01864E">
    <TABLE WIDTH="340" BORDER="0" CELLSPACING="1" CELLPADDING="2">
      <TR>
        <TD WIDTH="26%" BGCOLOR="#01864E">
        <B><FONT COLOR="#ffffff" SIZE="-3" FACE="Verdana">Error</FONT></B></TD>
      </TR>
      <TR>
        <TD WIDTH="26%" BGCOLOR="#ffffff">
        <FONT COLOR="#000000" SIZE="-3" FACE="Verdana"><? echo $error; ?></FONT></TD>
      </TR>
    </TABLE></TD>
  </TR>
</TABLE></CENTER>

<?
exit();
}


    $extra ="\r\n";
          $headers = "";
          $headers .= "From: $_POST[name] <$_POST[email]>".$extra;
          $headers .= "Reply-To: $_POST[name] <$_POST[email]>".$extra;
          $headers .= "Return-Path: $_POST[name] <$_POST[email]>".$extra;
          $headers .= "Message-ID: <".time()." - $_POST[email]>".$extra;
          $headers .= "X-Mailer: PHP v".phpversion().$extra;
          $headers .= 'MIME-Version: 1.0'.$extra.$extra;

$num=0;

while($num < $tellnumber) {
$num++;
$temail = "femail".$num;
$tname = "fname".$num;
$print_f_name = $_POST[$tname];
$print_f_email = $_POST[$temail];

if($_POST[$temail] AND $_POST[$tname]) {


mail($print_f_email,"$subject","
Hi, $print_f_name

$message

From
$_POST[name]


",$headers);


}

}

header("Location: $thankyouurl");
exit();


} else {

$num=0;
while($num < $tellnumber) {
$num++;
$theboxes .= " <TR>
        <TD WIDTH=\"49%\" BGCOLOR=\"#ffffff\">
        <CENTER><B><FONT COLOR=\"#000000\" SIZE=\"-3\" FACE=\"Verdana\">$num</FONT></B></CENTER></TD>
        <TD WIDTH=\"26%\" BGCOLOR=\"#ffffff\">
        <CENTER><INPUT NAME=\"fname$num\" TYPE=\"text\" SIZE=\"-3\"></CENTER></TD>
        <TD WIDTH=\"25%\" BGCOLOR=\"#ffffff\">
        <INPUT NAME=\"femail$num\" TYPE=\"text\" SIZE=\"-3\">
</TD>
      </TR>";
}


?>
<BODY BGCOLOR="#ffffff">
<P><CENTER><FONT FACE="Verdana"><B>Tell your friend about our site</B></FONT></CENTER></P>
<FORM ACTION="tellfriend.php" METHOD="POST"><P><CENTER><TABLE BORDER="0" CELLSPACING="0"
CELLPADDING="0">
  <TR>
    <TD WIDTH="100%" BGCOLOR="#01864E">
    <TABLE WIDTH="340" BORDER="0" CELLSPACING="1" CELLPADDING="2">
      <TR>
        <TD WIDTH="26%" BGCOLOR="#01864E">
        <CENTER><B><FONT COLOR="#ffffff" SIZE="-3" FACE="Verdana">Your Poker Account</FONT></B></CENTER></TD>
        <TD WIDTH="25%">
        <CENTER><B><FONT COLOR="#ffffff" SIZE="-3" FACE="Verdana">Your Email</FONT></B></CENTER></TD>
      </TR>
      <TR>
        <TD WIDTH="150" BGCOLOR="#ffffff">
        <CENTER><INPUT NAME="name" TYPE="text" SIZE="12px"></CENTER></TD>
        <TD WIDTH="200" BGCOLOR="#ffffff">
        <INPUT NAME="email" TYPE="text" SIZE="-3">
</TD>
      </TR>
    </TABLE></TD>
  </TR>
</TABLE></CENTER></P><P><CENTER><TABLE BORDER="0" CELLSPACING="0" CELLPADDING="0">
  <TR>
    <TD WIDTH="100%" BGCOLOR="#01864E">
    <TABLE WIDTH="340" BORDER="0" CELLSPACING="1" CELLPADDING="2">
      <TR>
        <TD WIDTH="49%" BGCOLOR="#01864E"></TD>
        <TD WIDTH="26%" BGCOLOR="#01864E">
        <CENTER><B><FONT COLOR="#ffffff" SIZE="-3" FACE="Verdana">Friends name</FONT></B></CENTER></TD>
        <TD WIDTH="25%">
        <CENTER><B><FONT COLOR="#ffffff" SIZE="-3" FACE="Verdana">Friends email</FONT></B></CENTER></TD>
      </TR><? echo $theboxes; ?></TABLE></TD>
  </TR>
</TABLE></CENTER></P>
<P><CENTER><INPUT NAME="submitform" TYPE="submit" VALUE="Submit"></CENTER></FORM>
<?
exit();

}

?>
</h3>
                                    </td>
                                    </tr>
                                    </table></td>
                                <td width="1" bgcolor="#CCCCCC"></td>
                              </tr>
                              <tr>
                                <td height="1" colspan="3" bgcolor="#CCCCCC"></td>
                              </tr>
                            </table></td>
                          </tr>
                        </table></td>
                      </tr>
                      <tr>
                        <td height="10" align="center" valign="top"></td>
                      </tr>
                                         </table>
</td>
               </tr>
               </table>
               </td>
                </tr>
                <tr>
                  <td align="left" height="17" valign="top" class="style19">
                  &nbsp;</td>
                </tr>
                <tr>
                  <td align="left" height="17" valign="top" class="style19">
                  &nbsp;</td>
                </tr>
              </tbody>
            </table>
            </td>
          </tr>
        </tbody>
      </table>
      </td>
    </tr>
    <tr>
      <td align="left" valign="top">&nbsp;</td>
    </tr>
    <tr>
      <td align="left" valign="top">
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tbody>
          <tr>
            <td align="left" valign="top" width="11"><img
 src="images/footer_bg_left.gif" alt="" height="120" width="11" /></td>
            <td class="footer" align="left" valign="middle">
            <table border="0" cellpadding="0" cellspacing="0"
 width="100%">
              <tbody>
                <tr>
                  <td style="padding-left: 12px;" align="left"
 valign="top" width="260"><img src="images/footer_img.gif" alt=""
 height="110" width="249" /></td>
                  <td align="left" valign="middle">
                  <table border="0" cellpadding="0" cellspacing="0"
 width="100%">
                    <tbody>
                      <tr>
                        <td class="footer_border" align="left"
 valign="top"> <a href="index.php">Homea> | <a href="#">Terms
&amp; Conditions</a> | <a href="#"> Privacy Policy</a> | <a href="#">Site
Map</a> | <a href="#">Contact Us</a></td>
                      </tr>
                      <tr>
                        <td class="footer_border"
 style="font-size: 10px; line-height: 22px;" align="left" valign="top">ReturnTheRake.com
Copyright &copy; 2010, All Rights Reserved.</td>
                      </tr>
                    </tbody>
                  </table>
                  </td>
                </tr>
              </tbody>
            </table>
            </td>
            <td align="left" valign="top" width="11"><img
 src="images/footer_bg_right.gif" alt="" height="120" width="11" /></td>
          </tr>
        </tbody>
      </table>
      </td>
    </tr>
    <tr>
      <td align="left" valign="top">&nbsp;</td>
    </tr>
  </tbody>
</table>
<br />
</body>
</html>

Hi i followed a guid to create a login area to my site however i believe its a little outdated and therefore not working, i have done a little bit but being quite new i cannot find all the problems at the moment i have:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/a9855336/public_html/checklogin.php on line 12
here is my script line 12 is marked

<?php
$host="*************"; // Host name 
$username="a9855**6_root"; // Mysql username 
$password="************"; // Mysql password 
$db_name="****3***36_mail; // Database name 

// Connect to server and select databse.
mysql_connect($host, $username, $password)
mysql_select_db($db_name);

// username and password sent from form 
$myusername=$_POST['myusername']; // line 12
$mypassword=$_POST['mypassword'];

// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

// encrypt password 
$encrypted_mypassword=md5($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$encrypted_mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword"); 
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>

if you help please tell me the error so i can learn to debug scripts myself in the future

thanks

blink359

I have a html for that posts to a form processing script which is fully functional atm,

in the processing script i have if statements, if the condition is met it updates tables in database, if there not met i echo a "not met" statment.

problem is my form processing script just goes straight back to the index.php page using the following code;


header('Location: index.php');



here is the form processing script:

<?php
session_start();

header('Location: index.php');

include "connect.php";

$id = $_SESSION['id'];
$user = $_SESSION['user'];
$ticketNumber = $_POST[ticketNumber];
//echo $_POST[ticketNumber];
$today = date('Y-m-d H:i:s', time() - 3600);

// Query "Ticket" Table to check if user has purchased a "regular" ticket within the last 24 hours
$query24hour = mysql_query("SELECT * FROM tickets WHERE username = '$user' AND HOUR(TIMEDIFF(NOW() , purchaseDate)) < 24;") or die(mysql_error());

// Query "promoTickets" table to grab information of previous tickets bought to the "promotional" auction and LIMIT tickets to 1 per user for "promotional" auctions. 
$querySold = mysql_query("SELECT * FROM promoTickets WHERE promoID='$_POST[promoID]' AND (ticketNumber='$ticketNumber' OR username = '$user');") or die(mysql_error());
//echo $querySold;
$sold = mysql_fetch_assoc($querySold);
//print_r($sold);
//echo $sold;
//echo query24hour;

$querycount24hour = mysql_num_rows($query24hour);
//echo $querycount24hour;

//check if ticket is sold and if user has purchased a "regular" ticket within 24 hours

if(empty($sold)!=FALSE and $querycount24hour >= 1){

//Checks users balance to see if they have enough for the ticket
$queryBal = mysql_query("SELECT user_iskbalance FROM users WHERE username = '$user';") or die(mysql_error());
//echo $querySold;
//echo $user;
//echo $queryBal;
$balArray = mysql_fetch_assoc($queryBal);
$bal = $balArray[user_iskbalance];
$newBal = $bal-$_POST[ticketPrice];



//check if he has the money to buy the ticket
if($bal>=$_POST[ticketPrice]){
//remove the money
$queryBalRemoveal = mysql_query("UPDATE `users` SET `user_iskbalance`='$newBal' WHERE `username`='$user';") or die(mysql_error());

//buy ticket & insert data into "promoTickets" table
$query = mysql_query("INSERT INTO promoTickets(promoID, username, charID, ticketNumber, ticketPrice, purchaseDate) VALUES ('$_POST[promoID]', '$user', '$id', '$_POST[ticketNumber]', '$_POST[ticketPrice]', '$today');") or die(mysql_error());
}
else{
die("Insufficent balance. Please add more ISK") ;
}


}
else{
die("Ticket has already been Sold or you have already bought a ticket to this promotion..!");
}
?>


any way i can get the errors to be passed onto the index.php (with the form) and echo them there?

as it stands errors arnt shown to the users and its confusing people 

I recently switched hosts to DreamHost, and even after a completely clean install of Codesort I'm getting these errors:   The top of the Codesort admin panel: 

Deprecated: Assigning the return value of new by reference is deprecated in /home/fatedus/fatedus/loved/codesort/functions.php on line 35

WARNING: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/fatedus/fatedus/loved/codesort/functions.php:35)

WARNING: Cannot modify header information - headers already sent by (output started at /home/fatedus/fatedus/loved/codesort/functions.php:35)

And displayed on the codes page of my fanlistings is this, too:

Deprecated: Assigning the return value of new by reference is deprecated in /home/fatedus/fatedus/loved/codesort/functions.php on line 35

This is line 35 of the functions.php file:

           $instance =& new $object;

Here is a link to the script for those unfamiliar with it: http://fanupdate.net/codesort.php   Here's a link to one of my fanlisting pages where the error shows up: http://odin.fated.us/codes.php   Also here is a screenshot of what the error looks like inside the Codesort admin panel: http://i.imgur.com/yDlT8d9.png   Help would be really appreciated, this host move has been such a pain. ;c

Hi folks,

I am a complete n00b at php and mysql. I am teaching myself from books and the WWW, but alas I am stuck...

the error I get is:
Parse error: syntax error, unexpected T_STRING in X:\xampp\htdocs\search.php on line 7

here is the code:




<?php
  
  mysql_connect ("localhost", "user", "password") or die (mysql_error());
  mysql_select_db ("it_homehelp_test") or die (mysql_error());
  
  $term = $_POST['term'];
  $sql = $mysql_query(select * from it_homehelp_test where ClientName1 like '%term%');   <<<------this is line 7
  while ($row = mysql_fetch_array($sql)){
   echo 'Client Name:' .$row['ClientName1'];
echo 'Address:' .$row['Address1'];
echo 'Phone:' .$row['Tel1'];
}
?>



Any help you can offer would be great. I can also post the ".html" file that creates the search bar if it is needed.

Thanks

When I open the page in browser it list everything that's in my DB without searching for anything. What is wrong to make it do this?

Code: [Select]
<form method="post" action="<?=$PHP_SELF?>">
<center>
    <table border="0" cellpadding="0" width="100%">
      <tr>
        <td width="30%">
  <p align="right">Search For GID Number:</p></td>
        <td width="80%"><input type="text" name="searchterm"></td>
      </tr>
</table>
</center>
<p align="left">
<input type="submit" value="Search"><br><br>
</form>

<?php
include('fbvar.php');

/*set varibles from form */
$searchterm = $_POST['searchterm'];
trim ($searchterm);

/*check if search term was entered*/
if (!$searchterm){
        echo 'Please enter a search term.';
}
/*add slashes to search term (')(")*/
if (!get_magic_quotes_gpc())
{
$searchterm = addslashes($searchterm);

}

/* connects to database*/
@ $dbconn = new mysqli($databaseserver, $databaseuser, $databasepass, $databasename); 
if (mysqli_connect_errno()) 
{
 echo 'Error: Could not connect to database.  Please try again later.';
 exit;
}

/*query the database*/
$query = "SELECT gid, gift FROM $gifts WHERE gift like '%".$searchterm."%' ORDER BY gid";
$result = $dbconn->query($query);

/*number of rows found*/
$num_results = $result->num_rows;

echo '<p>Found: '.$num_results.'</p>';
/*loops through results*/
for ($i=0; $i <$num_results; $i++)
{
 $num_found = $i + 1;
 $row = $result->fetch_assoc();
 echo "$num_found. ".($row['gid']).' '.($row['gift'])." <br />";
}
/*free database*/
$dbconn->close();
//End of the Search Database form
?>

hello i need a script that sends data from the searchbar to a search.php and there the entries are displayed with the category someone knows how to write it or has someone an example

https://prnt.sc/ujzvuf

I would like to edit this script's SQL query to SELECT FROM multiple tables within my database. Can this be done first of all and what would i need to change?

here's the script:

Code: [Select]
<?php

  // Get the search variable from URL
  $var = @$_GET['q'] ;
  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=10; 

// check for an empty string and display a message.
if ($trimmed == "")
  {
  echo "<p>Please enter a search...</p>";
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }

//connect to your database ** EDIT REQUIRED HERE **
mysql_connect("host","username","password"); //(host, username, password)

//specify database ** EDIT REQUIRED HERE **
mysql_select_db("database name") or die("Unable to select database"); //select which database we're using

// Build SQL Query  
$query = "select * from the_table where 1st_field like \"%$trimmed%\"  
  order by 1st_field"; // EDIT HERE and specify your table and field names for the SQL query

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

// If we have no results, offer a google search as an alternative

if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>";

// google
 echo "<p><a href=\"http://www.google.com/search?q=" 
  . $trimmed . "\" target=\"_blank\" title=\"Look up 
  " . $trimmed . " on Google\">Click here</a> to try the 
  search on google</p>";
  }

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
echo "<p>You searched for: &quot;" . $var . "&quot;</p>";

// begin to show results set
echo "Results";
$count = 1 + $s ;

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["1st_field"];

  echo "$count.)&nbsp;$title" ;
  $count++ ;
  }

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt; 
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";
  
?>

All i want it to do is search a field in 3 different tables in my database called "postcode" and return search results. Ive seen the JOIN feature but don't know how to use it, any help i would appreciate. Thank you.

I am building a simple search engine script for my website which allows users to search for electronic devices that we have in our database.

Here is the HTML code.
Code: [Select]
<form name="search" action="search.php" method="get">
<input type="text" name="query" size="50" />
<input type="submit" name="submit" value="Search" />
</form>

Here is the PHP code.

<?php

error_reporting(0);

include 'config.php';

mysql_connect("localhost", "root", "password") or die(mysql_error());
mysql_select_db("maindatabase") or die(mysql_error());

// get the data from the form
$search_query = $_GET['query'];

// mysql query
$query = mysql_query("SELECT * FROM `products` WHERE productName LIKE '%$search_query%'");
$count_rows = mysql_num_rows($query);

echo "Results found: " . $count_rows;

?>


Here is the problem:

Whenever I enter  a single keyword in the search, the search brings some results. BUT, whenever I enter multiple keywords, the search brings 0 rows. For example:

I have a product called Sony Bravia Television 42 inches - 1080p HD in my database. When type "sony" in the search and press the search button, I only get 1 row as the result. But when I enter "sony television" in the seach, I get 0 row results. Why is that? What can I do to fix this problem? I want to return results that contain all the keywords that the search query had. Just like any search engine: Google, Yahoo, etc.

I wrote this script to query the database and get the count between timestamps. I'm using strtotime to convert the user selected date and the pre-selected times into a usable timestamp to search with. I've echo the first one to ensure that it's creating the correct timestamp with time and it is. The problem is that it's returning data that's outside of the time. I don't know if it's my php or mysql, so I was hoping one of you could help. Thanks!

Code: [Select]
<?php

/**
 * @author William Morris
 * @copyright 2010
 */
 
include('inc/db.php');

$startdate = "2010-07-01";
$enddate = "2010-08-05";

echo "Start Date: ".$startdate."<br>";
echo "End Date: ".$enddate."<br>";


//convert dates into timestamp
$startdate1 = strtotime($startdate."00:00:00");
$enddate1 = strtotime($enddate."11:59:59");

echo "Start Date 1: ".$startdate1."<br>";
echo "End Date 1: ".$enddate1."<br>";

//convert dates into morning timestamp
$startdate1 = strtotime($startdate."06:00:00");
$enddate1 = strtotime($enddate."11:59:59");

$sql = mysqli_query($conn, "SELECT COUNT(event_time) FROM `event` WHERE event = 'Registration' 
AND event_time BETWEEN '$startdate1' AND '$enddate1'");

$row = mysqli_fetch_array($sql);

//convert dates into afternoon timestamp
$startdate2 = strtotime($startdate."12:00:00");
$enddate2 = strtotime($enddate."17:59:59");

$sql1 = mysqli_query($conn, "SELECT COUNT(event_time) FROM `event` WHERE event = 'Registration' 
AND event_time BETWEEN '$startdate2' AND '$enddate2'");

$row1 = mysqli_fetch_array($sql1);

//convert dates into Evening timestamp
$startdate3 = strtotime($startdate."18:00:00");
$enddate3 = strtotime($enddate."23:59:59");

$sql2 = mysqli_query($conn, "SELECT COUNT(event_time) FROM `event` WHERE event = 'Registration' 
AND event_time BETWEEN '$startdate3' AND '$enddate3'");

$row2 = mysqli_fetch_array($sql2);

//convert dates into night timestamp
$startdate4 = strtotime($startdate."00:00:00");
$enddate4 = strtotime($enddate."05:59:59");

$sql3 = mysqli_query($conn, "SELECT COUNT(event_time) FROM `event` WHERE event = 'Registration' 
AND event_time BETWEEN '$startdate4' AND '$enddate4'");

$row3 = mysqli_fetch_array($sql3);




echo "<table width='50%' border='0'>
  <tr>
    <td bgcolor='#d3d3d3'><div align='center'>Morning (6am-12pm)</div></td>
    <td bgcolor='#d3d3d3'><div align='center'>Afternoon (12pm-6pm)</div></td>
    <td bgcolor='#d3d3d3'><div align='center'>Evening (6pm-12am)</div></td>
    <td bgcolor='#d3d3d3'><div align='center'>Night (12am-6am)</div></td>
  </tr>";

echo "<tr>
    <td><div align='center'>".$row['COUNT(event_time)']."</div></td>
    <td><div align='center'>".$row1['COUNT(event_time)']."</div></td>
    <td><div align='center'>".$row2['COUNT(event_time)']."</div></td>
    <td><div align='center'>".$row3['COUNT(event_time)']."</div></td>
  </tr>";

echo "</table>";

?>