I’m trying to make a website that displays all userprofiles. I want to wrap every two users in a <div>, until there is no left. So say we have 19 arrays consisting of userprofileinfo in $info – the following code will work fine, but will print out the 20th out as an empty div, which ..
Category : php
Due to the number of tickets I have ordered, I am currently trying to save a PDF button with a download link. This download link requires the OrderID for every order. The only problem is, I want several PDF download buttons to be issued if several tickets have been ordered. My approach looks like this: ..
All the best, I’m a little LOL😂. I am only learning laravel and cannot understand how this code can be optimized $items = DB::table(‘menu_items as i’) ->selectRaw(‘i.*, COUNT(childs.id) as childs_count’) ->leftJoin(‘menu_items as childs’, function($join) { $join->on(DB::raw(‘childs.parent_id’), ‘=’, DB::raw(‘i.id’)) ->whereRaw(‘childs.is_enabled = 1’); }); if($menu_id !== false){ $items->where(‘i.menu_id’, $menu_id); } if ($parent_id !== false){ $items->where(‘i.parent_id’, $parent_id); } ..
I’m not sure with the title, sorry for that. I have a condition which checks if account is present and if not add the amount to the next account. user-1 – present user-2 – not present user-3 – present user-4 – not present user-5 – present Each user has a corresponding amount to receive, but ..
In my PHP webapp I use OneDrive login to allow users to read and only read files. I use to URL scope params: files.read.all offline_access in the authorize endpoint call: https://login.microsoftonline.com/common/oauth2/v2.0/authorize My code is based on this source: https://docs.microsoft.com/en-us/onedrive/developer/rest-api/getting-started/graph-oauth?view=odsp-graph-online However, during the login process, the OneDrive dialog from Microsoft shows the user that my app ..
I have a problem connecting Laravel to a MySQL database. The project is not inside a docker/homestead virtual box, it’s directly on my PC running Windows 10 (sadly). The .env file looks like that: DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=simac DB_USERNAME=root DB_PASSWORD= When I try to run the migrations with artisan migrate I get the following: simacvendorlaravelframeworksrcIlluminateDatabaseConnectorsConnector.php:70 ..
I’m writing a code that takes the top 10 rows from an SQL Table and shows them first in a table, and then plots a marker for each on the same GMaps (each row has latitude and longitude info). I’m able to get the table part (display top 10 rows working), but I’m having a ..
I have a following problem to solve and looking for best solution for it. I do have a table called person and I do have table language. Between these two tables there is ManyToMany relation. Right now I would like to have possibility to use fulltext benefits (MATCH AGAINST) and give the user possibility of ..
Here’s my code: $terminosBuscados = ‘Vender la porteria’ $x = $conectarDB->prepare(" SELECT DISTINCT titulo, FROM_UNIXTIME(fecha, ‘%d-%m-%Y’) AS fecha, cuerpo, tipoContenido, autor FROM searchIndex WHERE match(titulo) AGAINST (‘ ? ‘ IN BOOLEAN MODE) ORDER BY contenidoID DESC "); $x->bindParam(1, $terminosBuscados); $x->execute(); $y = $x->fetchAll(PDO::FETCH_ASSOC); This is showing no results at all ($y returns null), when trying ..
WordPress website is set on localhost via xampp. I’ve made contact form but I’m not recieving emails from it. I have installed WP mail SMTP plugin and changed the mailer to "other SMTP" with TLS encryption, port 587, SMTP host: smtp.gmail.com and Gmail username and password. After sending test email it displays: "There was a ..