[PHP] Parse error - Softwareontwikkeling

vrijdag 23 november 2001 20:43

Acties:

Topicstarter

Hoi,

Er staan al wat parse errors tussen, het lijkt er echter op dat ik een nieuwe heb

Namelijk deze:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /webroot/httpdocs/engine/processproduct.php on line 63

Ik krijg deze melding steeds opnieuw. Zelfs als ik code aanpas waardoor de code die op regel 63 op regel 64,62,65 of waar dan ook terecht komt dan blijft het regel 63 heten.
Met Google kwam ik al wat dingen tegen met betrekking tot het gebruik van quotes en aanhalingstekens door elkaar maar dat is hier niet het geval. Ik heb het tenminste niet kunnen vinden.
Misschien dat er nog een andere oorzaak is. De source code is wat veel om hier neer te zetten aangezien het volgens mij niet direct iets met regel 63 te maken heeft.
Dit staat er ronde regel 63:

61 /* Produkt ID parameter */
62 if( $prod_id != null )
63 {
64 $qkey1 = "id = '".$prod_id."' ";
65 }

Verder is het zo dat ik dit script al eerder gebruik zonder dat ik die error melding krijg. Via een formpost. De erro melding ontstaat nadat ik het aanroep via een directe link.

Nog sterker is het dat het lokaal wel werkt maar online (op de server van de provider) niet. Terwijl het gewoon een 1 op 1 kopie is.

Ik hoop dat iemand nog een idee heeft.

Alvast bedankt.

vrijdag 23 november 2001 20:53

Acties:

chris

Hmmz, heel vreemd... Kan je misschien het hele script posten? Ik zie nl. de fout niet zo snel...

vrijdag 23 november 2001 21:12

Acties:

rvrbtcpt

Topicstarter

Ok dan, hier komt ie:<blockquote>php:<hr><pre><code><?
/*
 Scriptname : processproduct.php
 Description : Handle several product actions like add, change and view

 Version : 1.0
 Date : 13-05-2001
 Changed : 29-09-2001
 Author : R. Frijns
 Company : WeCreate
*/
session_start();
if( !isset($session["anonymous"]) || $session["anonymous"] == 0 )
{
 include( "/usr/local/slash/apache/vhosts/bardolino.nl/httpdocs/bardolino/backoffice/templates/nl/error/no_auth.htm" );
 exit;
}
include( $session["dirinc"]."/general.inc");
include( $session["dirlib"]."/messages.inc");
include( $session["dirlib"]."/catalogsql.inc");
include( $session["dirlib"]."/prodsql.inc");
include( $session["dirlib"]."/dbconnect.inc");

writeLog( 0, "processproduct.php started - 001 - ");
writeLog( 0, "Action = ".$act );

switch($act)
{
 /**
 * Search for one or more products in the catalog
 *
 * Form fields : prod_id, prod_name
 * Checkbox : prod_hotdeal , prod_available
 * Radio : prod_online ( online / offline / alles )
 * Drop down : prod_sort ( sortname / sortid )
 *
 */
 case "search":

 // Process the given search parameters and create an SQL statement which
 // should be used in the search

 writeLog(0, "Search parameters for backoffice produkt list generation ");
 writeLog(0, "ID : ".$prod_id );
 writeLog(0, "Name : ".$prod_name );
 writeLog(0, "Hotdeal : ".$prod_hotdeal );
 writeLog(0, "Online : ".$prod_online );
 writeLog(0, "Available : ".$prod_available );
 writeLog(0, "Sort : ".$prod_sort );

 // *************************************** Create search query - Start *****************************************

 // Standard query string

 $query = "SELECT * FROM products WHERE ";
 $qkey1 = "";
 $qkey2 = "";
 $qkey3 = "";
 $qkey4 = "";
 $qsort = "";

 // Produkt ID parameter
 if( $prod_id != null )
 {
 $qkey1 = "id = '".$prod_id."' ";
 }

 // Produkt name parameter
 if( $prod_name != null )
 {
 $qkey1 = "name LIKE '%".$prod_name."%' ";
 }

 // Search for hotdeals only ?
 if( $prod_hotdeal == true )
 {
 if( $qkey1 == null )
 {
 $qkey2 = " hotdeal = 1 ";
 } else {
 $qkey2 = " AND hotdeal = 1 ";
 }
 } else {
 $qkey2 = "";
 }

 // This line should be added
 $qadd = $qkey1.$qkey2;

 // Search for online products only ?
 if( $prod_online == 'online' ) {
 if( $qadd == null ) {
 $qkey3 = " online = 1 ";
 } else {
 $qkey3 = " AND online = 1 ";
 }
 }
 if( $prod_online == 'offline' ) {
 if( $qadd == null ) {
 $qkey3 = " online = 0 ";
 } else {
 $qkey3 = " AND online = 0 ";
 }
 }
 if( $prod_online == 'alles' ) {
 $qkey3 = " online = 0 or online = 1 ";
 }

 $qnew = $qadd.$qkey3;

 // Search for available products only
 if( $prod_available == true ) {
 if( $qnew == null ) {
 $qkey4 = " available = 1 ";
 } else {
 $qkey4 = " AND available = 1 ";
 }
 } else {
 $qkey4 = "";
 }

 // Sort parameter
 if( $prod_sort == 'sortname') {
 $qsort = " ORDER BY name";
 }
 if( $prod_sort == 'sortid') {
 $qsort = " ORDER BY id";
 }

 // This is the search query which needs to be executed
 $searchquery = $query.$qnew.$qkey4.$qsort;
 writeLog(0,"Search query created : ".$searchquery );
 $session["search_query"] = $searchquery;

 // *************************************** Create search query - end *****************************************

 $rows_per_page = $session["listsize"];
 writeLog(0,"Number of products per page : ".$rows_per_page );

 // Make a database connection
 $db = new mysqlconnection();
 $connid = $db->mysqlconnect();

 // Determine the number of records in this result
 $total_records = getSearchResultCount($searchquery);

 $pages = floor($total_records / $rows_per_page); // Or ceil ?

 unset($prevpage, $nextpage);

 writeLog(0,"The product search result has a size of : ".$total_records );
 if( $total_records > 0 ) {

 writeLog(0,"Productlist size : ".$total_records ." Maximum listing on one page : ".$rows_per_page." Result is ".$pages." pages." );

 if( !isset($pg) ) {
 writeLog( 0, "Showing first page." );
 $pg = 0;
 } else {
 writeLog( 0, "Showing page ".$pg );
 }

 // Determine the start page
 $start = $pg * $rows_per_page;

 // These are for display purposes only (not for use in a query)
 $showstart = $start +1;
 $showend = $start + $rows_per_page;
 if( $showend > $total_records ) {
 $showend = $total_records;
 }

 $productList = array();
 $productList = processSearchQuery( $searchquery , $connid, $start, $rows_per_page );

 if ($pg > 0) {
 $prevpage = $pg - 1;
 }

 if ($pg < $pages) {
 $nextpage = $pg + 1;
 }

 $session["origin"] = "productlist";

 include ( $session["tmpldir"]."product/productlist.php");

 } else {
 // No products found
 writeLog(0,"The search did not deliver any products" );
 include ( $session["tmpldir"]."product/productindex.php");
 }

 break;

 // View the search result continued (show the next or previous page)
 case "scont":

 writeLog( 0, "Show another page from the search result." );

 $searchquery = $session["search_query"];
 writeLog(0,"Search query from session : ".$searchquery );


 $rows_per_page = $session["listsize"];
 writeLog(0,"Number of products per page : ".$rows_per_page );

 // Make a database connection
 $db = new mysqlconnection();
 $connid = $db->mysqlconnect();

 // Determine the number of records in this result
 $total_records = getSearchResultCount($searchquery);

 $pages = floor($total_records / $rows_per_page); // Or ceil ?

 unset($prevpage, $nextpage);

 writeLog(0,"The product search result has a size of : ".$total_records );
 if( $total_records > 0 ) {

 writeLog(0,"Productlist size : ".$total_records ." Maximum listing on one page : ".$rows_per_page." Result is ".$pages." pages." );

 if( !isset($pg) ) {
 writeLog( 0, "Showing first page." );
 $pg = 0;
 } else {
 writeLog( 0, "Showing page ".$pg );
 }

 // Determine the start page
 $start = $pg * $rows_per_page;

 $showstart = $start + 1;
 $showend = $start + $rows_per_page;
 if( $showend > $total_records ) {
 $showend = $total_records;
 }

 $productList = array();
 $productList = processSearchQuery( $searchquery , $connid, $start, $rows_per_page );

 if ($pg > 0) {
 $prevpage = $pg - 1;
 }

 if ($pg < $pages) {
 $nextpage = $pg + 1;
 }

 include ( $session["tmpldir"]."product/productlist.php");

 } else {
 // No products found
 writeLog(0,"The search did not deliver any products" );
 include ( $session["tmpldir"]."product/productindex.php");
 }

 break;

 // Show the page to fill out new product information
 case "new":

 $db = new mysqlconnection();
 $connid = $db->mysqlconnect();

 $catagories = getAllCatagories();

 $session["origin"] = "shownewproduct";

 include( &

vrijdag 23 november 2001 22:31

Acties:

_-= Erikje =-_

hmm, misschien php van provider brak?

vrijdag 23 november 2001 22:40

Acties:

Cheater

64 $qkey1 = "id = '".$prod_id."' ";

Probeer eens;

64 $qkey1 = "id = '.$prod_id.' ";

Want dit doe je in andere delen wel zo.

zaterdag 24 november 2001 01:06

Acties:

thomaske

» » » » » »

Maak van dit:

62 if( $prod_id != null )

eens dit:

62 if( $prod_id != "null" )

ik weet niet of het dan nog werkt, maar daar ligt volgens mij wel de fout!

Brusselmans: "Continuïteit bestaat niet, tenzij in zinloze vorm. Iets wat continu is, is obsessief, dus ziekelijk, dus oninteressant, dus zinloos."