PHP - Div Inside Div

I have a php code... In which there is a link and i want to apply a javascript onclick event onthat link...

Code: [Select]
echo "<a onclick=vieww_det(". $arr[$i].", ".$arr[$j].")>View Details </a>";

But its not working...

Any help will be appreciated

- Pranshu Agrawal
pranshu.a.11@gmail.com

I need to put php inside php.
Code: [Select]
$insertGoTo = "index.php? "$sbninesven" ";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
What do I do to get that inside of
$insertGoTo = "index.php? "$sbninesven" ";

I want to use a window.open java script but generate the list of links via phpe


<script>
function multiWin()
{
$s=2;
while ($s <= 25) {
echo '$links[$s]';
$s++;
}
}
</script>


I realize the above coding is wrong and it will be inside php so how would I do it correctly? Also I want it to drop a liner after every link. I've played around with this for a few hours now and I am completely lost now.

im trying to create a table for a site admin. bsicaly all he has to do is fill out a form and the values of the form are turned into the table name.

im using a .sql file as a template but to create the table i need the php genarated table name to be inserted into the .sql file.

<?php
include("config.php");
$con details

$tbl_name = "static_name_for_now";
if (mysql_query("seat_plan.sql")) { 
  echo "success"; 
} else{
echo "fail"; 
}
?>

sql file snippet
INSERT INTO `<?php $tbl_name ?>` VALUES('A', 1, 0, 'Y');
also tried

INSERT INTO `<?php echo $tbl_name ?>` VALUES('A', 1, 0, 'Y');
thanks

Hello,

I need to add rel="..." in the first part of the script but it is not working,

below is the script:

Code: [Select]
echo " <a href='products/".$image[$abc]."' target='_blank'><img border=0 src='products/thumbs2/".$image[$abc]."' /></a>";

Thank you,

how can i put an if statement inside an echo this is what i want to do
Code: [Select]
<?php
echo "<li> <a  class='thumb' href='../images/Sections/pinkpanthers/" . $year . "/" . $sessions . "/" . $day . "/" . $y . ".jpg' title=''>
<img src='../images/Sections/pinkpanthers/" . $year . "/" . $sessions . "/" . $day . "/thumbs/" . $y . ".jpg ' /></a><div class='caption'>
<div class='download'><a href='../images/Sections/pinkpanthers/" . $year . "/" . $sessions . "/" . $day . "/big/" . $y . ".jpg ' target='_blank' />Download</a>
</div><div class='image-desc'>" . if ($count == 1){echo "<a href='tag.php?tag=$name'" . $name . ">" . $name . "</a>";}if ($count > 1){$z = 0;$w = $count - 1;while ($z <= $w){$p = $multi[$z];echo "<a href='tag.php?tag=$p'" . $p . ">" . $p . "</a>";$z++;}} . "</div></div></li>";
?>
all the code works wright up until i added the if statements in the last little bit

As of right now I have values of 0 for the fields in champ_id as well as the con1_id, con2_id, and con3_id which is all fine. The end query returns 0 results which I understand however I'm trying to figure out that if the values in these fields is 0 then have it echo "Vacant" but i'm not sure if you can do a if statement inside a select statement.

$query = "SELECT 
titles.titlename,
    titles.id, 
( SELECT c.charactername FROM characters AS c WHERE c.id = champions.champ_id ) AS champion,
( SELECT c.charactername FROM characters AS c WHERE c.id = champions.con1_id ) AS con1, 
( SELECT c.charactername FROM characters AS c WHERE c.id = champions.con2_id ) AS con2, 
( SELECT c.charactername FROM characters AS c WHERE c.id = champions.con3_id ) AS con3
FROM 
     champions 
     INNER JOIN titles 
          ON champions.title_id = titles.id";

I get this error so I was wondering if it is because I can't put a while inside a foreach?
"syntax error, unexpected T_WHILE in home/g/h/t...."

while($rows=mysql_fetch_array($rr)){
$pt_id = unserialize($rows['pts']);
foreach ($pt_id as $indiv) {
$q = "select * from indiv where id_incr = '$indiv'";
echo $q;
$result = mysql_query($q)
while $ptrow =mysql_fetch_array($result)){
echo $ptrow['v1'];
echo "<br>";
}
}
}

I'm sure you can do this in PHP, but for some reason when I view news.php - It automatically tells me I liked the post, when I haven't even clicked like yet!


while($fetch = mysql_fetch_assoc($query))

{

if($_GET['like'] == $fetch['id'])

{

$like = mysql_real_escape_string($_GET['like']);

$has_liked = mysql_query("SELECT * FROM likes WHERE id = '$like' AND username = '". $_SESSION['user'] ."'");

if(mysql_num_rows($has_liked) > 0)

{

echo "

<div id='post-1' class='post'>

<h2 class='title'><font color='white'>#". $i." ".$fetch['title'] ."</font>

<h3 class='date'>". $fetch['date'] ."</h3>

<div class='entry'>

<p>". nl2br(stripslashes($fetch['content'])) ."</p>

</div>

<p class='meta'><b>You've already liked this announcement.</b></p>

</div>

";

}

else

{

mysql_query("UPDATE news SET likes = likes + 1 WHERE id = '". $_GET['id'] ."'");

echo "

<div id='post-1' class='post'>

<h2 class='title'><font color='white'>#". $i." ".$fetch['title'] ."</font>

<h3 class='date'>". $fetch['date'] ."</h3>

<div class='entry'>

<p>". nl2br(stripslashes($fetch['content'])) ."</p>

</div>

<p class='meta'><b>You liked this announcement.</b></p>

</div>

";

}

}

else

{

echo "

<div id='post-1' class='post'>

<h2 class='title'><font color='white'>#". $i." ".$fetch['title'] ."</font>

<h3 class='date'>". $fetch['date'] ."</h3>

<div class='entry'>

<p>". nl2br(stripslashes($fetch['content'])) ."</p>

</div>

<p class='meta'><a href='news.php?like=". $fetch['id'] ."'>Like</a></p>

</div>

";

}

}

I have &quotThe Unforgettable&quot Jimmy Watkins  inside my db  and it PRODUCES
&quoteThe Unforgettable" Jimmy Watkins when its rendered.

Anyone know why?

Ok, so I am new to Ajax and am making a forma that will check the user etc. Seems easy, but wow, I'm just lost with all the different things I'm reading, but I know exactly what I want and can easily do it in PHP but of course that is slower and reloads the page. But I am trying to really secure my page so I am stripping everything before it gets to anywhere on my site, even the ajax. So this is what I am doing.

My form on index.php
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
      <script src="js/runonload.js"></script>
      <script type="text/javascript" src="js/checkcreateuser.js"></script>
      <link href="css/check.css" media="all" type="text/css" rel="stylesheet">
</head>

 
<body id="mysite">
                 <form method="post" id="registerForm" name="create_form" action="index.php">
                   <input type="hidden" name="action" value="create" />
                  <table width="290px">
                  <tr>
                  <td align="right">
                  User Name:
                  </td><td>
                  <input name="usernamecreate" id="usernamecreate" class="sign_up_input_area" type=text value="">
                  </td>
                  </tr><tr>
                  <td align="right">
                  Password:
                  </td><td>
                  <input name="passwordcreate" id="passwordcreate" class="sign_up_input_area" type=password value="">
                  </td>
                  </tr>
</table>
                  <input type="submit" class="submitButton2" name="Login" value="Create Account">
                 <div id="error_log">
                  <label class="error" for="usernamecreate" id="username_error">Username is required.</label>
                  <label class="error" for="usernamecreate" id="username_error2">Username is already in use.</label>
                  <label class="error" for="passwordcreate" id="password_error">Password is required.</label>
              </div>
Then I want my javascript to work, which does work right now, but only for empty values. I want to be able to compare if the user is in the database and for other PHP functions. Like Would I put this in a seperate checkcreate.php file?

Code: [Select]
$usernamemain1 = trim($_POST['username']);   
    $usernamemain = stripslashes(strip_tags($usernamemain1));
    $usernamecheck = mssql_real_escape_string($usernamemain, $link);
    $username_lower = strtolower($usernamecheck);
         
    $sql = "SELECT LoweredUserName FROM Users where LoweredUserName = '$username_lower'";
    $sql_result = mssql_query($sql);
    $login_row = mssql_fetch_assoc($sql_result);
    $username = $login_row['LoweredUserName'];

    $passwordmain1 = trim($_POST['password']);     
    $passwordmain = stripslashes(strip_tags($passwordmain1));
    $passwordcheck = mssql_real_escape_string($passwordmain, $link);
so I want to be able to use thos evariables in my checkcreateuser.js which is settup like

Code: [Select]
$(function() {
  $('.error').hide();
  $('input.sign_up_input_area').css({backgroundColor:"#FFFFFF"});
  $('input.sign_up_input_area').focus(function(){
    $(this).css({backgroundColor:"#FFDDAA"});
  });
  $('input.sign_up_input_area').blur(function(){
    $(this).css({backgroundColor:"#FFFFFF"});
  });

  $(".submitButton2").click(function() {
// validate and process form
// first hide any error messages
    $('.error').hide();


  var username = $("input#usernamecreate").val();
if (username == "") {
      $("label#username_error").show();
      $("input#usernamecreate").focus();
      return false;
    }
    if (<?echo $username_lower?> == "<?echo $username?>") {
      $("label#username_error2").show();
      $("input#usernamecreate").focus();
      return false;
    }
var password = $("input#passwordcreate").val();
if (password == "") {
      $("label#password_error").show();
      $("input#passwordcreate").focus();
      return false;
    }


var dataString = 'username='+ username + '&password=' + password;
//alert (dataString);return false;

$.ajax({
      type: "POST",
      url: "",
      data: dataString,
      success: function() {
        $('#contact_form').html("<div id='message'></div>");
        $('#message').html("<h2>Form Submitted!</h2>")
        .hide()
        .fadeIn(1500, function() {
          $('#message').append("<img id='checkmark' src='images/check.png' />");
        });
      }
     });
    return false;
});
});
runOnLoad(function(){
  $("input#username").select().focus();
});
I can't get the if (<?echo $username_lower?> == "<?echo $username?>") to use variables, of course they aren't seeing any of the variables because I don't know if I put this into a different file, then point my form action to that file and the ajax then sees it run or what? I'm really confused on it all, if anyone can help out that would be great. All the tutorials I keep finding are the same things over and over and don't really help because they always leave out various parts they are using or doing. I understand this much so far tho, but how do I do the variables in ajax when it posts type thing? Thanks!!!

Is it possible to echo php inside php? Im guessing not because you are already inside php but there must be a way round my problem.

What I would like to do is if the url has project = something then echo <?php require "footer.php"; ?> if not dont echo anything.

What is the best way to go about doing this ?

i have a database which contains a table named girls with three columns ...Serial(int) name(text) hits(int)

<?php
error_reporting(E_ALL ^ E_NOTICE);
$con = mysql_connect("localhost","gaurav","");
mysql_selectdb("website",$con);
$index1 = rand(1,$count);
$sql = mysql_query("SELECT * FROM girls WHERE Serial=$index1");
$row = mysql_fetch_array($sql);
$name1 = $row['name'];
$hits1 = $row['hits'];

echo <<<ECO
<html>
<script language="javascript">
increment(){
// some php code to increase the hits in database where name = $name1
}
</script>
<input type="button" value="increment" onclick="increment();" name="button">
</html>
ECO;
?>

sorry for the code to be really haphazard..i jst started with php.....now i dont know wat code to put to increment the hits in increment function since it would also use varialble $name1 and $index1.....

Hey guys I have the following script that correctly retrieves 2 values from mysql: security_code and selected_address:
The problem I have, is how can I add the retrieved values (more than 1 row) inside an array called $data


$data = array();
$result = mysql_query("SELECT security_code, selected_address FROM purchase WHERE purchase_id = '412012' AND selected_address = 'General Roca 900' ORDER BY `offers_bought`.`security_code` ASC"); 
$cant = 0; 
while($row=mysql_fetch_array($result))
{
array_push($data[$row['selected_address']], $row['security_code']);
        $cant++;
}


The array_push function gives me the following error:
Warning: array_push() [function.array-push]: First argument should be an array in C:\wamp\www\Test\test\excelTest.php on line 24

In other words this is want I want to achieve:
$data = array(array("selected_address" => $row['security_code']));
Only that this example adds only 1 retrieved row

Any ideas?
Thanks in advance!
Cheers,

Currently whether data from the queries are found or not, its surrounded inside the div tags...

i want to somehow echo the div tags inside the while loop, but only echo once.

the confusing part for me is that the queries are connecting to 2 different tables for data.. and both need to be found for the div to be echo.
 
if($item['quantity'] >= 1){   
if($item2['type'] == 'weapon'){


code below....


Code: [Select]

<div class="g_content"><h3 style="text-align: left">&nbsp;&nbsp;Weapons</h3><div class="g_text">
<table align='center' cellspacing='10'>
<?php

$current_col = 1;
$max_col = 4;


$query = $db->execute("select * from items where `player_id`=?", array($player->id));

while($item = $query->fetchrow())
{
$query2 = $db->execute("select * from `blueprint_items` where `id`=?",array($item['item_id']));
$item2 = $query2->fetchrow();


//DISPLAY IF QUANTITY IS 1 OR MORE.
if($item['quantity'] >= 1){
if($item2['type'] == 'weapon'){
    //Open new row if first column
    if($current_col==1)
    {
        echo "<tr>\n";
    }

    //Display current record

    echo "<td width='25%'>";
echo "<center><img src=\"{$item2['img']}\" width='80' height='80' style=\"border: 1px solid #CC9900\"></center>";
    echo "<center><a href=\"../description.php?id={$item2['id']}\">{$item2['name']}</a> [x".$english_format_number = number_format($item['quantity'])."]</center>";
    echo "<center>$".$english_format_number = number_format($item2['value'])."</center>";
echo "<center>[<a href='../item.php?sell=".$item['id']."'>Sell</a>] [<a href='../item.php?market=".$item['id']."'>Market</a>] <br>[<a href='../item.php?send=".$item['id']."'>Send</a>] [<a href='../item.php?equip=".$item['id']."'>Equip</a>]</center><br>";
    echo "</td>\n";
 //Close row if last column
    if($current_col==$max_col)
    {
        echo "<tr>\n";
        $current_col = 0;  //<---Changed
    }
    $current_col++;
}
}

}
//Close last row if needed
if ($current_col!=1)
{
    for(; $current_col<=$max_col; $current_col++)
    {
        echo "<td>&nbsp;</td>\n";
    }
}

?>
</table>
</div></div>