POST .. GET

[mrlankee]

Hi,

 

I'm trying to figure this out.. I am creating a user search on my website thats connected to mysql.  What I have does not work :\

<form action="useraccount.php" method="post">
<input type="text" name="username"/>
<input type="submit" value="submit"/>
</form>

<?php

$username = $_POST['nome'];
$pdo = new PDO('mysql:host=myhost;dbname=mydb', 'user', 'pw');

if ($pdo->query("SELECT * from TABLENAME where username='".$username."'")->fetchColumn() > 0){
foreach($pdo->query("SELECT * from TABLENAME where username='".$username."'") as $row) {
echo $row['Player_Name'] . $row['Time_Online'];
}
$pdo = null;
}
else{
echo "Sorry, that username does not exist in our database.";
}
?>

[Zane]

What do you mean it doesn't work?

[NotionCommotion]

Actually it is working perfectly.  It is doing exactly what it is suppose to do.

[Psycho]

 

 

<input type="text" name="username"/>

 

 

 

$username = $_POST['nome];

[mrlankee]

Sorry what i ment is .. If i enter username Alpha instead of Bravo.. it'll show Alpha's row's... 

 

it's basically drawing data from a game MySql

[mrlankee]

www.rpproject.net/useraccount.php 

As you can see.. no matter what you enter.. the "else" does not show up as "Sorry, that username does not exist in our database.";"

 

I cannot figure out whats going on.. exact code.

<form action="account.php" method="GET">
In-Game Name:<br>
<input type="text" name="username" value="Username">
<br>
<input type="submit" value="Submit">
</form>

       <?php

$username = $_POST['username'];
$pdo = new PDO('mysql:host=xxxxx;dbname=xxxx', 'xxxx', 'xxxx');


if ($pdo->query("SELECT * from TABLENAME where username='".$username."'")->fetchColumn() > 0){
foreach($pdo->query("SELECT * from TABLENAME where username='".$username."'") as $row) {
echo $row['Player_Name'] . $row['Time_Online'];
}
$pdo = null;
}
else{
echo "Sorry, that username does not exist in our database.";
}
?>

Any ideas?

[hansford]

 

 

Sorry what i ment is .. If i enter username Alpha instead of Bravo.. it'll show Alpha's row's

There is a problem in your logic. If you enter any value in the form that exists in the database - it's going to return that row's value because you asked it to with this select statement.

SELECT * from TABLENAME where username='".$username."'"

Edited January 1, 2015 by hansford

[mrlankee]

how do i fix it? :\ lol

[hansford]

Try:

$username = $_POST['username'];
$pdo = new PDO('mysql:host=xxxxx;dbname=xxxx', 'xxxx', 'xxxx');
$sql = "SELECT COUNT(*) from TABLENAME where username='".$username."'";

if ($result = $pdo->query($sql)
{
    if ($result->fetchcolumn() > 0)
    {
        $sql = "SELECT * from TABLENAME where username='".$username."'";
        
        foreach ($pdo->query($sql) as $row)
        {
            echo $row['Player_Name'] . ' ' . $row['Time_Online'];
        }
    }
}
else 
{
    echo "Sorry, that username does not exist in our database.";
}

[mrlankee]

Parse error: syntax error, unexpected '{' in ......."removed".../account.php on line 96

 

Which is the first { after "if"

Edited January 1, 2015 by mrlankee

[hansford]

Sorry, I can't test the code for errors and I don't know from your file which line the error occurred.

 

Looking at it - I see:

if ($result->fetchcolumn() > 0)

fetchcolumn - should be fetchColumn with a capital 'C'.

[mrlankee]

 

still shooting the error.

 

 

 

Parse error: syntax error, unexpected '{' in ......."removed".../account.php on line 96

Edited January 1, 2015 by mrlankee

[ginerjm]

Why do a fetchcolumn at all? Check the result of the operation, don't waste time on a retrieval of one piece of data. Of course if your db does not support rowcount() then stick with what you have, but here is how I would write your code:

 

<form action="useraccount.php" method="post">
<input type="text" name="username"/>
<input type="submit" value="submit"/>
</form>

<?php
$username = $_POST['username'];  // you retrieve form data using the html's name= attribute
$pdo = new PDO('mysql:host=myhost;dbname=mydb', 'user', 'pw');

// assign your query statement to a var so you can view it if you need to debug it
$q = "SELECT * from TABLENAME where username='$username'";

if (!$pdo->query($q)
{
   echo "Query failed - query is $q";// only do this during development - not in prod.
   exit();
}
if ($pdo->rowcount()== 0)
{
   echo "Sorry, that username does not exist in our database.";
   exit();
}
// now get your results
while ($row = $pdo->fetch_assoc(PDO::FETCH_ASSOC))
{
   echo $row['Player_Name']," ",$row['Time_Online'];
}
exit();

[hansford]

ginerjm - posted the preferred way to code this - smooth, elegant - with error handling. Just test that rowCount() works on the particular DB you're using. I use rowCount(), but because of the manual "warning", I am in the habit of using fetchColumnt() - however, it is an extra query and slows things down and usually unnecessary.

[mrlankee]

I switched up the code

 

still getting the error

 

Parse error: syntax error, unexpected '{' in /home/xxxxxxxxxxxxxxx/xxxxx/account.php on line 100

 

 

 

 

 

I did add a ?> to close out the PHP after the image was taken.

Edited January 2, 2015 by mrlankee

[ginerjm]

You're missing a right paren

[mrlankee]

this is hurting my brain lol where i cannot figure it out?

[ginerjm]

The error message says unexpected { at line 100. That is because the line above doesn't have a ) at its end, thus making the { unexpected. My bad.

[mrlankee]

ah =] thanks!

 

I appreciate all the help!

[ginerjm]

So are we any closer to a total solution?