msbatal / php-pdo-database-class

PHP PDO database class that utilizes PDO and prepared statements (MySQL, MariaDB, MSSQL, SQLite, etc)

Hi 👋, I'm Mehmet Selcuk Batal!

Founder of Naature Technology and Sunhill Int'l Holding, Author and Instructor

• 🔭 I’m currently working on Recruss, Memjoo, Bomansy, Onducera, Lambda, Certifigate, Verifigate, Tawcu and Pellup projects

• 📝 I regularly write articles on my personal web page

• 💬 You can ask me about JavaScript, PHP, C#, and Python

• 📄 Know about my experiences via my LinkedIn page

• 📫 Don't hesitate to touch with me on [email protected]
  
  
  

Connect with me:

Languages and Tools:

php-pdo-database-class's Issues

no join functions

LEFT JOIN, INNER JOIN etc. no functions. Your class is very good, just what I was looking for, thank you for your efforts.

Group by question

This is my query

$select = $db->select('sales_tbl', ['sum(total) as total', 'count(*) as count', 'hour(createdAt) as label'])
->where('createdAt', 'DATE_SUB(CURDATE(), INTERVAL 24 HOUR', '>=')
->groupBy('createdAt')
->run();

I need to group by HOUR('createdAt') but it seems not possible?

New SQL Code

Hello, how can I run the following SQL code?

SELECT sum(((u.alisfiyati/b.oran)*(m.cikismiktari))) as maliyetim FROM menuler v, urunler u, menuicerikleri m, birimler b where u.id=m.urunid and u.birim=b.id and v.id=m.menuid and v.id=7