Mysql And Php

[kcd-clan 0]

I need to be abel to talk to my php or mysql on website with autoit is there anyplugins?

[jvanegmond 297]

Uhm, try a search before you post anything.

Search for "SQL UDF's" or just PHP

[kcd-clan 0]

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 March 28, 2006 by kcd-clan

[kcd-clan 0]

Iv not found it yet but they way im going to do it will be easy to hack but if any one knows how tih outoit then please help

[jvanegmond 297]

http://www.autoitscript.com/forum/index.ph...l=SQL+UDF's

Have it the easy way. Just follow the detailed instructions in the topic and you should be fine.

It has functions like MySQLConnect and Query.

[kcd-clan 0]

i get errors on taht script.

[cdkid 1]

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

~cdkid

[kcd-clan 0]

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

[cdkid 1]

#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 March 28, 2006 by cdkid

[kcd-clan 0]

thanks i hope it works but doo tell i get website up