{!-- UPDATE THE ENTRY WITH THE CANONICAL --}
{exp:ce_str:ing php}
<?php
	$servername = "localhost";
	$username = "a58bc5af_goh";
	$password = "YukAtoneRowingBurred";
	$dbname = "a58bc5af_hawaiiguide";

	$entry_canonical = '{stash:canonical_url}';
	$the_id = '{stash:entry_id}';
	
		if(isset($entry_canonical, $the_id)) {
			
			try {
			    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
			    // set the PDO error mode to exception
			    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			
			    $sql = "UPDATE exp_channel_data SET field_id_955='$entry_canonical' WHERE entry_id=$the_id";
			
			    // Prepare statement
			    $stmt = $conn->prepare($sql);
			
			    // execute the query
			    $stmt->execute();
			
			    // echo a message to say the UPDATE succeeded
			    // echo $stmt->rowCount() . " records UPDATED successfully";
			    }
			catch(PDOException $e)
			    {
			    //echo $sql . "<br>" . $e->getMessage();
			    }
			
			$conn = null;
		}
?>
{/exp:ce_str:ing}