you can use this : <?php $update = “”; foreach($_POST as $key => $value) { if(!empty($value)) { $update .= $key. “='”.$value.”‘,”; } } $update = substr($update,0,-1); $query = “UPDATE table_name SET “.$update.” WHERE id=$id”; ?> solved PHP: Create SQL query for available $_POST variable [closed]
Change this; $query=mysql_query(“select * from users where userId=’$uname’ and pwd =’$pwd’ “); to: $query=mysql_query(“SELECT * FROM users WHERE pwd =’$pwd’ AND (userId = ‘$uname’ OR PhoneNum = ‘$uname’)”); What this does it will take both $uname value and search both Userid column and Phone Num column for a match. Please note that PhoneNum is the … Read more
Use this. here I use userId to select a particular row. you can alter it or not use it according to your requirement. $query = “SELECT amount FROM table1 WHERE userId='{$id}'”; $result = mysqli_query($con,$query); $sql = “UPDATE table2 SET total=”{$result}” WHERE userId='{$id}'”; mysqli_query($con,$sql); 0 solved i want to transfer data from column to another table … Read more
You’ve given very little in the way of details. I’ll provide an answer here that’s as simple as possible: Use SSD If you’re not already using SSD that’s probably the issue. Conventional hard drives are terrible at random I/O and will bog down on occasion when too busy to service requests in a timely manner. … Read more
This is not the complete solution. Just a hint for you to do your homework. select a.column3 + b.column3 from mytable a, mytable b where a.column1 = b.column2 and a.column2 = b.column1; solved Write SQL query to fetch data from below table [closed]
The place of mysql_query isn`t correct. You must insert records in loop: foreach ($xml as $syn) { $w1 = $syn->w1; $w2 = $syn->w2; $sql = “INSERT INTO db_name (w1, w2) VALUES (‘$w1′,’$w2’)”; $query = mysql_query($sql); if (!$query) { echo (‘Error: ‘ . mysql_error()); } else { echo “Record added”; } } mysql_close($con); 3 solved Parse … Read more
There is no $dbh variable, so you can’t call prepare() on it. 2 solved Hi am new to hostgator cpanel.I get this database connection error when testing my website [closed]
Consider adding a flag to the User table that indicates if the user is a temporary user or not: alter table user add is_temp tinyint unsigned default 0 not null; This will allow a simple foreign key reference from In_Out: alter table In_Out change id User_id <Match Data Type And Nullness Here>, add constraint User_id_fk … Read more
There are multiple problems with your latest revision: Problem #1: You should use some variant of mysql_fetch_ in order to fetch the rows from the resource returned by mysql_query(). Using mysql_result can be inefficient. Usually, people use mysql_fetch_assoc(). This will return an array, which you can then access using its key, which depends on which … Read more
Change $sqlUpdate = “UPDATE `annonces` SET `etat` = `offline`… to $sqlUpdate = “UPDATE `annonces` SET `etat` = ‘offline’… Put quotes around “offline”, and it should work. 0 solved Update query with PHP and PDO doesn’t work [closed]
select cat_id, count(1) cnt from category join topic on cat_is = cat_id join comment on topic_is = topic_id group by cat_id solved How to count total comment in a category not a topic
First change the method signature to return a value: public static boolean checkUSPASS(String a,String b) Then return a value from within the method: return true; or: return false; Note that all code paths must return some value. So you have this in your try block: if (rs.next()) { return true; } else { return false; … Read more
You need to give your anchor tag’s href property some value. <a href=”https://stackoverflow.com/questions/35997885/<?php echo $results[“Website’] ?>”><?php echo $results[ ‘Website’]?></a> As it is now, the href property is empty, which some browsers will interpret as pointing to your current page. This is what’s causing your page to reload. 1 solved Retrieving URL from MySQL database
Your <body> tag is within your <head> tag. solved I dont know what is wrong with my html and php code.It gives Error:Query was empty
THere is no way, not how you’re doing it. You’re making individual HTTP connections for each request. Unless your webserver only maintains a single instance of a database connection for all requests, its going to create new ones for each request (this would also mean your website only has a single server- in other words … Read more