python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - mysqli

Update db with hashed pw using the password_hash and password_verify

I am just a little confused as to where I can fit it in this file. The file is for pw validation currently but I would like the pw to be hashed using password_hash. That being said I understand how pa...
test-img

Liam Arscott B

php

mysqli

Votes: 0

Answers: 1

Latest Answer

You need to write a single, separate script to run one time to update all the plaintext passwords to those generated by password_hash(). Something like: // FOR UPDATE locks the rows $res = $dbh->qu...
test-img

Sammitch

Fast way to find out if one value of one column exists in the same table with 2 or 3 other values

I have 3 tables. One for products, one for tags and one for products-tags-associations. The tags have different levels and work like categories and subcategories, but the tags are not associated direc...
test-img

Suzanne Edelman

php

mysql

sql

mysqli

mariadb

Votes: 0

Answers: 1

Latest Answer

SELECT product_id, COUNT(*) AS ct FROM table GROUP BY product_id Then, ct tells you how many times each product_id shows up in the table. Tacking on HAVING ct > 1 to list just the product...
test-img

Rick James

PHP MySQL prepared statement: procedural Insert / update example

I struggle to understand prepared statements in PHP to allow users to edit a MySQL-database. The user input is UTF-8, typical examples are the name in Arabic, Chinese, ... It also generates a problem ...
test-img

Juergen

php

mysql

mysqli

prepared-statement

on-duplicate-key

Votes: 0

Answers: 1

Latest Answer

If I understood correctly, you want to make a mysql prepared query? (I apologize if I misunderstood the problem) But here my solution and explanation. First : $stmt = mysqli_prepare($link, "INSE...
test-img

TheHuman

Unable to run mysqli_result

$user_id = mysqli_result($query_result, 0, student_id’); I want to bring the student_id from the database for the student that logged in
test-img

Demola

php

mysql

mysqli

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs