Author Topic: Making a webcomic: "dynamic hyperlinks"  (Read 11307 times)

0 Members and 1 Guest are viewing this topic.

Offline squidgetx

  • Food.
  • CoT Emeritus
  • LV10 31337 u53r (Next: 2000)
  • *
  • Posts: 1881
  • Rating: +503/-17
  • rawr.
    • View Profile
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #15 on: September 21, 2011, 05:37:10 pm »
I think I can figure this out...

On a new subject, what are some good free webhosting places? I'm looking for some 200+mb space, php, and ad-free. Also it would be nice if the hosting is reliable, etc. and doesn't insert their own scripts into my webpages

Offline Eeems

  • Mr. Dictator
  • Administrator
  • LV13 Extreme Addict (Next: 9001)
  • *************
  • Posts: 6266
  • Rating: +318/-36
  • little oof
    • View Profile
    • Eeems
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #16 on: September 21, 2011, 05:51:04 pm »
I think I can figure this out...

On a new subject, what are some good free webhosting places? I'm looking for some 200+mb space, php, and ad-free. Also it would be nice if the hosting is reliable, etc. and doesn't insert their own scripts into my webpages
freehostia should work for a while I would think. You could also probably ask netham or albert if they can spare some space for you.
/e

Offline sqrt(Time)

  • LV2 Member (Next: 40)
  • **
  • Posts: 37
  • Rating: +4/-0
    • View Profile
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #17 on: September 21, 2011, 06:44:49 pm »
Zymic is a little-heard-of, but very nice one in my experience... they also give you MySQL databases, and limited .htacess allowance,

Offline Spyro543

  • LV9 Veteran (Next: 1337)
  • *********
  • Posts: 1189
  • Rating: +74/-3
    • View Profile
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #18 on: September 21, 2011, 08:47:29 pm »
Ask Juju for awesome hosting.

Offline Juju

  • Incredibly sexy mare
  • Coder Of Tomorrow
  • LV13 Extreme Addict (Next: 9001)
  • *************
  • Posts: 5730
  • Rating: +500/-19
  • Weird programmer
    • View Profile
    • juju2143's shed
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #19 on: September 21, 2011, 09:11:01 pm »

Remember the day the walrus started to fly...

I finally cleared my sig after 4 years you're happy now?
THEGAME
This signature is ridiculously large you've been warned.

The cute mare that used to be in my avatar is Yuki Kagayaki, you can follow her on Facebook and Tumblr.

Offline squidgetx

  • Food.
  • CoT Emeritus
  • LV10 31337 u53r (Next: 2000)
  • *
  • Posts: 1881
  • Rating: +503/-17
  • rawr.
    • View Profile
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #20 on: September 21, 2011, 11:30:56 pm »
Haha, well I'll wait until I get it working completely before I do anything...atm I'm just using a random free host to test out the php and stuff.

The xml isn't working, plus I realized it's probably not the best idea to load and parse a large xml file every time a page loads, so I think I'll go with what Eeems suggested instead. I can keep the many .txt files in another directory to avoid clutter...

Offline Juju

  • Incredibly sexy mare
  • Coder Of Tomorrow
  • LV13 Extreme Addict (Next: 9001)
  • *************
  • Posts: 5730
  • Rating: +500/-19
  • Weird programmer
    • View Profile
    • juju2143's shed
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #21 on: September 22, 2011, 02:14:21 am »
Why not using MySQL?

Remember the day the walrus started to fly...

I finally cleared my sig after 4 years you're happy now?
THEGAME
This signature is ridiculously large you've been warned.

The cute mare that used to be in my avatar is Yuki Kagayaki, you can follow her on Facebook and Tumblr.

Offline leafy

  • CoT Emeritus
  • LV10 31337 u53r (Next: 2000)
  • *
  • Posts: 1554
  • Rating: +475/-97
  • Seizon senryakuuuu!
    • View Profile
    • keff.me
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #22 on: September 22, 2011, 02:44:48 am »
I used to use walrus, (http://walrus.newbsoft.com/), then completely change the layout to whatever else.
In-progress: Graviter (...)

Offline Eeems

  • Mr. Dictator
  • Administrator
  • LV13 Extreme Addict (Next: 9001)
  • *************
  • Posts: 6266
  • Rating: +318/-36
  • little oof
    • View Profile
    • Eeems
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #23 on: September 22, 2011, 03:16:10 am »
Why not using MySQL?
Lets start him off slow ok :P Adding MySQL to the mix when he barely knows PHP isn't a good idea yet.
/e

Offline cooliojazz

  • Support Staff
  • LV7 Elite (Next: 700)
  • *******
  • Posts: 619
  • Rating: +66/-9
  • I omnoms on your soul
    • View Profile
    • Unreal Phantasies
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #24 on: September 22, 2011, 01:24:07 pm »
I like x10, ive been using them for a good few years.  or just beg juju.  thats normally pretty good too :P If you want, i can show you a stripped down version of Frameless Comic to show you an example of how to store everything in a mysql db and some other features =)

EDIT:  Ssomehow i guess i didnt refresh the page.  somehow.  There needs to be a notifier for that too :P Also Eeems, idk, I learned php and mysql at the same time, it wasnt bad, only downsied is that i basically think of mysql as an extensioin of php, not its own thing XD
« Last Edit: September 22, 2011, 03:07:03 pm by cooliojazz »
Spoiler For Random signess:
You can not beat my skills.
Trust me.
So don't even try.
And remember never to trust someone who says, "Trust me."

TI File Editor Progress: Remade in java like a boss. 50% we'll call it? IDK =P
Java Libraries: JIRC - 90% JTIF - 5%
TI Projects: Unreal Notator - -5000%
Nomcraft, a Bukkit mod
Some of the music I write can be found here | The Rest Should Be Here (Bandcamp)

Offline squidgetx

  • Food.
  • CoT Emeritus
  • LV10 31337 u53r (Next: 2000)
  • *
  • Posts: 1881
  • Rating: +503/-17
  • rawr.
    • View Profile
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #25 on: September 22, 2011, 08:24:45 pm »
I'd like to learn the best and most efficient way to do things haha. I don't mind adding in MySQL, I think I've got a handle on PHP.

I tried looking up MySQL and I got a lot of info on how to create and manipulate data tables; but I'm really looking for just a way to access a data table? How can you do that?

Offline Eeems

  • Mr. Dictator
  • Administrator
  • LV13 Extreme Addict (Next: 9001)
  • *************
  • Posts: 6266
  • Rating: +318/-36
  • little oof
    • View Profile
    • Eeems
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #26 on: September 22, 2011, 09:20:33 pm »
http://www.w3schools.com/php/php_mysql_intro.asp
That's where I went to learn the initial stuff. I then just googled to find answers to whatever I needed.

This is what you probably want specifically though: http://www.w3schools.com/php/php_mysql_select.asp

Offline squidgetx

  • Food.
  • CoT Emeritus
  • LV10 31337 u53r (Next: 2000)
  • *
  • Posts: 1881
  • Rating: +503/-17
  • rawr.
    • View Profile
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #27 on: September 22, 2011, 10:13:18 pm »
I ended up using w3 to figure it out before I saw your post O_o thanks though ahaha.

Anyway, looks like I've got everything done :D Titles, alts, and tags all get fetched out of a mySQL using $cur, there's also a $max which helps the navigation buttons work perfectly. Thanks guys!

Now to wrap up the layout and CSS...
« Last Edit: September 22, 2011, 11:11:47 pm by squidgetx »

Offline Jim Bauwens

  • Lua! Nspire! Linux!
  • Editor
  • LV10 31337 u53r (Next: 2000)
  • **********
  • Posts: 1881
  • Rating: +206/-7
  • Linux!
    • View Profile
    • nothing...
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #28 on: September 23, 2011, 03:24:36 am »
Just a note, be sure to filter $cur, so that SQL and code injections aren't possible ;)
Since $cur should be a number, using intval() on it should be fine :)

Offline squidgetx

  • Food.
  • CoT Emeritus
  • LV10 31337 u53r (Next: 2000)
  • *
  • Posts: 1881
  • Rating: +503/-17
  • rawr.
    • View Profile
Re: Making a webcomic: "dynamic hyperlinks"
« Reply #29 on: September 24, 2011, 03:30:26 pm »
We're live :D

Now I'm wondering if it's a good idea to change to individual pages (no php/mysql) to deal with navigation, just for cleanliness and search visibility :* Since adding a new comic entails going to the file manager to upload a new file and change the value of $max AND then going into mySQL to enter the title/alt text I feel like it's pretty much the same amount of work either way...

Oh, and is there a way to strip the .html off the end of the url of an hmtl file (in the address bar)
« Last Edit: September 24, 2011, 03:35:58 pm by squidgetx »