/wdg/ - Web Development General

File: 1498904568636.jpg (4KB, 225x225px) Image search: [Google]

4KB, 225x225px

I have a database with three user types. Businesses, Business Clients, and Workers.

I have my database organized this way:
>account_info (to store basic account info, such as password/address/etc)

>person_info (stores specific info about people. Has account_info foreign key)
>>client_info (stores specific info about clients)
>>worker info (stores specific info about workers)

>business_info (stores specific info about business. Has account_info foreign key)

Is this fine?

>>61814015
Depends, does the data you store for different types of users change?

USERS ( 
    id
    user_type_id references user_type
    user_data_id references user_data 
)
USER_TYPE (
    id
    type
)
USER_DATA(
    id
    <ALL DATA FIELDS>
)

seems to make more sense

>>61814151
I was doing this, but I was cheating for stuff like business/industry name.
Example:
>first_name
>last_name

I was storing the business name and business industry in these fields, which is not good. Also, wouldn't it be easier just to do this in your example?

USER_DATA(
    id
    user_type_id references user_type
    <ALL DATA FIELDS>
)
USER_TYPE (
    id
    type
)

>>61814245

You could. But then you just do

[CODE]
USER (
id
type
<ALL DATA FIELDS>
)
[/code]

Depends on what the requirements are, you might want to have some data fields (the ones you'll allways need) on the user model, and others in a seperate table.

Or you might want a history of USER_DATA, to be stored whenever someone edits somethings, which would result in

USER_DATA (
    id
    user_id references user
    <ALL DATA FIELDS>
)

I am tryibg to hit an API and it keeps reaponding with "invalid resource"

I am correct in assuming they probably have no data or it's not set up correctly, right? It is responding with xml though.

>>61814396
Since there is no http error code for invalid resource is probably custom error. So RTFM like you should have in the first place.

>>61814015
That sounds like you will have some unnecessary joins.

I'd have 'business', and 'user' tables.

User can be a worker of a business (has employer_id referencing business table). You can also store what role they have in the biz here, etc.

Then have a 'client' table, which joins two businesses, i.e. biz 1 is client of biz 2. You can also put any info related to the client relationship here.

>>61814989
I did. It's their fault for not following the documentation of their adopted standard.

What sort of test should I perform to make sure my html form auth is bulletproof?

>>61815978
In what way?

File: 0 xkJgg-6HskYrQ3N7.jpg (69KB, 500x500px) Image search: [Google]

69KB, 500x500px

Reminder not to fall for the React meme, when you can choose superior Vue.js

File: shitcoins7.jpg (218KB, 1303x1023px) Image search: [Google]

218KB, 1303x1023px

Sup senpai.

Making progress on my crypto bot. Streaming data and making predictions and shit.

What are you working on?

I've spent the last few weeks learning the basics of web design, but i have no idea how to progress. I'm interested in the back end stuff, but have no idea how to set it up myself, I've spent the last few days trying to figure out how MySQL works and i'm making almost zero progress.

Can you guys suggest some reading or videos that will hold my hand through it? I really wanna learn how to do the hosting/database side of things.

>>61817288
What did you use for the graph?

>>61817401

Canvas + vanilla JS

>>61817293
the visual studio environment is good for this sort of thing and they have pretty thorough tutorials on the msdn

>>61817409
Nice.

>>61817293
>how to set it up myself
>how MySQL works

Are you asking about resources to learn SQL? Or about guides for setting up MySQL locally on your computer?

You should probably just use XAMPP or a similar package to set up a hosting environment. If you want to do it yourself, there are guides for installing the different parts though.

For learning it, probably use one of the links from the OP. I know codecademy has a SQL course.

>>61817288
not sure how I feel about those bots.
You leave it running and it's basically free money from other people making bad trades?

Isn't the value of all these crypto coins based 99,9% on pure speculation...
The only place I ever came across where you could actually pay with bitcoins was some VPN service.

Im doing colt steele bootcamp but i ultimately want to learn php and mysql, should i finish it all and them seek another material or do i stop before mongodb and nodejs stuff and look for php stuff?

File: fgfgfgf.png (12KB, 301x257px) Image search: [Google]

12KB, 301x257px

>>61817471
I've done a lot of the courses on code academy (i finished the php one i just reset it for reviewing). So i know how to do that part, i'm just lost trying to actually set it up on my PC, i don't know how to make data bases, i don't know the command line stuff. The closest i come is setting up a free static site on AWS using the buckets (still dunno how that works).

I'm looking for how to set up and use these things in a way analogous to a something that would be expected from an employer.

I'm looking to setup a MySQL server and practice creating and manipulating databases, I'd like to use a database to make more dynamic webpages, and i'd eventually like to make my own CMS.

>>61817416
I think ill check those out.

>>61817536

Disclaimer: the project is for fun and I don't expect it to actually make any money. I'm interested from purely a maths/ statistics perspective. If it breaks even I'm happy.

Crypto is purely speculative, yes (imho). A bot isn't capitalising so much on poor decisions as it is statistical market trends. And there isn't an algorithm in the world that can predict how real-world events will affect the market. At least not one I can write.

Bitcoins can be sold for cash.

>>61817614
>a free static site on AWS using the buckets (still dunno how that works)
That's a static site on S3 (simple storage service), basically it just serves files that the user requests. S3 can't run any code, so if you want to make a non-static site on AWS, then you'd have to use EC2 or something. You could install a database like MySQL on that EC2 instance, or you could use a database web service, RDS (sql) or Dynamo (nosql).

For a local install, you should probably learn how to install MySQL yourself. Look up a guide for your OS.

>>61817293
Well if you know node and express, this video series helped me understand mysql
https://youtu.be/gYjHDMPrkWU

>>61817787
ahh ok that makes sense now didn't know what S3 meant. I don't think i'm gonna know how EC2 works until i know how the stuff works on my own PC, since EC2 just hosts virtual machines doesn't it?

>>61817471
>>61817614
If you're using Windows you probably just want to use Wamp. On Linux you can install packages independently but they will play nice with each other. On OSX no idea lol.

hey /wdg/, I'm most interested in backend which I'm studying already but I also want to have a basic but good understanding of the frontend (HTML/CSS/JavaScript). this MDN link in the OP would be enough or is there a better website/youtube playlist/online course I could do?

Colt Steele course ir FCC? And why?

Thanks

>>61817911
Yeah, EC2 is basically just cloud virtual machines. But yeah, I'd recommend getting familiar with the software on your own machine first.

>>61818047
>On OSX no idea
I set up a local server recently on my Mac. I followed this guide:
https://jason.pureconcepts.net/2012/10/install-apache-php-mysql-mac-os-x/

Basically, Apache comes preinstalled with PHP (I think 5.5). You just have to enable it though in the main Apache config file; httpd.conf

MySQL is the only part you have to install, and it's easy if you already have homebrew set up. It was kind of annoying getting it set up so PHP could connect, but it didn't take too long overall.

>>61818094
The MDN link covers frontend basics that you'll still eventually have to know, whether you're nominally backend or not.

>>61818847
thx for replying

I just asked here to make sure. I guess everything is in the OP in case I want to learn more in depth

How do I get Sublime Text to set the syntax for template toolkit files based on file content? Most of my template files contain HTML, but it defaults to TT3 syntax without HTML highlighting, despite the majority of the file being HTML content

Thoughts on unobtrusive javascript?

I'm having a hard time justifying it as it's slowing down my project's UX a fair bit. It was fine when I was working on a project for clients that don't like javascript, but now that it's an internal project, having a fucking horrible mess of a UI for a month with the promise of making it better later isn't quite working.

>>61817540
Help

>>61820808
How experienced at programming are you?

If you're new to programming in general, learning nodejs will do you some good because the more languages you know, the easier it is to learn a new language. Adaptation is highly valuable.

On the other hand, if you just really want to get some php out the door, skip it. You can always come back later.

>>61820863
I want to know node and such but i have a friend that is using php and he needs help so im kinda inclined to learn it first. Any good courses or books on php+mysql?

>>61820602
I forgot what unobtrusive JavaScript means because I haven't heard that term in so long.

>>61821604
I like it in principle and often find myself just not using websites that require javascript to function at all, but I think this might be something that will never see widespread use.

Propsed a few talks about it recently and got rejected pretty fast.

>>61820981
You didn't really answer if you're experienced or not, so this might not be terribly useful for you but what I did about 3 months ago when I needed to learn php in a week was to just read through the tutorial on php.net, read through the tutorial on w3c and then started developing the thing I needed.
My potential employer basically wanted me to develop a micro app that could load spreadsheets and display the data on a web browser. I think it was a pretty good project to get started with php as it taught me a lot of the basics like importing a 3rd party library (to parse the excel file, fuck learning to deal with that in less than a week), handling files and manipulating data. It wasn't required, but I stuffed the data into a mysql database and had file access based on session tokens.
Also column sort and filters to learn how to make and handle your own requests, also some additional database work.

This was after about 10 years of unrelated programming in an academic environment though, so your mileage may vary. About a month into my new job I decided to just ditch raw php and started using laravel for the new projects I was assigned. Makes life a whole lot easier, but I wouldn't recommend jumping into a framework before having at least some basic understanding of how php works. The number of people who ask for help in laravel forums and have basic programming problems is high enough as it is.

>>61822355
That helped me, ill finish the colt steele course and then delve into php after i know more things about webdev. Thanks m8

File: Chen_3.png (92KB, 256x256px) Image search: [Google]

92KB, 256x256px

Im trying to install vichan and this come up when i run php install.php

PHP Fatal error:  Uncaught Error: Call to undefined function mb_internal_encoding() in /root/vichan/inc/functions.php:35

>>61823424
Install or enable the multi-byte string extension

>>61823452
Thanks mate!
i ran the PhP and this came up with the copyright html. im sure this is suppose to come up on a browser, but im doing this through ssh. i went to my ip though and it still has the default php page. is this normal? what am i missing?

>>61823577
Perhaps the base www directory is not the same directory of your application.

I think you should follow a detailed SSH+Apache guide, like the Digital Ocean ones.

My website has been online for 3 weeks now with a .com domain and it still isnt getting indexed by google, i did everything except using google analytics. It shows up as the top result on any other search engine using only 2 keywords

Is google just trying to jew me into using google analytics?

File: キャプチャ.png (122KB, 1739x748px) Image search: [Google]

122KB, 1739x748px

>>61823724
well yes. unless hundreds of people use it.
>>61823703
DO you mean installng lamps?
this is the output btw

Trying to replicate this small navbar is fucking me up. Just can't think of how to get my head round it.

http://delinear.p-a-n.org/

Where it you hover over the 'logo' and the bar expands.

how the fuck I do that???

>>61823724
Did you google search console? You don't need GA.

Is your domain low quality or flagged for being virus/illegal?

File: google search.png (116KB, 2000x1156px) Image search: [Google]

116KB, 2000x1156px

>>61824523
The website is http://www.dotaclassic.com/

The website shows in any other search engine, google requires a higher quality website? is so how is the quality defined?

If you scroll down on the "This is how Googlebot saw the page" you would see "An unexpected error has ocurred", thats why there is a big empty white space, i havent been able to fix this error because even older browsers load my website just fine

Its a one page application, but i still uploaded the sitemap with only the "/" route

>>61824479
Thats like the worlds shittiest webpage. They are using JQuery and some plugins.

.hover()
Bind one or two handlers to the matched elements, to be executed when the mouse pointer enters and leaves the elements.

also JQuery has effects like .slideDown() or you can use plugins or you can make your own.

>>61824667
You problem is your content is entirely Syndicated content. Scraped content doesn't rank.

Other things to consider:
How old is your Domain? What is the history of your Domain? Do you have Public WhoIs registered? Is your webserver in your moms basement? How about you get some more above the fold content to load in the first 2000ms champ? Do you have outbound links to anything shady? How is your Domain Trust/Trust Rank? How many HTML errors does that page have? Have you considered https? Have you considered building backlinks?

>>61824843
cheers