Skip to content

How to store array in Laravel?

There are two mysql tables 1.seats (id,number), 2.reservedseats(id,seat_id,sceering_id). I show all the seats of a specific sceering as checkboxes in show.blade: {!!Form::model($screening,[‘method’=&…

Sum price of one to many relation ship (laravel)

i have problem with one to many relation ship! So im try to sum product prices so here is what i mean: Model: Product.php Model: Orders.php So i want make smth like this: $var->product->price->sum(); My database if it needed: Orders: id product_id|user_id| |-|———-|——-| |…

MySQL 5.7 equivalent to PHP’s json_decode()?

I’m converting some php scripts into mysql stored procedures and have come across the usage of php’s json_decode() on a result set’s data. It occurs on a field which is stored as a mediumtext,utf8,utf8_unicode_ci How can I perform the ‘json_decode()’ process using pure MySQL? Sam…

Error: Class ‘PHPMailer’ not found

Error: Fatal error: Uncaught Error: Class ‘PHPMailer’ not found in C:xampphtdocsphp-mailerindex.php:4 Stack trace: #0 {main} thrown in C:xampphtdocsphp-mailerindex.php on line 4 My PHP Code here: Please let me know what mistake I made here in my code. Answer It’s because you’ve not con…

Symfony 4 – Autowiring not working

I have a form that write values to an specific Entity, and I am trying to edit the information through a function in the controller, pretty simple. BancoController.php The problem is, when I access /banco/{id}, I get the error: My service.yaml is all default, so I guess it should work automatically. The entit…

Impossible to load pdo driver on Windows Server 2016

Im trying to load the pdo driver for firebird database on a windows server 2016 (64 bits). Configuration is the next : Firebird in 32 bits successfully installed. Apache 2.4 successfully installed (Apachelounge binary, 32 bits). Apache configuration properly set (installed in C:/Apache24) PHP 32 bits successf…

Destroy cookie when browser window closes PHP

I have created a popup in WordPress that will open when visitor IP is from Australia. The popup will show up on page load. I want to make it not show until the browser screen is closed. For this, I used the cookie. I set the cookie when the close button is clicked and creating the cookie in PHP using