My table: +———-+———————+ | bonus_id | created | +———-+———————+ | 11 | 2020-04-28 19:50:13 | | 12 | 2020-04-29 00:00:00 | | …
Tag: php
Select count(column) from table of mysql in php
I have a database and I am trying to make a website and connect it to my database. I am trying to count the number of instances in a column but I am having trouble. I have this so far: Answer I hope you have the connection done. Here something is column which you are using to filter the output
SQL SUM values in declared column into total and group by id
Hello people of the internet. Once again I seek your advice. I have multiple meter readers collecting power consumption every 5 minutes and storing to MS SQL Database. I execute SQL query to get a days worth of data from all meter readers and check how much power it has used every five minutes and returning a…
how to successfully add a foreign key constraint to your Database table in laravel using eloquent?
I have a database containing two Tables(students, payments) with id as primary key and another column studentID within the students Table. Am making studentID a foreign key in payments Table. I am getting this error message: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column ‘studentID&#…
How to get the SUM of 3 individual columns in codeigniter
I am trying to get the SUM of 3 individual columns. When I try to output I get nothing. What do I do wrong? Model Controller View Answer $this->db->select() accepts an optional second parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table names. This is useful if you …
Cron job to update row after 5 days
I’m having difficulty to make a cron job on cpanel to update the state of an user if the account has been created for 5 days. It just doesn’t work at all. When I program the cron job on the cpanel it …
MSSQL, PDO, error when inserting XML string: General error: 102 Incorrect syntax near ‘<?xml version="1.0"
I am trying to insert XML string into a MSSQL database from PHP. I get: SQLSTATE[HY000]: General error: 102 Incorrect syntax near ‘ (a chunk of the xml follows). The prepared statement is: The $xml is a valid XML string. The same XML can be inserted OK using an identical statement in an SQL client app (…
Checking for an overlap and if values are already taken
I’m trying to write an SQL query that must check if an overlap between two hours exists and if certain values are already selected or not. For example, you have a record in a table and you need to …
(PHP,MySQL) Adding information from an SQL table to a PHP web page table which has same field id
My English is not so well and I am new with php. So, maybe you can be bored with my question. I am really sorry for that. Here’s the Question: I have a table created in SQL database like this: – ID Name PICTURE – 1 John john.jpg – 1 dora h.jpg – 1 Dane hkjpg – 2 Mougli f.jp…
What is correct format for on duplicate key update sql query ? Looks like typo mistake or something missing
I need to make on duplicate key update query, looks there is something missing in my query. This query works fine with # in values I need to add ON DUPLICATE KEY UPDATE. This query works fine with on duplicate update but I need to add # in values to make it SQL injection safe. I am trying this with