256 Kilobytes

All Content > Databases

Type All Category All Tag Databases

Profile Photo - August R. Garcia

[Infographic] The Beginner's SQLite Cheat Sheet

Articles in Web Scraping, Data Analysis | By August R. Garcia

Published 2 weeks agoSat, 04 May 2019 23:59:37 -0700

Profile Photo - August R. Garcia

The important hotkeys, commands, and tri...

MoreWhat a great infographic. Copy-Pasteable Version of the SQLite Commands Cheat Sheet General SQLite Commands and Information Opening SQLit...
🗨
0
🐏
0
👁
45
Profile Photo - Some Guy

How to fix "Operand should contain 1 column(s)"?

Answers in Databases | By Some Guy

Published 5 months agoSun, 16 Dec 2018 09:41:02 -0800

Profile Photo - Univa

Last Reply This error can occur if you accidentally use commas instead of AND in the ON clause of a JOIN. FOR EXAMPLE: JOIN joined_table ON (joined_table.c... Univa,

This error can occur if y...

Thu, 18 Apr 2019 07:57:10 -0700 1 month ago
🗨
1
🐏
0
👁
72
Profile Photo - Biskwits

What are some common Database interview questions?

Answers in Local and Offline Businesses | By Biskwits

Published 1 month agoTue, 19 Mar 2019 02:34:28 -0700

Profile Photo - 888_eight_888

Last Reply Define DBMS. What are the advantages of DBMS? What is data redundancy? What are the various types of Database relationships? Describe Normalization an... 888_eight_888,

Define DBMS. What are the...

Thu, 21 Mar 2019 00:15:33 -0700 1 month ago
🗨
1
🐏
0
👁
28
Profile Photo - August R. Garcia

[Solution] How to View Queries in Laravel for Debugging

Answers in Frameworks | By August R. Garcia

Published 2 months agoTue, 12 Mar 2019 03:30:21 -0700 | Last update 2 months agoTue, 12 Mar 2019 04:53:04 -0700

Profile Photo - August R. Garcia

Ghetto hack edition.

MoreStep 1: Open app/Providers/AppServiceProvider.php Step 2: Add this code to the boot() function: if ( TRUE ) { $G...
🗨
0
🐏
0
👁
65
Profile Photo - Some Guy

How do I become a database developer?

Answers in Database Development | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:22:05 -0800

Profile Photo - roxblade

Last Reply I'll line-out the very basic necessities to become a database developer. You need to learn SQL and be proficient in MySQL. A bachelor's degree is very... roxblade,

I'll line-out the very ba...

Sun, 03 Feb 2019 11:33:59 -0800 3 months ago
🗨
1
🐏
0
👁
97
Profile Photo - Some Guy

How to delete a database in PHPmyadmin?

Answers in Server-Side | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:32:06 -0800

Profile Photo - August R. Garcia

Last Reply You can also directly run these commands through the PHPMyAdmin UI: SHOW DATABASES; If you need to look up the database name(s) DROP... August R. Garcia,

You can also directly run...

Sat, 02 Feb 2019 21:43:54 -0800 3 months ago
🗨
2
🐏
0
👁
94
Profile Photo - Some Guy

[Laravel] Count post views?

Answers in Frameworks | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:44:24 -0800 | Last update 4 months agoSat, 29 Dec 2018 05:36:24 -0800

Profile Photo - August R. Garcia

Last Reply There are two basic ways to do this: Easiest: Increment a FIeld in the Posts Table Easiest: Add a field to your posts table and increment it eac... August R. Garcia,

There are two basic ways...

Sat, 29 Dec 2018 05:59:17 -0800 4 months ago
🗨
1
🐏
0
👁
142
Profile Photo - Some Guy

What is "mysqli_real_escape_string" in PHP?

Answers in Databases | By Some Guy

Published 5 months agoSun, 16 Dec 2018 09:38:14 -0800

Profile Photo - Some Guy

I'm writing a program for a class p...

MoreI'm writing a program for a class project. I'm writing PHP for the program and I can figure out a code. I don't know what "mysqli_...
🗨
0
🐏
0
👁
61
Profile Photo - Some Guy

How can I check if row a exists with Laravel?

Answers in Frameworks | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:45:39 -0800 | Last update 5 months agoMon, 03 Dec 2018 14:56:02 -0800

Profile Photo - Hash Brown

Last Reply It depends on what you want to do with the data. If you just want to check if it exists: if (User::where('username', '=', Input::get('username... Hash Brown,

It depends on what you wa...

Mon, 03 Dec 2018 14:58:11 -0800 5 months ago
🗨
1
🐏
0
👁
48
Profile Photo - Some Guy

How does the soft delete feature work for Laravel projects?

Answers in Frameworks | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:45:23 -0800

Profile Photo - August R. Garcia

Last Reply Soft deletes are marked with a timestamp at the time of deletion/"deletion," but the data remains in the database (and can be recovered/unde... August R. Garcia,

Soft deletes are marked w...

Sun, 02 Dec 2018 03:49:22 -0800 5 months ago
🗨
1
🐏
0
👁
47
Profile Photo - Some Guy

[Laravel] Pluck Method

Answers in Frameworks | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:44:57 -0800

Profile Photo - August R. Garcia

Last Reply Collections: https://Laravel.com/docs/5.7/collections#method-pluck Queries (See "Retrieving A List Of Column Values"): ht... August R. Garcia,

Collections:

Sun, 02 Dec 2018 03:48:56 -0800 5 months ago
🗨
1
🐏
0
👁
45
Profile Photo - Some Guy

[Laravel] Create migration with model?

Answers in Frameworks | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:43:43 -0800

Profile Photo - August R. Garcia

Last Reply Instead of:PHP artisan make:migration create_roles_table -mRun this:PHP artisan make:model Role -m August R. Garcia,

Instead of:PHP artisan ma...

Sun, 02 Dec 2018 03:47:42 -0800 5 months ago
🗨
1
🐏
0
👁
42
Profile Photo - Some Guy

[Laravel] How to query a many-to-many relationship?

Answers in Frameworks | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:44:55 -0800

Profile Photo - Some Guy

MoreHalp.
🗨
0
🐏
0
👁
44
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreHow do you do the thing in the title?
🗨
0
🐏
0
👁
44
Profile Photo - Some Guy

[Laravel] Specify foreign key name in model?

Answers in Frameworks | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:44:23 -0800

Profile Photo - Some Guy

MoreI am using a foreign key name that is not the default. Can I specify this in the model file for my class?
🗨
0
🐏
0
👁
59
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreIf anyone can provide an example or point me toward the right documentation, I am willing to figure out the rest from there.
🗨
0
🐏
0
👁
47
Profile Photo - Some Guy

[Laravel] How does the whereHas() method work with Eloquent?

Answers in Frameworks | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:42:56 -0800

Profile Photo - Some Guy

MorePls help.
🗨
0
🐏
0
👁
62
Profile Photo - Some Guy

[Laravel] Order by last comment?

Answers in Frameworks | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:42:41 -0800

Profile Photo - Some Guy

MoreI'd like to have the posts on my website order by the most recent comment. Is this possible through Laravel?
🗨
0
🐏
0
👁
50
Profile Photo - Some Guy

[Laravel] How to pass a parameter to a factory?

Answers in Frameworks | By Some Guy

Published 5 months agoSun, 02 Dec 2018 03:42:17 -0800

Profile Photo - Some Guy

MoreI have a factory that generates posts, which have category_id values. I would like to be able to either pass no value (and have a random one set - I&#...
🗨
0
🐏
0
👁
58