Jump to content

Recommended Posts

Can anyone please help me insert this line of html and javascript into my php code?

I have a radio button which when clicked will open delete_news.php
I want to put that in the php code so every record will have the radio button next to it so it can be deleted.

[code]<input style="border:none;" type="radio" name="loc" onClick="go('index.php?page=delete_news');">[/code]

[code]while($code = mysql_fetch_object($q)) {
    echo("[b]<h3>[/b]".$code->title."</h3><BR>");}[/code]

I would like the HTML to replace the <h3> but becuase the HTML has " in it i'm not sure how to insert it
escape the quotes (\") or do this:
[code]
while($code = mysql_fetch_object($q)) {
    echo '<input style="border:none;" type="radio" name="loc" onClick="go(\'index.php?page=delete_news\');">' . $code->title . "<br />\n";[/code]
I did what you mentioned but I am getting an error.  It says [b]Parse error:[/b] syntax error, unexpected '>' in ........on line [b]47[/b]


line 47 is the line i changed

Here is the entire script
[code]<fieldset>
<?
//REMEMBER TO CONNECT TO DATABASE!

include_once("../includes/connection.php");
    @mysql_connect($host, $user, $password) or die("ERROR--CAN'T CONNECT TO SERVER");
    @mysql_select_db($database) or die("ERROR--CAN'T CONNECT TO DB");
//**EDIT TO YOUR TABLE NAME, ECT.

$t = mysql_query("SELECT * FROM `news`");
  if(!$t) die(mysql_error());
   
$a                = mysql_fetch_object($t);
$total_items      = mysql_num_rows($t);
$limit            = $_GET['limit'];
$type            = $_GET['type'];
$page            = $_GET['pagenum'];

//set default if: $limit is empty, non numerical, less than 2, greater than 50
if((!$limit)  || (is_numeric($limit) == false) || ($limit < 2) || ($limit > 50)) {
    $limit = 2; //default
}
//set default if: $page is empty, non numerical, less than zero, greater than total available
if((!$page) || (is_numeric($page) == false) || ($page < 0) || ($page > $total_items)) {
      $page = 1; //default
}

//calcuate total pages
$total_pages    = ceil($total_items / $limit);
$set_limit          = $page * $limit - ($limit);

//query: **EDIT TO YOUR TABLE NAME, ECT.

$q = mysql_query("SELECT * FROM `news` LIMIT $set_limit, $limit");
  if(!$q) die(mysql_error());
    $err = mysql_num_rows($q);
      if($err == 0) die("No matches met your criteria.");

//Results per page: **EDIT LINK PATH**
echo(" 
<a href=?page=delete_news&limit=10&amp;pagenum=1></a>
<a href=?page=delete_news&limit=25&amp;pagenum=1></a>
<a href=?page=delete_news&limit=50&amp;pagenum=1></a>");

//show data matching query:
while($code = mysql_fetch_object($q)) {
    echo("<input style=\"border:none;\" type=\"radio\" name=\"loc\" onClick=\"go('index.php?page=deletenews');\">\".$code->title."<br>");
     
}

$id = urlencode($id); //makes browser friendly

//prev. page: **EDIT LINK PATH**

$prev_page = $page - 1;

if($prev_page >= 1) {
  echo("<input style=\"border:none;\" type=\"radio\" name=\"loc\" onClick=\"go('index.php?page=deletenews');\">\".$code->title."<br>");
}

//Display middle pages: **EDIT LINK PATH**

for($a = 1; $a <= $total_pages; $a++)
{
  if($a == $page) {
      echo("<b> $a</b> | "); //no link
    } else {
  echo("  <a href=?page=delete_news&limit=$limit&amp;pagenum=$a> $a </a> | ");
    }
}

//next page: **EDIT THIS LINK PATH**

$next_page = $page + 1;
if($next_page <= $total_pages) {
  echo("<a href=?page=delete_news&limit=$limit&amp;pagenum=$next_page><b>Next</b></a> &gt; &gt;");
}

//all done
?>
</fieldset>[/code]
line 47... that would be:

[code] echo("<input style=\"border:none;\" type=\"radio\" name=\"loc\" onClick=\"go('index.php?page=deletenews');\">\".$code->title."<br>");[/code]
?

echo "<inpput style=\border:none;\" type=\"radio\" name=\"loc\" onClick=\"go('index.php?page=deletenews');\">" . $code->title . "<br>";

should work.  It seems to me that you didnt need to escape the " around );\">\[b]"[/b].$code
Nope.....still didn't work.

in the same script that I use on another page, I have
[code]echo("<h3>".$code->title."</h3><BR>");[/code] on line 47 and it works perfectly except all that it does is display each of the records.
As soon as I add the other code it comes up with the error and i think it's referring to [b].$code->title.[/b]

Is there another way I can perform the query to display all the records with a radio button
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.