First Website Progress - Developers

I'm an aspiring graphic designer/programmer, currently enrolled in digital communications classes at my high school. The last big project that we do in my school is called our Senior Exhibition of Mastery, which gives us a chance to show off what we've learned with our time at the school, and what we plan to do as a career in the future. For my senior mastery project, I decided to develop a website for a band I am in with a couple of friends, as I felt this would be a great way to show off both programming and design skills. I planned on making it entirely from scratch, with nothing but dreamweaver and google to help me. Going into this project, I had decent knowledge of html, minimal knowledge of css, and no knowledge of any other (web related) languages. So far, I've learned html, css, php, jquery/javascript, and mysql. [url=http://imgur.com/a/Z6Tok#0]Here[/url] is an imgur gallery full of pictures of my website, with comments on each picture. I do plan on uploading it to [url]www.wethebroken.com[/url] when it's finished, or at least when I polish what I have so far and make a place holder index page. As this is my first website, any constructive criticism is very welcome, so please let me know what you think!

I would recommend not using dreamweaver, it should be do-able if you don't use the design part though.

[QUOTE=Killervalon;42985154]I would recommend not using dreamweaver, it should be do-able if you don't use the design part though.[/QUOTE] With that said, I recommend Sublime Text. And I think I speak for quite a lot in here :v:

[QUOTE=PortalGod;42954356]I'm an aspiring graphic designer/programmer, currently enrolled in digital communications classes at my high school. The last big project that we do in my school is called our Senior Exhibition of Mastery, which gives us a chance to show off what we've learned with our time at the school, and what we plan to do as a career in the future. For my senior mastery project, I decided to develop a website for a band I am in with a couple of friends, as I felt this would be a great way to show off both programming and design skills. I planned on making it entirely from scratch, with nothing but dreamweaver and google to help me. Going into this project, I had decent knowledge of html, minimal knowledge of css, and no knowledge of any other (web related) languages. So far, I've learned html, css, php, jquery/javascript, and mysql. [url=http://imgur.com/a/Z6Tok#0]Here[/url] is an imgur gallery full of pictures of my website, with comments on each picture. I do plan on uploading it to [url]www.wethebroken.com[/url] when it's finished, or at least when I polish what I have so far and make a place holder index page. As this is my first website, any constructive criticism is very welcome, so please let me know what you think![/QUOTE] Hi! It's great you are getting into web development! May I suggest you demonstrate even more mastery of web programming and learning more by incorporating a database, and using with forms and SQL to develop a registration/login system based on sessions? I know this will be hard, but if you can do this simply process, you will understand how to set up a database (hopefully using cpanel, and phpmyadmin), and simply queries using SQL to pull data from the databse, and check user inputed data using POST method woth forms against the database to verify credentials. Good luck in your journey! Web development is an amazing career. <3 If you need any help with any of this, feel free to ask! :dance:

[QUOTE=Luna Prey;43071507](hopefully using cpanel, and phpmyadmin)[/QUOTE] "hopefully"

[QUOTE=supersnail11;43072093]"hopefully"[/QUOTE] Cpanel and Phpmyadmin are both very useful tools. They make it easy for a new programmer to set up a database, and a table, and also to practice SQL in it's SQL command box, and perform searches of the database, and export database, and import, and lots of nice features! I am personally in love with cpanel and phpmyadmin. :smile:

[QUOTE=Luna Prey;43072137]Cpanel and Phpmyadmin are both very useful tools. They make it easy for a new programmer to set up a database, and a table, and also to practice SQL in it's SQL command box, and perform searches of the database, and export database, and import, and lots of nice features! I am personally in love with cpanel and phpmyadmin. :smile:[/QUOTE] I wouldn't hire you if you used cpanel and phpmyadmin to rely on things.

[QUOTE=jung3o;43072315]I wouldn't hire you if you used cpanel and phpmyadmin to rely on things.[/QUOTE] don't worry, i wouldn't want to be hired by someone who judges a developer based on weather or not they use cpanel or phpmyadmin. why are you flaming me anyway? i'm just trying to help someone who's starting out.. it's friendly advice, there is no need to flame

[QUOTE=Luna Prey;43072436]don't worry, i wouldn't want to be hired by someone who judges a developer based on weather or not they use cpanel or phpmyadmin. why are you flaming me anyway? i'm just trying to help someone who's starting out.. it's friendly advice, there is no need to flame[/QUOTE] OP already said he knew SQL. Anyways, I know what I said is really blunt which was uncalled for. I have my own company which my friends and I started and we quickly learned that relying on cPanel and/or phpmyadmin is terrible because we found it very inefficient when we had to change things quickly.

[QUOTE=jung3o;43072593]OP already said he knew SQL. Anyways, I know what I said is really blunt which was uncalled for. I have my own company which my friends and I started and we quickly learned that relying on cPanel and/or phpmyadmin is terrible because we found it very inefficient when we had to change things quickly.[/QUOTE] well, in that case you should be posting helpful advice, instead of flaming those who do~

[QUOTE=Luna Prey;43072632]well, in that case you should be posting helpful advice, instead of flaming those who do~[/QUOTE] [quote] I wouldn't hire you if you used cpanel and phpmyadmin to rely on things. [/quote] theres your advice. also thats not flaming.

[QUOTE=/dev/sda1;43072709]theres your advice. also thats not flaming.[/QUOTE] the topic was for improving his web development skills. i don't think he plans on hiring anyone :eng101:

[QUOTE=Luna Prey;43074025]the topic was for improving his web development skills. i don't think he plans on hiring anyone :eng101:[/QUOTE] why do you shit up literally every thread you post in?

[QUOTE=Luna Prey;43074025]the topic was for improving his web development skills. i don't think he plans on hiring anyone :eng101:[/QUOTE] he can improve his webdev skills by taking jung3os advice

[QUOTE=/dev/sda1;43074941]he can improve his webdev skills by taking jung3os advice[/QUOTE] you guys are mean

So what do you guys suggest for building databases? I'm studying web-design but am mostly on the design part, not so much coding; yet I believe it's probably pretty important for me to be able to build a website around a database. [quote=Luna Prey]you guys are mean[/quote] Welcome to Facepunch! I wouldn't say mean, i'd say very direct and mostly honest.

[QUOTE=MyAlt91;43076518]So what do you guys suggest for building databases?[/QUOTE] [URL="http://dev.mysql.com/downloads/tools/workbench/"]MySQL Workbench[/URL].

[QUOTE=MyAlt91;43076518]So what do you guys suggest for building databases? I'm studying web-design but am mostly on the design part, not so much coding; yet I believe it's probably pretty important for me to be able to build a website around a database.[/QUOTE] Models and MySQL Workbench. I also recommend checking out MongoDB because it's pretty great. [editline]5th December 2013[/editline] [QUOTE=Luna Prey;43072137]Cpanel and Phpmyadmin are both very useful tools. They make it easy for a new programmer to set up a database, and a table, and also to practice SQL in it's SQL command box, and perform searches of the database, and export database, and import, and lots of nice features! I am personally in love with cpanel and phpmyadmin. :smile:[/QUOTE] it's like i'm looking at myself 3 years ago

[QUOTE=supersnail11;43081845]I also recommend checking out MongoDB because it's pretty great.[/QUOTE] When you're using it under the right conditions, yes. There are a [I]lot[/I] of situations where a relational database is a better choice. I [B]vastly[/B] prefer PostgreSQL over MySQL though.

[QUOTE=KmartSqrl;43089929]When you're using it under the right conditions, yes. There are a [I]lot[/I] of situations where a relational database is a better choice. I [B]vastly[/B] prefer PostgreSQL over MySQL though.[/QUOTE] And why is that?

[QUOTE=KmartSqrl;43089929]When you're using it under the right conditions, yes. There are a [I]lot[/I] of situations where a relational database is a better choice. I [B]vastly[/B] prefer PostgreSQL over MySQL though.[/QUOTE] I just really like the lack of a schema. I don't have to create tables and edit them when I want to add new fields, I just add a new line to the model. I always thought the differences between MySQL and PostgreSQL were mostly just personal preference. Are there any objective advantages of PostgreSQL over MySQL?

PostgreSQL and MySQL are quite similar these days. There's not really any differences anymore. The real difference is that PostgreSQL conforms to ISO standards, unlike MySQL.

[QUOTE=KmartSqrl;43089929]When you're using it under the right conditions, yes. There are a [I]lot[/I] of situations where a relational database is a better choice.[/QUOTE] Would you mind giving a few? I'm genuinely curious since I am quite fond of MongoDB and like to know the pro and contras of the stuff I use.

[QUOTE=commander204;43099178]Would you mind giving a few? I'm genuinely curious since I am quite fond of MongoDB and like to know the pro and contras of the stuff I use.[/QUOTE] I don't completely agree with this article, but it explains some of the pitfalls pretty well: [url]http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/[/url]

[QUOTE=Killervalon;42985154]I would recommend not using dreamweaver, it should be do-able if you don't use the design part though.[/QUOTE] [QUOTE=Moofy;42986029]With that said, I recommend Sublime Text. And I think I speak for quite a lot in here :v:[/QUOTE] What's wrong with dreamweaver? I don't really use the design part much, but it has a bunch of useful things like intellisense (especially useful with css), error highlighting, browsing for assets, link updating, and the one I use the most, a test server with xampp for testing php and stuff. [QUOTE=Luna Prey;43071507]Hi! It's great you are getting into web development! May I suggest you demonstrate even more mastery of web programming and learning more by incorporating a database, and using with forms and SQL to develop a registration/login system based on sessions? I know this will be hard, but if you can do this simply process, you will understand how to set up a database (hopefully using cpanel, and phpmyadmin), and simply queries using SQL to pull data from the databse, and check user inputed data using POST method woth forms against the database to verify credentials. Good luck in your journey! Web development is an amazing career. <3 If you need any help with any of this, feel free to ask! :dance:[/QUOTE] I have an admin login system, I don't plan on adding registrations or anything. The only place clients would get to use their accounts would be commenting on News posts, or in the shop. The admin accounts do use what you said though, with one way hashed and salted passwords on the database, and I use a session for storing whether a client is logged in as an admin or not. I do use a database, for more things than I probably should (because of the way admins edit pages), and although I use phpmyadmin, I'm trying as hard as I can to stick to using queries rather than using any shortcuts or anything. [editline]8th December 2013[/editline] [t]http://i.imgur.com/rDOmfQ2.png[/t] [t]http://i.imgur.com/YzwKfAP.jpg[/t] [t]http://i.imgur.com/Zwa0GoJ.jpg[/t] [t]http://i.imgur.com/tWY1f5s.png[/t] Also added uploading in bulk (title and desc get disabled, title defaults to the filename), deleting from detail.php (but I also have to add bulk deleting from gallery.php), and adding shows to shows.php (the date defaults to today's date, but I dunno about the layout yet)

big bump, it's been a while, but my website is finally up: [url]http://wethebroken.com/[/url] hopefully you guys can check it out, and although I don't expect everything to work (mainly the music player), I'd appreciate any bug reports or anything!

[QUOTE=PortalGod;44512173]big bump, it's been a while, but my website is finally up: [url]http://wethebroken.com/[/url] hopefully you guys can check it out, and although I don't expect everything to work (mainly the music player), I'd appreciate any bug reports or anything![/QUOTE] The URLs in the Contact page are broken, and go to wethebroken.com/\*facebook....... Also, the big pixelated crosses on the About part look bad. You might want to find a better placeholder until you fill it up.

updated both [url]http://wethebroken.com/about.php[/url] [url]http://wethebroken.com/contact.php[/url]

[QUOTE=FrankPetrov;43093108]PostgreSQL and MySQL are quite similar these days. There's not really any differences anymore. The real difference is that PostgreSQL conforms to ISO standards, unlike MySQL.[/QUOTE] PostgresSQL actually supports boolean columns as well as [url=http://www.postgresql.org/docs/9.3/static/datatype.html]many other data types[/url] such as UUIDs, IP and MAC addresses, and even JSON data (on which you can use [url=http://www.postgresql.org/docs/9.3/static/functions-json.html]special functions and operators[/url]). MySQL and MariaDB [url=https://mariadb.com/kb/en/data-types/]don't support[/url] any of that.