ACDB  Log In
Busca

READ ONLY MODE IS ACTIVATED

Post Reply
ACDB Forums :: Anime Characters Database :: Site Discussion
Posted 16 year(s) ago Re: # 2580

brobb355
theeccentrician

brobb355 Avatar
8 Stars

Joined on 11-03-07
Posts 701

wow, this is interesting. I started reading my SQL book over the last few days, just going over the basics atm but it all relates to what was just discussed. I'm like "oh hey, I know this, awesome". I was surprised at a eureka moment happening so soon. This is going to be an interesting semester IMO.
Top PM brobb355
Posted 16 year(s) ago Re: # 2582

Kyareshi
The Plotmeister

Kyareshi Avatar
10 Stars

Joined on 01-08-09
Posts 940

Glad you're enjoying it so far, brobb355. If you like SQL already, I guarantee you're going to love it later. Feel free to join the discussion if you have a question.
[Image]
Top PM Kyareshi
Posted 16 year(s) ago Re: # 2583

chiqui1970


chiqui1970 Avatar
2 Stars

Joined on 06-28-08
Posts 162

I continue with the same problem, cut and paste well in tags but not in voice.
Top PM chiqui1970
Posted 16 year(s) ago Re: # 2587

Rei
ダメ人間

Rei Avatar
10 Stars
Head Admin
Joined on 05-24-07
Posts 2102

chiqui1970

I continue with the same problem, cut and paste well in tags but not in voice.


It might work now. If not, click Submit rather than Post.
Post = Instant Change
Submit = Submit to Moderators

Kyareshi

[quote1232445395=Rei]Maybe it's great, maybe it sucks, but all I know is once I start coding, something good will take shape.

I admire your confidence.

Well, if you run into any trouble, you know you can always turn to me for advice.
[/quote1232472484]
Truth be told, I'm not happy with my approach as it is now either. Once I better idea comes to me, I'll throw it at you. ^^

brobb, are you taking an Intro SQL course? You might be disappointed... seemed like the one at my University only covered the most basic skills, and left all the advanced, fun stuff out. I never took the class tho. lol More fun to learn on the job.
[Image]

私は日本語を少し読むと書くをできます。あなたも?

[Image]
Top PM Rei
Posted 16 year(s) ago Re: # 2589

brobb355
theeccentrician

brobb355 Avatar
8 Stars

Joined on 11-03-07
Posts 701

^yes, I am taking an intro to SQL course. I thought the skills might be useful in the line of work that I want to pursue (Network administration). Well, it is good to know the basics, that way you'll be able to get into the fun stuff later on without much difficulty.
Top PM brobb355
Posted 16 year(s) ago Re: # 2629

Rei
ダメ人間

Rei Avatar
10 Stars
Head Admin
Joined on 05-24-07
Posts 2102

brobb355

^yes, I am taking an intro to SQL course. I thought the skills might be useful in the line of work that I want to pursue (Network administration). Well, it is good to know the basics, that way you'll be able to get into the fun stuff later on without much difficulty.


Awesome. SQL plus a little PHP might even help you a lot with Network Administration, since you can use it to create various tools that'd possibly be of help.

brobb, check out the improved debug mode if you're interested in knowing more about the SQL queries behind the web site.
http://www.animecharactersdatabase.com/publisher.php?id=491&debug

That SQL class I wrote earlier - this is one of the benefits. $_GET & $_POST & $_SESSION are superglobals, so they can be accessed within a function within a class within an include within a PHP script no problem. So, if you modify the GET array to have debug, you'll see the queries as in the link above. I've mostly finished switching everything in publisher.php and related includes to the new class. I'll do viewone.php and related includes next. So if you are interested, be sure to check it out now, cause it wont be long before my queries are trade secrets. ;-)
[Image]

私は日本語を少し読むと書くをできます。あなたも?

[Image]
Top PM Rei
Posted 16 year(s) ago Re: # 2633

brobb355
theeccentrician

brobb355 Avatar
8 Stars

Joined on 11-03-07
Posts 701

huh, that's interesting. there are only one or two things in those queries that I don't understand... and I've only just started with the syntax. Pretty good for only a week or so of study IMO.

I'm going to have to continue reading my web scripting textbook after I'm done with the class. The class is only covering XHTML, CSS, XML, Javascript, DOM and ASP. I've taken a look through the contents and there are sections on PHP, flash, and a few others that look interesting, we'll see what that has to say.
Top PM brobb355
Posted 16 year(s) ago Re: # 2634

Rei
ダメ人間

Rei Avatar
10 Stars
Head Admin
Joined on 05-24-07
Posts 2102

brobb355

huh, that's interesting. there are only one or two things in those queries that I don't understand... and I've only just started with the syntax. Pretty good for only a week or so of study IMO.

I'm going to have to continue reading my web scripting textbook after I'm done with the class. The class is only covering XHTML, CSS, XML, Javascript, DOM and ASP. I've taken a look through the contents and there are sections on PHP, flash, and a few others that look interesting, we'll see what that has to say.


Wow, I'm impressed. You should do quite well with databases. If you'd like any of those queries explained, I could try.
[Image]

私は日本語を少し読むと書くをできます。あなたも?

[Image]
Top PM Rei
Posted 16 year(s) ago Re: # 2636

brobb355
theeccentrician

brobb355 Avatar
8 Stars

Joined on 11-03-07
Posts 701

well, understanding queries and implementing those queries are two different things. I can say that I know enough syntax to understand what was being expressed but understanding the database composition as well as making the extracted data useable eludes me as of yet.
Top PM brobb355


Post Reply