sr57

Thanks @bugsysha

Thanks @jlrdw , I agree with you , I know debug in general, never used for php (till now). But my question is about 'profiling', I have a 'complex' job that I need to reduce duration as better as I can. Till now, microtime(true) and looking in the main loop(s) was enough but this time I have many different loops in several recursive functions. (including changing the language of the heart ... but it should be another question)

You can't disable a trigger, so if you put a before trigger when you delete a repo, triggers will act on each file, and it works.

If you can have a lot a file per repo this solution is not to use, so do not use trigger (for file deletion) and put the logic in controller.

I just wonder if anyone use other tool than XDebug to profile php codes? And why?

Yes but tired :-)

You forgot the get

$obj = DB::table("V_PRENOTAZIONI_SHARING") ->where("id_prenotazione", 360) ->where("f_principale", "=",1) ->get()->first();

Hello @maxtenco , what are you afraid of?

Same answer as my first one : YES

If you are not comfortable to do this for the first time in prod, try it on a app test in prod, and always have your an updated backup.

In 2 times +

1. $rn=rand(0,9).rand(0,9) ... (10 times or better with a loop)

1.1) better with @martinbean solution (Laravel solution versus plain php with rand)

1. Check if this number does not exist for a user

2. redo 1 & 2 if already exists (very low probability)

same as insert, seeder.

Your question was about to insert a record :-), for this you have to use a seeder

If you want to add a field (or do other change in the db structure), use migration of course.

First you have to know (application specific) that your update will not change st bad ...

That said, let's assume that add a category is not a sensible update you can :

1. quickest way (test) : directly insert in the db

2. better way ie laravel one shot way (app updated) : write et run a seeder

3. if can/must be done by user : :write a form

Strange if you don't change migrations! Can you re-create* your db and rod the test.

• php artisan migrate:refresh

Hi @foks

So you have a pb with your db ... and sqlite is probably not updated.

Is-it a fresh version of Laravel/Jetstream?

I should try 2 things

1. réinstall node

https://phoenixnap.com/kb/update-node-js-version

1. do a fresh new version of Laravel/Jetstream and compare

Try recreate totally the db

php artisan migrate:refresh

Strange ... does your test connect to the right db?

Does the table permissions exist in the db?

Can you show your migrations and tests?

Very BEST answer :-) Thanks @chaudigv

I use FusionCharts

https://www.fusioncharts.com/blog/charts-laravel-web-application/

Thanks @bugsysha

Usually they group similar logic

Can be useful, I'm used to do this by (bash) scripts over my code, should be a better (more standard) solution. I'll see in the future.

Thanks @nimrod , never heard before.

Hi @bugsysha @marketintelligence

English is not my mother-tongue language, what's the meaning of 'trait'?

Have a look of the variable old('status') (use dd or dump for example ) and/or a look in the source of html page in your browser.

Hy @tray2

irrelevant better than incorrect?

The question concerns table alias and not column alias.

In your code your selected option is disabled & hide, you should put your 'old value' , enable it and probably not hide it.

You are lost, it's a second error.

Post your error log concerning 'Array to string conversion' here between 3 ` like your code, it's easier to read than your image.

You should look at the error stack, to see which line of you original code is concerned.

have a look in the last error in the file : storage/logs/laravel.log

Can you show the error logs?

Hi @prudencesedo

PHP is stateless, session variables is the 'standard' way to store 'states', after you can use other 'solutions', put in a file, put in a cookie, put in the url, put in the db, ... just choose the one that feet your need.

Nor specific to Laravel, just a 'classic' php error

Array to string conversion

means you put an array where a string is needed.

Have a look to your log to see the line number, dd the variable(s) et correct your code.

If you do not do the job in the db, either you have the right associative array or first you construct it

Then the easiest way to do a simple sort on an associative array is to use

asort : to sort by value

ksort : to sort by key

then you can foreach ...

and if you need to reverse key/value you can use array_flip

You can use session variables

First store the data

https://laravel.com/docs/8.x/session#storing-data

Then use it where you want

https://laravel.com/docs/8.x/session#retrieving-data

Hi @osama_abdullah , theroicaly you are not wrong but doing this will :

• be confusing (looking at an IP to know if it's public or private and mainly for many tools that deals with that standard)

• give a very little (<1%) more number of new public IP and far less the need and IPV6 standard.

IPV4 = 2^32 = 4*10^9 (less than one IP per person on Earth)

IPV6 = 2^128 ~10^39 that's 10^21 more ! (each of us on Earth can have 10^11 IP addresses, should be enough for a long time)

You can use gammu/wammu or directly adb

With Eloquent you must use 'right naming' for keys

Remember, Eloquent will automatically determine the proper foreign key column

https://laravel.com/docs/8.x/eloquent-relationships#one-to-many

Without Eloquent you must define you foreign key in your migration

Right, I read and posted my answer too quickly. Can you show your migration?

You forgot the line

$feature->model_number = ...

In your css define an 'alias' class name and use it where you don' want the log

.my-class-2, .my-class-2_1 { //styles }

When you pass over 'HOVER THIS CLASS 1' you enter in a row the 2 div , your result is normal.

Try to put a 3rd class and you'll see 3 logs, or to reverse the div and your log will be reverse.

Not a laravel pb, use db tools to improve query performance.

Hi @osama_abdullah , theroicaly you are not wrong but doing this will :

• be confusing (looking at an IP to know if it's public or private and mainly for many tools that deals with that standard)

• give a very little (<1%) more number of new public IP and far less the need and IPV6 standard.

IPV4 = 2^32 = 4*10^9 (less than one IP per person on Earth)

IPV6 = 2^128 ~10^39 that's 10^21 more ! (each of us on Earth can have 10^11 IP addresses, should be enough for a long time)

Option B is better than A in absolute but, with good index and cache in service you'll see no difference till all your data will be in memory, real advantage will arrive when table A that should be the smallest size will still be in memory and not table B.

Don't forget that there good tools to optimize sql in mariadb or postgresl.

HI @levitorres If you don't find the answer in this subject, open a new one, this one is close and few people will see your question.

t works fine by me just dump($task->select) , maybe it does not contain expected data.

$ts=array( array('id' => '27','slug' => 'moderne-kommunikation'), array('id' => '26','slug' => 'nachwuchs-binden') );

	$c=collect();
	foreach ($ts as $t) $c=$c->mergeRecursive($t);
	$r=$c['id'];

Yes, the same, it just makes you create a non mandatory job.

Hi @npalmqvist

Just select one as best answer, ti can be yours (if you want to reformulate a conclusion), in general try to select the one that help the most you.

Arr::has(....) ? ... : "";

https://laravel.com/docs/8.x/helpers#method-array-has

Pb solved?

Why not if that's feet your need, personally I think it's a little more complicated; Let's know where you are with your memory pb and don't forget to close your subjects.

For gmail don't forget to go in the parameters of you account o activate 'less secure app' (and pop/imap if needed) et less known

https://accounts.google.com/DisplayUnlockCaptcha

Have a look to the mail(s) sent by gmail to your account.