PHP jQuery code mix

Question

I would be very grateful if somebody would take the time to read my code and could tell me a way to put variable $kakka in the script below, so that it works. As of now variable $kakka has no value because the php code is down there. Sorry I understand nothing about jQuery but I need this function to work.

Markup and jQuery

<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script>
var refreshId = setInterval(function()
{
  $('#puu').fadeOut("slow").text($kakka).fadeIn("slow");
}, 5000);
</script>
</head>
<body>

PHP

<?php
$rs = mysql_query("SELECT * FROM users WHERE id='$_SESSION[user_id]'");
  while 
    ($row= mysql_fetch_array($rs))
    {$starter= $row['id'];
     $user_name= $row['user_name'];}


$starterID=$starter;
$companyID=$_GET['id'];


$input = $_POST['viesti'];


date_default_timezone_set('Europe/Helsinki');
$timestamp = date('h:i', time());


$file = $companyID." and ".$starterID.".txt";


if (file_exists($file)) {
$kakka = $companyID." and ".$starterID.".txt";
} else {
$kakka = $starterID." and ".$companyID.".txt";
}


$current = file_get_contents($kakka);

if(isset($_POST['viesti']) && $_POST['viesti'] != null){
$currents= $current. "<b>$user_name</b> <br> $input $timestamp\n<br>";
$shipuli= "<b>$user_name</b> <br> $input $timestamp\n<br>";
file_put_contents($kakka, $currents);
}
echo '<div id="puu">'.$current.$shipuli.'</div>';

?>

Prevent SQL Injection! Here is an example of what happens when you continue to use mysql_* functions. Learn about prepared statements instead, and use PDO or MySQLi. This article will help you decide. — Jay Blanchard
– Jay Blanchard, Commented Oct 17, 2014 at 15:59

Barry127 · Accepted Answer · 2014-10-17 15:59:30Z

<?php
$rs = mysql_query("SELECT * FROM users WHERE id='$_SESSION[user_id]'");
  while 
    ($row= mysql_fetch_array($rs))
    {$starter= $row['id'];
     $user_name= $row['user_name'];}


$starterID=$starter;
$companyID=$_GET['id'];


$input = $_POST['viesti'];


date_default_timezone_set('Europe/Helsinki');
$timestamp = date('h:i', time());


$file = $companyID." and ".$starterID.".txt";


if (file_exists($file)) {
$kakka = $companyID." and ".$starterID.".txt";
} else {
$kakka = $starterID." and ".$companyID.".txt";
}


$current = file_get_contents($kakka);

if(isset($_POST['viesti']) && $_POST['viesti'] != null){
$currents= $current. "<b>$user_name</b> <br> $input $timestamp\n<br>";
$shipuli= "<b>$user_name</b> <br> $input $timestamp\n<br>";
file_put_contents($kakka, $currents);
}
echo '<div id="puu">'.$current.$shipuli.'</div>';

?>

<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script>
var refreshId = setInterval(function()
{
  $('#puu').fadeOut("slow").text('<?php echo $kakka;?>').fadeIn("slow");
}, 5000);
</script>
</head>
<body>

Some things to consider

mysql_query is deprecated
The use of jquery latest is not recommended in production

Jay Blanchard · Accepted Answer · 2014-10-17 16:01:49Z

0

Just echo it into a variable -

var refreshId = setInterval(function()
{ 
  var kakka = '<?php echo $kakka; ?>';
  $('#puu').fadeOut("slow").text(kakka).fadeIn("slow");
}, 5000);

answered Oct 17, 2014 at 16:01

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

1 Comment

Barry127 Over a year ago

This won't work because $kakka is a string. You have to put define it like this in the script: var kakka = '<?php echo $kakka;?>';

Collectives™ on Stack Overflow

PHP jQuery code mix

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related