PHP codes shows a warning while connecting to MySQL [duplicate]





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0
















This question already has an answer here:




  • mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result

    32 answers



  • Reference - What does this error mean in PHP?

    32 answers




i have written a piece of code in order to give access to my android app to connect to the MySQL database through PHP.
It works fine but log shows a warning says:




Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:xampphtdocsapp_login.php on line 7




this is my php for connecting the database (app_conn.php):



<?php

$db_name="score_test";

$mysql_username="root";

$mysql_password="PxyG8PPJFRGxAmhP";

$server_name="localhost";

$conn= mysqli_connect($server_name,$mysql_username,$mysql_password,$db_name);

if(mysqli_connect_errno()== false){

    echo "Done";

}

?>


and the login php (app_login.php):



<?php

require "app_conn.php";

$user_name = "test";

$user_pass="481";

$mysql_qry= "select * from score_test where C_USER like '$user_name' and C_SCORE like '$user_pass';";

$result = mysqli_query($conn , $mysql_qry);

if(mysqli_num_rows($result) == 0){

echo "Login Succesful";

}

else{

echo "Login Failed";

}

?>





php mysql mysqli







share|improve this question















marked as duplicate by FrankerZ, Masivuye Cokile, Jeto, Nick, RiggsFolly mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 23 '18 at 12:21


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • 2





    Your script is at risk for SQL Injection Attacks.

    – FrankerZ
    Nov 23 '18 at 12:16






  • 1





    @TobiasF. - The OP is only using mysqli_. It's only a few of their variables that's called $mysql_* which doesn't matter.

    – Magnus Eriksson
    Nov 23 '18 at 12:24


















0
















This question already has an answer here:




  • mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result

    32 answers



  • Reference - What does this error mean in PHP?

    32 answers




i have written a piece of code in order to give access to my android app to connect to the MySQL database through PHP.
It works fine but log shows a warning says:




Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:xampphtdocsapp_login.php on line 7




this is my php for connecting the database (app_conn.php):



<?php

$db_name="score_test";

$mysql_username="root";

$mysql_password="PxyG8PPJFRGxAmhP";

$server_name="localhost";

$conn= mysqli_connect($server_name,$mysql_username,$mysql_password,$db_name);

if(mysqli_connect_errno()== false){

    echo "Done";

}

?>


and the login php (app_login.php):



<?php

require "app_conn.php";

$user_name = "test";

$user_pass="481";

$mysql_qry= "select * from score_test where C_USER like '$user_name' and C_SCORE like '$user_pass';";

$result = mysqli_query($conn , $mysql_qry);

if(mysqli_num_rows($result) == 0){

echo "Login Succesful";

}

else{

echo "Login Failed";

}

?>





php mysql mysqli







share|improve this question















marked as duplicate by FrankerZ, Masivuye Cokile, Jeto, Nick, RiggsFolly mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 23 '18 at 12:21


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • 2





    Your script is at risk for SQL Injection Attacks.

    – FrankerZ
    Nov 23 '18 at 12:16






  • 1





    @TobiasF. - The OP is only using mysqli_. It's only a few of their variables that's called $mysql_* which doesn't matter.

    – Magnus Eriksson
    Nov 23 '18 at 12:24














0












0








0









This question already has an answer here:




  • mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result

    32 answers



  • Reference - What does this error mean in PHP?

    32 answers




i have written a piece of code in order to give access to my android app to connect to the MySQL database through PHP.
It works fine but log shows a warning says:




Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:xampphtdocsapp_login.php on line 7




this is my php for connecting the database (app_conn.php):



<?php

$db_name="score_test";

$mysql_username="root";

$mysql_password="PxyG8PPJFRGxAmhP";

$server_name="localhost";

$conn= mysqli_connect($server_name,$mysql_username,$mysql_password,$db_name);

if(mysqli_connect_errno()== false){

    echo "Done";

}

?>


and the login php (app_login.php):



<?php

require "app_conn.php";

$user_name = "test";

$user_pass="481";

$mysql_qry= "select * from score_test where C_USER like '$user_name' and C_SCORE like '$user_pass';";

$result = mysqli_query($conn , $mysql_qry);

if(mysqli_num_rows($result) == 0){

echo "Login Succesful";

}

else{

echo "Login Failed";

}

?>





php mysql mysqli







share|improve this question

















This question already has an answer here:




  • mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result

    32 answers



  • Reference - What does this error mean in PHP?

    32 answers




i have written a piece of code in order to give access to my android app to connect to the MySQL database through PHP.
It works fine but log shows a warning says:




Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:xampphtdocsapp_login.php on line 7




this is my php for connecting the database (app_conn.php):



<?php

$db_name="score_test";

$mysql_username="root";

$mysql_password="PxyG8PPJFRGxAmhP";

$server_name="localhost";

$conn= mysqli_connect($server_name,$mysql_username,$mysql_password,$db_name);

if(mysqli_connect_errno()== false){

    echo "Done";

}

?>


and the login php (app_login.php):



<?php

require "app_conn.php";

$user_name = "test";

$user_pass="481";

$mysql_qry= "select * from score_test where C_USER like '$user_name' and C_SCORE like '$user_pass';";

$result = mysqli_query($conn , $mysql_qry);

if(mysqli_num_rows($result) == 0){

echo "Login Succesful";

}

else{

echo "Login Failed";

}

?>




This question already has an answer here:




  • mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result

    32 answers



  • Reference - What does this error mean in PHP?

    32 answers







php mysql mysqli




php mysql mysqli






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 23 '18 at 12:17









Masivuye Cokile

4,39421431




4,39421431










asked Nov 23 '18 at 12:15









RegetixRegetix

12




12




marked as duplicate by FrankerZ, Masivuye Cokile, Jeto, Nick, RiggsFolly mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 23 '18 at 12:21


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.









marked as duplicate by FrankerZ, Masivuye Cokile, Jeto, Nick, RiggsFolly mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 23 '18 at 12:21


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.










  • 2





    Your script is at risk for SQL Injection Attacks.

    – FrankerZ
    Nov 23 '18 at 12:16






  • 1





    @TobiasF. - The OP is only using mysqli_. It's only a few of their variables that's called $mysql_* which doesn't matter.

    – Magnus Eriksson
    Nov 23 '18 at 12:24














  • 2





    Your script is at risk for SQL Injection Attacks.

    – FrankerZ
    Nov 23 '18 at 12:16






  • 1





    @TobiasF. - The OP is only using mysqli_. It's only a few of their variables that's called $mysql_* which doesn't matter.

    – Magnus Eriksson
    Nov 23 '18 at 12:24








2




2





Your script is at risk for SQL Injection Attacks.

– FrankerZ
Nov 23 '18 at 12:16





Your script is at risk for SQL Injection Attacks.

– FrankerZ
Nov 23 '18 at 12:16




1




1





@TobiasF. - The OP is only using mysqli_. It's only a few of their variables that's called $mysql_* which doesn't matter.

– Magnus Eriksson
Nov 23 '18 at 12:24





@TobiasF. - The OP is only using mysqli_. It's only a few of their variables that's called $mysql_* which doesn't matter.

– Magnus Eriksson
Nov 23 '18 at 12:24












0






active

oldest

votes

















0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes

-

Popular posts from this blog

Paul Cézanne

Image
Pour l’article ayant un titre homophone, voir Sézanne. Paul Cézanne.mw-parser-output .entete.artiste{background-image:url("//upload.wikimedia.org/wikipedia/commons/f/f3/Picto_infobox_artiste.png")} Autoportrait vers 1861 Naissance 19 janvier 1839 Aix-en-Provence (France) Décès 22 octobre 1906 (à 67 ans) Aix-en-Provence (France) Nationalité Française Activité Peintre Formation Académie de Charles Suisse Maître Joseph Gilbert, Antoine Guillemet, Camille Pissarro Mouvement Impressionnisme postimpressionnisme Influencé par Eugène Delacroix, Gustave Courbet, Véronèse A influencé Braque, Picasso, Matisse Conjoint Hortense Fiquet (depuis 1886) Enfant Paul Cézanne  ( d ) Œuvres principales La Montagne Sainte-Victoire, Portrait de madame Cézanne signature modifier - modifier le code - modifier Wikidata Paul Cézanne , né le 19 janvier 1839 à Aix-en-Provence et mort le 22 octobre 1906 dans la mê...
Read more

UIScrollView CustomStickyHeader Resize height generates problems when scroll is too fast

Image
0 I have been trying for a while to create a UIViewController that has a CustomStickyHeader and a UITableView. The idea I have been following is use the UITableView scrolling for changing the header view with the value of the contentOffset. The layout for the ViewController (AlbumsViewController) looks like: The UItableView Scrolling functions from the delegate are implemented like that: func scrollViewDidScroll(_ scrollView: UIScrollView) { let endReached = contentTableView.contentOffset.y >= (contentTableView.contentSize.height - contentTableView.frame.size.height) let isUP = lastContentOffset > scrollView.contentOffset.y if scrollView.contentOffset.y < 0 { headerHeightConstraint.constant += abs(scrollView.contentOffset.y) } else{ if !endReached{ ...
Read more

Angular material date-picker (MatDatepicker) auto completes the date on focus out

Image
3 3 I am using angular material/mat-datepicker in my project and whenever the user enters one digit inside of it, and goes out of focus - the date picker is auto completing with a random date. Example Just enter 1 and go out of focus, or enter 5/5/20 The date picker is adding date automatically Update : Also I am using reactive forms and I'm validating the input with that approach Can I disable this ? angular datepicker angular-material angular6 angular-material-datetimepicker share | improve this question edited Nov 20 '18 at 13:21 ...
Read more