Menu
I want to update one same column in all rows in one table can some one give me a hand how to update the table ? there is just one input field that should update all rows value . this code is not working and I know there is something wrong in index and array .
<?php <form method="post" dir="rtl" name="maxcharfield" > <textarea onKeyDown="textCounter(this,'progressbar1',300)" onKeyUp="textCounter(this,'progressbar1',300)" onFocus="textCounter(this,'progressbar1',300)" style="font-family:'B_yekan';" id="text" name="text" rows="0" cols="0" class="required"></textarea> <div class="cleaner h10"></div> <div style="font-family:'B_yekan';" dir="rtl" id="progressbar1" class="progress" ></div> <script>textCounter(document.getElementById("maxcharfield"),"progressbar1",100)</script> <input class="styled-button-8" style="margin-top:10px; float:right; margin-right:50px; font-size: 14px; padding: 5px 14px;" type="submit" value="save" name="Submit" /> <input style="font-family:'B_yekan';" type="reset" value="reset" id="reset" name="reset" class="submit_btn float_l" /> </form> <?php // for updating Check if button name "Submit" is active, do this if(isset($_POST['Submit']) && $_POST['Submit'] == 'save') { $sql1="UPDATE `".$tbl_name."` SET `board`='".$_REQUEST['text']."' "; $result1=mysql_query($sql1); } } ?> 
558
First, specify the table name that you want to change data in the UPDATE clause. Second, assign a new value for the column that you want to update. In case you want to update data in multiple columns, each column = value pair is separated by a comma (,). Third, specify which rows you want to update in the WHERE clause.
The UPDATE statement in SQL is used to update the data of an existing table in database. We can update single columns as well as multiple columns using UPDATE statement as per our requirement. UPDATE table_name SET column1 = value1, column2 = value2,...
The only way to update multiple tables in a single statement is when you create a view over these tables and use the option WITH SCHEMABINDING. Then you are able to update the columns by updating the view (UPDATE view SET ......).
Syntax: UPDATE table_name SET column_name1 = new_value1, column_name2 = new_value2 ---- WHERE condition; Here table_name is the name of the table, column_name is the column whose value you want to update, new_value is the updated value, WHERE is used to filter for specific data.
You're over-complicating the solution. In order to update every record, the approach you're trying to take is:
The UPDATE syntax has a much easier way to do this. You don't need to supply a WHERE clause to an UPDATE statement. Without that clause, it will by default update every record in the table:
UPDATE TableName SET `board`='value' Also, please be aware that you have a SQL injection vulnerability in your code. By using $_REQUEST['text'] directly in your SQL query, you allow any user to send SQL code to your query. Your code then executes whatever they send you. This could allow them to corrupt or delete your data, even gain administrative access to your server.
For starters, please stop using mysql_* functions. PHP has deprecated those and they should no longer be used. There is a mysqli_ replacement for them. In addition to that, use the mysqli_real_escape_string() function to sanitize your inputs before using them in a SQL query. And finally, use prepared statements instead of directly concatenating values into your SQL string.
83
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
