Questions tagged as 'mysqli'

Tagged questions
2
answers

results from mysql_query php use it in another query mysql_query

I'm trying to do 2 PHP queries ... basically it would be the first one: $sql = \mysql_query("SELECT * FROM tblaccounts WHERE date BETWEEN '2015-12-25 0:00:00' AND '2016-07-20 23:59:00'"); the results of this query I need to be able to us...
asked by 10.09.2016 / 11:21
6
answers

Change the input date format

I would like to know how to change the format of a date type input I have this input showing dd-mm-yyyy <p>Fecha <input type="date" name="fecha" required></p> But at the time of registering with php in my dat...
asked by 22.03.2018 / 16:22
1
answer

web service security with php, mysql, xml

I am trying to do a SOAP web service with security but I can not establish a good security here I have the example of what I do: public function Seguridad($variablesSeguridad){ $usuario='pagosyre'; $password='ladrones';...
asked by 01.02.2018 / 17:31
2
answers

Show only requested data in php and mysql

I have a database with a table called cantantes , with the structures: - nombre, - canciones, - no-albunes, - edad But I want that on the page katy-perry.php only show me the data of the singer. That tell me the ins...
asked by 24.06.2017 / 03:07
2
answers

How to limit the sum of records to a column up to an X value? [closed]

I have two tables: Customers : Save customer data, such as: ID, Name, Points . Sales : Registers the sales made by each customer, like: Customer_ID, Service ( 10 minutes for example ), among others. I would like to see that in th...
asked by 26.03.2017 / 13:09
2
answers

Error when validating user in a BD in a PHP + MySQL login

I am currently running a student administration system for a higher education institution. Previously, I used DreamWeaver CS6 for school projects and used the MySQL API to make connections to the DB's. However, this time I'm looking for more sec...
asked by 11.07.2017 / 06:51
2
answers

Differentiates or benefits of connecting to a class based on data

Today I come with a very basic question about connection to data base since I do not have some clear concepts and would like to know what is the difference or benefit of connecting to the database using a class or normally. That is, what woul...
asked by 06.09.2018 / 20:16
1
answer

Problem Database

Good! I need you to help me know how to upload correctly or what to do with this problem in my database: I uploaded my website to the host of 000webhost.com and everything goes well in fact I leave the link of my page: My website The problem i...
asked by 10.09.2017 / 20:56
2
answers

how can I do a do while php [closed]

I need some support on php side I'm up to mysqli since xampp no longer supports mysql now supports MARIADB and needed to update do and the while . Code: <?php do{?> } while ($row_DatosPost = mysql_fetch_as...
asked by 25.07.2017 / 17:39
1
answer

I want to DELETE a selected item while

I have a cart system on my website, I have no problem to insert the products in it, to add their prices, the problem arises when I want to delete the products. I do not want to empty the entire cart, I want each product to have its button to del...
asked by 29.11.2018 / 14:03