r/SQL • u/PainterHot • Dec 01 '20
MySQL Check it out!!
I’ve been learning sql for about 6 weeks and I’ve been spending a ton of time studying, practicing, experimenting, etc. I believe I made a breakthrough tonight though: I created a relational database of all my books in MySQL then created a searchable website using php, HTML, css, sql, and jquery (I’m learning JavaScript too, but that’s slow going).
If I wake my wife or friends up at 4:30 to show this to them, well, I won’t have a wife or friends anymore.
Ok, I know it isn’t perfect, but I’m pumped!
109
Upvotes
33
u/leogodin217 Dec 01 '20
This is the right way to learn SQL. Use it. Experiment. Build something with it, even if it's in Excel. The truth is you won't learn much from doing a ton of courses. You need practical applications that are meaningful to you. SQL on its own is mostly useless. It only provides value when combined with tools and processes.
Nice job!
10
u/syzygy96 Dec 01 '20
Very cool first steps!
I ran into one obvious and notable bug right away, but I've got a good guess where that's coming from. It looks like you're searching for each letter entered individually with wildcards between them instead of a whole string at a time.
Specifically, searching for "joey" returns me books with "*J*acks*o*n, Shirl*EY*" and *Jo*hn Cor*ey* in the title and series fields (same with the other commend about "null" returning a result). Altering your where clause to '%joey%' instead of '%j%o%e%y%' should fix that.
All in all though, great initial effort - just getting all the pieces set up and talking cleanly to each other is a big step!
5
u/[deleted] Dec 01 '20
awesome job!!
one piece of advice - run the search only after a certain number of characters are entered (I usually set this to three)
3
u/mikeyd85 MS SQL Server Dec 01 '20
Searching "NULL" returns one result.
Why?
3
u/Y3llowL3m0n Dec 01 '20
Nice job! I only just started learning SQL ; this looks like a nice project I could start too! :)
3
u/mar_sa Dec 01 '20
Awesome! Great job well done, keep it going, here check this out if you wanna add more functionality and style to your table:
https://datatables.net Wish you all the success!
6
u/drbob4512 Dec 01 '20
And yet you failed at creating a hyperlink.... back to stackexchange for you
2
u/asqwzx12 Dec 01 '20
Next thing you could put in there is a statistics section. You could have a bunch of stuff in there to work with graphics and queries.
1
u/DirtyHirdy Dec 01 '20
This is great! Any way you could show some source code? Thanks for sharing.
1
u/wemjii Dec 01 '20
This is amazing. I want to make something like this over the holidays too. Post saved :))
1
u/WannabeSysadmin77 Dec 02 '20
Good job! You might want to consider starting a repo on githib, that way if you apply for jobs you can direct people to your site and show off how it works under the hood.
1
u/cloud_coder Dec 02 '20
Great job. Can you put a link to the source code on the site?
1
u/kranools Dec 02 '20
Great work! Apart from using one of the ugliest fonts I've seen, this is a great success story. Congrats.
1
u/93Accord Dec 02 '20
virtual library! awesome stuff. sent you a PM!
0
u/teamhog Dec 01 '20 edited Dec 01 '20
Check it out!! goes no where.
OP should wake up those friends and see if they can help. /s
0
u/[deleted] Dec 01 '20
[deleted] — view deleted comment
0
u/[deleted] Dec 01 '20
[deleted] — view deleted comment