Moron question

[drf1229]

I am a programmer of many languages but I have a few issues. I want to learn sql code but have no idea where to input it! Do I make files or is there a program I use? Please, captain obvious point it out to me... Thanks in advance!

 

[diabolo]

well you can run it manually from PHPMyAdmin

or make a script to run it once an action has been completed in PHP, there are also other languages available, but i think this is the most popular

 

[ivandist]

Well that's a good start -> http://www.w3schools.com/sql/default.asp

What exactly do you need SQL for?
Are you working with any SQL based databases? MySQL, PostgreSQL?

 

[drf1229]

there are also other languages available, but i think this is the most popular

I usually use PHP and files instead of SQL but I felt like I should learn how to use SQL. Thank you for your advice!

 

[misson]

Also check out the thread "SQL for noobs".

 

[hezuo]

another silly question... can you create store procedures via phpmyadmin? (real noob here)

 

[espfutbol98]

yeah, you write commands in sql code and insert them in phpMyAdmin or have them in php files

 

[drf1229]

Thank you so much for your replies! I feel like such an idiot now...

 

[pythondev]

P.S.

phpMyAdmin will echo the SQL that it uses for each CREATE,INSERT, UPDATE, etc comand, good idea to copy it down...

then you can use it later for your php, just change the WHERE something='something' to something='".$value."' like that...

Have fun....

 

[misson]

then you can use it later for your php, just change the WHERE something='something' to something='".$value."' like that...

Better yet, use prepared statements: change statement to "... WHERE something=:something ...". PHP code looks like:

$stmt = $db->prepare('... WHERE something=:something ...');
$stmt->execute(array(':something', $value));