[ad_1] But never populate input values directly into a shell command. Use the function escapeshellarg(): $key = escapeshellarg($_POST[‘key’]); 5 [ad_2] solved How to use exec shell with PHP and MySQL?
[ad_1] Tack on another conditional to the end of your query: SELECT first_name, last_name FROM sc_application WHERE candidate_id = $user_id AND submitted = 0 1 [ad_2] solved Set a condition on an email being sent from an sql database [closed]
[ad_1] If you are getting a connection error, chances are your problem will be found on this line: $con = mysqli_connect(“localhost”,”username”,”password”,”database_name”); Are you sure you have got the correct host address, username, password and name of your database schema? You may also want to check that you have the mysqli php extension installed on wherever … Read more
[ad_1] Assuming there are no PK/Unique constraint involving Staffid and branchid, follows: select branchid from table group by branchid order by count(staffid) desc limit 5 Guess this will do. 2 [ad_2] solved need help to do a mysql query [closed]
[ad_1] If you want to show the complete data in first row you can do this: $i = 0; while($job = $result->fetch_object()){ if( $i == 0 ) { echo ‘<tr>’; echo ‘<td>’ . $job->JobDate .'</td>’; echo ‘<td>’ . $job->ReportTime.'</td>’; echo ‘<td>’ .$job->StartTime.'</td>’; echo ‘<td>’.$job->CustomerName.'</td>’; echo ‘<td>’.$job->EmployeeName.'</td>’; echo ‘<td>’.$job->EquipmentNumber.'</td>’; echo ‘<td>’.$job->JobDescription.'</td>’; echo ‘<td>’.$job->JobNotes.'</td>’; echo ‘</tr>’; } … Read more
[ad_1] Something like this? $query .= “WHERE 1=1 AND e.id=p.employee_id AND p.office_id=o.id AND (o.office_name=””.mysqli_real_escape_string($officeName).”” OR o.office_name=””.mysqli_real_escape_string($firstName).”” OR o.office_name=””.mysqli_real_escape_string($lastName).””) “; I used mysqli_real_escape_string() here as an example, you should use the correct and necessary precautions to avoid SQL injection in your system. 5 [ad_2] solved Build dynamic WHERE clause in mySQL
[ad_1] Your query should look like this: $insertData = “INSERT INTO facebook (fdId, fullName, email, dob, location, gender, postId) VALUES (‘”.$fbId.”‘,'”.$fullName.”‘,'”.$email.”‘,'”.$new_date.”‘,'”.$location.”‘,'”.$gender.”‘,'”.$postId.”‘)”; mysql_select_db(‘noskunk1_facebook’,$vdb); $result = mysql_query($insertData); if ($result)) { echo “New record created successfully”; } else { echo “Error: ” . $insertData . “<br>” . mysql_error($vdb); } but consider using pdo 3 [ad_2] solved error mysql_query() … Read more
[ad_1] Make another table called payments which has – id of payment – userid of user – date they last paid – length of payment Then, to check when a user’s set to expire, SELECT date+length as expy FROM payments WHERE userid = $userid ORDER BY date DESC LIMIT 1 Store dates & lengths as … Read more
[ad_1] This will give you the number of employees by country. SELECT o.country, COUNT(*) FROM office o INNER JOIN employee e ON e.office_id = o.office_id GROUP BY o.country 0 [ad_2] solved group by count in mysql [closed]
[ad_1] Rename loja.genesiseries/depoimentos/testemysql.html to loja.genesiseries/depoimentos/testemysql.php <div> <p> <font color=”#bdbdbd”> <?php $sql = “SELECT * FROM opinions ORDER BY id DESC LIMIT 15”; $resultado = mysql_query($sql); while ($linha=mysql_fetch_array($resultado)) { $depoimento = $linha[“depoimento”]; $client = $linha[“client”]; echo “$depoimento”; echo “$client”; } ?> </font> </p> </div> 3 [ad_2] solved ECHO MYSQL RESULT DISPLAY BLANK PAGE [closed]
[ad_1] You have to bind your variables like you do in your first code. The Version 1 and Version 2 codes are both INSECURE. [ad_2] solved PDO prepared statements [closed]
[ad_1] Don’t worry about the performance of polling. With a suitable INDEX, MySQL can handle 100 polls/second — regardless of dataset size. Let’s see SHOW CREATE TABLE and the tentative SELECT to perform the “poll”; I may have further tips. Also, let’s see the admin’s query that needs to ‘trigger’ the workers into action. Surely … Read more
[ad_1] Time to study. PHP With PDO (here you can work with databases using PHP): http://php.net/manual/pt_BR/book.pdo.php Use a POST form to save the data. You need to put each td value inside of a input. http://www.html-form-guide.com/php-form/php-form-post.html You need to create a database (http://dev.mysql.com/doc/refman/5.5/en/create-database.html) and a table (http://dev.mysql.com/doc/refman/5.1/en/create-table.html). And finally insert command, to add the values … Read more
[ad_1] include the order by clause to get the last 200 records. SELECT c.member_id,c.message_id, fm.firstname AS fname, up.gender, TIMESTAMPDIFF( YEAR, up.dob, NOW( ) ) AS age, c.upload_img, c.image, c.message_id AS msg_id, c.message AS msg, c.posted_timestamp AS time, c.topic_id AS topic_id, u.croppedpicture_filename,u.picture_filename FROM conversation_messages_tbl c, user_profileinformation_tbl up, user_tbl u, family_member_tbl fm WHERE c.member_id = fm.family_member_id AND … Read more
[ad_1] The quick and dirty fix is to use something like: level = level.Replace(“‘”,”whatever”); but there are still problems with that. It won’t catch other bad characters and it probably won’t even work for edge cases on the apostrophe. The best solution is to not construct queries that way. Instead, learn how to use parameterised … Read more