PHP - Didn't Understand This Bit From The Manual..

Hi,
I'm trying to login oscommerce with manual code. but unable to do that. all entries going to database but don't understand what is missing???
here is my code

Code: [Select]
$email_address = $_REQUEST['txtemail'];
       $password = $_REQUEST['password'];

    $check_customer_query = mysql_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from customers where customers_email_address = '" . $email_address . "'");
    if (mysql_num_rows($check_customer_query)> 0)
{
   $check_customer = mysql_fetch_assoc($check_customer_query);
  if (!tep_validate_password($password, $check_customer['customers_password']))
   {
     echo "password not found.";
   }else {

 

  tep_session_recreate();


$check_country_query = mysql_query("select entry_country_id, entry_zone_id from address_book where customers_id = '" . (int)$check_customer['customers_id'] . "' and address_book_id = '" . (int)$check_customer['customers_default_address_id'] . "'");
$check_country = mysql_fetch_array($check_country_query);

$customer_id = $check_customer['customers_id'];
$customer_default_address_id = $check_customer['customers_default_address_id'];
$customer_first_name = $check_customer['customers_firstname'];
$customer_country_id = $check_country['entry_country_id'];
$customer_zone_id = $check_country['entry_zone_id'];
tep_session_register('customer_id');
tep_session_register('customer_default_address_id');
tep_session_register('customer_first_name');
tep_session_register('customer_country_id');
tep_session_register('customer_zone_id');

mysql_query("update customers_info set customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1 where customers_info_id = '" . (int)$customer_id . "'");


anyone have any idea about?

[ m ]printf[/ m]produces a link to   php.net/<span>printf   Unless you use nobbc tags, then it works fine ???
Edited by Barand, 24 November 2014 - 02:25 PM.

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.

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 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,

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

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

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.

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,

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

Ok, if you've helped with any of my questions before (thanks again to those who have) you know that I'm fairly new to php and still learning.  This brings me to another question...

I have read the post on header errors and I understand that in order to prevent these errors or warnings I need to  process a form BEFORE OUTPUTTING ANYTHING TO THE BROWSER.  The thing is, I'm having a problem understanding how I can do this with the code that I have written.  Can someone please look at my code and explain what is causing the header warning that I'm getting and help me to understand how to fix it?

Here's my code (warning message is following the code):
Code: [Select]
<?php
session_start(); // Starts the session.
?>

<html>

<head>
<title>Welcome to CaresAbout.us!</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<SCRIPT TYPE="text/javascript">    <!-- THIS IS LINE 11 -->
<!--
function popup(mylink, windowname)
{
if (! window.focus)return true;
var href;
if (typeof(mylink) == 'string')
   href=mylink;
else
   href=mylink.href;
window.open(href, windowname, 'width=400,height=200,scrollbars=yes');
return false;
}
//-->
</SCRIPT>


<style type="text/css">
<!--
html { overflow: -moz-scrollbars-vertical; }
html { overflow-x: auto; }

body {
background-color: #000000;
background-image: url(bg.png);
background-position: 50% 50%;
background-repeat: repeat-y
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 14px;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.bluelink {color: #0000CC}
.blacklink {color: #000000}
-->
</style>

</head>

<body>

<div align="center">
<noscript><font size="+2" color="#000000"><strong>Some features of this site will not operate without Javascript enabled!<br>Please <a href="http://www.heart.org/HEARTORG/form/enablescript.html" class="bluelink">enable Javascript</a> in your browser to have full access.</strong></font></noscript>
  <table width="1000" height="175" border="0" cellpadding="0" cellspacing="0" style="background: transparent url('headbg.png') top center no-repeat;">
    <tr>
  <td height="125" width="160">&nbsp;</td>
  <td height="125">&nbsp;</td>
  <td height="125">&nbsp;</td>
  <td height="125" width="160">&nbsp;</td>
</tr>
<tr>
  <td height="50" width="160">&nbsp;</td>
 
  <?php

include("conf.inc.php"); // Includes the db and form info.
if ($_SESSION['logged'] == 1) { // User is already logged in.
    $_SESSION['email'] = $email;
header("Location: main.php"); // Goes to main page.
exit(); // Stops the rest of the script.
} else {
if (!isset($_POST['submit'])) { // If the form HAS NOT been submitted.
echo "<td width=\"320\" height=\"50\" align=\"left\" valign=\"middle\">&nbsp;</td>";
       echo "<td width=\"360\" height=\"50\" align=\"left\" valign=\"middle\">";
echo "<form name=\"form\" action=\"index.php\" method=\"POST\" style=\"margin-bottom:0;\">";
echo "<a href=\"signup.php\" class=\"bluelink\">Sign Me Up!</a>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ";
echo "<a href=\"pwordhelp.php\" class=\"bluelink\" onMouseOver=\"window.name = 'main'\" onClick=\"return popup(this, 'notes')\">Forgot Password</a><br>";
echo "<input type=\"text\" name=\"email\" size=\"17\" value=\"Email...\" style=\"color: #999999\" onfocus=\"if (this.value == 'Email...') {this.value=''; this.style.color='#000000'}\"> &nbsp; &nbsp;";
echo "<input type=\"password\" name=\"pword\" size=\"17\" value=\"Password...\" style=\"color: #999999\" onfocus=\"if (this.value == 'Password...') {this.value=''; this.style.color='#000000';}\"> ";
echo "<input type=\"submit\" name=\"submit\" value=\"Submit\">";
echo "</form>";
} else {    // If the form HAS been submitted
$email = form($_POST['email']);
$pword = md5($_POST['pword']); // Encrypts the password.

$q = mysql_query("SELECT * FROM `signin` WHERE email = '$email' AND pword = '$pword'") or die (mysql_error()); // mySQL query
$r = mysql_num_rows($q); // Checks to see if anything is in the db. 

if (!$r) { // There is nothing in the db. The username/password do not match up.

echo "<td width=\"108\" height=\"50\" align=\"left\" valign=\"middle\">&nbsp;</td>";
       echo "<td width=\"572\" height=\"50\" align=\"left\" valign=\"middle\">";
echo "<form name=\"form\" action=\"index.php\" method=\"POST\" style=\"margin-bottom:0;\">";
echo "&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a href=\"signup.php\" class=\"bluelink\">Sign Me Up!</a>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;";
echo "<a href=\"pwordhelp.php\" class=\"bluelink\" onClick=\"return popup(this, 'notes')\">Forgot Password</a><br>";
echo "<font color=\"#FF0000\"><strong>Incorrect Email or Password.</strong></font>&nbsp; &nbsp;";
echo "<input type=\"text\" name=\"email\" size=\"17\" value=\"Email...\" style=\"color: #999999\" onfocus=\"if (this.value == 'Email...') {this.value=''; this.style.color='#000000'}\"> &nbsp; &nbsp;";
echo "<input type=\"password\" name=\"pword\" size=\"17\" value=\"Password...\" style=\"color: #999999\" onfocus=\"if (this.value == 'Password...') {this.value=''; this.style.color='#000000';}\"> ";
echo "<input type=\"submit\" name=\"submit\" value=\"Submit\">";
echo "</form>";

} else {      // If the username/password is valid

$_SESSION['logged'] = 1; // Sets the session.
$_SESSION['email'] = $email;
header("Location: main.php"); // THIS IS LINE 118
exit(); // Stops the rest of the script.

}
}
}
?>
 
  </td>
  <td height="50" width="160">&nbsp;</td>
</tr>
  </table>
</div>

<?php

echo "<div align=\"center\">";
echo "<table width=\"1000\" height=\"395\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";
  echo "<tr>";
      echo "<td width=\"160\" align=\"center\" valign=\"top\">";
  // Begin Column 1.
  
  include("left.inc.php");
     
  // End Column 1.
  echo "</td>"; 
      echo "<td width=\"680\" align=\"center\" valign=\"top\" style=\"background: #FFFFFF url('bottombg.png') bottom center no-repeat;\">";
  // Begin Column 2.

  echo "<table width=\"650\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";
     echo "<tr>";
  echo" <td align=\"left\" valign=\"top\">";
  echo "<p><img src=\"nothing.gif\" height=\"5\"><br><img src=\"silouhette.png\" height=\"215\" width=\"325\" align=\"right\"><img src=\"nothing.gif\" height=\"215\" width=\"10\" align=\"right\"><div align=\"justify\"><font size=\"+2\">&nbsp;<br>Welcome students! Now you can contact the teachers and staff members of your school easily, safely, and TOTALLY ANONYMOUSLY!  Just follow these directions:</font></div></p>";
  echo "<p><font size=\"+1\">1. If you haven't already, <a href=\"signup.php\" class=\"bluelink\">sign up</a> for an account.  We will never ask for your name,<br>&nbsp; &nbsp; all you need is an email address (get one free at <a href=\"http://www.google.com/mail\" class=\"bluelink\" target=\"_blank\">Google.com</a>).<br><img src=\"nothing.gif\" height=\"5\"><br></font>";
  echo "** &nbsp;It is very important that your email address is correct because a notification will be sent to your email<br>&nbsp; &nbsp; &nbsp;when you receive a message from a staff member, otherwise you will NEVER be contacted by email.<br><img src=\"nothing.gif\" height=\"10\"><br>";
  echo "<font size=\"+1\">2. Sign in to your account using your email address and password that you chose<br>&nbsp; &nbsp; when you signed up.<br><img src=\"nothing.gif\" height=\"10\"><br>";
  echo "3. Once you are signed in, you will be able to send anonymous messages to staff<br>&nbsp; &nbsp; members, reply to staff members' messages, and play some cool games too!</p>";
  echo "<p><div align=\"center\"><font size=\"+3\">Thank you for using CaresAbout.us!</font></p>";
  echo "</td>";
  echo "</tr>";
  echo "</table>";
  
  // End Column 2.
  echo "</td>";
  echo "<td width=\"160\" align=\"center\" valign=\"top\">";
  // Begin Column 3.
  
  include ("right.inc.php");
  
  //  End Column 3.
  echo "</td>";
  echo "</tr>";
echo "</table>";
echo "</div>";

include("foot.inc.php");

?>

</body>
</html>

Here's the warning message that I'm getting:
Warning: Cannot modify header information - headers already sent by (output started at /home/content/29/6879529/html/calhoun/index.php:11) in /home/content/29/6879529/html/calhoun/index.php on line 118

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

Quote

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\xampp\htdocs\hofiles\mschginsert.php on line 12


<?php
$dep=$_POST['dep'];
$name=$_POST['name'];
$apt=$_POST['apt'];
$amtpaid=$_POST['amtpaid'];
$damage=$_POST['damage'];
$month=$_POST['month'];
$courtcost=$_POST['courtcost'];
$nsf=$_POST['nsf'];
$latechg=$_POST['latechg'];
mysql_connect(localhost,root,"");
mysql_select_db(mschgdb) or die "Unable to select database");
$query = "INSERT INTO miscdata VALUES ('','$dep','$name','$apt','$amtpaid','$damage','$month','$courtcost','$nsf','$latechg')";
mysql_query($query);

mysql_close();
?>

Hi All,
I'm trying to understand the following code.  I tried to display the field 'eligible' (an added field to a mysql table) for user input, but I keep getting an Invalid Type error at getFieldHTML('eligible').  Other fields are displayed correctly using the same syntax.  Is getFieldHtml a class, etc?  I'm sort of new to php..but I'm a quick learner...Thanks for any help!
Chris

<div class="form-container">
    <?php echo $form->getFormOpenHTML(); ?>
        <fieldset class="hidden">
            <ol>
                <li>Are you eligible?<?php echo $form->getFieldHTML('eligible'); ?></li>