Questions tagged as 'pdo'

2
answers

Search by date php pdo

I need to search the database using the DtBase column, for example: on day 26 I populated the table with several information, on day 28 I want to see what I did on day 26. I want an input date or another method that it is more feasible for me...
asked by 26.01.2016 / 16:34
2
answers

I can not call user information [closed]

User.php <?php class User { public static $Row = []; public static function Check() { global $PDO; $usersql = $PDO->prepare("SELECT * FROM users WHERE username = :username AND password = :p...
asked by 29.09.2015 / 15:29
1
answer

Display Image Within Another

Galera So I have this image of card and I need to display another image on the photo of the person, I was able to insert the wanted data of the bank but the photo of the person I can not get from the bank and display on top of that card image...
asked by 13.10.2015 / 20:20
2
answers

PECL / PHP PDO_OCI extension obsolete. How to proceed?

I need to install the pdo_oci PHP extension to work with Oracle database via PDO. However, I noticed that the extension available via PECL is deprecated and will no longer be maintained. As I understand this link (I do not know if I under...
asked by 27.06.2015 / 19:37
1
answer

How PDO :: PARAM_STR parameter works in PHP + PDO

Example: $sth->bindValue(':calories', $calories, PDO::PARAM_INT); PDO::PARAM_INT Is this parameter a kind of validation for data type? If so, why not give me an error when I pass an integer?     
asked by 11.06.2015 / 22:00
1
answer

Problem with select dynamic to show dropdown menu for user

I am building the visualization layer for the clients of a system in my database I have two tables with relationships: Ihaveamethodtoreturntheresultsofthesetables:publicfunctiondropDownCategoria(){$consulta=PDOUtil::getStance()->prepare("SELE...
asked by 14.06.2015 / 20:38
2
answers

Mysql automatically change data [closed]

Good afternoon, I wanted to implement a system that would cause my database to automatically change the value of one of the fields of an element when the expiration date field was higher than the current system date. I've already tried to implem...
asked by 12.05.2015 / 15:14
1
answer

PHP PDO does not run UPDATE on same page of SELECT

Problem: making UPDATE work Question: Is the script correct? Request: Identify the reason for not doing the UPDATE and generating error. Error: Notice: Undefined variable: db e Fatal error: Call to a member function prepare () on a non-object...
asked by 24.03.2015 / 15:10
4
answers

MySQLi vs PDO - Which is the most recommended to use?

With mysql_* entering the deprecated state, the PHP documentation recommends using the PDO and MySQLi. Which do you recommend for use? PDO seems to be more suitable for working with object-oriented only than at the same time I saw...
asked by 06.03.2014 / 18:10
1
answer

Query between Mysql dates showing every day of the range

Hello, I would like help with logic. I have an ecommerce system in which N products are sold and I am comparing the sales of a certain product per period of time, ie the admin will have an area in which he chooses a product and a date range (...
asked by 27.04.2018 / 03:37