I am just doing some testing with a few tables that I’m trying to relate together, based on the values of my ‘students’ table. Here are the total tables that I have: students TABLE id, name, course_num, msg_num biology TABLE id, details, msg_num chemistry TABLE id, details, msg_num physics TABLE id, details, msg_num So I’m trying to select the ‘students’
Tag: database-design
Cannot add or update a child row: a foreign key constraint fails – Laravel 7
I’m trying to add a relationship 1:1 between my Visitor & Contact When run I kept getting Answer In the latest versions of laravel the primary key is biginteger. so you might have to change this $table->integer(‘visitor_id’)->unsigned(); with this $table->bigInteger(‘visitor_id’)->unsigned();
How should I change the database layout of my html form to make it more scalable?
I have a HTML form which sends the results to a database currently. The questions are hardcoded to the html page and I am trying to make the form more scalable, dynamic and flexible. I got suggested …
Where does Facebook store multi millions of Images and Videos. In database or somewhere else? if so, Where? [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 10 months ago. Improve this question I am completely new to database. I require some information regarding where does the Facebook which stores millions and millions of
Systematic way to store pictures for social website [closed]
I’m building a basic social website where users can upload pictures. I’m going to store store the images on the file system. When a user uploads a picture, how do you think I should name the files? I …
Database Design For Developing ‘Quiz’ Web Application using PHP and MySQL
So, I’m trying to learn PHP and MySQL (I have a basic understanding of both; I’ve read the first half of both Head First SQL and Head First PHP & MySQL) and I figure the best way to solidify my knowledge is by building something rather than reading. With that in mind, I would like to create a basic webpage
How does facebook calculate mutual friends? [closed]
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 11 years ago. Improve this question In your opinion, how does facebook calculate mutual friends? Has it cached all mutual friends for each user? Or does it let MySQL calculate through a query each
PHP Access Control System
I am part of a team creating a web application using PHP and MySQL. The application will have multiple users with different roles. The application will also be used in a geographically distributed …