mysql

[Solved] How to change mysql column from html table with php scripting

by

1) You need to use ajax. 2) For every button you can use a form such as: <form method=”post” action=”approved.php” target=”_self”> <td> <input type=”submit” name=”submit” value=”Approved”> <input type=”hidden” name=”quoteID” value=”<?php echo $row[“quote_id’]?>’> </td> </form> approved.php: mysqli_connect $approvedElement = $_POST[‘quoteID’]; $query = ‘UPDATE … WHERE `Quote ID` = \”.$quoteID.’\’ ‘; mysqli_query($query); So before ajax I suggest … Read more

[Solved] Fatal error: Call to a member function prepare() on a non-object in C:\wamp\www\sideProjects\loginTut\db.php on line 20 [closed]

by

You forgot to assign a value to $conn from the return value of DBConnect(), eg this DBconnect($config); should be $conn = DBConnect($config); You also don’t need to use global $conn in your script as it will be in scope. I’d also recommend not catching the exception from the PDO constructor. How else will you know … Read more

[Solved] Is a date within some of periods [closed]

by

This function should do what you want. It relies on MySQL treating boolean results as either 1 or 0 in a numeric context, thus the MAX call effectively becomes an OR of all the conditions. CREATE FUNCTION check_activity(project_id INT, check_date DATE) RETURNS BOOLEAN DETERMINISTIC BEGIN RETURN (SELECT MAX(check_date BETWEEN ActiveFrom AND ActiveTo) FROM projects WHERE … Read more

[Solved] Get min and max time section

by

Try: select date(event_start), min(time(event_start)), max(time(event_start)) from t group by date(event_start) order by date(event_start) solved Get min and max time section

[Solved] Selecting distinct values from multiple column of a table with their count

by

Get all column values to one row and find the count SQL SERVER ;WITH CTE AS ( SELECT COL1 Name FROM YOURTABLE UNION ALL SELECT COL2 FROM YOURTABLE UNION ALL SELECT COL3 FROM YOURTABLE UNION ALL SELECT COL4 FROM YOURTABLE UNION ALL SELECT COL6 FROM YOURTABLE UNION ALL SELECT COL7 FROM YOURTABLE ) SELECT DISTINCT … Read more

[Solved] about mysql query in php [closed]

by

Your code should work. It is better to have some protection against SQL injection as below. I have changed addslashes to mysql_real_escape_string. So now it should be alright. $name1 = mysql_real_escape_string($_POST[‘name1’]); $name2 = mysql_real_escape_string($_POST[‘name2’]); $name3 = mysql_real_escape_string($_POST[‘name3’]); mysql_query(“INSERT INTO tb_people (name) VALUES (‘$name1’), (‘$name2’), (‘$name3’);”); 5 solved about mysql query in php [closed]

[Solved] Convert SQL WHERE query to JOIN [closed]

by

For the most part, you just change your comma separated tables to JOIN clauses. The “ON” clause of the join is what comes from the WHERE clause SELECT DISTINCT r.recipe_id, r.recipe_name, r.recipe_image, r.recipe_duration, r.recipe_serving, r.recipe_difficulty, (SELECT category_name FROM tbl_category WHERE r.category_id = category_id) AS category_name, (SELECT cuisine_name FROM tbl_cuisine WHERE r.cuisine_id = cuisine_id) AS cuisine_name, … Read more

[Solved] dynamic code style rather than hard coding [closed]

by

The difference in execution time would be hard to measure, as string interpolation and an implode call is going to be orders of magnitude faster than the round-trip time to the database server. We’re talking nanoseconds versus milliseconds. You’re asking the wrong question, though. It’s a really bad practice to be writing out literal SQL … Read more

[Solved] Delete From ,Statement Query Failure [closed]

by

If you want to remove only some entries, you should not use DELETE but UPDATE to your null value (if nullable). For instance UPDATE login SET username = null, last_seen = null WHERE username = ?; DELETE is intended for deleting rows. solved Delete From ,Statement Query Failure [closed]