Try this: SELECT users2.* FROM users2 LEFT JOIN user_location2 ON user_location2.uid = users2.id LEFT JOIN users_like ul ON ul.uid1 = users2.id WHERE ( 3959 * acos( cos( radians(28.547800068217) ) * cos( radians( `lat` ) ) * cos( radians( `lon` ) – radians(-82.726205977101) ) + sin( radians(28.547800068217) ) * sin( radians( `lat` ) ) ) ) … Read more
I finally went to using an index solar for doing fast requests while my table will contains more than 4 million entries which must be parsed fastly and without consuming a lot of memory. Here’s I my solution maybe someone will have same problem as me. public List<Synonym> completeSynonym(String query) { List<Synonym> filteredSynonyms = new … Read more
Error #2 and #3: You have written a bit nonsense to the if() statement, mixed parts of what you intended to do. replace these two lines if(mysqli_num_rows((int)$sql_login>0)){ $result = mysqli_fetch_array($sql_login); with this one line if( $result = mysqli_fetch_array($sql_login) ){ Description of said one line code: If there is a record, $result will become an array, … Read more
You need to learn the PHP from the basics. Learn about operators, PHP and HTML secion, etc.. Anyway, i fixed your code. The condition is if $vehicle->sold is not equal to 1. But i think, (in your OP you mentioned it should be 0) you want this: $vehicle->sold == 0 //Use sytnax like this. See … Read more
You need next code: $A = $data[‘B’] – $_POST[‘C’] – 50; //for your first question $A = $data[‘B’] – $_POST[‘C’] – ($data[‘B’]*0.1); //for second question solved Php Math Equation with variables [closed]
Consider the following… DROP TABLE IF EXISTS my_table; CREATE TABLE my_table (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,userid INT NOT NULL ,date DATE NOT NULL ,score INT NOT NULL ,UNIQUE(userid,date) ); INSERT INTO my_table (userid,date,score) VALUES (1,’2017-09-30′,1), (1,’2017-10-01′,1), (2,’2017-10-01′,2), (1,’2017-10-02′,2), (2,’2017-10-02′,2), (3,’2017-10-02′,1); SELECT x.* , COUNT(DISTINCT y.score) rank FROM my_table x JOIN my_table y … Read more
$sql = “SELECT * FROM users WHERE username=”$username” and password = ‘$password'” This works for me do not know why it does not for you guessing its your database setup rember this can be “hacked” solved Login form: no matter what it displays the message of “Username/Password combination incorrect” [closed]
You need to first count the number of rows in your present query: $numrows = $s->rowCount(); and need to place a vaiable for results per page say $resultsPerPage: $resultsPerPage=10; Then the page you are currenty in: $offset=$_REQUEST[‘offset’]; Then you need to run the below code : $limit=$resultsPerPage; $PHP_SELF=$_SERVER[‘PHP_SELF’]; if($numrows >= 1) { // determine if … Read more
The error Notice: Undefined offset is in essence saying that you have attempted to reference a value of an array that does not exist. Reviewing your code, there are two possible instances where this can happen, first $_POST[‘checkbox’] and second $checked[$i]. You can resolve this error by something like this if (isset ($_POST[‘submit’])) { $checked … Read more
Little change. Issue in execute. You are passing blank array in this. So you have to check first if array containing value or not function db_toplu_veri_oku($query, $execute = array() , $binds = array(),$debug = false) { global $db; $query = $db->prepare($query); foreach($binds as $bind) { $query->bindValue($bind[0], $bind[1], $bind[2]); } if(count($execute)) //<———–Add this condition $select = … Read more
As mentioned by tadman, the $P$B signature suggests that this is probably a hash generated by the WordPress password hasher, so it can’t be reversed The WordPress password hasher implements the Portable PHP password hashing framework, which is used in Content Management Systems like WordPress and Drupal. You can generate hashes using this encryption scheme … Read more
you are not connecting to database. you variables are strings. change this $conn = mysql_connect(“$DB_HostName”, “$DB_User”, “$DB_Pass”) to $conn = mysql_connect($DB_HostName, $DB_User, $DB_Pass) and your update is wrong . you have to use math part outside the query, try use this $RH = $RANK * $HEALTH ; $SP = $Skills + $POWER ; $SPRH = … Read more
you are looping on all results of your query, so of course you will get all images. Your query is to generic. Now I assume your table is something like this: – id, int, auto-increment, primary key – uid, varchar, foreing key from a user table, not null – file_name, varchar, not-null – upload_time, datetime, … Read more
For InnoDB If specific_field is not nullable, they are equivalent and have the same performance. If specific_field is nullable, they don’t do the same thing. COUNT(specific_field) counts the rows which have a not null value of specific_field. This requires looking at the value of specific_field for each row. COUNT(*) simply counts the number of rows … Read more
You aren’t returning a result, you’re returning a query resource: function checkMail($email){ $email = mysql_real_escape_string($email); $sql = “SELECT COUNT(*) as emailCount FROM users WHERE email=”$email””; $query = mysql_query($sql) or die(mysql_error()); // show error if one happens return mysql_fetch_assoc($query); } This will return an associative array containing your results (if it succeeds), and you should be … Read more