Posts by slydor37 • 1 point
5 posts
-
0
votes2
answers277
viewsA: Change mysql timestamp field via php
changed the field in Mysql from TIMESTAMP() to date type. php was making a mistake in $_POST because I do not enter any date in the form. was like this: Else { $datetime = time(); $sql = "UPDATE…
-
0
votes2
answers277
viewsQ: Change mysql timestamp field via php
I have the following database: CREATE TABLE Perdidos` ( `idPerdidos` INT UNSIGNED NOT NULL AUTO_INCREMENT, `dataEncontrado` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `descricao` VARCHAR(45) NOT…
-
0
votes1
answer54
viewsQ: PHP Mysql Search result
Good afternoon I’ve been trying to fix this for two days without success and I’d like your personal help :) The tables are as follows:: Chaves` ( idChaves int(10) AUTO_INCREMENT, nomeChave varchar,…
-
0
votes1
answer208
viewsQ: Insertion in Mysql via PHP foreign key
I am creating a PHP and mysql application to manage people outside my company. The logic is this already inserted the Companies that I will associate to each entity People but when trying to insert…
-
0
votes1
answer62
viewsQ: External employee registration Validation mysql php
I want to register external employees in a mysql database using php. Each employee has to have in his possession an access credential where it appears: Company, Validity of credential, validity of…