I am working on a photography project and I am facing a bit issue with joining tables and retrieving data from mysql database. I have created two tables for this project. One table named cm_team is for team members and another table named cm_events for photography events..Assume to shoot a event, we require 6…
Tag: mysql
Trying to upload files to a folder and to the database
I am trying to upload files to a given folder and to the database using PHP. Files are uploading to the folder successfully but don’t update the database. I can’t find the issue of that. Please help me to solve the problem. ?> This is a screenshot of the table that I am trying to update. screen…
Merge rows of item column having the same date column and display items in single row in PHP
I’m making an online shopping cart website and the customer must view all his/her orders in a table with all the order information like item names, price, date ordered, etc. And I want to group each order by date and display the items with same date in one row. My table looks like this: Orders Date Orde…
PHP MySQL Selecting Multiple Tables Based on Column/Row Value
I am just doing some testing with a few tables that I’m trying to relate together, based on the values of my ‘students’ table. Here are the total tables that I have: students TABLE id, name, course_num, msg_num biology TABLE id, details, msg_num chemistry TABLE id, details, msg_num physics T…
count multiple values in multiple column PHP
i want to count multiple values from 3 columns and sorted descending using PHP mysqli, and I can’t do it. name1 name2 name3 mike jack rose jack mike Mary jack Mary John expect output: My code: Answer Use UNION to get them all into a single column. Then use COUNT(*) and GROUP BY:
Sorting array in alphabetical order in php
I have a set of data in DB and I am sending it to my Android App using an API function. I have written this in PHP. I want to sort JSON array in alphabetical order and then send it in JSON array format. Here is the code I have, I am not sure how or where to sort this
Laravel – query to join tables in Many to many relation
I have the below tables posts – id – name categories – id – name category_post – post_id – category_id Post.php Category.php A post may contain many categories. I want to query all posts related to the categories of any given post in the least number of database queries. Fo…
Search result from other pages
I created a table that displays the values from the my mysql table. Then, using the tutorial, I created pagination system. Top of page: Bottom of page: Then I created a search engine (input) with onkeyup=”myFunction()” and MyFunction looks: My problem appears when I try to search for something &…
Fetch data from one table and compare with another one basic on contain values
I got 2 different databases and 2 tables Here’s Table.1: and there’s Table.2 but the users ask for all items separately according searching the ranking.values using Table.2 and compare with Table.1 How can I use Sql command having the result when something like : login as user2 so I would get but …
Laravel multiple foreign keys get specific value using querybuilder
I have a table of contracts and here is the example data And i got another table of spec and the values are how can i get the text from spec table? do i need to multiple join them? what I want is something like im selecting from contracts table I tried but its wrong and got some errors. Thanks