[RESOLVED] help with php syntax

Thikho

Hi im trying to put my javascript confirm delete on my delete link , I MA GETTING THIS ERROR syntax error, unexpected T_STRING in, im sure its all about my single quote and double quotes kindly help with this

the javascript works but i cannot fetch my id form the database , but itf i put the single quotes it does not work pls help me

 $delete   = '<a href='cat_delete.php?ategoryID=$row[0]' onclick="javascript:return confirm(\'Are you sure you want to delete ?\')">Delete</a>';

<?php
// Get details from database

$categoryID = $_POST['categoryID'];
$catname = $_POST['catname'];
$catpaid = $_POST['catpaid'];


if (isset($categoryID)) {
   $displayError = messageDisplay($errorMessage['cannot_connect_to_db'],"error");
   echo "</tr></table>
         $displayError
         <table><tr>";
} else {

   $startVal = $start - 1;
	$sql = "SELECT categoryID, name FROM Categories ORDER BY categoryID";
  	 $result = mysql_query($sql);

   while ($row = mysql_fetch_array($result)) {
      $categoryID  = $row[0];
      $catname = $row[1];
      $catpaid    = $row[2];

  $contentDisplayed = $catpaid;
  $contentDisplayed = strip_tags($catpaid);
  $contentDisplayed = (strlen($contentDisplayed) > 200) ? substr($contentDisplayed,0,200)."..." : "$contentDisplayed";


$edit    = "<a href='updatecategory.php?categoryID=$row[0]'>Edit</a>";

 $delete   = '<a href='cat_delete.php?categoryID=$row[0]' onclick="javascript:return confirm(\'Are you sure you want to delete ?\')">Delete</a>';


  $class      = ($class == "adminRow1") ? "adminRow2" : "adminRow1";
  echo        '<tr class="'.$class.'">'
              .'<td>'.$categoryID.'</td>'
              .'<td>'.$catname.'</td>'
              .'<td style="text-align: center">'.$edit.'</td>'
              .'<td style="text-align: center">'.$delete.'</td><div style="position: absolute; "></form></div></td>'
              .'</tr>';
   }
}

?>

leatherback

I am presuming the first statement is the one giving you the headache. Not sure why you posted the other code though.. Hm..

I think this should be about right:


$delete   = "
<a href=\"cat_delete.php?ategoryID=".$row[0]."\"
     onclick=\"javascript:return confirm('Are you sure you want to delete ?')\">Delete
</a>";

Thikho

tnks i managed to resolve the iSsue pls help with the new line \n when i add it doesnt work i want my test to move to the next line so that my confirm box with is a bit smaller

I want to put the new line between the database. and Are

$delete   = "<a href=\"cat_delete.php?categoryID=$row[0]\" onclick=\"javascript:return confirm('Please note:the information will be deleted from the database.Are you sure you want to delete this category details ?')\">Delete</a>";

bradgrafelman

Are you saying you want to add a line break into the Javascript alert box after "database." ? If so, you'll need to add a literal '\n' into the Javascript code (meaning you'll want to escape the backslash so that PHP doesn't try to interpret it as a special escape sequence for a new line).

Thikho

i have added the new line '\n' but it does not show my alert box it juts delete without showing the box , which take me back to the same issue of escaping the backlash so it can intepret as a new line

 $delete   = "<a href=\"cat_delete.php?ategoryID=$row[0]\" onclick=\"javascript:return confirm('Please note:the information will be deleted from the database.\"n\" Are you sure you want to delete this category details ?')\">Delete</a>";

i also tried but it does not work

  $delete   = "<a href=\"cat_delete.php?ategoryID=$row[0]\" onclick=\"javascript:return confirm('Please note:the information will be deleted from the database.'\n' Are you sure you want to delete this category details ?')\">Delete</a>";

laserlight

More like:

$delete = "<a href=\"cat_delete.php?ategoryID=$row[0]\" onclick=\"javascript:return confirm('Please note:the information will be deleted from the database.\\n Are you sure you want to delete this category details ?')\">Delete</a>";

As bradgrafelman noted, "you'll want to escape the backslash".

Thikho

tnks Laser n Brad works perfectly now

laserlight

You're welcome 🙂
Remember to mark this thread as resolved using the thread tools.