Sign in to follow this  
Followers 0
kcd-clan

Mysql And Php

10 posts in this topic




#3 ·  Posted (edited)

umm you think iv not done that.

php has like 50 pages and sql has like 4 results and there not waht i need.

I just need to be abel to get query from database.

hrm i just was thinking i think i figured it out for myself to put it to test right now...

Edited by kcd-clan

Visit mEMy programs made.Iul - IulG-V Console - G-V Console_RandomLetter - _RandomLetter()Saftey Kill - Saftey Killcolorzone() = colorzone()

Share this post


Link to post
Share on other sites

Post your script, I should be able to help you find your problem.

~cdkid


AutoIt Console written in C#. Write au3 code right at the console :D_FileWriteToLineWrite to a specific line in a file.My UDF Libraries: MySQL UDF Library version 1.6 MySQL Database UDF's for AutoItI have stopped updating the MySQL thread above, all future updates will be on my SVN. The svn location is:kan2.sytes.net/publicsvn/mysqlnote: This will still be available, but due to my new job, and school hours, am no longer developing this udf.My business: www.hirethebrain.com Hire The Brain HireTheBrain.com Computer Consulting, Design, Assembly and RepairOh no! I've commited Scriptocide!

Share this post


Link to post
Share on other sites

Well i cant right now my stupede host keeps messing up my website.

I need to get usernames if = kcdclan and if pass= password

i need demo of it


Visit mEMy programs made.Iul - IulG-V Console - G-V Console_RandomLetter - _RandomLetter()Saftey Kill - Saftey Killcolorzone() = colorzone()

Share this post


Link to post
Share on other sites

#9 ·  Posted (edited)

#include <MySQL.au3>
$sql = _MySQLConnect("usn","pwd","root","somehost.com")
$qur = _Query("SELECT * FROM `users`");Get every column from the "users" table
With $qur
While NOT .eof;Do until we've reached the last record
If $qur.Fields("username").Value = "username" then;Check username
$pass = $qur.Fields("password").Value
exitloop
EndIf
.MoveNext;Move to the next record
WEnd
EndWith
_MySQLEnd($sql)

Replace the values such as "sa", "somehost.com", and "root" with your

Username, Password, Host, and Database

Replace "SELECT * FROM users" with

"SELECT * FROM " and your user table

etc.

~cdkid

Edited by cdkid

AutoIt Console written in C#. Write au3 code right at the console :D_FileWriteToLineWrite to a specific line in a file.My UDF Libraries: MySQL UDF Library version 1.6 MySQL Database UDF's for AutoItI have stopped updating the MySQL thread above, all future updates will be on my SVN. The svn location is:kan2.sytes.net/publicsvn/mysqlnote: This will still be available, but due to my new job, and school hours, am no longer developing this udf.My business: www.hirethebrain.com Hire The Brain HireTheBrain.com Computer Consulting, Design, Assembly and RepairOh no! I've commited Scriptocide!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0