Searching mySQL database!!

[raladin]

Inva

[CornedBee]

Hi raladin.

Do you have an actual question? You've got to learn PHP and MySQL of course. Beyond that, we cannot help you yet. We're here to solve problems, not write programs.

[raladin]

Inva

[mendhak]

Originally posted by raladin
Hi all..

First of all I want to introduce my self because I'm sure you are saying "Who is this guy!!! a very stupid guy " so :

I'm 14 years old.. in the 9th grade (At school).. you know I don't have the enough time to learn much about PC languages... so I'm now prepairing to get CompTIA A+ and I know of course HTML and PhotoShop..... Also I have many certificates from : the Associated Board of the Royal Schools of Music - Lodon in playing Classical Piano.. and I'm prepairing for the Dip. the next year..
And I will receive a FULL ScholarShip from Carnegie Mellon as they said me and my brother..

I don't play the piano, but I can use winamp really well. I have no certificates for it though. However, I can easily see how your certifications with the pianos are going to help you with your project.

I made 90% of my new project (E-Learning System) and I want now something in PHP (I'm new to PHP).. I want to make a PHP page for the admin to activate users accounts.. so a PHP page with a TextBox (UserName) with an "Activate" button.. the admin enters the user name for any user.. and then press the "Activate".. the PHP page will search the database for that username.. and when it find its row there it will change a value in the database (In that row).. the value that will be changed is under the field "Activation" from "Not Activated" to "Activated".. so the user now is activated..

Hope you got my meaning.. and sorry for my bad English

Example code off google:

function dbConnect()
{
    //define the database connection information
    $dbHost = "localhost";
    $dbUser = "username";
    $dbPass = "password";
    $dbName = "nameofdatabase";


    //connect to the mysql server
    $link = @mysql_connect($dbHost, $dbUser, $dbPass);

    //return success or failure of connection
    if(!$link)
    {
        //report error
        echo "Could not connect to server";
        exit;
    }

    //select the database
    if(!@mysql_select_db($dbName))
    {
        //report error
        echo "Could not select database";
        exit;
    }
} 

Once connected (using similar-to-above code), you can query it:

$result = mysql_query("SELECT * FROM myusers WHERE username='" + $storedvar + "'",$db);
//$storedvar retrieved from the previous page

if mysql_result($result,0,"activated") == "0"
{
$result2= mysql_query("UPDATE myusers SET activated='1' WHERE username = '" + $storedvar + "'", $db)
} 

This is just a rough example. GO through this link here for a good DB tutorial:

http://hotwired.lycos.com/webmonkey/...tw=programming

Notice : I attached my CV and my brothers' CV to see them

Thank you. I'll forward these to Newt Gingrich ASAP. He'll know what to do with you two.

[raladin]

Inva

[The Hobo]

I think you googled bad code. Much easier to do:

function dbConnect() { 
    //define the database connection information 
    $dbHost = "localhost"; 
    $dbUser = "username"; 
    $dbPass = "password"; 
    $dbName = "nameofdatabase"; 

    //connect to the mysql server 
    $link = @mysql_connect($dbHost, $dbUser, $dbPass) or die('Could not connect to server.'); 
    mysql_select_db($dbName, $link) or die('Could not select database.');
}

Maybe that's just my opinion, though.

[raladin]

Inva

[mendhak]

Originally posted by The Hobo
I think you googled bad code.

I googled for "how would hobo connect to mysql?"

[CornedBee]

Must I store the variable MD5.. or I can import it then convert it to MD5 then echo it?

What variable

[raladin]

Inva

[The Hobo]

Originally posted by raladin
Thanks The Hobo for your reply.. it is the same..

No, it's not the same. Mine is a few lines shorter. Plenty of characters shorter. Shorter means less file size. And in a big project, that matters to some.

Originally posted by raladin
but mendhak gave me a code also to insert the value to the database..

Yes, I know this. Thanks.

[The Hobo]

Originally posted by mendhak
I googled for "how would hobo connect to mysql?"

Well, google lies. It's all lies!

[mendhak]

In case you guys don't know, raladin here is trying to make a super-secure app that would transfer the user's hard drive serial number to his website.

It's 4 lines of code that retrieves the serial number, and 2000 lines of code for securing it.

Now he's at the PHP part.

And he plays the piano as well.

[The Hobo]

Thanks for the wrap up. Sounds like fun.

[kows]

I think it'd probably be alot easier to control the database from the VB program, instead of relying on some PHP script.. I guess it would depend on how well he knows VB though.

[raladin]

Inva

[The Hobo]

Originally posted by raladin
Waiting your help..

On what? You didn't ask a question...

[raladin]

Inva

[The Hobo]

The same way you're comparing user names in the code you provided.

[raladin]

Inva

[raladin]

Inva

[The Hobo]

I personally think the easiest thing to do is to use mysql_fetch_array rather than mysql_fetch_row.

$rows = mysql_query("SELECT * FROM tblName") or die(error_thing_here);
$row = mysql_fetch_array($row) or die(error_thing_here);

// Now you can access by field name:
if ($password = $row['password_field_name']) {
    // Do something
}

That way you don't have to worry about whether it's the 1st, 2nd, or 3rd field, you can just access it by what you named it.

Much easier, in my opinion.

But yes, you're on the right track.

[CornedBee]

Originally posted by kows
I think it'd probably be alot easier to control the database from the VB program, instead of relying on some PHP script.. I guess it would depend on how well he knows VB though.

Control a MySQL database from VB?
Errr...

[The Hobo]

Originally posted by CornedBee
Control a MySQL database from VB?
Errr...

Why Errr?

It can be done through VB, although most of the hosts I've had in my life don't allow outside connections to the database.

[kows]

why err? it can be done.. I'm making a project right now that does it.. Maybe I should have used "interact with" instead of "control"?

Most web hosts don't allow remote connections, but some do.. most good ones I've found allow it.

[The Hobo]

I'm sure I wouldn't be too happy if anyone could connect to my database and start trying to log in.

I should mention that my host allows you to add IP addresses to allow certain remote machines to connect. In that case, that's a good method, as you can control who connects to your database.

[CornedBee]

But unsuited for the situation.

How do you deal with a MySQL database from VB? MyODBC?

[kows]

Unsuitable for the situation? The guy is using a VB application to basically update the database and check if some user information is correct, and he's just using PHP as a middle man. I suggested it just so that he would cut out PHP and leave it as plain VB and MySQL.

By the way, yeah, MyODBC is used for VB/MySQL interaction.

[CornedBee]

I was referring to the "accept specific IPs". Since every user of his app needs to connect there, that's quite a lot of IPs to activate, aside from the impossibility of finding out which.

[The Hobo]

Plus, dialup users have changing IPs, so each time they connected to the internet, they'd have to give you their IP to allow the connection.

Unless the server allowed any computer to connect. And that's not cool, if you ask me.

[CornedBee]

As long as the passwords a secure and there's always the latest security updates...

[The Hobo]

Originally posted by CornedBee
As long as the passwords a secure and there's always the latest security updates...

Whatever floats your boat.