AutoSQL

[borednerd]

I just finished this script today.

AutoSQL is my version of PHPMyAdmin.

It allows you to edit MYSql databases from the script, but through querys.

So, for example, if you are installing a script, and it requires MySql, and you dont know how to edit, all you have to do is open AutoSQL, put in the query (SQL COMMAND) and press submit, and AutoSQL does it for you.

Ive designed this, becuase a friend of a friend, needed help with invision, installing a mod. I told him to use MyAdmin, but he didnt know how, so I created AutoSQL to help him.

You only have to edit one file:
sql.php.

Only 4 lines, though:

    $server = "/"; 
	$username = "/"; 
	$pass = "/"; 
	$db = "/";

Just replace the "/"'s with:

From top to bottom:
Server Name, eg. Localhost
Username, name for database
Password, pass corresponding with username
Database, name of the database you want to edit.

-----

No extra editing is required. Just upload those 2 files in the same directory

*can be anywere on your server*

Go on the link "AutoSQL" type in your query, and hit AutoSQL, and your done.

Heres some screenshots:

HOME PAGE:

AutoSQL:

Help:

What you have to edit (sql.php):

Enjoy!

 

[Dopple_Of_Stalin]

Good job. 10/10, requesting a sticky.

 

[borednerd]

heres a test function:
http://www.gamingplus.org/borednerd/autosql.php

Props to nickf for hosting and letting me test:

And thanks dopple, ive spent many a hours on this

 

[ProdigiousLucidOsprey]

I believe the option to simply sumbit the query is already in phpMyAdmin, is it not? Very nice work, do you know mysql well?

 

[borednerd]

Well id say i know the gist of it, but im far from knowing alot of it.

Yeah i know that the submit is already in phpmyadmin, but ive discovered that some amateur webdesigners have not even heard of phpmyadmin.

 

[ProdigiousLucidOsprey]

Thats cool, Im trying to learn currently. I want to create a dynamically driven site, and from what I know php and sql is the way to go. Battleforums could use someone with that kind of knowledge for optimization of the site.

 

[Forged]

TheSummit is the guy PLO.

 

[borednerd]

Well i could alyways help, as you see ive learned alot about variables and text areas and forms, inserts into sql and the such. I even see how i can make my own forum, now. It would be extremely simple compared to vB, but the variables and stuff would reflect all that i have learned.

Ive never really seen thesummit with php, cuase al ive seen of him/her/it is his/her/it's forum, which was of course premade. Id be glad to help anyone who asks.

 

[Forged]

most people don't make there own forum since there are teams that do it, and do it much beter. TheSummit has made quite a few hacks, and has converted hacks for ipb for his site.