I have the credentials username, phonunmber, password and device serial number saved in my phpmyadmin database. I want to input the username, phonunmber and password and if all of them matches with device serial number in the databse, then the user can log in. How can i do that? P.S device serial number is sa…
Tag: mysql
$_SESSION problem – I have same ID on all
I don’t know, how I do this: I want to add $id from database to $_SESSION[“dbID”] and after click, it shows me more information from database. But table generates in while function and $_SESSION[“dbID”] every time set to the highest number of row from table. Please, Can you anyone chan…
Why can’t I export MySQL table values as a CSV file in this Codeigniter application?
I have been developing a blogging application with CodeIgniter 3.1.8 and Twig. The application has a newsletter subscription system. I make use of a table named newsletter with 3 columns: id, email and subscription_date. In the class Subscribers controller, I have created an export() method intend to export s…
Can’t get a list of streets to create a card [closed]
public function create() { $streets = street::get(); return view(‘dashboard.house.created’); } public function store(Request $request) { $this->validate($request, [ …
Add the results from a PHP array into a SQL Select for each Result to be procesed
I am a newbie so I want to know if what I am asking is possible. I have a SQl Select query that returns a While loop and I convert the results (peoples names)to a php Array. In a another SQL Query …
Compare and trim binary/unicoded string to normal string?
I am using below mysql query to check which records vary from the trimmed value Above query returns binary value and trimmed value as shown below. Result of mysql query: Highlighted values in above image show that binary value vary from trimmed value. I tried below 2 things: calculating length of both binary …
i cannot change and how to open /etc/my.cnf
I’m new to laravel I’d like to change utf8 from the others but I don’t know why i was not able to open the file and change. please help. Answer You need to add a space between the vi command you are trying execute and the file path you are passing to it.
How to use CakePHP ORM to query belongsToMany relationship
I am working on a custom query builder piece of code that supports a CakePHP 3 based API. I recently got a request to make it search against a Task item for associated Users. The association from a Task to users is a belongsToMany, which has not been supported in the custom query functionality up to this poin…
From database via join to REST how does it work?
I have a database with two tables (orders & orderProducts) with 1:n-Relation. I would like to combine this two tables to give a JSON to my REST-Tool. For this I have the following SQL-Query: $…
shopping cart with PHP and connected to the MySQL
Good evening, I am currently working on the implementation of a shopping cart through PHP and MySQL, I am getting the following error at line 172 onwards, I have been looking at the quotes but I cannot find the problem, what could be the solution to this? I have been changing this cart from a mysqli version o…