|
PHP - Want To Remove Block Of Php Code But Get Unexpected End Of File Error
Hi
By the the way the server this site is hosted on is flipping fast! I'm still a php beginner. I have a php file, the entire code is he <?php get_header(); ?> <?php if(!is_paged()) { ?> <div id="top" class="clearfloat"> <div id="headline"> <?php if ( function_exists('show_nivo_slider') ) { show_nivo_slider(); } ?> </div> <div id="featured"> <?php if ( !function_exists('dynamic_sidebar') || !dynamic_sidebar(8) ) : ?> <?php endif; ?> </div> </div> <div id="middle" class="clearfloat"> <?php $display_categories = array(7, 13, 17, 18, 1528); $i = 1; foreach ($display_categories as $category) { ?> <div id="cat-<?php echo $i; ?>" class="category"> <?php query_posts("showposts=1&cat=$category")?> <span class="cat_title"><a href="<?php echo get_category_link($category);?>"><?php single_cat_title(); ?></a></span> <a href="<?php echo get_category_link($category);?>"></a> </div> <?php $i++; ?> <?php } ?> </div> <?php } ?> <div id="bottom" class="clearfloat"> <div id="front-list"> <?php $page = (get_query_var('paged')) ? get_query_var('paged') : 1; query_posts("cat=-27,-28&paged=$page&posts_per_page=10"); ?> <?php while (have_posts()) : the_post(); ?> <div class="clearfloat"> <h3 class=cat_title><?php the_category(', '); ?> »</h3> <div class="title"><a href="<?php the_permalink() ?>" rel="bookmark"><?php the_title(); ?></a></div> <div class="meta">[<?php the_time('j M Y') ?> | <?php comments_popup_link('No Comment', 'One Comment', '% Comments');?> | <?php if(function_exists('the_views')) { the_views(); } ?>]</div> <div class="spoiler"> <?php $values = get_post_custom_values("Image"); if (isset($values[0])) { ?> <a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>"> <img src="<?php echo bloginfo('template_url'); ?>/scripts/timthumb.php?src=/<?php $values = get_post_custom_values("Image"); echo $values[0]; ?>&w=150&h=150&zc=1&q=100" alt="<?php the_title(); ?>" class="left" width="150px" height="150px" /></a> <?php } ?> <?php the_excerpt(); ?> </div> </div> <?php endwhile; ?> <div class="navigation"> <?php if(function_exists('wp_pagenavi')) { wp_pagenavi(); } else { ?> <div class="right"><?php next_posts_link('Next Page »') ?></div> <div class="left"><?php previous_posts_link('« Previous Page') ?></div> <?php } ?> </div> </div> <?php get_sidebar(); ?> </div> <?php get_footer(); ?> I want to remove the following block on line 19 to 33 because I don't need it: <?php $display_categories = array(7, 13, 17, 18, 1528); $i = 1; foreach ($display_categories as $category) { ?> <div id="cat-<?php echo $i; ?>" class="category"> <?php query_posts("showposts=1&cat=$category")?> <span class="cat_title"><a href="<?php echo get_category_link($category);?>"><?php single_cat_title(); ?></a></span> <a href="<?php echo get_category_link($category);?>"></a> </div> <?php $i++; ?> <?php } ?> </div> <?php } ?> But when I remove that I get the error, unexpected end of file error and references to <?php get_footer(); ?> I need to understand why this is happening, not just how to fix it (although I need that too). My suspicion is one of the endif's. Similar Tutorialshi i m adding the last field to my query but getting unexpected t_string error $order_detail="insert into detail_table(unique_id,order_id, customer_name, customer_login_id, order_date, product_name, quantity, shipping, price,total_cost,compatibility) values('$unique_id',$order_id,'$username','$log_id','$shop_date','".$row['product_name'] . "' , " . $row['quantity'] . "," . $row['shipping_cost'] . ",". $row['price'] .",". $row['total_cost']. ",". '". $row['compatibility'] . "'. ")"; mysql_query($order_detail); help me remove it vineet Hi guys i have this error, Parse error: syntax error, unexpected end of file in C:\wamp64\www\nigthclub\videos.php on line 103
but i know is probably easy to solve but for some reason i dont see the error. please help me
<?php
session_start();
?>
<?php error_reporting (E_ALL ^ E_NOTICE); ?>
<!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" />
<link href="style.css" rel="stylesheet" type="text/css" />
<link href="tablefiestas.css" rel="stylesheet" type="text/css" />
<title>La Taverna de Juan</title>
</head>
<body>
<div id="container">
<div id="header">
<!--MENU BAR-->
<?php include("includes/db.php"); ?>
</div>
<!--VIDEOS-->
<?php
$query = ("SELECT * from videos");
$result = mysqli_query($connection,$query);
$num_per_page =05;
?>
<table border="1" width="100%">
<tr>
<td>Video Id</td>
<td>Titulo</td>
<td>Video</td>
</tr>
<tr>
<?php
while ($row=mysqli_fetch_assoc($result))
{
$videoid = $row['videoid'];
$titulo = $row['titulo'];
$url_video = $row['url_video'];
?>
<td><?php echo $videoid ?></td>
<td><?php echo $titulo ?></td>
<td><?php echo $url_video ?></td>
</tr>
<?php}?>
</table>
<?php
$query = "SELECT * from videos";
$pr_result = mysqli_query($connection,$query);
$totalrecord = mysqli_num_rows($pr_result);
echo $totalrecord;
?>
<br>
<div id="footer">
<!--FOOTER-->
<?php include("includes/footer.inc.php"); ?>
</div>
</div>
</body>
</html>
Edited November 18, 2019 by Psycho Added code tags Hi, I got this form, but I dont want the form to be displayed if the user has run out of credits.
The page worked until I added the credit check and now I get this error
Parse error: syntax error, unexpected end of file in /Applications/XAMPP/xamppfiles/htdocs/other_items.php on line 269
I know this is because some } are missing, but whenever I move them about, it either doesnt work, or says there is no { to match the } with. Im really confused now and got another 2 pages to do this to, so really need to sort this one out.
Here is what I got
<?php
include 'init.php';
include 'includes/overall/header.php';
include 'includes/logo.php';
if (!isset($_SESSION['loggedin'])) {
die("You must be logged in to sell a item"); //this causes to script to stop executing and lets the user know there is a problem
/*
Note: instead of the die() function, you could use the echo() function and provide an HTML link back to the login page, or use the header() function to just redirect users to the login page without any message. It is up to you to decide what your application should behave.
*/
}
//else { //logged in
elseif (isset($_SESSION['loggedin']) ){ //logged in
$username = $_SESSION['loggedinuser'];
$results = $con->query("SELECT * FROM user WHERE username = '$username';");
while($row = $results->fetch_array()) {
$email = $row['email'];
$town = $row['town'];
$county = $row['county'];
}
}
// THIS IS NEW
// CHECK WHETHER USER HAS CREDITS REMAINING
$query = "SELECT SUM(amount) FROM transaction WHERE username = $username";
$result = mysqli_query($con, $query);
if($result) {
$row = mysqli_fetch_row($result);
$amount = $row['amount'];
if ( ($amount) <= 0) {
//not enough credits - show message and redirect
echo "You either have no remaining credits or not enough to complete this transaction. You will be redirected to purchase more.";
header( "Refresh:5; url=purchase.php", true, 303);
exit();
} else {
// UP TO HERE
?>
<script type="text/javascript" src="jquery.js"></script>
<form action="otherItemsCheck.php" id="sellForm" method="POST">
<input type="hidden" name="username" value="<?php echo $username ?>"></li>
<input type="hidden" name="email" value="<?php echo $email ?>"></li>
<input type="hidden" name="town" value="<?php echo $town ?>"></li>
<input type="hidden" name="county" value="<?php echo $county ?>"></li>
<h2>Sell your item</h2>
<p><strong>A basic listing will cost 1 credit - extras will be added to the total cost of your listing</strong></p>
<ul>
<li>Category*:</br>
<select name="category">
<option value="none">--choose--</option>
<option value="air_pumps">Air Pumps</option>
<option value="air_stones">Air Stones</option>
<option value="aquariums">Aquariums</option>
<option value="cleaning">Cleaning & Maintenance</option>
<option value="equipment">CO2 Equipment</option>
<option value="coral">Coral & Live Rock</option>
<option value="decorations">Decorations</option>
<option value="feeders">Feeders</option>
<option value="filter_media">Filter Media & Accessories</option>
<option value="food">Food</option>
<option value="gravel">Gravel & Substrate</option>
<option value="health_care">Health Care</option>
<option value="heaters">Heaters & Chillers </option>
<option value="lighting">Lighting & Hoods</option>
<option value="meters">Meters & Controllers</option>
<option value="deionization">Reverse Osmosis & Deionization </option>
<option value="tubing">Tubing & Valves</option>
<option value="uv">UV Steriliser Water Pumps</option>
<option value="water_tests">Water Tests & Treatment</option>
<option value="other">Other Fish & Aquarium</option>
</select>
</li>
<li>Listing Title*:</br>
<input type="text" name="listing_title">
<li><strong>Would you like your listing displayed in Bold?: <input type="checkbox" name="bold" value="1"/> 1 Credit</strong>
</li>
<li>Condition*:</br>
<select name="item_condition">
<option>--choose--</option>
<option value="New (Packaged)">New (Packaged)</option>
<option value="New (None or damaged packaging">New (None or damaged packaging</option>
<option value="Used - Working">Used - Working</option>
<option value="Used - Not Working">Used - Not Working</option>
</select>
</li>
<li>Brand*:</br>
<select name="brand">
<option>Choose...</option>
<option value="AI (Aqua Illumination)">AI (Aqua Illumination)</option>
<option value="Algarde">Algarde</option>
<option value="API">API</option>
<option value="AquaEl">AquaEl</option>
<option value="AquaGro">AquaGro</option>
<option value="Aquamedic">Aquamedic</option>
<option value="Aquarian">Aquarian</option>
<option value="Aquarium Systems">Aquarium Systems</option>
<option value="Aquatlantis">Aquatlantis</option>
<option value="Arcadia">Arcadia</option>
<option value="Azoo">Azoo</option>
<option value="BiOrb/Reef One">BiOrb/Reef One</option>
<option value="Blagdon">Blagdon</option>
<option value="Boyu">Boyu</option>
<option value="Classica">Classica</option>
<option value="Cloverleaf">Cloverleaf</option>
<option value="Deltec/D-D">Deltec/D-D</option>
<option value="Dennerle">Dennerle</option>
<option value="Eheim">Eheim</option>
<option value="ESHa">ESHa</option>
<option value="Hagen/Fluval">Hagen/Fluval</option>
<option value="Hikari">Hikari</option>
<option value="Hobby">Hobby</option>
<option value="Hugo Kamishi">Hugo Kamishi</option>
<option value="Interpet">Interpet </option>
<option value="JMC">JMC</option>
<option value="Juwel">Juwel</option>
<option value="King British">King British</option>
<option value="New Era">New Era</option>
<option value="Nishikoi">Nishikoi</option>
<option value="NT Labs">NT Labs</option>
<option value="Oase">Oase</option>
<option value="Ocean Nutrition">Ocean Nutrition</option>
<option value="Penn Plax">Penn Plax</option>
<option value="Pontec">Pontec</option>
<option value="Red Sea">Red Sea</option>
<option value="Rena">Rena</option>
<option value="Salifert">Salifert</option>
<option value="Seachem">Seachem</option>
<option value="Seneye">Seneye</option>
<option value="SuperFish">SuperFish</option>
<option value="Tanktests">Tanktests</option>
<option value="Tetra">Tetra</option>
<option value="TMC">TMC</option>
<option value="Tunze">Tunze</option>
<option value="Two Little Fishies">Two Little Fishies</option>
<option value="Waterlife">Waterlife</option>
<option value="Wave Point">Wave Point</option>
<option value="other">Other</option>
</select>
</li>
<li>Model*:</br>
<input type="text" name="model">
</li>
<li>Colour*:</br>
<select name="colour">
<option value="">--choose one--</option>
<option value="White">White</option>
<option value="Grey">Grey</option>
<option value="Black">Black</option>
<option value="Blue">Blue</option>
<option value="Green">Green</option>
<option value="Orange">Orange</option>
<option value="Red">Red</option>
<option value="Multicoloured">Multicoloured</option>
<option value="Other">Other</option>
</select>
</li>
<li>Quantity*:</br>
<select name="quantity">
<option value="">--choose one--</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select><strong> 1 Credit entitles you to sell up to 10 of the same item. </strong>
</li>
<li>Price*:<br>
<input type="text" name="price"> In UK Pound Sterling
</li>
<li>Description*:</br>
<textarea name="comments"></textarea>
</li>
<li>Postage Type*:</br>
<select name="postage_type">
<option>Choose...</option>
<option disabled>Economy services</option>
<option value="UK_CollectPlusTracked">Collect+ Economy Tracked (3 to 5 working days)</option>
<option value="UK_HermesTracked">Hermes Tracked (3 to 5 working days)</option>
<option value="UK_RoyalMailSecondClassStandard">Royal Mail 2nd Class (2 to 3 working days)</option>
<option value="UK_RoyalMailSecondClassRecorded">Royal Mail 2nd Class Signed For (2 to 3 working days)</option>
<option value="UK_RoyalMailTracked">Royal Mail Tracked 48 (2 to 3 working days)</option>
<option value="UK_RoyalMail48">Royal Mail 48 (2 to 3 working days)</option>
<option value="UK_OtherCourier3Days">Other Courier 3 days (3 working days)</option>
<option value="UK_OtherCourier5Days">Other Courier 5 days (5 working days)</option>
<option value="UK_OtherCourier">Other Courier (3 to 5 working days)</option>
<option value="UK_SellersStandardRate">Other Courier 3-5 days (3 to 5 working days)</option>
<option disabled>Standard services</option>
<option value="UK_RoyalMailFirstClassStandard">Royal Mail 1st Class (1 working day)</option>
<option value="UK_RoyalMailFirstClassRecorded">Royal Mail 1st Class Signed For (1 working day)</option>
<option value="UK_RoyalMailNextDay">Royal Mail Tracked 24 (1 working day)</option>
<option value="UK_RoyalMail24">Royal Mail 24 (1 working day)</option>
<option value="UK_CollectPlusStandard">Collect+ Standard (2 working days)</option>
<option value="UK_Parcelforce48">Parcelforce 48 (1 to 2 working days)</option>
<option value="UK_OtherCourier48">Other 48 Hour Courier (1 to 2 working days)</option>
<option disabled>Express services</option>
<option value="UK_RoyalMailSpecialDeliveryNextDay">Royal Mail Special Delivery (TM) 1:00 pm (1 working day)</option>
<option value="UK_RoyalMailSpecialDelivery9am">Royal Mail Special Delivery (TM) 9:00 am (1 working day)</option>
<option value="UK_Parcelforce24">Parcelforce 24 (1 working day)</option>
<option value="UK_OtherCourier24">Other 24 Hour Courier (1 working day)</option>
<option disabled>Services from outside UK</option>
<option value="UK_EconomyShippingFromOutside">Economy Delivery from outside UK (10 to 22 working days)</option>
<option value="StandardDeliveryfromOutsideUKwithRoyalMail">Standard Delivery from outside UK with Royal Mail (7 to 13 working days)</option>
<option value="UK_StandardShippingFromOutside">Standard Delivery from outside UK (4 to 10 working days)</option>
<option value="UK_ExpeditedShippingFromOutside">Express Delivery from outside UK (1 to 3 working days)</option>
<option value="UK_FedExIntlEconomy">FedEx International Economy (3 to 4 working days)</option>
<option value="UK_TntIntlExp">TNT International Express (2 to 3 working days)</option>
<option value="UK_TrackedDeliveryFromAbroad">Tracked delivery from outside UK (2 to 5 working days)</option>
<option disabled>Collection</option>
<option value="UK_CollectInPerson">Collection in Person </option>
</select>
</li>
<li>Postage Cost*:</br>
<input type="text" name="postage_cost">
</li>
</ul>
<ul>
<li>Upload Photo:</br>
<input id="text" type="text" name="upload_photo">
</li>
<li><input type="checkbox" name="rotate" value="10"/><strong>For 10 credits, you can have your listing displayed on our homepage on a rotation basis. </strong>
</li>
<li>
<input type="submit" value="List Item"></li>
</ul>
</form>
<script type="text/javascript" src="saleSpecies.js"></script>
<?php
}
include 'includes/overall/footer.php';
?>
eg, it says this } he
<?php } include 'includes/overall/footer.php'; ?>Is unmatched. I know whats wrong, just not how to fix it Any help is always much appreciated. aquaman Hi i tried to fix something but ended up screwing something up.Ive got a problem and i dont know how to fix it. Down here u can see the code. the error im getting is "Parse error: syntax error, unexpected end of file." Could someone please help me?
Hello, i got a problem with my codes, it says Parse error: syntax error, unexpected token "endwhile" . Please help me, Here's my code:
<?php
while($rows=mysqli_fetch_array($result)); 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] <?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&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 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 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,
1 <?php
7 // Create connection
10 // Check connection
14 $firstname = $conn->real_escape_string($_REQUEST['firstname']); 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;
if($conn->query($sql2) === true){
if($conn->query($sql3) === true){ 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! This topic has been moved to Third Party PHP Scripts. http://www.phpfreaks.com/forums/index.php?topic=315281.0 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() ); } } } ?> i keep getting the above error.. help this is a class of the log entry <?php require_once "config.php"; abstract class DataObject { protected $data = array(); public function__construct( $data ) { foreach ( $data as $key => $value ) { if ( array_key_exists( $key, $this->data )) $this->data[$key] = $value; } } public function getValue( $field ) { if ( array_key_exists( $field, $this->data )) { return $this->data[$field]; } else { die( "field not found" ); } } public function getValueEncoded( $field ) { return htmlspecialchars( $this->getValue( $field )); } protected function connect() { try { $conn = new PDO(DB_DSN, DB_USERNAME, DB_PASSWORD ); $Conn->setAttribute( PDO::ATTR_PERSISTENT, true ); $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); } catch ( PDOException $e->getMessage() ); die( "connection failed: " . $e->getMessage() ); } return $conn; } protected function disconnect( $conn ) { $conn = ""; } } ?> |
|||||||