Error in my php script

Dakkar

I wrote a php code like this but it is giving this error

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in c:\program files\apache group\apache\htdocs\acc\kapatma.php on line 52

and my php code is this

<html>
<body bgcolor="#FFFFFF" text="#000000">
<form action="kapatma.php" method="get">
<b>Kullanici Adi:</b><input type="text" name="username" size="20"><br>
<b>Sifre:</b><input type="password" name="pass" size="20"><br>
<input type="submit" value=" Kayit ">
</form>


<?


include("ust.php");
include("config.php");

@mysql_connect("localhost", "abcd", "12345")
    or die("Veritabani ile baglanti kurulamadi!");
@mysql_select_db("account")
    or die("Veritabaninda bir hata olustu!");


$query = "SELECT password FROM acc_tmp WHERE username='$u_name' and password='$pass'";
$sonuc=mysql_query($query);


if(mysql_num_rows($sonuc)==1) {
$pfix = "WHERE disable ='0'";
$eded = "(Aktif)";
} else {
$pfix = "";
}

$result = mysql_query("SELECT bitis FROM accounts $pfix");
$num_rows = mysql_num_rows($result);

echo "Toplam $eded Kay?t: $num_rows<br>";

if(mysql_num_rows($sonuc)==1)
    $pfix = "WHERE disable='0'";  

else  

    $pfix = "LIMIT $startl , $stopl";  

$result = mysql_query( "SELECT  id,username,fullname,email,bitis,baslangic,disable
 FROM accounts $pfix");  

$where=""; 

WHILE ($row=mysql_fetch_array($result)) {  

 if($row['bitis']=now()) {  

   mysql_query("UPDATE accounts  SET disable=1 WHERE username='$row['username']'");
   echo "Kapatilan Accountlar:$row['username']";
 }
}

?>


</body>
</html>

I couldnt find why it is giving that error
can anyone help me about it?

azunoman

would help alot if you were to show exactly which line of code is on your error line...52

ahundiak

PHP does not allow using the array 'name' syntax inside of double quotes.
Change
echo "Kapatilan Accountlar:$row['username']";
To
echo "Kapatilan Accountlar:$row[username]";

There is a similiar problem in the line before it.

You might find it easier to simply do:
$username = $row['username'];

Dakkar

I made my code like this but it is giving this error this time

Fatal error: Call to undefined function: now() in c:\program files\apache group\apache\htdocs\acc\kapatma.php on line 49

<html>
<body bgcolor="#FFFFFF" text="#000000">
<form action="kapatma.php" method="get">
<b>Kullanici Adi:</b><input type="text" name="username" size="20"><br>
<b>Sifre:</b><input type="password" name="pass" size="20"><br>
<input type="submit" value=" Kayit ">
</form>


<?


include("ust.php");
include("config.php");

@mysql_connect("localhost", "acc", "1234")
    or die("Veritabani ile baglanti kurulamadi!");
@mysql_select_db("account")
    or die("Veritabaninda bir hata olustu!");


$query = "SELECT password FROM acc_tmp WHERE username='$u_name' and password='$pass'";
$sonuc=mysql_query($query);


if(mysql_num_rows($sonuc)==1) {
$pfix = "WHERE disable ='0'";
$eded = "(Aktif)";
} else {
$pfix = "";
}

$result = mysql_query("SELECT bitis FROM accounts $pfix");
$num_rows = mysql_num_rows($result);

echo "Toplam $eded Kay?t: $num_rows<br>";

if(mysql_num_rows($sonuc)==0)
    $pfix = "WHERE disable='0'";  

else  

    $pfix = "LIMIT $startl , $stopl";  

$result = mysql_query( "SELECT  id,username,fullname,email,bitis,baslangic,disable
 FROM accounts $pfix");  

$where=""; 

WHILE ($row=mysql_fetch_array($result)) {  

 if($row['bitis']=now()) {  

   $user = $row['username'];
   mysql_query("UPDATE accounts  SET disable=1 WHERE username='$user'");
   echo "Kapatilan Accountlar:$row[username]";
 }
}

?>


</body>
</html>

weekender

again, it helps if you show which line the error is on - the line number is in the error message.

also, the error message "Call to undefined function now()" is kinda obvious - there is no now() function - have a look at the date functions at www.php.net/date

azunoman

It's unfortuante I do not know how to unsubscribe. I asked you orginally to post the line that contained the error...

Maybe someone just go ahead and code it for you cause you waisted my time. Oh guess what...I can unsubscrive now that I am responding.

Dakkar

The error on this line

if($row['bitis']=now()) {

and i think it is because of php doesnt understand now() function
but i dont know how can i make it possible to do it with mysql?

weekender

there is no such function as now() in php

to get the current time, use [man]time()[/man] - but comparing this to your bitis field depends entirely on the format of the field, so have a read of the manual page for [man]date()[/man] and read up on date formatting.

nobody will do it for you...

Dakkar

I editted like this but it still doesnt work

Note:the finish part which is in mysql is in date type

$tarih = date("Y-m-d");

 if($row['finish']==$tarih) {  

   $user = $row['username'];
   mysql_query("UPDATE accounts  SET disable=1 WHERE username='$user'");
   echo "Kapatilan Accountlar:$row[username]";
 }