And I am building a search functionality, anyone with experience in building a good db search who can point me in the right direction about indexing?

Who can help me??

Db table settings does not exist, try migrating or create the table

Check env file

This web site was run in shared hosting for a long time. But, today I got this error suddenly. Why is that ?? Env file is updated.

This web site was running on a shared hosting for a long time without any problem. But, today I got this database connection error suddenly. Env file and everything is fine. Why is this ?? How can I fix this ??

Hey guys. I have an HTML question

We have a form with a field called “phone”. When the user focuses on the field, Firefox suggests email addresses

I’ve tried autocomplete=”off”

Still Firefox doesn’t care

Tried these values to:
“tel”,
“tel-national”,
“mobile tel”

The field is of type tel

do it in jquery

Please doesn’t anyone has any resource to refer me to any resource that explains database indexing properly

Please doesn’t anyone has any resource to refer me to any resource that explains database indexing properly

I understand normal indexing but I saw somewhere someone said indexing is highly need for fast db querying

$(‘input’).attr(‘autocomplete’,’off’);

Will try that. Thanks

And I am building a search functionality, anyone with experience in building a good db search who can point me in the right direction about indexing?

What do you want to know?

Ok thank you, what I want to know is I understand indexing as a concept to of giving my a record unique identify from other records such as numbering index but how does this translate to making searching fast?

I’ll give you the short version

I created registration form in laravel . After submit button Data is not added in database also how to create index.php. after executing project it shows follows

Hi everyone, need help,
does any one know how to implement AES Encryption 128 bit in PHP? I am using Yii 2

PS: I know its laravel group, but just asking for help

Especially my db record is getting to around 20k but I kind of start having some load time issues with search things, could it be because of I need to upgrade hardware ?although I plan to do so but someone mentioned indexing

If you dont have an index, your database will start from row1 and search for what you want all the way until the very last result. Thus it will take a long time if you have more rows.

But with an index, your database will know where certain data is located and directly go to the row. Thus shortening the time

20k to be honest is not alot of data

If you are not doing any indexing, then that’s very high chance where your culprit are

yes thank

I only used basic indexing like id. Is that enough?

Whether is it enough will depend on your query use in your app

for example, if youa re just doing

SELECT * FROM users WHERE id = 5;

Sure your basic indexing for id is definitely enough. But if you are doing

SELECT * FROM users WHERE level = 5 AND ratings = ‘4’;

Ok good so if I use email instead o id, then I need to use email as an index right?

I can’t install AdminLTE with Laravel 5.8. What problem?

Then your basic index is literally useless