I am trying to create a table in a database in phpMyAdmin and I keep getting the “a symbol name was expected” error and I cannot figure out what is going on. Is my syntax wrong? I am new to this and I’m at a loss. Answer Column names, table names should be surrounded by backticks(“) Or…
Tag: php
Pull values from string to assign into an array
I’ve got a project where I’m pulling data from SOQL using salesforce’s RestAPI. I’ve cleaned up the response and this is what I’m currently working with: I’m working in PHP and I’d like to build an array based off this data. For example: Anyone have suggestions for th…
Display sum of item quantity in PDF export
I’m having issues displaying total quantity of all items at the bottom of my PDF export script I’m using with my WordPress site. I’ve been able to display total quantity of each item using Then I want to calculate the sum of all item quantities and show that as a single figure at the bottom …
How can i reformat array this array?
So i have this database table From that table i want to achievie this (My Expected result) I don’t know the best way to handle this, so for now i create two query. My first query SELECT * FROM ( …
How to generate a number pattern with given start and end value?
How can i generate a number pattern like this using php? a. Start = 1, End = 3 123 231 312 b. Start = 2 , End = 7 234567 345672 456723 567234 672345 723456 UPDATE: I tried this code: and get this output: But how to show the rest numbers? Answer you can try this algorithm:
How do I convert this mysqli array statment into a mysqli prepared statement?
How do I rewrite this mysqli statement into a prepared statement? I tried converting the code provided below into the prepared statement. But, only the first row of values get inserted not the rest. I am trying to integrate dynamic text fields into my form. So, user can easily add or remove input fields. Orig…
Trigger PDF Download PHP – Laravel 7
I have a simple report page, and I am using Laravel 7 to build it. I want to trigger auto-download a PDF with that view. What would be the most lightweights I should look into? I did a quick Google, and I saw so many options. I decided to try this and did all the steps, below is my final
Searching by name and date between codeigniter 4
Hello everyone I’m creating report through the fetched data, I created search based on category, amount and date between. But the problem is that, If I entered category and trigger the search button I get the data, And If I set the dates between to range it aslo returning the data. But if I set both cat…
How to dynamically set a parent table when accessing a collection?
I’m trying to fetch data from dynamically different tables depending on which user is logged on and if he is allowed to edit said table, what I thought was going to work was this: And it outputs an error on the last bit of code saying “Trying to get property ‘id’ of non-object” I…
Laravel : Fetch contact form data into notification facade mail
Just made a contact me form on my website and I would like to send an email to the website’s admin when someone sends a message. I’m using the Notification Façade in Laravel to do so, I managed to send the email but I can’t fetch the contact form’s data in the mail. How can I achieve t…