Learn VBA & Macros in 1 Week!

PHP - Moved: Php Syntax Required.

Full Excel VBA Course - Beginner to Expert

Moved: Php Syntax Required.	View Content

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=313541.0

Full Excel VBA Course - Beginner to Expert

Moved: Just A Little Php Help Required. Php Album

Similar Tutorials

View Content

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=326412.0

Moved: Syntax Error

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=327615.0

Moved: You Have An Error In Your Sql Syntax

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=321480.0

Moved: Mysql Syntax Error

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=352460.0

Moved: Phpbb Geshi Syntax Highlighter

Similar Tutorials

View Content

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=333143.0

Moved: Mysql Syntax Error On Insert Into

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=342913.0

Moved: Syntax Of 2 Left Joins And Alias

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=320409.0

Moved: Parse Error: Syntax Error, Unexpected $end, Expecting T_function

Similar Tutorials

View Content

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=315281.0

Moved: Parse Error: Syntax Error, Unexpected T_if In . On Line 1

Similar Tutorials

View Content

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=344105.0

Moved: Php Parse Error: Syntax Error, Unexpected T_endif

Similar Tutorials

View Content

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=323310.0

You Have An Error In Your Sql Syntax; Check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Use Near 'cost`=`60',

Similar Tutorials

View Content

I have been looking at this code most of the morning and do not have a clue what is wrong with the code. I am hoping its not a stupid mistake, can someone please help me out? thank you

 
<title>Inputing Travel Detials</title>
 
<header>
  <h1 align="center"> Adding Travel Detials </h1>
  
 
  <body>
    <p>  <center><img  src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center>
        <table border="1">
          <tr>
            <td><a href="index.php"> Home Page </a></td>
            <td><a href="administratorhomepage.html">Administrator Home Page </a></td>
            <td><a href="viewhomepage.html">View Home Page </a></td>
            <td><a href="Inputhomepage.html">Input Home Page </a></td>
            <td><a href="traveldetials.html">Enter More Travel Detials </a></td>
        </table>
    </p>
 
 
<?php
 
include "connection.php";
 
$Applicant_ID = $_POST["Applicant_ID"];
$Method_Of_Travel = $_POST["Method_Of_Travel"];
$Cost = $_POST["Cost"];
$ETA = $_POST["ETA"];
$Main_Gate_Advised = $_POST["Main_Gate_Advised"];
 
$query = ("UPDATE `int_board_applicant` SET `Method_Of_Travel`=`$Method_Of_Travel', `Cost`=`$Cost', `ETA`='$ETA', `Main_Gate_Advised`='$Main_Gate_Advised' WHERE `Applicant_ID`='$Applicant_ID'");
   
 
$result = mysqli_query($dbhandle, $query) 
    or die(mysqli_error($dbhandle));
 
if($result){ echo "Success!"; }
 
  else{ echo "Error."; }
 
 
// successfully insert data into database, displays message "Successful".
 if($query){
  echo "Successful";
}
 
  else {
  echo "Data not Submitted";
}
 
 
//closing the connection
   mysqli_close($dbhandle)
   
 
 
 
 
?>

Could Not Delete Data: You Have An Error In Your Sql Syntax; Check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Us

Similar Tutorials

View Content

Ok this is puzzleing. I am geting "Could not delete data: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1". but its is deleting the entry that needs to be removed. The "1" is the entry. Just not sure what is causing the error. I do have another delete php but I have put that on the back burning for the time being. <?php

         $con = mysqli_connect("localhost","user","password","part_inventory");
   // Check connection
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
   exit();
} else {

   $result = mysqli_query($con, "SELECT * FROM amp20 ");

   $amp20ptid = $_POST['amp20ptid'];              // escape variables for security
   $amp20ptid = mysqli_real_escape_string($con, $_POST['amp20ptid']);

   mysqli_query($con, "DELETE FROM amp20 WHERE amp20ptid = '$amp20ptid'");


if (!mysqli_query($con, $amp20ptid));

{
die('Could not delete data: ' . mysqli_error($con));
}
echo "Part has been deleted to the database!!!\n";
   mysqli_close($con);
}
?>

Syntax Error:check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Use Near ''sfapp' ('surname_add','forename_add')

Similar Tutorials

View Content

Hi guys I have this code below and all works fine when submitting this online application apart from when someone types either ' # & into one of the comment fields in which it throws up the error. Have tried various fixes from across the internet but no joy. Can anyone offer suggestions? <?php $con = mysql_connect("localhost:3306","root","password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db('sfapp', $con); $sql="INSERT INTO 'sfapp' ('surname_add','forename_add','dob_add','hometele_add','mobiletele_add','homeadd_add','siblings_add','schoolname_add','headname_add','schooladd_add','schooltele_add','schoolem_add','alevel_add','personstate_add','nameprovided_add','pe_add','se_add','PredGrade_Art','PredGrade_AScience','PredGrade_BusStudies','PredGrade_Electronics','PredGrade_EnglishLang','PredGrade_EnglishLit','PredGrade_French','PredGrade_German','PredGrade_Geog','PredGrade_Graphics','PredGrade_History','PredGrade_Maths','PredGrade_SepScience','PredGrade_ProductDesign','PredGrade_Spanish','PredGrade_Other','Gender_Male','Gender_Female','Sub_EnglishLit','Sub_Maths','Sub_FurtherMaths','Sub_Biology','Sub_Chemistry','Sub_Physics','Sub_French','Sub_German','Sub_Spanish','Sub_Geography','Sub_History','Sub_RE','Sub_FineArt','Sub_Business','Sub_Computing','Sub_GlobPersp','Sub_DramaAndTheatre','Sub_PE','Sub_Dance','Sub_Politics','Sub_Psychology','Sub_Sociology','readprospect_chk','Sib_Yes','Sib_No','Current_Student_Yes','Current_Student_No','I_Understand_chk','Current_Education_chk','Local_Care_chk','Staff_Cwhls_chk','Sub_Film') VALUES ('$_POST[surname_add]','$_POST[forename_add]','$_POST[dob_add]','$_POST[hometele_add]','$_POST[mobiletele_add]','$_POST[homeadd_add]','$_POST[siblings_add]','$_POST[schoolname_add]','$_POST[headname_add]','$_POST[schooladd_add]','$_POST[schooltele_add]','$_POST[schoolem_add]','$_POST[alevel_add]','$_POST[personstate_add]','$_POST[nameprovided_add]','$_POST[pe_add]','$_POST[se_add]','$_POST[PredGrade_Art]','$_POST[PredGrade_AScience]','$_POST[PredGrade_BusStudies]','$_POST[PredGrade_Electronics]','$_POST[PredGrade_EnglishLang]','$_POST[PredGrade_EnglishLit]','$_POST[PredGrade_French]','$_POST[PredGrade_German]','$_POST[PredGrade_Geog]','$_POST[PredGrade_Graphics]','$_POST[PredGrade_History]','$_POST[PredGrade_Maths]','$_POST[PredGrade_SepScience]','$_POST[PredGrade_ProductDesign]','$_POST[PredGrade_Spanish]','$_POST[PredGrade_Other]','$_POST[Gender_Male]','$_POST[Gender_Female]','$_POST[Sub_EnglishLit]','$_POST[Sub_Maths]','$_POST[Sub_FurtherMaths]','$_POST[Sub_Biology]','$_POST[Sub_Chemistry]','$_POST[Sub_Physics]','$_POST[Sub_French]','$_POST[Sub_German]','$_POST[Sub_Spanish]','$_POST[Sub_Geography]','$_POST[Sub_History]','$_POST[Sub_RE]','$_POST[Sub_FineArt]','$_POST[Sub_Business]','$_POST[Sub_Computing]','$_POST[Sub_GlobPersp]','$_POST[Sub_DramaAndTheatre]','$_POST[Sub_PE]','$_POST[Sub_Dance]','$_POST[Sub_Politics]','$_POST[Sub_Psychology]','$_POST[Sub_Sociology]','$_POST[readprospect_chk]','$_POST[Sib_Yes]','$_POST[Sib_No]','$_POST[Current_Student_Yes]','$_POST[Current_Student_No]','$_POST[I_Understand_chk]','$_POST[Current_Education_chk]','$_POST[Local_Care_chk]','$_POST[Staff_Cwhls_chk]','$_POST[Sub_Film]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } ?> <?php //if "email" variable is filled out, send email if (isset($_REQUEST['pe_add'])) { //Email information $admin_email = $_REQUEST['pe_add']; $forename = $_REQUEST['forename_add']; $email = "autoreply@testing.com"; $subject = "Application"; $desc = "Dear $forename Thank you for submitting your online application, we will be in touch shortly. " ; //send email mail($admin_email, "$subject", "$desc", "From:" . $email); //Email response echo "Thank you for contacting us!"; } //if "email" variable is not filled out, display the form else { ?> If you are seeing this, you need to go back and fill out the Personal Email section! <?php } header("location:complete.php"); mysql_close($con) ?> Thanks in advance.

Problem In Syntax From Mysql To Php Syntax

Similar Tutorials

View Content

Hi..

I create mysql syntax for query testing before i input to my php code

here is my mysql code:

Code: [Select]
set @t = 0;
set @rqty=31968;
SELECT LOT_CODE as code, DATE_ENTRY,
CASE WHEN @t+OUTPUT_QTY > @rqty
THEN @rqty -@t
ELSE OUTPUT_QTY
END as qty,
@t := @t + d.OUTPUT_QTY as cumulative
FROM dipping d WHERE SUBSTR(LOT_CODE, 9,4) = 'P28' AND (@t < @rqty);

and i attach the sample output of the above query.

Now that query test is work i will input that code to my php codes.

     $sql = "SELECT SKUCode, Materials, Comp, Qty
     FROM bom  WHERE SKUCode = '$SKUCode'";
     $res = mysql_query($sql, $con);

    ($row = mysql_fetch_assoc($res));
     $Materials = $row['Materials'];
     $Qty = $row['Qty'];
     $Comp = $row['Comp']; //P28
//-----Compute Req Qty and Save to table---//

     $ReqQty = $Qty * $POReq; // 31968


$sql = "UPDATE bom SET ReqQty = '$ReqQty' WHERE SKUCode = '$SKUCode' AND Materials = '$Materials'";
$resReqQty = mysql_query($sql, $con);

$t = 0;

$sql = "SELECT LOT_CODE as code,  DATE_ENTRY,
CASE WHEN $t+OUTPUT_QTY > $ReqQty
THEN $ReqQty  -$t
ELSE OUTPUT_QTY
END as qty,
$t := $t + d.OUTPUT_QTY as cumulative
FROM dipping d  WHERE SUBSTR(LOT_CODE, 9,4) = '$Comp' AND ($t < $ReqQty)";

when I echo the query:

I got this:

SELECT LOT_CODE as code, DATE_ENTRY, CASE WHEN 0+OUTPUT_QTY > 31968 THEN 31968 -0 ELSE OUTPUT_QTY END as qty, 0 := 0 + d.OUTPUT_QTY as cumulative FROM dipping d WHERE SUBSTR(LOT_CODE, 9,4) = 'P28' AND (0 < 31968)

then I run it to the sql

and I got an error:

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':= 0 + d.OUTPUT_QTY as cumulative FROM dipping d WHERE SUBSTR(LOT_CODE, 9,4) = '' at line 1
(0 ms taken)

Any help is highly appreciated

Thank you so much

Syntax V Alternative Syntax?

Similar Tutorials

View Content

Which of the below syntax is the better to be using?

$bal = 100;
if($bal > 100)
{
echo "you have over 100 pounds;
}
else
{
echo "you have less than 100 pounds";
}

if ($bal > 100);
echo "you have over than 100";
else ;
echo "you have less than 100";
endif;

Required Help In Api

Similar Tutorials

View Content

Hi Friends,

I am trying to do an API with oracle database. The JSON request from 3rd party will look like below.

{
    "contact_id": "1",
    "serial_no": "100",
    "name": "baby",
    "inv_date": "2018-06-27",
    "due_date": "2018-06-27",
    "currency": "KD",
    "subtotal": "143",
    "tax_total": "13",
     "shipment_data": [
        {
            "serial_no": "33",
            "master_no": "55",
            "house_no": "77",
            "cost_revenue_items": [
                {
                    "charge_ref": "rr",
                    "currency": "INR",
                    "quantity": "2",
                    "selling_rate": "45",
                    "exchange_rate": "7",
                     "taxes": [
                        {
                            "serial_no": "1",
                            "ref": "INR",
                            "voiding_remarks": "oo"
                        },{
                            "serial_no": "2",
                            "ref": "KWD",
                            "voiding_remarks": "asd"
                        }
                    ]
                    
                }
            ]
        }
     
       
    ]
}

how to handle request for JSON in which master is updated (PUT) and child record is (Either INSERTED, UPDATED or DELETED) ?

Required Field

Similar Tutorials

View Content

Trying to make the email field in my form mandatory. Im new to php, more used to javascript but from everything i have read php is more universal. Here is my code, any help would be great.
Code: [Select]
<?php

   $emailsubject = 'Golf Registration';
   $webMaster = 'dustin@duncantek.com';

   $namea = $_POST['namea'];
   $nameb = $_POST['nameb'];
   $namec = $_POST['namec'];
   $named = $_POST['named'];
   $total = $_POST['total'];
   $sponsor = $_POST['sponsor'];
   $email = $_POST['email'];
   $comments = $_POST['comments'];

   $body = <<<EOD
<br><hr><br>

Golfer1: = $namea <br>
Golfer2: = $nameb <br>
Golfer3: = $namec <br>
Golfer4: = $named <br>
Total Owed: = $total <br>
Sponsorship Name: = $sponsor <br>
Comments: = $comments<br>
EOD;

   $headers = "From: $email\r\n";
   $headers .= "Content-type: text/html\r\n";
   $success = mail($webMaster, $emailsubject, $body, $headers);


   $theResults = <<<EOD
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Thanks For Registering</title>
<link href="golf-website.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div id="border">
<div class="name">Thanks For Registering!</div>
<div id="links_bg">
<div class="toplinks"><a href="default.html">Homepage</a></div>
<div class="toplinks"><a href="file:///C|/Users/Dustin/Desktop/Templates/Golf-Website/index.html">About Us</a></div>
<div class="toplinks"><a href="file:///C|/Users/Dustin/Desktop/Templates/Golf-Website/index.html">Donations</a></div>
<div class="toplinks"><a href="tourneyinfo.html">Events</a></div>
<div class="toplinks"><a href="file:///C|/Users/Dustin/Desktop/Templates/Golf-Website/index.html">Contact us</a></div>
</div>
<div class="gap"></div>

</div>
</div>
<div id="heading-bg">
  <div align="left">Registration Complete</div>
</div>
<div id="main">
  <p>Thank you for taking the time to register, we will email you back shortly to confirm registration along with an invoice via paypal. This is strictly for your convenience, we will also accept payment at the course on the day of the tournament. Thanks Again!</p>
</div>
<div id="bottom">
<div class="bottomlink"><a href="default.html">Home</a></div>
<div class="sap">|</div>
<div class="bottomlink"><a href="aboutus.html">About Us</a></div>
<div class="sap">|</div>
<div class="bottomlink"><a href="file:///C|/Users/Dustin/Desktop/Templates/Golf-Website/index.html">Donations</a></div>
<div class="sap">|</div>
<div class="bottomlink"><a href="tourneyinfo.html">Events</a></div>
<div class="sap">|</div>
<div class="bottomlink"><a href="file:///C|/Users/Dustin/Desktop/Templates/Golf-Website/index.html">Contact Us</a></div>
</div>
<center><div class="quicklinks"></div>
</div>
</body>
</html>

EOD;

   echo "$theResults";

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Tournament Info</title>
<link href="golf-website.css" rel="stylesheet" type="text/css" />
</head>

<body>
<td width="104"><label for="namea">
<div align="right">Golfer #1:</div>
</label> </td>
<td width="387"><div align="left">
<input name="namea" type="text" id="namea" size="35" maxlength="80" />
</div></td>
</tr>
<tr>
<td><label for="name2">
<div align="right">Golfer #2:</div>
</label> </td>
<td><div align="left">
<input name="nameb" type="text" id="nameb" size="35" maxlength="80" />
</div></td>
</tr>
<tr>
<td><label for="namec">
<div align="right">Golfer #3:</div>
</label> </td>
<td><div align="left">
<input name="namec" type="text" id="namec" size="35" maxlength="80" />
</div></td>
</tr>
<tr>
<td><label for="named">
<div align="right">Golfer #4:</div>
</label> </td>
<td><div align="left">
<input name="named" type="text" id="named" size="35" maxlength="80" />
</div></td>
</tr>
<tr>
<td><div align="right"></div></td>
<td><div align="left">The option to sponsor a hole is also available, the price per hole is $200.00, please enter in the box below what you would like the sponsorship to be if any.</div></td>
</tr>
<tr>
<td><div align="right">
<label for="total">Total:</label>
</div></td>
<td><div align="left">
<input name="total" type="text" id="total" size="35" maxlength="80" />
</div></td>
</tr>
<tr>
<td><div align="right">
<label for="sponsor">Sponsorship:</label>
</div></td>
<td><div align="left">
<input name="sponsor" type="text" id="sponsor" size="35" maxlength="80" />
</div></td>
</tr>
<tr>
<td><div align="right">
<label for="email">Email: </label>
</div></td>
<td><div align="left">
<input name="email" type="text" id="email" size="35" maxlength="80" />
</div></td>
</tr>
<tr>
<td><label for="comments">Additional Comments:</label></td>
<td><textarea name="comments" cols="35" rows="6" id="comments"></textarea></td>
</tr>
</table>
<p> </p>
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<p>
<input type="submit" name="send" id="send" value="Submit" />
<input type="reset" name="reset" id="reset" value="Reset" />
</p>
</blockquote>
<
</body>
</html>

MOD EDIT: code tags added.

Login Required Twice

Similar Tutorials

View Content

I have a login page that after logging in it sets a session
Code: [Select]
$_SESSION['user_info'] = $_POST['username'];

and takes me to a start page (and checks for the session) which all works wonderfully. The problem is that no matter what link is clicked on that page it takes me to the login page again after checking to see if that same session is set
Code: [Select]
session_start();
if(!isset($_SESSION['user_info'])){
header("Location: http://website.com/folder/log_in.php");
}
After logging in a second time every link on that same start page works wonderfully.

If it works the second time why not the first?

Required Changes When Going From Mod_php To Php-fpm

Similar Tutorials

View Content

One of my virtual hosts contained php_value upload_max_filesize 8M which resulted in error when running as php-fpm. Also, looks like .htaccess files are no longer used. Any other gotcha's???

Reading up on it, looks like I want to move all .htaccess instructions to a https://www.php.net/manual/en/configuration.file.per-user.php file. Should be straight forward enough.

Looking at https://www.php.net/manual/en/configuration.changes.php, looks like I should scan /etc/httpd/* as well as any virtual sites defined elsewhere for "php_" and move these requirements elsewhere. Will this also have to be a per directory .user.ini file? Reason I ask is I always thought it was better performance to when possible use apache's conf file than a .htaccess file.

Php Coding Help Required

Similar Tutorials

View Content

Hi Buddy

I'm new to Php and downloaded shopping cart for www.phpwebcommerce.com/download/plaincart.zip

With this code, i'm unable to update the shopping cart. On clicking the update button, it goes to previous page. But in demo version the update is working properly.

Kindly help.

Thanks
Sakhsen