Tag: mysql

How to match input credentials with database credentials without typing them in laravel 8?

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 saved only in the database. I

$_SESSION problem – I have same ID on all

html mysql php session tr

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 change my code as I have $_SESSION[“dbID”] on every <tr> of

Why can’t I export MySQL table values as a CSV file in this Codeigniter application?

codeigniter codeigniter-3 mysql php

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 subscribers as a CSV file: In the Newsletter_model model: The export form:

Can’t get a list of streets to create a card [closed]

eloquent laravel mysql php

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

arrays mysql php

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?

binary mysql php regex trim

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 and trimmed column but it is same

i cannot change and how to open /etc/my.cnf

laravel mysql php

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

associations cakephp cakephp-4.x mysql php

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 point. The relationship

From database via join to REST how does it work?

arrays mariadb mysql php

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

mysql pdo php sql

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 of it into