guys. Can somebody please help how to do that script goes through MySQL database every row and creates specific QR code to every row and stores that in database?
I am creating small online store and I would like to have QR code next to items. Here are good example how I would like to get things done: http://www.basethings.com/p4030/Anti-Doze-Off-Device-For-Drivers/product_info.html
Any help is more than welcome.
Set up a PHP function to read, create, and store your items as a QR image. There are open source generators out there you can use, like this one: http://phpqrcode.sourceforge.net/
Edit: If you're really new at PHP/Databases, you'll also need to look into PDO and at the very least, foreach or while loops to automate the process. If you're new to SQL, that too. It's hard to gauge what you do and do not know about programming since you didn't provide any code.
Edit #2: This question contains code like I would have expected to see with your question. It should give you a basic idea of the format.
To paraphrase that question for your purposes:
function getContent() {
$db = PDOconn();
$query = "SELECT * FROM yourtable";
$sql = $db->prepare($query);
$sql->execute();
$row = $sql->fetchAll();
return $row;
}
function setQR($id,$code) {
$db = PDOconn();
$query = "UPDATE yourtable SET qr WHERE id=:$id";
$sql = $db->prepare($query);
$sql->execute();
echo "QR created for item $id <br> \n";
}
$data = getContent(); //you're storing the DB array
foreach($data as $row)
$id = $row['ID'];
//your URL or whatever to be a QR
$content = $row['Column'];
//create QR using generator
$code = insert_code_here($content);
//add the new row to the database
setQR($id,$code); #similar to 1st function, but setting and passing parameters
}
