PHP - Show Records Horizontal: Syntax Error, Unexpected T_string

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

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

can't seem to find the error. helppp


Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /export/SOI-50/students/m2009/abhr428/web/WebIbs/view_user.php on line 20

<?php

require_once( "common.inc.php");
require_once( "config.php" );
require_once( "users.class.php" );
require_once( "LogEntry.class.php" );


$userid = isset( $_GET["userid"] ) ? (int)$_GET["userid"] : 0;


   if ( !$user = user::getuser( $userid) ) {
   displayPageHeader( "Error" );
   echo "<div>User not found.</div>;
   displayPageFooter();
   exit;
}

$logEntries = LogEntry::getLogEntries( $userid );
displayPageHeader( "View user: ". $user->getValueEncoded( "usr_name")
." ". $user->getValueEncoded( "usr_surname") );

?>

   <dl style="width: 30em;">
   <dt>Username</dt>
   <dd><?php echo $user->getValueEncoded( "usr_username" ) ?></dd>
   <dt>First name</dt>
   <dd><?php echo $user->getValueEncoded( "usr_name" ) ?></dd>
   <dt> Last name</dt>
   <dd><?php echo $user->getValueEncoded( "usr_surename" ) ?></dd>
   <dt>Joined on</dt>
   <dd><?php echo $user->getValueEncoded( "usr_recordtime") ?></dd>
   <dt>Last time active</dt>
   <dd><?php echo $user->getValueEncoded( "usr_lastlogintime" ) ?></dd>
   
   </dl>
   
   <h2> Access Log </h2>
   
   
   <table cellspacing="0" style="width":30em; border: 1px solid #667;">
   <tr>
      <th>Web Page</th>
      <th>Number of visits</th>
      <th> Last visit</th>
   </tr>
   
   <?php
      
      $rowCount = 0;
      foreach ~( $logEntries as $logEntry ) {
      $rowCount++;
   ?>
   
   
       <tr<?php if ( $rowCount % 2 == 0 ) echo ' class="alt"' ?>>
        <td><?php echo $logEntry->getValueEncoded( "pageUrl" ) ?></td>
        <td><?php echo $logEntry->getValueEncoded( "numVisits") ?></td>
        <td><?php echo $logEntry->getValueEncoded( "lastAccess") ?> </td>
       
        </tr>
       
      <?php
    
    
     </table>
    
     <div style="width: 30em; margin-top: 20px; text-align: center;">
        <a href="javascript:history.go(-1)">back</a> 
    </div>
   
    <?php
    displayPageFooter();
    ?>
   
     

SET UP: Windows vista
# XAMPP 1.7.3,
# Apache 2.2.14 (IPv6 enabled) + OpenSSL 0.9.8l
# MySQL 5.1.41 + PBXT engine
# PHP 5.3.1
# phpMyAdmin

After entering various different information from previous forms on different pages I finally get this error message "Parse error: syntax error, unexpected T_STRING in C:\blablah on line 31" on the following code:


<?php

//let's start our session, so we have access to stored data
session_start();

include 'db.inc.php';

$db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD) or 
    die ('Unable to connect. Check your connection parameters.');
mysql_select_db(MYSQL_DB, $db) or die(mysql_error($db));

//let's create the query
$query = 'INSERT INTO subscriptions (name, email_address, membership_type, terms_and_conditions,
name_on_card,
credit_card_number, credit_card_expiration_data)
VALUES (
"' . $_SESSION[$name, $db] . '",
' . $_SESSION[$email_address, $db] . '",
' . $_SESSION[$membership_type, $db] . '",
' . $_SESSION[$terms_and_conditions, $db] . '",
' . $_POST[$name_on_card, $db] . '",
' . $_POST[$credit_card_number, $db] . '",
' . $_POST[$credit_card_expiration, $db] . ')';

if (isset($query)) {
        $result = mysql_query($query, $db) or die(mysql_error($db));
}
?>
<p>Done!</p>
</body>
</html>

?>

Any help would be appreciated. I'm practicing this with the ambition to develop a multi-page registration using sessions for a website so even web pages that might help me with this aim would be good.

I Can't find the problem. The code:

mysql_query("insert into games(week, fight, league_id)values($_REQUEST['week'],'$_REQUEST[home_team]-$_REQUEST[guest_team]',$_REQUEST['home_league'])", $Link);

The error message:   Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING    

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>

Hey guys,

I am getting the same error and I can't figure out why, I've double checked all my brackets and everything. It's probably just something simple but once you've been staring at it for ages you can't see very much.

My code is:
Code: [Select]
if (isset($_POST['Submit'])) {
    if (isset($_POST['username'] == '***') && ($_POST['password'] == '***')) { //THIS IS THE LINE
$_SESSION['username'] = 'login';
    }
else {
echo "<b>Your login details are not correct. Please login again</b>";
    }
}

I've highlighted the line that the error appears on , can anybody help me? 

Hi,

I was wondering if somebody can help me with an error I am getting.

Here is my code:

Code: [Select]
if ($_SESSION['username']=='login') {
   if (isset($_REQUEST['file'])) {
       $fc = file_get_contents($_REQUEST['file']);
       $text = explode("<!-- EDITABLE -->",$fc);
       echo "<form method='post' action=''><textarea name='content'>$text[1]</textarea>";
       echo "<p><input type='hidden' name='file' value='".$_REQUEST['file']."' /><input name='submitUpdate' type='submit' value='Update Page'></form>";
   }
   else {
      echo "<p align='center'>
       <a href="index.html">Home Page</a><br/> //THIS IS THE LINE THAT IS GIVING THE ERROR
       <a href="contact_us.html">Contact Us</a><br/>
       <br/>
       <em>Click on the links above to edit the files.</em><br/>
      <a href="?logout">logout</a></p>";
   }
}

This code is within php tags is that correct? As I am coding in notepad ++ and it doesn't have any colour which makes me think something is wrong.

If someone could help that would be brilliant! Thanks in advance

Hey there,

I was having that error message (Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in) in this line:
 echo "<td>" . $row['name'] . "</td>";

And fixed it with:
 echo "<td>" . $row[".name."] . "</td>";


It seems to work fine, but this is the right way?
Thank you in advance.


EDIT: Nop, it didnt do the job xD

Can anyone tell me what's wrong with this particular part of my php code?
$handle = fopen(''lovell.txt, ''a'');
That was the line it said there was an issue with, and I'm new and can't seem to figure it out.

Well I see a tutorial of Ajax tabs system, but it uses html code to display the tab instead of php. Therefore, I made a tiny bit of changes, but got this weird T_STRING error on line111, where $text is defined. Here is the script I currently have:

Code: [Select]
<style type="text/css">
body
{
font-family: Arial;
font-size: 12px;
}
.container
{
float: left;
width: 400px;
border: 1px solid #000000;
}
.navcontainer ul
{
background-color: #5F707A;
border-bottom:1px solid #DFDFDF;
border-top:1px solid #DFDFDF;
float:left;
font-family:arial,helvetica,sans-serif;
font-size:12px;
margin:0pt;
padding:0pt;
width:100%;
}
.navcontainer ul li
{
display: inline;
text-align: center;
}
.navcontainer ul li a:hover
{
background-color:#CCCCCC;
color:#FFFFFF;
}
.navcontainer ul li a
{
border-right:1px solid #DFDFDF;
background-color: #BBBBBB;
font-weight: bold;
color:#FFFFFF;
float:left;
padding:10px;
text-decoration:none;
width: 50px;
}
.navcontainer ul li a.current
{
border-right:1px solid #f00;
background-color: #f00;
font-weight: bold;
color:#fff;
float:left;
padding:10px;
text-decoration:none;
width: 50px;
}
#tabcontent
{
min-height: 200px;
padding-top: 80px;
padding-left: 10px;
}
#preloader
{
position: absolute;
top: 150px;
left: 100px;
z-index: 100;
padding: 5px;
text-align: center;
background-color: #FFFFFF;
border: 1px solid #000000;
}
</style>
<script type="text/javascript" src="jquery-1.2.3.pack.js"></script>
<script type="text/javascript">

function loadTabContent(tabUrl){
$("#preloader").show();
jQuery.ajax({
url: tabUrl,
cache: false,
success: function(message) {
jQuery("#tabcontent").empty().append(message);
$("#preloader").hide();
}
});
}

jQuery(document).ready(function(){

$("#preloader").hide();
jQuery("[id^=tab]").click(function(){

// get tab id and tab url
tabId = $(this).attr("id");
tabUrl = jQuery("#"+tabId).attr("href");

jQuery("[id^=tab]").removeClass("current");
jQuery("#"+tabId).addClass("current");

// load tab content
loadTabContent(tabUrl);
return false;
});
});

</script>
<?php

$text="<div class="container">
<div class="navcontainer">
<ul>
<li><a id="tab1" href="tabs.php?id=1">Google</a></li>
<li><a id="tab2" href="tabs.php?id=2">Yahoo</a></li>
<li><a id="tab3" href="tabs.php?id=3">Hotmail</a></li>
<li><a id="tab4" href="tabs.php?id=4">Twitter</a></li>
</ul>
</div>

<div id="preloader">
<img src="loading.gif" align="absmiddle"> Loading...
</div>

<div id="tabcontent">
Simple AJAX Tabs
</div>
</div>";
      echo $text;
?>

Can anyone of you please tell me how to fix this problem? Thanks.

Hello,

I have this error and I cant figure out what is causing it , anyone able to help?

Error:
Code: [Select]
Parse error: syntax error, unexpected T_STRING in /home/******/public_html/******/manage.php on line 54
Line 45:
Code: [Select]
$result = mysql_query(SELECT * FROM p8_subscribers) or die(mysql_error());
Here is my code:

Code: [Select]
<?php
include('config.php');
include('functions.php');

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-us" dir="ltr">
<head>

<title>JneroMailer</title>
<link href="./style.css" media="screen" rel="stylesheet"/>

</head>
<body>
<div class="container">
<div id="navigation">
<ul id="menu">
<li><a  href="./index.php">Home</a></li>
<?php if(isset($_SESSION['loggedin'])) 
{ 
echo "
<li><a href='./newsletter.php'>Send Newsletter</a></li>
<li><a href='./manage.php'>Manage Subscribers</a></li>
<li><a href='./archive.php'>Newsletter Archive</a></li>
<li><a href='./index.php?logout'>Logout</a></li>"; 
} 
?>
</ul>
</div>
<div id="header">
<div id="logo"></div>
<form action="./index.php?login" method="post">
<div id="login">
<?php 
if(!isset($_SESSION['loggedin'])) 
{ 
echo "Username: <input type='text' name='username' /> ";
echo "Password: <input type='password' name='password' />";
echo "<input type='submit' name='login_go' value='Login' />"; 
} else { 
echo "Welcome <b>".$_SESSION['username']."</b>"; 
} 
?>
</div>
</form>
</div>
<div id="content">
<h2>Manage Subscribers</h2>

<?php
if(isset($_SESSION['loggedin'])) 
{ 

$result = mysql_query(SELECT * FROM p8_subscribers) or die(mysql_error());
echo "<table border='1'>";
echo "<tr>";
echo "<th>ID</th><th>Name</th><th>Email</th><th>Active</th><th>Authorization</th><th>Edit</th><th>Delete</th>";
echo "</tr>";
while($row = mysql_fetch_array( $result )) {
echo "<tr>"
echo "
<td>".$row['id']."</td>
<td>".$row['name']."</td>
<td>".$row['email']."</td>
<td>".$row['active']." <a href='./activate.php?activate=".$row['id']."&auth=".$row['authorization']."'>Force Activate</a></td>
<td><a href='./edit.php?sub=".$row['id']."><img src='./images/edit.png' alt='Edit' border='0' /></a></td>
<td><a href='./edit.php?sub=".$row['id']."&delete=yes'><img src='./images/delete.png' alt='Delete' border='0' /></a></td>
</tr>";

}
echo "</table>";
} else {
echo "YOU ARE NOT AUTHORIZED TO ACCESS THIS PAGE";
}
?>

</div>
</div>
<div id="footer">
<div class="container">
Copyright 2011 <a href="http://www.JneroCorp.biz">JneroCorp</a> - JneroMailer
</div></div>
</body>
</html>