Can't login to my own forum, that sucks

I'm unable to login? plz help

Expand|Select|Wrap|Line Numbers

  
session_start();

include_once ('dbconnect.php');
 
if(isset($_POST['log'])) {

    $dbselect = mysql_query("USE codb");

    $uname = mysql_real_escape_string($_POST['username']);

    $upass = mysql_real_escape_string($_POST['pass']);

    $sql = mysql_query("SELECT * FROM users WHERE username=".$uname." AND password=".$upass." LIMIT 1");

    $res = mysql_query($sql);
 
    if(mysql_num_rows($res) == 1) {

        $row = mysql_fetch_assoc($res);

        $_SESSION['user'] = $row['user_id'];

        header("Location: speak.php");

    }else{

        $error = error_reporting(E_ALL^E_WARNING);

        echo "<script>alert('Wrong details!');</script>";

    }
 
}

It displays

Expand|Select|Wrap|Line Numbers

  
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\log.php on line 14

Jan 30 '16 #1

Subscribe Post Reply

1168

RonB

589

Expert Mod 512MB

Your mysql_query($sql)statement failed i.e., it returned FALSE. Add error checking/handling to that statement to find out why it failed.

Hint, you have a syntax (quoting) error in the query.

Jan 30 '16 #2

Toxicous8

Error checking and handling? what is it?
And where's the quoting error please? tnx

Feb 1 '16 #3

Toxicous8

Error checking and handling? what is it? If it's like

Expand|Select|Wrap|Line Numbers

$error = error_reporting();

, then i don't see how it would be useful to fix this problem. If not then what is it?

And where's the quoting error please? tnx

Feb 1 '16 #4

Similar topics

PHP forum / external login

by: Egon Schneider | last post by:

Hi *, I have a a website running for a bunch of people, written in PHP. Everyone has it's own login, I use some session-based authentication mechanism and a MySQL database for storing the users...

PHP

Limit Login Access

by: tchangmian | last post by:

I want to limit user login by writing ASP program. In details, if a user had logged in wrongly for more than three times, then the user will not be abled to log in to the system anymore even...

ASP / Active Server Pages

The File Transfer Manager Sucks

by: clintonG | last post by:

That's the title of the suggestion I just left at MSDN Product Feedback Center . Please login, use that string to find the suggestion I made and vote for it to support my outrageous demands. If you...

.NET Framework

Need help from senior programmers: Login forum and Post messages in WinForm app

by: Brian | last post by:

Hello, I usually login a forum and post some messages. I can't directly post message because the forum ask me to login first. I guess it need some session information. Now I want to program a...

C# / C Sharp

Cant login to yahoo on my cell phone

by: yaya319 | last post by:

I have been trying for some time to log into my yahoo on my cell phone and it says login incorrect or data server unailable.Please help thank you ...

General

This UI on this forum sucks!

by: dba123 | last post by:

Who can I contact to complain about this entire newsgroup UI? It's horrible, and half the time, the right pane doesn't load...even in other browsers. It's sluggish as well, just very choppy. --...

C# / C Sharp

Help trying to login to myspace programatically in vb.net

by: AppleBag | last post by:

I'm having the worst time trying to login to myspace through code. Can someone tell me how to do this? Please try it yourself before replying, only because I have asked this a couple of times in...

.NET Framework

Cant Login on a sql2005 machine from VS2005 IDE debug mode

by: =?Utf-8?B?Q2hpV2hpdGVTb3g=?= | last post by:

Hi, i got machine A that has sql2005, vs2005 project. project runs okay there. But when i copied that whole project folder to machine B, running sql2005, VS2005, edited the web.config file to...

.NET Framework

How do i restrict access using login routine?

by: beyrself | last post by:

Hi, i've created a application using microsoft visual studio 2005. I've publish the exe application using IIS. now is issue is. I need to restrict the login part. For example is A login to this...

Visual Basic .NET

by: lgoddgreat | last post by:

Hi I have this project currently on going and I'm stack in the login form, I've done most of the part but still i cant seem to find a solution to this part. the login form has 2 Textbox and 1...

Microsoft Access / VBA

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice