I’m using a free hosting solution for my MySQL database. However, when I try to connect to it through my PHP code it throws me a uncaught PDOException error and my access is denied. I can’t seem to find why the connection is denied as my credentials are correct. I’m using Ionic 2 framework, …
Tag: php
How to compare time in mysql
I have a column of Time data type in mysql. I want to compare the time with a time string but don’t know how to compare it. e.g., I want to know that some specific time is greater than 10:30:00. How …
php add a counter in while loop and return to a new line when i reach this counter
this is my code: now this code works fine, but it echo my results on the same line since its a loop. i want my output to be 3 photos per line for example: image1 image2 image3 (jumps to line) image4 image5 image6 and not: image1 image2 image3 image4 image5 image6. To be more precise i want to add a
SQL database value to variable
So, I am kinda new to php and mysql, but I have found a login form and adapted it to my needs as I dont have the knowledge to make one my self yet. I added a firstname and surname column into the database and the register form adds the values into the database fine. Now I want to be
About set id=1 and password = ‘ ‘ in the SQL injection [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 5 years ago. Improve this question Here is certain expert’s code: https://github.com/DalerAsrorov/Security-Flaws-And-Thei…
Display contact database by all categories it is marked, then alphabetical order
I’m trying to build a Vendor Contact Database with categories. Various vendors are marked under more than one category. I have structured my table as the following: My Current Code This is just a basic idea. My contact database has more fields including phone number, email, etc. Seeing how our category …
php How to link comment sql to the blog sql
first time here and I hope you guys can help me further. I have created a blogging system to use by mine employees via an admin login system. As well a login system and registration system to use by my customers/viewers. So now I created a comment section for the blog system where people can commenting. The p…
Propel adds CROSS JOIN to query when using an alias to JOIN tables
Trying to do a fairly simple query in Propel 2. I have a Person table and a Possession table – persons can have many possessions but only one of each possession type. So a person can have 1 book, 1 car, etc. I’m trying to write a query in Propel that will return all persons along with their car na…
Laravel using where clause on a withCount method
I am trying to do a where clause on withCount method of laravel’s eloquent query builder using this piece of code. and this code is giving me this error. SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘upvotes_count’ in ‘where clause’ (SQL: select , (select count() from u…
Can I fetch multiple different SQL statements in one times loop? in PHP
I have to query SQL-SERVER’s Query and MYSQL’s Query (That have the same result format but it’s difference database) , But I want to call them in one while loop in PHP, Can I do that? Ex. EDITED : I just have an solved answer. It’s work for me Idea from @Drew while(bContinue) this my c…