|
if you need to read data (forward only), you can write code like
$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "id: " . $row["id"];
}
} else {
echo "0 results";
}
$conn->close();
you can look at the sample available here
Ashwin Shetty
|
|
|
|
|
Thanks Ashwin for giving me ideas. I really appreciate it. I have managed to fix it.Please see my code below for main program.
=====================================
$dbUser=DB::getInstance();
$dbUser->processQuery("SELECT * FROM users");
echo count($dbUser->getResultSet());
foreach($dbUser->getResultSet() as $rows){
echo $rows['username'];
}
|
|
|
|
|
You are using fetch() which will not return anything but the first row.
Try return $this->rowResult=$q->fetchAll();
That will then return an array of the rows into $users which I think is what you were expecting.
|
|
|
|
|
Buenas el caso es este:
[IMG]https:
code:[url]http:
[code]package practica;
public class adivinar2 {
public static void main(String[] args) {
int numeroAdivinar;
int numeroComparar;
short contador;
int cifrasAdivinar= 0;
int bandera=0;
int nDesAdivinar;
int nDesComparar;
int digitoAdivinar;
int digitoComparar;
System.out.println("Introduzca el primer numero");
numeroAdivinar=Leer.datoInt();
for ( contador=1 ; contador<=10; contador++){
System.out.println("Introduzca el segundo numero");
numeroComparar=Leer.datoInt();
if(numeroAdivinar==numeroComparar){
contador=10;
bandera=1;
}else{
nDesAdivinar=numeroAdivinar;
nDesComparar=numeroComparar;
while( nDesAdivinar!=0){
nDesAdivinar = nDesAdivinar/10;
digitoAdivinar= nDesAdivinar%10;
nDesComparar = nDesComparar/10;
digitoComparar=nDesComparar%10;
if(digitoAdivinar==digitoComparar){
cifrasAdivinar=cifrasAdivinar+1;
}
}cifrasAdivinar=cifrasAdivinar-1;
System.out.println("Has introducido un total de: "+cifrasAdivinar+" dígitos");
}
}
if(bandera==1){
System.out.println("Has acertado todas las cifras");
}else{
System.out.println("Se te acabaron las oportunidades");
}
}
}
[/code]
prblema:[spoiler][code]Introduzca el primer numero123
Introduzca el segundo numero
153
Has introducido un total de: 2 dígitos
Introduzca el segundo numero
223
Has introducido un total de: 2 dígitos
Introduzca el segundo numero
555
Has introducido un total de: 2 dígitos
Introduzca el segundo numero
153
Has introducido un total de: 2 dígitos
Introduzca el segundo numero
123
Has acertado todas las cifras
[/code][/spoiler]
Parece que cuando vuelve a partir de la segunda vez, ya se desloquece
[spoiler][code]
Introduzca el primer numero
123456789
Introduzca el segundo numero
123456779
Has introducido un total de: 8 dígitos
Introduzca el segundo numero
123456779
Has introducido un total de: 8 dígitos
Introduzca el segundo numero
123456669
Has introducido un total de: 8 dígitos
Introduzca el segundo numero
123466669
Has introducido un total de: 8 dígitos
Introduzca el segundo numero[/code][/spoiler]
|
|
|
|
|
All you have to do is put a breakpoint and watch and see what is happening. You'll have it fixed in no time.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Buenas el caso es este:
[IMG]https:
code:[url]http:
[code]package practica;
public class adivinar2 {
public static void main(String[] args) {
int numeroAdivinar;
int numeroComparar;
short contador;
int cifrasAdivinar= 0;
int bandera=0;
int nDesAdivinar;
int nDesComparar;
int digitoAdivinar;
int digitoComparar;
System.out.println("Introduzca el primer numero");
numeroAdivinar=Leer.datoInt();
for ( contador=1 ; contador<=10; contador++){
System.out.println("Introduzca el segundo numero");
numeroComparar=Leer.datoInt();
if(numeroAdivinar==numeroComparar){
contador=10;
bandera=1;
}else{
nDesAdivinar=numeroAdivinar;
nDesComparar=numeroComparar;
while( nDesAdivinar!=0){
nDesAdivinar = nDesAdivinar/10;
digitoAdivinar= nDesAdivinar%10;
nDesComparar = nDesComparar/10;
digitoComparar=nDesComparar%10;
if(digitoAdivinar==digitoComparar){
cifrasAdivinar=cifrasAdivinar+1;
}
}cifrasAdivinar=cifrasAdivinar-1;
System.out.println("Has introducido un total de: "+cifrasAdivinar+" dígitos");
}
}
if(bandera==1){
System.out.println("Has acertado todas las cifras");
}else{
System.out.println("Se te acabaron las oportunidades");
}
}
}
[/code]
prblema:[spoiler][code]Introduzca el primer numero123
Introduzca el segundo numero
153
Has introducido un total de: 2 dígitos
Introduzca el segundo numero
223
Has introducido un total de: 2 dígitos
Introduzca el segundo numero
555
Has introducido un total de: 2 dígitos
Introduzca el segundo numero
153
Has introducido un total de: 2 dígitos
Introduzca el segundo numero
123
Has acertado todas las cifras
[/code][/spoiler]
Parece que cuando vuelve a partir de la segunda vez, ya se desloquece
[spoiler][code]
Introduzca el primer numero
123456789
Introduzca el segundo numero
123456779
Has introducido un total de: 8 dígitos
Introduzca el segundo numero
123456779
Has introducido un total de: 8 dígitos
Introduzca el segundo numero
123456669
Has introducido un total de: 8 dígitos
Introduzca el segundo numero
123466669
Has introducido un total de: 8 dígitos
Introduzca el segundo numero[/code][/spoiler]
|
|
|
|
|
All you have to do is put a breakpoint and watch and see what is happening. You'll have it fixed in no time.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Hello
i'm trying to make a form to upload an image.
So i combined two events in one just to click only once an upload the file.
But when i click and choose the file, the tmp file is not uploaded.
here's my code, do you have an idea of why? Thank you in advance.
<form target='_self' action='upload.php' method='post' enctype='multipart/form-data'>
<div class = 'testocentrato'>
<input style='display:none' type='file' accept='.jpg' name='file' id='file'/>
<input style='display:none' type='submit' id='caricaimmagine' name='caricaimmagine' />
<input class='inputfile' type='button' value='Scegli file da PC' onclick='document.getElementById('file').click(); document.getElementById('caricaimmagine').click();' />
<input style='display:none' type='submit' />
<input class='inputfile' type='submit' name='eliminaimmagine' onclick='document.getElementById('eliminaimmagine').click();' value='".$lang['TASTO_ELIMINA_FOTO']."' />
<input type='hidden' name='id_utente' value='".$user['id']."' />
</form></div>
|
|
|
|
|
Well, a lot of it has to do with the fact that you're applying a synchronous methodology to an asynchronous construct. Event handlers do not block the main thread, they run in their own context.
That means that the form is being submit before any file is actually chosen.The better route is to use an event handler.
$('#file').change(function(){
$('#theForm').submit();
});
Then your HTML could look something like:
<form id="theForm" target='_self' action='upload.php' method='post' enctype='multipart/form-data'>
<input style='display:none' type='file' accept='.jpg' name='file' id='file'/>
<input type='hidden' name='id_utente' value='".$user['id']."' /><br />
<input type='button' value='Scegli file da PC' onClick="$('#file').trigger('click');" /><br />
</form>
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
HI, ok i understand the 2 asynchronous construct,
but the code you wrote is not working.
Maybe that i need to raise first event to choose the file and then the second event
(the button "upload image") is raised still before the load of image.
the change event is not working, it seems.
Thank you
|
|
|
|
|
I have a strange problem and i'm looking for solution a few days now.
this is my Tools :
- my own Webservice Configurator : create webservice with certificate on IIS
- my own client (WCF client) which consume this webservice
1.I create the wcf web service with certificate.
2.I run it on browser and show its wsdl (it is ok)
3.I try to open the channel to it but NOT WORKS
Up to now it seems a problem with my WCF Client 
BUT no, because when I do the First point (1) on other machine with same tool and try to do the 2 and 3 points , it works fine and the same WCFClient works with the service created on other server (other machine and other iis)
have you an idea about this please ?
Best Regards,
|
|
|
|
|
Permissions, firewalls, User Rights Assignments, missing DLLs....
If it works in one place and not in another, it's generally one of two things: configuration or runtime support
The Event Viewer is your friend. You can also drop some debug lines into your client to find your failure point.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
As I say the same WCF client works with the same webservice in other machine
But with the one created and hosted (which works on browser !!!! ) in my machine it not works and I have the Exception "EndpointNotFoundException"
|
|
|
|
|
Yeah....that's why I suggested that you have an environmental factor. Check the firewall.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
so, it seems to be resolved and it related to configuration of my IIS
Thank you for help 
|
|
|
|
|
I have a simple SignalR app that runs fine when self hosted or hosted in VS2015's IIS.
When I attempt to host it in full IIS I don't get very far. Here's my connect code:
public void Connect()
{
_connection = new HubConnection(ServerUri);
if (_enableDebugging)
{
_connection.TraceLevel = TraceLevels.All;
_connection.TraceWriter = Console.Out;
}
_hubProxy = _connection.CreateHubProxy(HUB_NAME);
_hubProxy.On<string>("EchoMessage", EchoMessage);
_hubProxy.On<AssayDashboardInfo>("ResultsAdded", ResultsAdded);
_hubProxy.On<AssayDashboardInfo>("ResultsChanged", ResultsChanged);
_connection.Error += _connection_Error;
_connection.StateChanged += _connection_StateChanged;
try
{
_connection.Start();
}
catch (Exception e)
{
_logger.Error("*** Connection failed", e);
}
}
I get no error messages or exceptions. What I DO get is some output in the Console Window:
23:57:41.8538683 - null - ChangeState(Disconnected, Connecting)
23:57:42.0208850 - null - Disconnected
23:57:42.0208850 - null - Transport.Dispose()
23:57:42.0218851 - null - Closed
Again, with no exception or error info I can only assume that it's not finding the hub. The _connection_StateChanged event is called twice - first with "Connecting" then immediately with "Disconnected." And that's as far as I get.
At this point I'm reaching out to see of anyone know what these messages mean or what I'm doing wrong.
Thanks
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Just a guess, but it is probably a permissions issue related to the account that is running your Application Pool in IIS. That is the account the code will execute as.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
But both VS2015's IIS Express and the full IIS are both running on my Dev PC under my account
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Kevin Marois wrote: VS2015's IIS Express
This runs as whatever account you are logged into the machine with.
Kevin Marois wrote: full IIS
You have to look at the application pool's identity.
If they truly are the same, then I'm not sure where to look next. Event logs?
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
The app is using the DefaultAppPool, and it's Identity is set to ApplicationPoolIdentity under Build-In Account.
How do I know what account VS's IIS is running under?
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Kevin Marois wrote: it's Identity is set to ApplicationPoolIdentity
Perhaps try an account that is a domain admin account or at least an admin on the machine. Your account that you log onto the machine with might work.
Kevin Marois wrote: How do I know what account VS's IIS is running under?
Because it runs under the context of VS, which is loaded as a UI app using your account.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
The only IIS logging I got was:
Software: Microsoft Internet Information Services 7.5
Version: 1.0
Date: 2017-01-06 16:58:50
Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status time-taken
2017-01-06 16:58:50 ::1 GET /signalr/negotiate - 5396 - ::1 SignalR.Client/1.0.0.0+(Microsoft+Windows+NT+6.1.7601+Service+Pack+1) 404 0 2 151
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Kevin Marois wrote: 404 0 2 151
That means Url not found. Are you sure you have it configured in IIS correctly?
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
RyanDev wrote: Are you sure you have it configured in IIS correctly?
No. That's been a real problem as there are no tutorials that I can find that ACTUALLY show a SignalR service being hosted in IIS. Google and other people point to this which shows how to CREATE an app that runs in IIS, but doesn't actually SHOW you how to host it in IIS.
One thing I did discover is that I was not Awaiting the Connect method nor the _connection.Start. Once I did that I now get an exception:
StatusCode: 404, ReasonPhrase: 'Not Found', Version: 1.1, Content: System.Net.Http.StreamContent, Headers:
{
Cache-Control: private
Date: Fri, 06 Jan 2017 17:46:14 GMT
Server: Microsoft-IIS/7.5
X-Powered-By: ASP.NET
Content-Length: 5265
Content-Type: text/html; charset=utf-8
}
Which is just as useless as the prior message.
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Kevin Marois wrote: 404, ReasonPhrase: 'Not Found'
Still tells me something is not configured right.
Kevin Marois wrote: there are no tutorials that I can find that ACTUALLY show a SignalR service being hosted in IIS.
This looks like it might be it, Hosting a SignalR application on Windows 2008r2 and IIS 7.5 – Timlee's Blog[^]
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
