Questions tagged as 'mysqli'

Tagged questions
2
answers

PHP Catchable fatal error: Object of class mysqli could not be converted to string

I'm starting in PHP, and I think my code is missing something so that it can work, because the error that I mentioned occurs. The code of my mysqlcon.php is: <?php session_start(); $host=; $username=; $password= ; $db_name=; $link=mysqli...
asked by 26.04.2018 / 02:29
1
answer

how to insert the value of a select into multiple columns of a table in MYSQL PHP

good day, I hope you can support me with this query, How can I insert the value of a select (combobox) php in multiple columns in a table in mysql depending on the selected data? . For example I have this form linked to nested combobox with...
asked by 14.05.2018 / 17:41
1
answer

Know time difference in mysql query

I have a table in mysql to see the wrong accesses of a login. If there are 3 records in less than 60 minutes I want to be able to block access to the ip address that you are trying to enter. In the database I keep 2 fields: ip: varchar format ho...
asked by 08.04.2018 / 21:13
1
answer

error when querying in mysql from php Warning: mysqli_fetch_array () expects parameter 1 to be mysqli_result, boolean given in

When trying to make a query in mysql from php to start a session I get the following error: Warning: mysqli_fetch_array () expects parameter 1 to be mysqli_result, boolean given in C: \ xampp \ htdocs \ procesologin.php on line 10 after the quer...
asked by 27.03.2018 / 08:29
1
answer

I do not understand the operation $ sql-bind_param

I would like to understand this little code. Which I see, avoid SQL-Injection They could correct me and add information. Sorry if I mention failures <?php $mysqli = new mysqli("localhost", "root", "", "bdpersona"); $sql = $mysqli-&...
asked by 21.03.2018 / 16:42
1
answer

Do not insert all my records (type Time) in PHP AND MYSQL

I make a form which is a schedule for workers, which contains shifts, time of entry, time of departure and day for the assignment. The problem I have is that I insert the shift and the day in my BD but the time of entry and exit in my BD...
asked by 23.02.2018 / 05:51
1
answer

How can you get the number of matches in a mysql query with left join?

I have in a database a table where the logins of each user are registered, and another where I store the modifications that the same user makes in the system. If the user does not make any changes to the system, nothing will be saved in the tab...
asked by 23.02.2018 / 19:45
2
answers

Problem with LAST_INSERT_ID

I am trying to get the next number in a column called TARIMA , the problem is that% is not% co_ since it is apart from autoincremento general ID , try to use AI to get the next lastinsertid of the table but it do...
asked by 23.02.2018 / 10:13
2
answers

How can I know if the table exists

The problem is that I do not know how I can check that logeo. I currently do a query directly to a table, when there is perfect nothing happens, it shows me the information. when it does not exist it throws me the following error: Unexpected '...
asked by 13.02.2018 / 00:12
2
answers

Visitor / user permissions

Generate the following comparison : <?php if($_SESSION['id_nivel'] == 1 || 2){ ?> <div class="col-md-6"> <select name="cantidad" class="form-control"> <option class="form-control...
asked by 01.02.2018 / 15:58