Alans
-
Posts
7 -
Joined
-
Last visited
Alans's Achievements
Newbie (1/5)
0
Reputation
-
Updated Data Not Shown on PHP Page But the MySQL DB Is Updated
Alans replied to Alans's topic in MySQL Help
Correction, in the last sentence it should say .. does NOT show up ... -
Updated Data Not Shown on PHP Page But the MySQL DB Is Updated
Alans replied to Alans's topic in MySQL Help
My form and process to insert/update the database work just fine. I have confirmed that several times. I do not understand why the refresh of both the form edit page, and a second page that just displays the data, which retrieves the data from the database every time the page is accessed or refreshed would not show the current data confirmed to be in the database. Also puzzling is that the data does show up on my display page even when it is added to the database with the phpMyAdmin application in cPanel. thanks -
Updated Data Not Shown on PHP Page But the MySQL DB Is Updated
Alans replied to Alans's topic in MySQL Help
Just in case this is useful, here is the overview of the process I am using going back and forth between two php pages: First I launch the starting page with this https://<domain name>/<directory 1>/<directory 2>/<php edit page>?lv_action=U Then I send my updates with a Submit button using this echo "<form name='<form1>' action='<php dml processing page>' method='POST'>"; Then I go back to the initial page with echo "function GoBack()"; echo "{ "; echo " location.href='<php edit page>?lv_action=U'"; echo "}"; echo "<body link='#000000' vlink='#000000' alink='#000000' onLoad='GoBack()'>"; The <php edit page> is displayed, however, the updated data is not displayed on the form but is updated in the database -
Updated Data Not Shown on PHP Page But the MySQL DB Is Updated
Alans replied to Alans's topic in MySQL Help
From what I can tell all are using https. Baring giving you all of my code and assuming it is a sessions problem are you able to suggest any possible solutions or things I can try? -
I added SSL to my website and now data entered in a php form is not being refreshed after saving even though I see the data was updated in the MySQL database
-
I had found this, but your error reporting statement works much better. error_reporting(E_ALL); ini_set('display_errors', 1); after running again I found it was a data issue. there was a rogue single quote in my text. I removed that and now it is working as expected many thanks
-
I have crated a form and the DML to update the data in a MySQL database. I have confirmed the data is coming over from the form however it is not getting saved/committed to the database. The user in the DB connection $db_elect has full privileges to the database. I have tried all of these with no luck $db_elect->commit(); $sql_commit = mysqli_query($db_elect ,"COMMIT"); if ( !mysqli_commit($db_elect) ) { $sql_commit = 'FAILED'; } Here is the update statement. When it is ran I get no errors in the error_log file $sql_result_update = mysqli_query( $db_elect ,"UPDATE campaign_positions SET position_text = '$lv_position_text' ,position_actv = '$lv_position_actv' ,position_dt = '$lv_position_dt' ,position_title = '$lv_position_title' ,position_order = '$lv_position_order' WHERE position_id = $lv_position_id");