I want to see the number of rows in a table in SQL server
my sentence is:
$result12 = sqlsrv_num_rows($conn, "SELECT asistencia FROM asistencia");
but you are not giving me any results when trying to show it in php, taking 100 results in m...
Friends, you could guide me with this problem that I have, I am receiving an array, but when I want to update the data to my base it throws me the following error:
Attempt to assign property 'stock' of non-object
My code is as follows:...
I have the following code where I get the MAX of a code, but this code is a String . To this MAX I separate it in two to get the first 3 initials that are letters and in the numbers to add 1 to the numbers.
$query = "S...
Maybe what I'm asking is something very obvious, but as I'm learning I prefer to consult. When I have a form with all the complete data and send me an error message, the input fields bring back the written data to not write it again, but in the...
Good day, I'm working with laravel and bootstrap, right now I'm more focused on the design, the problem is that when creating the modal I see two white lines as if it were a margin, is there any way to remove them?
Code
<div cla...
I need to consult the following id where the following is fulfilled:
Values entered by the user from 1 to 5 (people per room), and I have to obtain the id's of the hotels where it is true that there is a place, for example;
ROOM-1 : 2 PAS...
$qry = "select
CONVERT(VARCHAR(20),fechaSalida,108) AS fechaSalida,
CONVERT(VARCHAR(20),fechaEntrada,108) AS fechaEntrada,
CAST(DATEDIFF(minute, fechaEntrada, fechaSalida)/60.0 as decimal (18,2)...
I'm trying to login and I'm using PDO. This is my code
Form
<form method="POST" action="ajax.php?mode=login" class="form-signin">
<h1 class="h3 mb-3 font-weight-normal">Iniciar Sesión</h1>
<label...
Hi, I would like to export php excel with sql server:
The error that is coming to me is this:
sqlsrv_query () expects parameter 1 to be resource, string given in
sqlsrv_fetch_array () expects parameter 1 to be resource, boolean given in...