I can’t find how to print data on the blade.view. I have a list of “customers” on overview.blade.php, and I have a button that redirects to their profile based on their “nCustomerID” (which is blade….
Tag: mysql
How to display data one to many relationship using php and mysql
I have a lot of products and each product has many flavour. How can i display one product name with multiple flavor. below is the script that i have tried. It doesn’t display anything. I’m really new …
How to insert array values to different MySQL column
I have an array that contains multiple images directory that I defined as $multipleDir. Also I have table named product that contains the following structure: CREATE TABLE `product` ( `id` int(…
sql query selecting birthday today from number format
Let say i have identification card number in this format we can convert the number to birthday by using this code how do i select all user that is having birthday today ? is this possible ? Answer What I understand is first 6 digits of your ic is YYMMDD. If this is not the case please ignore. Accordingly you
Invalid credentials adldap2/adldap2-laravel package
I am implementing LDAP authentication in laravel app. When I run this code I am getting an error. I don’t know whether it is correct or not. I am totally new to LDAP and I don’t know how it works by …
MySQL syntax for summing several count data
I have a MySQL table called things_they_own with two columns: person and thing and my primary key is the combination of the two. Thus, there are several rows where the first column is a certain …
insert data from while loop into database php
I am trying to post data into my database from these while loop. It helps me get the monthly periods within a particular range. I want to pick the dates and input the dates into my database along with …
phpmyadmin not opening and showing “The page isn’t working HTTP ERROR 500”
Below is my apache2 php.ini log file line which shows Fatal error. [Thu Jan 23 11:21:04.634143 2020] [php7:error] [pid 9929] [client ::1:56044] PHP Fatal error: Allowed memory size of 2097152 …
Android / MySQL: Spinner not populate data from MySQL
I have a problem with my code. I already created a spinner that populates from the MySQL database. The PHP code seem not have problem at all since I run the link “localhost/latihan1/menu/php”, the …
How to pass array as SELECT params for Laravel Query Builder
If I have an AJAX call that returns an array called $selectArray, which is [foo,bar,foobar], how do utilize it in a Laravel Query Builder so that it’s sanitized? Currently, I have It seems awfully unintuitive. Either there are better ways sanitizing the input or passing Array as SELECT without having mu…