PHP - Parse Error Can't Find

echo "</select></td>\r\n  </tr>\r\n \r\n <tr>\r\n <td align=\"right\">Total Views Allowed:</td>\r\n <td><input type=\"text\" id=\"ad_total_views\" style=\"width:50px;\" value=\"\" disabled=\"disabled\" /> <label><input type=\"checkbox\" checked=\"checked\" onclick=\"if(this.checked==true){$('#ad_total_views').val('');$('#ad_total_views').attr('disabled','disabled');}else{$('#ad_total_views').val('');$('#ad_total_views').removeAttr('disabled');$('#ad_total_views').focus()}\" />Unlimited</label></td>\r\n          </tr>\r\n            \r\n            <tr>\r\n              <td align=\"right\">Total Clicks  Allowed:</td>\r\n              <td><input type=\"text\" id=\"ad_total_clicks\" style=\"width:50px;\" value=\"\" disabled=\"disabled\" /> <label><input type=\"checkbox\" checked=\"checked\" onclick=\"if(this.checked==true){$('#ad_total_clicks').val('');$('#ad_total_clicks').attr('disabled','disabled');}else{$('#ad_total_clicks').val('');$('#ad_total_clicks').removeAttr('disabled');$('#ad_total_clicks').focus()}\" />Unlimited</label></td>\r\n          </tr>\r\n        </table></td>\r\n   </tr>\r\n    <tr bgcolor=\"#FFFFFF\">\r\n     <td class=\"td_th\" align=\"center\">Smarty Code (Developer)</td>\r\n     <td>{\$ads->getAdCode(<span id=\"smartycode\">1</span>)}</td>\r\n   </tr>\r\n    <tr bgcolor=\"#FFFFFF\">\r\n      <td class=\"td_th\" align=\"center\">&nbsp;</td>\r\n      <td><input type=\"button\" value=\"Create New Campaign\" onclick=\"new_ad()\" /></td>\r\n    </tr>\r\n    </TBODY></TABLE>\r\n<br />\r\n\r\n<TABLE cellSpacing=1 cellPadding=4 width=\"100%\"  border=0>\r\n  <TBODY>\r\n  <TR class=\"td_title\">\r\n    <TD  colSpan=7>Ad Campaigns</TD></TR>\r\n  <TR bgColor=#ffffff>\r\n  \r\n    <TD width=\"10%\" align=\"center\" class=\"td_th\">&nbsp;</TD>\r\n    <TD width=\"4%\" align=\"center\" class=\"td_th\">ID</TD>\r\n    <TD width=\"29%\" align=\"center\" class=\"td_th\">Campaign Name</TD>\r\n    <TD width=\"12%\" align=\"center\" class=\"td_th\">Start Date</TD>\r\n    <TD width=\"11%\" align=\"center\" class=\"td_th\">End Date</TD>\r\n    <TD width=\"17%\" align=\"center\" class=\"td_th\">Viewed / Views Allowed</TD>\r\n    <TD width=\"17%\" align=\"center\" class=\"td_th\">Clicked / Clicks Allowed</TD>\r\n    </TR>\r\n ";

Hi

I'm not sure if this needs to be in the MySQL forum so bare with me.

I have small script which parses an RSS feed and inserts data into a table. This all works fine, but my problem now, is that I have another table, which has logos and when i parse the RSS, I'd like to be able to pass in the logo from the logos table into the RSS parse table.

The problem is the RSS feed are products, with different suppliers, so I need to somehow check which manufacturer it is and then insert the image_id from the images table.

I have a field in the main table, which has things like 'Available at Amazon' and 'Available at Play.com'

What I want is some kind of join/like clause, where I can check, for example the word 'Amazon' in one field and match it to the images table.

schema of both tables
rss_table
id, title, message, price, logos_id
1, iPad, Available at Apple, 400.00, BLANK_ID

logos
id, name, src
2, Apple, apple-logo.jpg

So you can see, any product that gets parsed that has is available at apple, needs to have the logos_id of 2, if that makes sense?

Below is a small snippet of my code (it isn't brilliant but works)

I just need to then need to find the corresponding image to the manufacturer

<?php

$test = $_POST['post_title'];

$articles = array();
$easy_url = $_POST["url"];

$rawFeed = file_get_contents($easy_url);
$xml = new SimpleXmlElement($rawFeed);

$channel = array();
$channel['title']       = $xml->channel->title;
$channel['link']        = $xml->channel->link;
$channel['description'] = $xml->channel->description;

foreach ($xml->channel->item as $item)
{
        $article = array();
        $article['title'] = $item->title;
        $article['link'] = $item->link;
        $article['description'] = (string) trim($item->description);

preg_match_all('/&#38;#xA3;([0-9.]+)/', $item->description, $results);
foreach ($results as $k => $v) {
}

$all = '&#38;#xA3;'.$v[0];
$price_stripped = str_replace($all, '', $item->description);
$desc = preg_match('/&#38;#xA3;([0-9.]+)/', $item->description);

preg_match_all('/~#&pound;([0-9.]+)/', $item->description, $discount);
foreach ($discount as $d => $disc) {
str_replace("~#&pound;","", $disc[0]);
}

preg_match_all('/&pound;([0-9.]+)/', $item->description, $delivery_cost);
foreach ($delivery_cost as $del => $deliv) {
}
   
preg_match_all('/\|(.*?)\./',$item->description,$match);           
        foreach ($match as $rel => $retail) {
  $retail[0] = str_replace("|","", $retail[0]);
}   

//$retail_logo = str_replace('On sale at', '', $retail[0]);

$connection = mysql_connect("localhost","root","password");
if (!$connection)
{
  die('Could not connect: ' . mysql_error());
}

$total = $v[0] + $deliv[0] - $disc[0];

mysql_select_db("db_test", $connection);

mysql_query("INSERT INTO rss (title,  price, retailer_message,  logo_id)
VALUES ('$item->title', '$price_stripped', '$retail[0]', '$logo_id')");

mysql_close($connection);

}

?>


Any help is appreciated.

Thanks

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\mywork\unique.php on line 15


<html>
<head>
<title>

</title>
</head>
<body bgproperties="fixed">
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$con = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'mywork';
mysql_select_db($dbname, $con);
$sql=mysql_query(insert into users (regno,name,gender,date,month,year,emailid,cell,paddress,caddress,incometype,incomeamt,dad,fyes,dadocup,mom,myes,momocup,password) VALUES ('$_POST[regno]','$_POST[name]','$_POST[gender]','$_POST[date]','$_POST[month]','$_POST[year]','$_POST[emailid]','$_POST[cell]','$_POST[paddress]','$_POST[caddress]','$_POST[incometype]','$_POST[incomeamt]','$_POST[dad]','$_POST[fyes]','$_POST[dadocup]','$_POST[mom]','$_POST[myes]','$_POST[momocup]','$_POST[password]')");
$sql1=mysql_fetch_array($sql);
$result = @mysql_query($SQl1);
$result="SELECT * FROM users WHERE regno='$regno'";
while($row = mysql_fetch_array($result))
{
    //echo $row['regno']."regno<br>";
//echo $row['name']."name<br>";
//echo $row['gender']."gender<br>";
//echo $row['date']."date<br>";
//echo $row['month']."month<br>";
//echo $row['year']."year<br>";
//echo $row['emailid']."emailid<br>";
//echo $row['cell']."cell<br>";
//echo $row['paddress']."paddress<br>";
//echo $row['caddress']."caddress<br>";
//echo $row['incometype']."incometype<br>";
//echo $row['incomeamt']."incomeamt<br>";
//echo $row['dad']."dad<br>";
//echo $row['fyes']."fyes<br>";
//echo $row['dadocup']."dadocup<br>";
//echo $row['mom']."mom<br>";
//echo $row['myes']."myes<br>";
//echo $row['momocup']."momocup<br>";
//echo $row['password']."password<br>";

}
echo "Thanks for Register!";
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";
mysql_close($con);
?>
<form name="security" action="index.php" method="post">

<input type="submit" value="click here to login">
</form>
</body>
</html>

Code: [Select]
This is a clip of my PHP file:
<?php
$con = mysql_connect($host,$username,$password);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db($database, $con);

$result = mysql_query("SELECT * FROM purchase_order
WHERE purchase_order_number=='$purchase_order_number'");

while($row = mysql_fetch_array($result))
  {
$vendor=$row['vendor'];
$purchase_order_date=$row['purchase_order_date'];
$ship=$row['ship'];
$state=$row['state'];
$fob=$row['fob'];
$terms=$row['terms'];
$buyer=$row['buyer'];
$freight=$row['freight'];
$req_date=$row['req_date'];
$confirming_to=$row['confirming_to'];
$remarks=$row['remarks'];
$tax=$row['tax']
 } // [i][u][b]<-- This is line 88 (The one with the error)[/b][/u][/i]
?>Thanks in advance!

Code: [Select]
<?php
mysql_connect ("-","-","-") or die ('Error');
mysql_select_db ("-");

$out = mysql_query("SELECT * FROM guestbook ORDER BY id DESC");

while($row = mysql_fetch_assoc($out); --and this one if that braces is deleted
{ ----this is where im getting the error
$name = $row['name'];
$email = $row['email'];
$txt = $row['comment'];

        $msg = "Are you sure you want to delete";

/* @var $_REQUEST <type> */
if (isset($_REQUEST ["action"]) && $_REQUEST["action"] == "del") 
    {
                    $id = intval($_REQUEST['id']);
                    mysql_query("DELETE FROM guestbook WHERE id=$id;");
                   echo "<action=index.php>";
                }

echo "<font face='verdana' size='1'>";
echo "<table border='0'>
<tr><td>Name: ".$name."</td></tr>"."
<tr><td>Email: ".$email."</td></tr>
<tr><td colspan='2'>Comment:</td></tr>
<tr><td colspan='2' width='500'><b>".$txt."</b></td></tr>
                     <tr><td><a onclick=\"return confirm('.$msg.');\" href='index.php?action=del&amp;id=".$row['id']."'><span class='red'>["."Delete"."]</span></a>
                        </td></tr>
  </table><br />";


echo "<hr size='1' width='500' align='left'></font>";
}
?>

Kindly help me please. When i delete ({) the error will become the ( i dont know what to do already. Thanks.

I don`t get it, waht is wrong?!
Code: [Select]
<?php
require_once 'auth.php';
if (!isset($_SESSION['SESS_VERIFY'])) {
header("location: access-denied.php");
exit();
}
if ($_SESSION['lang'] == 'Ro') {

// setare data romania
date_default_timezone_set('Europe/Bucharest');

$today = getdate();


$zi = $today['mday'];
$luna = $today['mon'];
$lunastring = $today['month'];
$an = $today['year'];
$data = $zi.$luna.$an;
$data = (string)$data;
$ora = date('H:i:s'); 

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

$luni = array (
1=>'Ianuarie',
2=>'Februarie',
3=>'Martie',
4=>'Aprilie',
5=>'Mai',
6=>'Iunie',
7=>'Iulie',
8=>'August',
9=>'Septembrie',
10=>'Octobrie',
11=>'Noiembrie',
12=>'Decembrie');

// comun
const SQL_ERR = 'SQL statement failed with error: ';
const ADD_MODEL = 'ADAUGA UN MODEL NOU';
.
.many constants..
.
}
elseif ($_SESSION['lang'] == 'It') {...

Thank you!

I have been trying to get my files to upload onto a computer and I receive this message: Parse error: syntax error, unexpected T_STRING in /home/content/19/6550319/html/listing.php on line 27. Line 27 is how the php logs into my SQL. The problem is that I was able to log in before. I just made changes to the form by adding a dropdown menu and price and now it says it doesnt parse.

Can anyone figure this out. I will include the code without the login information because the forum is public but I did put the words left out for you to see where I took out the passcodes.

Code: [Select]
<?php




//This is the directory where images will be saved
$target = "potofiles/";
$target = $target . basename( $_FILES['photo']['name']);

//This gets all the other information from the form
$price=$_POST['price'];
$gig=$_POST['giga'];
$yesg=$_POST['yesg'];
$pic=($_FILES['photo']['name']);
$pic2=($_FILES['phototwo']['name']);
$pic3=($_FILES['photothree']['name']);
$pic4=($_FILES['photofour']['name']);
$description=$_POST['iPadDescription'];
$condition=$_POST['condition'];
$fname=$_POST['firstName'];
$lname=$_POST['lastName'];
$email=$_POST['email']



// Connects to your Database
mysql_connect ("left out", "left out", "left out") or die(mysql_error()) ;
mysql_select_db("left out") or die(mysql_error()) ;

//Writes the information to the database
mysql_query("INSERT INTO listing (price,giga,yesg,photo,phototwo,photothree,photofour,iPadDescription,condition,firstName,lastName,email)
VALUES ('$price', '$gig', '$yesg', '$pic', '$pic2', '$pic3', '$pic4', '$description', '$condition', '$fname', '$lname', '$email')") ;

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{

//Tells you if its all ok
echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory";
}
else {

//Gives and error if its not
echo "Sorry, there was a problem uploading your file.";
}

echo date("m/d/y : H:i:s", time()) 


?>

Hello everyone,
I am a total newbie in PHP and so do here. I am trying to build a table consisting foreign key and primary key and it is showing error like "Parse error: syntax error, unexpected 'cities' (T_STRING) in line number 29". I have marked up my lines according to sublime text 3 editor. I am trying to create a database. 

 

1 <?php
2 $servername = "localhost";
3 $username = "username";
4 $password = "password";
5 $dbname = "newDB";

7 // Create connection
8 $conn = new mysqli($servername, $username, $password, $dbname);

10 // Check connection
11 if ($conn->connect_error) {
12   die("Connection failed: " . $conn->connect_error);}

14 $firstname = $conn->real_escape_string($_REQUEST['firstname']);
15 $lastname = $conn->real_escape_string($_REQUEST['lastname']);
16 $address = $conn->real_escape_string($_REQUEST['address']);
17 $city = $conn->real_escape_string($_REQUEST['city']);
18 $country = $conn->real_escape_string($_REQUEST['country']);
19 $phone_number = $conn->real_escape_string($_REQUEST['phone_number']);
20 $email = $conn->real_escape_string($_REQUEST['email']);
 
22 // Attempt insert query execution
23 $sql1 = "INSERT INTO cities VALUES ('$city')";

25 $sql2 = "INSERT INTO countries VALUES ('$country')";

27 $sql3 = "INSERT INTO Contacts (firstname, lastname, address, city, country, phone, email) VALUES ('$firstname', '$lastname', '$address', $city, $country, '$phone_number','$email')";

29 SELECT * FROM cities;
SELECT * FROM countries;
SELECT * FROM Contacts;

if($conn->query($sql1) === true){
    echo "City added successfully.";
} else{
    echo "ERROR: Could not able to execute " . $conn->error;
}

if($conn->query($sql2) === true){
    echo "Çountry added successfully.";
} else{
    echo "ERROR: Could not able to execute " . $conn->error;
}

if($conn->query($sql3) === true){
    echo "Çontact added successfully.";
} else{
    echo "ERROR: Could not able to execute " . $conn->error;
}
 
// Close connection
$conn->close();
?>

I just enabled error reporting and I am not that familiar with it.  I know I have an error some where around line 33.  I know I am missing a bracket or a comma or some other syntax error I just cannot find where the error is.  Below is my script.
Thanks for any help.

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Airline Survey</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<meta name="author" content="Revised by abc1234"/>
</head>
<body>
<?php
$WaitTime = addslashes($_POST["wait_time"]);
$Friendliness = addslashes($_POST["friendliness"]);
$Space = addslashes($_POST["space"]);
$Comfort = addslashes($_POST["comfort"]);
$Cleanliness = addslashes($_POST["cleanliness"]);
$Noise = addslashes($_POST["noise"]);
if (empty($WaitTime) ||
    empty($Friendliness) ||
    empty($Space) ||
empty($Comfort) ||
    empty($Cleanliness) ||
    empty($Noise))
    echo "<hr /><p>You must enter a value in each field. Click
     your browser's Back button to return to the form.</p><hr />";
else {
        $Entry = $WaitTime . "\n";
        $Entry .= $Friendliness . "\n";
        $Entry .= $Space . "\n";
        $Entry .= $Comfort . "\n";
        $Entry .= $Cleanliness . "\n";
        $Entry .= $Noise . "\n";
        $SurveyFile = fopen("survey.txt", "w")
}
        if (flock($SurveyFile, LOCK_EX)) {
                if (fwrite($SurveyFile, $Entry) > 0) {
                        echo "<p>The entry has been successfully added.</p>";
                        flock($SurveyFile, LOCK_UN;
                        fclose($SurveyFile);
  else
                        echo "<p>The entry could not be saved!</p>";
        }
        else
                echo "<p>The entry could not be saved!</p>";
}
?d>
<p><a href="AirlineSurvey.html">Return to Airline Survey</a></p>
</body>
</html>

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

Hey, Its something to do with the ' or \ I know that as Ive been trying alot.
Code Code: [Select]
if ($this->isAdmin && count ($func_players) > SettingsManager::GetSetting(Settings::BAN_LIMIT))
return $this->sendErrorBox('max', 'You can\'t ban that many Users at once!', 'Gosh', 'iBan');

      foreach($func_players as $func_player) $func_player->ban(&this->playerName, $this->isAdmin);
  return $this->sendErrorBox('max', sprintf(
  '%s ha%s been banned.'
  $this->getPlayerString($func_players),
   count($func_players) == 1 ? 's' : 've'),
   'SykoPwns:P', 'Sykos:iBan');
Thanks for your help! Ive tried alot of things I think I could just take out the \ or something!!

sorry this was the actuall php code for this error...



<?php

require_once "DataObject.class.php";

class LogEntry extends DataObject {

   protected $data = array(
   "userid" => "",
   "pageUrl" => "",
   "numVisits" => "",
   "lastAcces" => "",
);

public static function getLogEntries( $userid ) {
   $conn = parent::connect();
   $sql = "SELECT * FROM " . TBL_accesslog . " WHERE userid = : userid
   
   ORDER BY lastAcces DESC";
   
   try {
      $st = conn->prepare( $sql );
      $st->bindValue( ":userid", $userid, PDO::PARAM_INT );
      $st->execute();
      $logEntries = array();
      foreach ( $st->fetchAll() as $row ) {
         $logEntries[] = new logEntry( $row);
      }
      
      parent::disconnect( $conn );
      return $logEntries;
   }   catch ( PDOExeception $e ) {
      parent::disconnect( $conn );
      die( "Query failed: " . $e->getMessage() );
      
      }   
   }
   
}

?>