PHP - Broken "php Manual" Tags

Hello I have the following error:

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 'FROM players WHERE ((NOT inactive_player) AND ((players.Player_Last_Name = 'p' at line 3

I think my error is in the statement below...


    Code: [Select]
echo "1";
$getNewPlayers =
"SELECT players.Player_number,
players.Player_name,
FROM players
WHERE ((NOT inactive_player)
AND ((players.Player_Last_Name = 'player_find%')))
ORDER BY player_name";
$rsNewPlayers = mysql_query($getNewPlayers, $link) or die (mysql_error());
$varNewCount = mysql_num_rows($rsNewPlayers);
echo $varNewCount['Player_name'];


Can you tell me where the error is and how I might go about to fix it?

Thanks,

Hello forum.
I'm new here, but I've been reading and finding useful things for a while now.

I'm still new to PHP and I need a little help.

I'm doing a school project and I have some things I want to do, but do not know how to write it down in PHP.

I think I'll ask a lot of questions this week, and I hope I will get some help..

For start I want to ask this:

I've been using Code: [Select]
mysql_fetch_array() for doing loops and populating check-boxes. And everything's working fine.. but what I want is to control the actual loop by clicking buttons. Let's say first time a while-do is run, my check-boxes get populated from the database and every other loop the next data from the table is added.. pretty straightforward.
I want to be able to populate once, then click "next" and the new data to be added and so on..
Code: [Select]
<?php
$tema = mysql_query("SELECT * from questions")or die(mysql_error());

function answer1($string)
{
$string1 = explode("/", $string);
echo $string1[0];
}
function answer2($string)
{
$string1 = explode("/", $string);
echo $string1[1];
}

while ($row=mysql_fetch_array($tema))
{
echo mysql_fetch_array($tema);
$tip=$row["tip"];
if ($tip==2)
{
$id=$row['prasanje_id'];
$question=$row['question'];
$answer=$row['answer'];
?>
   <label> <?php echo $question?></label><br>
   <input type="checkbox"  name="CheckboxGroup1" value="checkbox" id="CheckboxGroup1_0" />
      <?php answer1($tekst) ?></label>
    <label>
      <input type="checkbox"  name="CheckboxGroup1" value="checkbox" id="CheckboxGroup1_1" />
      <?php answer2($tekst) ?></label>
<?php
}
}
?>I want an alternative to the while-do loop..
Is it possible to do this?

Thanks!!

Hello,
I have a wordpress site using Thesis 2.1 theme and I am displaying "excerpts" for each post on homepage.. I don't want to add <!-- more --> to each post and I want to show sth different, sth more valuable on the homepage to my readers.. Thats why I use excerpts.

I added this line of code to my custom.php file:

function new_excerpt_more($more) {
global $post;
return ' <a href="'. get_permalink($post->ID) . '">Continue Reading...</a>';
}
add_filter('excerpt_more', 'new_excerpt_more');

It added a "continue reading.." link to the posts that I haven't yet defined excerpt.. So, If nothing is written on the excerpt area of that post, it shows some part of the post and adds a "continue reading.." link to it on the homepage. But if I have written sth in the excerpt area of the post, it does shows the excerpt, but doesn't add the "continue reading.." link at the end..
I will be happy if you may help me on this, this drives me nuts currently! [/size]

MERGED

So basically, what I am trying to do is, adding read more tag to custom excerpts which we define manually.
Here is another code I tried but had no luck again!

//* Changing excerpt more - only works where excerpt IS hand-crafted
function manual_excerpt_more( $excerpt ) {
	$excerpt_more = '';
	if( has_excerpt() ) {
    	$excerpt_more = '&nbsp;<a href="' . get_permalink() . '" rel="nofollow">[Read more]</a>';
	}
	return $excerpt . $excerpt_more;
}
add_filter( 'get_the_excerpt', 'manual_excerpt_more' );

Edited by Ch0cu3r, 09 November 2014 - 01:18 PM.

Hi, I have been trying to make a page which shows a number of thumbnails, populated by images and text from a database, this I got working perfectly fine, but as I am now trying to make it so users can log in and edit or delete each one, it has all started to go a bit wrong and I was wondering if anyone could spot why?!?

It is currently bringing up this message on the screen:

Error fetching entries from the database, error: Statement: SELECT image,id,projecttitle,projectcode,FROM portfolio ORDER BY id DESC LIMIT 16
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 'FROM portfolio ORDER BY id DESC LIMIT 16' at line 1
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /Users/mdfcows/Sites/atelier/portfolio.php on line 129

I don't quite know how to get it to print out the full nature of the error, but this is the code I am using:
Code: [Select]
<?php
$max_items2 = 16; /* max number of news items to show */

require_once('config.php');
$db2 = mysql_connect (DB_HOST,DB_USER,DB_PASSWORD);
if(!$db2) {
die('Failed to connect to server: ' . mysql_error());
}
mysql_select_db (DB_DATABASE,$db2);

function displayNews($all2 = 0) {
    global $db2, $max_items2;
    
    if ($all2 == 0) {
        /* query for news up to $max_items */
        $query9 = "SELECT image,id,projecttitle,projectcode," . 
                 
                 "FROM portfolio ORDER BY id DESC LIMIT $max_items2";
    } else {
        /* query for all news */
        $query9 = "SELECT image,id,projecttitle,projectcode," . 
                 
                 "FROM portfolio ORDER BY id DESC";
    }
    $result9 = mysql_query($query9) or print("<p>Error fetching entries from the database, error: " . "Statement: " . $query9 . "</p>" . mysql_error());


    while ($row9 = mysql_fetch_assoc ($result9)) {
        
        $title = htmlentities ($row9['projecttitle']);
        $news = nl2br (strip_tags ($row9['projectcode'], '<a><b><i><u>'));
$image = $row9['image'];
$id = $row9['id'];
        
        /* display the data */
?>
<div class="boxgrid captionfull">
            <a id="<?php echo $id ?>"
           
<a class='visit' href="project.php?id=<?php echo $news ?>">
               
                <?php echo $image;

                if(strstr($image, 'jpg') or (strstr($image, 'png')) or (strstr($image, 'gif')) or (strstr($image, 'bmp')) or (strstr($image, 'jpeg')) ) {
echo "<img class='cpimg' src='images/portfolio/$image' alt='' />";
}else {
echo "";}
?>"></a>
               
               
                <div class="cover boxcaption" style="top: 122px; ">
<p align="left"><?php echo $title ?></p>
</div>
                </div>
        <?php

//Check whether the session variable SESS_MEMBER_ID is present or not

if(isset($_SESSION['SESS_MEMBER_ID']) || (!trim($_SESSION['SESS_MEMBER_ID']) == '')) {
echo "<form class='editbtn' action='editportfolio.php' method='POST'>";
echo "<input type='hidden' name='idf' value='$id' />";
echo "<input src='images/editbtn.png' type='image' value='Edit' />";
echo "</form>";
echo "<form class='editbtn' action='deletportfolio.php' method='POST'>";
echo "<input type='hidden' name='ide' value='$id' />";
echo "<input src='images/delbtn.png' type='image' value='Delete' />";
echo "</form>";
} else {
echo "";
}



    }
    
   
}

/* this is where the script decides what do do */

echo "\n";
switch($_GET['action']) {

    case 'all':
        displayNews(1);
        break;
    default:
        displayNews();
}
echo "\n";
?>

<?php
//Check whether the session variable SESS_MEMBER_ID is present or not
if(isset($_SESSION['SESS_MEMBER_ID']) || (!trim($_SESSION['SESS_MEMBER_ID']) == '')) {
echo "<span class='show_all'>";
echo "<a class='show' href='admincp.php'>&nbsp;&nbsp;Admin</a>";
echo "</span>";
echo "<span class='show_all'>";
echo "<a class='show' href='logout.php'>&nbsp;Logout</a>";
echo "</span>";
} else {
echo "";
}
?>

with the line, " while ($row9 = mysql_fetch_assoc ($result9)) {"   being line 129

any help would be much appreciated!

Thank you, Martin

I was looking at the manual:   http://php.net/manua....precedence.php   And I notice that the parenthesis () operator and print operator are missing from the list. Why so? I would like to know where these operators fall in the precedence and associativity chart.

$pastelink = "<br /><a href='view.php?paste=$lol&language=$language'>$name</a>";
mysql_query("INSERT INTO recent (url) VALUES ('$pastelink')");


That query won't run, however if I do this:


$test = $_POST['name'];
//$pastelink = "<br /><a href='view.php?paste=$lol&language=$language'>$name</a>";
mysql_query("INSERT INTO recent (url) VALUES ('$test')");


It will run, is this because of the single quotes in $pastelink?

& If so, how can I fix it?

Hi,

I'm just trying out some basic code and playing around with passing variables by reference and i was reading this on the php manual at this page http://php.net/manual/en/language.references.pass.php :


No other expressions should be passed by reference, as the result is undefined. For example, the following examples of passing by reference are invalid:

<?php
function foo(&$var)
{
    $var++;
}
function bar() // Note the missing &
{
    $a = 5;
    return $a;
}
foo(bar()); // Produces fatal error since PHP 5.0.5

foo($a = 5); // Expression, not variable
foo(5); // Produces fatal error
?>


So, i decided to try it out myself like i always do, and i noticed that i'm not getting an error when i do foo(bar()); i.e calling bar() without the & in the function declaration. Infact it works perfectly fine and returns an incremented $a after its passed to foo(). Likewise foo($a = 5); also works great and returns an incremented $a after being passed to foo(). Is this  a mistake in the manual or am i missing something?

Running PHP 5.3.2-1ubuntu4.5

I am trying to use this: http://php.net/manual/en/function.xml-parse-into-struct.php to parse this:

Code: [Select]
<?xml version="1.0" encoding="utf-8"?>
<PaymentNotification xmlns="http://">
  <PaymentMethod>card</PaymentMethod>
<Hash>12345KKLS</Hash>
<Payments>
    <Payment>
      <PaymentID>709750ba-b9b6-44c4-9812</PaymentID>
      <Amount>70</Amount>
      <Currency>USD</Currency>
      <Date>2011-05-11T07:41:44.957</Date>
      <StatusID>4</StatusID>
    </Payment>
    <Payment>
      <PaymentID>e0c66bae-c423-43c6-b896</PaymentID>
      <Amount>50</Amount>
      <Currency>USD</Currency>
      <Date>2011-05-11T07:42:13.55</Date>
      <StatusID>2</StatusID>
    </Payment>
  </Payments>
</PaymentNotification>

...but can't work out which numbers to use. I only need to grab the payment ID where the statusID is 4 (for each one as could be 1 or more per xml message).

It's very complicated http://php.net/manual/en/function.xml-parse-into-struct.php

hi everyone,

did not know what to make the subject, but here is what I want to do:

I have a string, which gets returned to me from a linux app on my server, it looks something like this:
Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=utf-8">
<TITLE> </TITLE>
<META NAME="GENERATOR" CONTENT="OpenOffice.org 3.2  (Linux)">
<META NAME="AUTHOR" CONTENT="Administrator">
<META NAME="CREATED" CONTENT="20110106;14170000">
<META NAME="CHANGEDBY" CONTENT="HOD">
<META NAME="CHANGED" CONTENT="20110522;16540000">
<STYLE TYPE="text/css">
<!--
@page { margin: 0.26in }
P { margin-bottom: 0.15in; direction: ltr; color: #000000; line-height: 0.15in; text-align: justify; widows: 2; orphans: 2 }
P.western { font-family: "Arial", sans-serif; font-size: 10pt; so-language: en-US }
P.cjk { font-family: "Batang", "바탕", serif; font-size: 10pt }
P.ctl { font-family: "Times New Roman", serif; font-size: 10pt; so-language: ar-SA }
A:link { color: #0000ff }
-->
</STYLE>
</HEAD>
<BODY LANG="en-US" TEXT="#000000" LINK="#0000ff" DIR="LTR" STYLE="border: 5.05pt double #000000; padding: 0.67in 0.92in">

<P>I want this and the tags around it, just not the html, head, body and their closing tags.</P>

</BODY>
</HTML>

within the body, the tags are each styled for example: <p style="color: red"></p> so I cannot just get rid of all html, I want to get only all the content within the body tags, but without the body tags obviously
strip_tags does not work as i need, I only want to strip certain tags.

If someone can help me with this i will much appreciate it.

I am asking out of curiosity, how does this problem usually get solved, when using a tag system to sort content, and users enter similar tags.

For example:

flower and flowers...

which means the difference between singular and plural. Judging by other sites which are around, this problem is not solved at all, they simply let you add as many tags as you want and then rank the most used tags, it indeed is a solution, but seems more like a walk-around solution to me.

Any ideas how somebody could approach to solve this one?

EDIT:

My suggestion would be an analysis function, which analyzes the entered tag and then suggests the user that similar tags have been already entered and perhaps he wants to choose one of those which have been already entered. This does work though with a high traffic websites what can happen is the following:

php and php5

You can end up with two similar tags which are both widely used though have different meanings to the user base.

This one could be solved by simply prohibiting similar tags with little additions or changes, and so to speak "forcing" the user to choose something which is already there. May be a way, though it can turn out as a bad solution as well.

Do anyone know how i can put the html tags in the same line as the other html tags?

Here's an example:

Code: [Select]
Images | Link | Delete | Enabled

On my code, it break the tags to the new line without put on the same line as the other tags.


Here's the code:

Code: [Select]
[code]<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'mypass');
    define('DB_DATABASE', 'mydbtable');

    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {
  die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }

    $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    if($username == '') {
  $errmsg_arr[] = 'username ID missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD ID missing';
  $errflag = true;
    }

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE username='$username' AND passwd='$password'";
  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());

if(mysql_num_rows($result) > 0) {
  $qrytable1="SELECT images, id, public FROM members WHERE username='$username'";
  $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());

  while ($row = mysql_fetch_array($result1)) {  
  echo '<p id="images"> <a href="images.php?id='.$row['id'].'">Images</a></td> | <a href="http://' .  $row["links"] . '">Link</a> </td> | <a href="delete.php?id='.$row['id'].'">Delete</a> </td> |  <p> <p id="test">'.$row['Public'].'</td>'';
  }
}
}
?>[/code]

Say I have the following text stored in a MySQL database...

Code: [Select]
<b>Classic Quote from movie</b>
and I retrieve it into a variable called $text, how do I properly echo that so that it keeps the bold tags and actually display the text "Classic quote from movie" in BOLD?

I'm doing something wrong somewhere along the line (simply doing "echo $text;") because it displays on the page as...

Code: [Select]
<b>Classic Quote from movie</b>

Instead of...

Classic Quote from movie

Any info on properly storing and echoing back HTML would be very appreciated.

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

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

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.