Php - mysql select?

[zero_ZX]

hi, i have this code:

 

<?php
session_start();
// dBase file
include "config.php";

if ($_GET["op"] == "login")
{
if (!$_POST["username"] || !$_POST["password"])
  {
  die("You need to provide a username and FG-Pass.");
  }

// Create query
  $id = "SELECT member_id FROM `members` "
  ."WHERE `name`='".$_POST["username"]."' "

$q = "SELECT * FROM `members` "
  ."WHERE `name`='".$_POST["username"]."' "
  ."AND `p_locked`=0 "
  ."AND SELECT field_13 FROM `pfields_content` "
  ."WHERE `id`='".$id."' "
  ."AND WHERE `field_13`=('".$_POST["password"]."') "
  
  
//`pass`=('".$_POST["password"]."') "
  
  ."LIMIT 1";
// Run query
$r = mysql_query($q);

if ( $obj = @mysql_fetch_object($r) )
  {
  // Login good, create session variables
  $_SESSION["valid_id"] = $obj->id;
  $_SESSION["valid_user"] = $_POST["username"];
  $_SESSION["valid_time"] = time();

  // Redirect to member page
  Header("Location: shop.php");
  }
else
  {
  // Login not successful
  die("Sorry, could not log you in. Wrong login information.
  <br> Or your fg has been locked. Please contact Smilie.");
  }
}
else
{
//If all went right the Web form appears and users can log in
echo "<form action=\"?op=login\" method=\"POST\">";
echo "Username: <input name=\"username\" size=\"15\"><br />";
echo "FG-Password: <input type=\"password\" name=\"password\" size=\"8\"><br />";
echo "<input type=\"submit\" value=\"Login\">";
echo "</form>";
}




?>

Error:

Parse error: syntax error, unexpected T_VARIABLE in /home/b2ku00/public_html/fg/login.php on line 17

I don't get this.. I can't find any error in line 17 :/

[Buddski]

// Create query

  $id = "SELECT member_id FROM `members` "

  ."WHERE `name`='".$_POST["username"]."' "

 

is missing its ;

 

[premiso]

Next time please point out line 17, as it is annoying having to find it, especially since we are helping you, you should help us.

 

 // Create query
  $id = "SELECT member_id FROM `members` "
  ."WHERE `name`='".$_POST["username"]."' ";

 

You were missing the semicolon there.

[Maq]

You should really get into the habit of properly formatting and indenting your code.  As of now, it's all over the place and makes everything exponentially harder to debug and maintain.

[zero_ZX]

Sorry guys I'll give you the lines next time

 

Any way, i guess that's time is now, cause for some reason i think my include is failing..

When trying to login, php returns:

 

 

Warning: mysql_query() [function.mysql-query]: Access denied for user 'b2ku00'@'localhost' (using password: NO) in /home/b2ku00/public_html/fg/login.php on line 26

 

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/b2ku00/public_html/fg/login.php on line 26

 

  ."LIMIT 1";
// Run query
$r = mysql_query($q);

 

This is my database configuration:

 

<?php
// SQL info
$host = "lpsql01.lunariffic.com";
$user = "b2ku00_admin";
$pass = "****";
$db   = "b2ku00_forum";

// Setup connection
$ms = mysql_pconnect($host, $user, $pass);
if ( !$ms )
{
echo "Error connecting to database.\n";
}

// Select DB
mysql_select_db($db);

?>

 

[Buddski]

Ensure you have the right permissions on your database for that user..

The error you are receiving says it all

[zero_ZX]

Error says:

'b2ku00'@'localhost' (using password: NO)

1) not using that user

2) not that host

3) i am using password

 

[Buddski]

mysql_select_db($db,$ms) or die(mysql_error());

replaces

mysql_select_db($db);

And let us know the outcome.

[zero_ZX]

Same.. browsing the config file returns nothing..

[Buddski]

So you changed that line and still nothing? Has the error changed?

[zero_ZX]

Yea i changed the line, but no new output when trying to view the config file in the browser, and error on the login.php is the same.

[premiso]

Are you sure you are accessing the correct config.php?

 

Try this:

<?php
// SQL info
$host = "lpsql01.lunariffic.com";
$user = "b2ku00_admin";
$pass = "****";
$db   = "b2ku00_forum";

// Setup connection
$ms = mysql_pconnect($host, $user, $pass) or trigger_error("Unable to connect: " . mysql_error());
if ( !$ms )
{
echo "Error connecting to database.\n";
}

// Select DB
mysql_select_db($db) or trigger_error("Database not selected: " . mysql_error());

echo "The database has been selected.";
?>

 

And see if the echo statement echos or if there is an error. If there is no "The database has been selected." echo'ed you are modifying / including the wrong file and you need to look at that to fix it.

[zero_ZX]

Wierd.. nothing displays

but my php.ini have

display_errors = On

display_startup_errors = on

 

:/

Nothing display when using a bad password either..

[Maq]

Wierd.. nothing displays

but my php.ini have

display_errors = On

display_startup_errors = on

 

:/

Nothing display when using a bad password either..

 

After making changes to php.ini you have to restart apache, but just to be safe, you can add:

 

ini_set ("display_errors", "1"); 
error_reporting(E_ALL);

 

directly after your opening PHP tag, to temporarily turn error_reporting on max.  Is your config file in the same directory you're including it from?

 

Are you local?  If so, you can try to login manually through a terminal.

 

[zero_ZX]

Hmm...

Now im getting this error:

Fatal error: Call to undefined function phpini_set() in /home/b2ku00/public_html/fg/inc/config.php on line 1

<?php

ini_set ("display_errors", "1");
error_reporting(E_ALL);

[zero_ZX]

Up!

[Maq]

Up!

 

Is that a form of bumping?

[premiso]

Given this: phpini_set() you have your code most likely like so:

 

<?phpini_set()

 

Make sure that is not what is going on etc. If it is separate it out like this:

 

<?php
ini_set()

[zero_ZX]

I have linebreaks like this:

 

<?php

ini_set ("display_errors", "1");
error_reporting(E_ALL);

// SQL info
$host = "lpsql01.lunariffic.com";
$user = "b2ku00_admin";
$pass = "**";
$db   = "b2ku00_forum";

// Setup connection
$ms = mysql_pconnect($host, $user, $pass) or trigger_error("Unable to connect: " . mysql_error());
if ( !$ms )
{
echo "Error connecting to database.\n";
}

// Select DB
mysql_select_db($db) or trigger_error("Database not selected: " . mysql_error());

echo "The database has been selected.";
?>

 

:/

[premiso]

Well your code somewhere is messed up and you do not know, either in translation (uploading it to the server) or something.

 

As the only way I can see to produce that error is a mistake like this:

<? phpini_set();

 

Other than that I do not know how your files are setup and where that error is coming from. But given that it is on line one, maybe the editor is not really breaking out the lines. Make sure you are editing the proper file and that it is saving in the right spot.

[teynon]

What program are you using to modify your code?

[zero_ZX]

I'm using notepad ++

[dbradbury]

sorry didnt see the second page! lol

[Maq]

sorry didnt see the second page! lol

 

Hehe, it's OK, that's what the modify button is for 

 

I'm using notepad ++

 

Any luck?

[zero_ZX]

Not at all lol, this is wierd:

<?php
/*
// SQL info
$host = "lpsql01.lunariffic.com";
$user = "b2ku00_admin";
$pass = "deCheepiji";
$db   = "b2ku00_forum";

// Setup connection
$ms = mysql_pconnect($host, $user, $pass) or trigger_error("Unable to connect: " . mysql_error());
if ( !$ms )
{
echo "Error connecting to database.\n";
}

// Select DB
mysql_select_db($db) or trigger_error("Database not selected: " . mysql_error());

echo "The database has been selected.";
*/
echo "The database has been selected.";
?>

 

returns: Parse error: syntax error, unexpected T_ECHO in /home/b2ku00/public_html/fg/inc/config.php on line 1

 

only lined not commented: echo "The database has been selected."; (and the php tags)

 

Common!