Dreamweaver troubles - Revision history

Shawn: /* For future web pages */

2013-05-16T17:25:48Z

For future web pages

← Older revision		Revision as of 10:25, 16 May 2013
Line 57:		Line 57:
	====For future web pages====		====For future web pages====
	When creating new web pages, I should not use the old Dreamweaver way of constructing queries, but use the more secure methods for which mysqli was improved, like using parameters and binding for passing parameters from forms into preset mysql queries.		When creating new web pages, I should not use the old Dreamweaver way of constructing queries, but use the more secure methods for which mysqli was improved, like using parameters and binding for passing parameters from forms into preset mysql queries.

			On the other hand, I will be tempted to let Dreamweaver help me build pages the old way, then convert them using the steps outlined here.

	Some interesting, simple tutorials about using mysqli, to show multiple rows of data, insert rows from form variables, and other basic routines, are available here: http://www.phpmysqlitutorials.com/category/mysqli/		Some interesting, simple tutorials about using mysqli, to show multiple rows of data, insert rows from form variables, and other basic routines, are available here: http://www.phpmysqlitutorials.com/category/mysqli/

Shawn: converting mysql_ details

2013-05-16T17:24:05Z

converting mysql_ details

Shawn: /* My best solution */

2013-05-14T23:38:55Z

My best solution

← Older revision		Revision as of 16:38, 14 May 2013
Line 71:		Line 71:
	You might run into trouble if you use a line editor like awk or sed, because the XML file uses 0D, a carriage return, for line endings—Some sort of throwback to Classic Mac OS 9 Dreamweaver.		You might run into trouble if you use a line editor like awk or sed, because the XML file uses 0D, a carriage return, for line endings—Some sort of throwback to Classic Mac OS 9 Dreamweaver.
	====My best solution====		====My best solution====
	I opened Terminal and used the following sequence of line editors to do the whole process automatically, assuming a CS 6 installation.		I opened Terminal and used the following sequence of line editors to do the whole process automatically, assuming a CS 6 installation. Of course this should be done while DW is not running.
	cd ~/Library/Application Support/Adobe/Dreamweaver CS6/en_US/Configuration/Menus		cd ~/Library/Application Support/Adobe/Dreamweaver CS6/en_US/Configuration/Menus
	tr '\r' '\n'< menus.xml \| sed -E 's_(.key=".Ins".)(platform="")(.)_\1platform="win"\3_' \| tr '\n' '\r' > menus_fixed.xml		tr '\r' '\n'< menus.xml \| sed -E 's_(.key=".Ins".)(platform="")(.)_\1platform="win"\3_' \| tr '\n' '\r' > menus_fixed.xml
Line 95:		Line 95:
	mv menus.xml menus.xml.bak		mv menus.xml menus.xml.bak
	mv menus_fixed.xml menus.xml		mv menus_fixed.xml menus.xml
			Then I restart Dreamweaver and YAY! I can type capital I without freaky pasting!


	[[Category:Computers]]		[[Category:Computers]]

Shawn: /* Shift+I pasting on Mac */

2013-05-14T23:37:39Z

Shift+I pasting on Mac

← Older revision		Revision as of 16:37, 14 May 2013
Line 67:		Line 67:
	You could use regular expressions to ensure that all lines where the key attribute has a value that includes "Ins" also has a platform attribute with a value of "win":		You could use regular expressions to ensure that all lines where the key attribute has a value that includes "Ins" also has a platform attribute with a value of "win":
	^(.?key=".?Ins".?platform=")(\w?)(".*?)$		^(.?key=".?Ins".?platform=")(\w?)(".*?)$
	~~Replace~~ the above with:		Replacing the above with:
	^$1win$3$		^$1win$3$
	You might run into trouble if you use a line editor like awk or sed, because the XML file uses 0D, a carriage return, for line endings—Some sort of throwback to Classic Mac OS 9 Dreamweaver.		You might run into trouble if you use a line editor like awk or sed, because the XML file uses 0D, a carriage return, for line endings—Some sort of throwback to Classic Mac OS 9 Dreamweaver.
			====My best solution====
	I opened Terminal and used the following sequence of line editors to do the whole process automatically, assuming a CS 6 installation.		I opened Terminal and used the following sequence of line editors to do the whole process automatically, assuming a CS 6 installation.
	cd ~/Library/Application Support/Adobe/Dreamweaver CS6/en_US/Configuration/Menus		cd ~/Library/Application Support/Adobe/Dreamweaver CS6/en_US/Configuration/Menus

Shawn: /* Shift+I pasting on Mac */

2013-05-14T23:35:34Z

Shift+I pasting on Mac

@@ Line 70: / Line 70: @@
   ^$1win$3$
 You might run into trouble if you use a line editor like awk or sed, because the XML file uses 0D, a carriage return, for line endings—Some sort of throwback to Classic Mac OS 9 Dreamweaver.
-I used the following sequence of line editors to do the whole process automatically, assuming a CS 6 installation.
+I opened Terminal and used the following sequence of line editors to do the whole process automatically, assuming a CS 6 installation.
   cd ~/Library/Application Support/Adobe/Dreamweaver CS6/en_US/Configuration/Menus
-  tr '\r' '\n'< menus.xml |sed -E 's_(.*key=".*Ins".*)(platform="")(.*)_\1platform="win"\3_'|tr '\n' '\r' >>menus_fixed.xml
+  tr '\r' '\n'< menus.xml | sed -E 's_(.*key=".*Ins".*)(platform="")(.*)_\1platform="win"\3_' | tr '\n' '\r' > menus_fixed.xml
 [[Category:Computers]]

Shawn at 23:08, 14 May 2013

2013-05-14T23:08:41Z

← Older revision		Revision as of 16:08, 14 May 2013
Line 58:		Line 58:

	Some interesting, simple tutorials about using mysqli, to show multiple rows of data, insert rows from form variables, and other basic routines, are available here: http://www.phpmysqlitutorials.com/category/mysqli/		Some interesting, simple tutorials about using mysqli, to show multiple rows of data, insert rows from form variables, and other basic routines, are available here: http://www.phpmysqlitutorials.com/category/mysqli/

			===Shift+I pasting on Mac===
			Working with Dreamweaver CS 5.5 and 6 on Mac OS X, I've noticed every time I try to type a capital I, the key-combination shift+I acts as a paste-command. I was recently adding keyboard shortcuts, and I realized I might have accidentally programmed shift+I to be a shortcut for paste. I searched for the files in Dreamweaver that contain keyboard shortcuts, and found the menus.xml file that contains the default shortcuts for all menu items. In it the key combination shift+Ins is assigned to paste, so I thought maybe Ins was being misinterpreted as its first letter, I. Lo and behold, there is a discussion about it at Adobe's forum: http://forums.adobe.com/thread/721127
			There are two possible fixes. One is to delete the offending lines containing shift+Ins. Another is to use Dreamweaver's notation for controlling when to use the command, a value called "platform". Notice in the line below how the offending line was written—with platform being left empty the key combination is always applied:
			<shortcut name="Paste2" key="Shift+Ins" command="if (dw.canClipPaste()) { dw.clipPaste() }" platform="" domRequired="FALSE" id="DWShortcuts_HTMLSource_Paste2" />
			But since Mac doesn't have an insert key built-in, tell DW to use this command only when running on Windows:
			<shortcut name="Paste2" key="Shift+Ins" command="if (dw.canClipPaste()) { dw.clipPaste() }" platform="win" domRequired="FALSE" id="DWShortcuts_HTMLSource_Paste2" />
			You could use regular expressions to ensure that all lines where the key attribute has a value that includes "Ins" also has a platform attribute with a value of "win":
			^(.?key=".?Ins".?platform=")(\w?)(".*?)$
			Replace the above with:
			^$1win$3$
			You might run into trouble if you use a line editor like awk or sed, because the XML file uses 0D, a carriage return, for line endings—Some sort of throwback to Classic Mac OS 9 Dreamweaver.
			I used the following sequence of line editors to do the whole process automatically, assuming a CS 6 installation.
			cd ~/Library/Application Support/Adobe/Dreamweaver CS6/en_US/Configuration/Menus
			tr '\r' '\n'< menus.xml \|sed -E 's_(.key=".Ins".)(platform="")(.)_\1platform="win"\3_'\|tr '\n' '\r' >>menus_fixed.xml


	[[Category:Computers]]		[[Category:Computers]]

Shawn: /* Stale PHP/MySQL routines */

2013-04-30T18:23:44Z

Stale PHP/MySQL routines

← Older revision		Revision as of 11:23, 30 April 2013
Line 9:		Line 9:

	===Stale PHP/MySQL routines===		===Stale PHP/MySQL routines===
	The developers of PHP have decided to deprecate their original mysql library. As of April 2013, Adobe ~~hasn~~'~~t changed the way~~ Dreamweaver handles PHP/MySQL connections and queries ~~much since version CS3~~. CS6 does not use the improved PHP library mysqli for connections, and the routines for recordsets and dynamic texts and actions are the same as ever. See the page on PHP.net that explains the deprecation: http://docs.php.net/manual/en/intro.mysql.php		The developers of PHP have decided to deprecate their original mysql library—If your php scripts use functions that begin with "mysql_" then you are using the old library; new functions and classes begin with "mysqli_". As of April 2013, Adobe's Dreamweaver handles PHP/MySQL connections and queries with the old library. CS6 does not use the improved PHP library mysqli for connections, and the routines for recordsets and dynamic texts and actions are the same as ever. See the page on PHP.net that explains the deprecation: http://docs.php.net/manual/en/intro.mysql.php

	However, all the behaviors can be edited by users, since Dreamweaver uses html, javascript, and their markup language edml to tell DW how to interpret dynamic page routines. In the Dreamweaver application package folder you can find those routines and might replace PHP's mysql functions with mysqli functions, for example changing mysql_num_rows to mysqli_num_rows. You'd have to change all the functions at once, since a single connection can be only mysql or mysqli, and would require all functions to match the connection. You might think changing might be as simple as replacing all instances of ''mysql_'' with ''mysqli_''. However, the way mysqli returns rows may be different and some mysqli functions take different arguments, so your scripts will need more careful editing.		However, all the behaviors can be edited by users, since Dreamweaver uses html, javascript, and their markup language edml to tell DW how to interpret dynamic page routines. In the Dreamweaver application package folder you can find those routines and might replace PHP's mysql functions with mysqli functions, for example changing mysql_num_rows to mysqli_num_rows. You'd have to change all the functions at once, since a single connection can be only mysql or mysqli, and would require all functions to match the connection. You might think changing might be as simple as replacing all instances of ''mysql_'' with ''mysqli_''. However, the way mysqli returns rows may be different and some mysqli functions take different arguments, so your scripts will need more careful editing.
	====Oracle's mysql>mysqli converter====		====Oracle's mysql>mysqli converter====
	For a utility that promises to change mysql procedures to mysqli procedures in the most straightforward fashion, see Oracle's converter:		For a utility that promises to change mysql procedures to mysqli procedures in the most straightforward fashion, see Oracle's converter, which I chose not to use:
	https://wikis.oracle.com/display/mysql/Converting+to+MySQLi		https://wikis.oracle.com/display/mysql/Converting+to+MySQLi

	It might be interesting to convert not only one's scripts but Dreamweaver's Server Behavior files themselves.		It might be interesting to convert not only one's scripts but Dreamweaver's Server Behavior files themselves. Dreamweaver allows new Server Behaviors to be added, so one might add custom behaviors that use the new system. It goes deep, however, because certain behaviors like the recordset-builder require a connection themselves, and that deeper connection will have to be updated if the test-server drops mysql_ support.

	I tried Oracle's converter on some Dreamweaver code and had two problems. One is that snippets must be solely the php part of scripts, not entire html pages. Another is that Dreamweaver uses a single, separate connection file with all pages that share the same connection parameters, so the connection is split from the rest of the code, and the converter doesn't handle the initial link properly anyway.		I tried Oracle's converter on some Dreamweaver code and had two problems. One is that snippets must be solely the php part of scripts, not entire html pages. Another is that Dreamweaver uses a single, separate connection file with all pages that share the same connection parameters, so the connection is split from the rest of the code, and the converter doesn't handle the initial link properly anyway.

Shawn: /* My way of converting existing web pages */

2013-04-30T18:09:39Z

My way of converting existing web pages

← Older revision		Revision as of 11:09, 30 April 2013
Line 44:		Line 44:
	:And that can be replaced with this, using regex back-references:		:And that can be replaced with this, using regex back-references:
	if(!$1 = mysqli_query($3, $2)) die(mysqli_error($3));		if(!$1 = mysqli_query($3, $2)) die(mysqli_error($3));
	;Fifth, note that getting a row and counting are pretty similar, except the row count may depend on whether the entire result is pre-loaded or buffered or not:		;Fifth, note that getting a row and counting rows are pretty similar, except the row count may depend on whether the entire result is pre-loaded or buffered or not:
	$row_rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName);		$row_rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName);
	$totalRows_rsRecordsetName = mysqli_num_rows($rsRecordsetName);		$totalRows_rsRecordsetName = mysqli_num_rows($rsRecordsetName);
	;Sixth, iterating through rows is also very similar:		;Sixth, data seeks and iterating through rows is also very similar:
			mysqli_data
	<?php } while ($rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName)); ?>		<?php } while ($rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName)); ?>
	;Seventh, as usual, you need to free the result at the end, but you also should close the connection:		;Seventh, as usual, you need to free the result at the end, but you also should close the connection:

Shawn: /* My way of converting existing web pages */

2013-04-30T04:00:19Z

My way of converting existing web pages

Shawn: /* My way of converting existing web pages */

2013-04-29T23:58:35Z

My way of converting existing web pages

← Older revision		Revision as of 10:24, 16 May 2013
Line 21:		Line 21:

	====My way of converting existing web pages====		====My way of converting existing web pages====
	I change all the functions to their mysqli equivalents, converting arguments to their proper order and place, and I add the ~~required procedures such as~~ mysqli_close(). Here's how I convert a typical page that lists rows of data from a database:		I change all the functions to their mysqli equivalents, converting arguments to their proper order and place, and I add the recommended procedure mysqli_close(). Here's how I convert a typical page that lists rows of data from a database:
	;First change the connect-function in the connection file to this:		;First change the connect-function in the connection file to this:
	$ConnectionName = mysqli_connect($hostname_ConnectionName,		$ConnectionName = mysqli_connect($hostname_ConnectionName,
Line 33:		Line 33:
	:Those can be found with the following regular expression, and replaced with nothing:		:Those can be found with the following regular expression, and replaced with nothing:
	mysql_select_db(\s$\w\s,\s$\w\s)\s*;		mysql_select_db(\s$\w\s,\s$\w\s)\s*;
	;Third, if there's data entry, change the GetSQLValueString function to use mysqli. Specifically, noting that mysqli_real_escape_string takes the connection, not the value, as the first argument, and the value as the second argument:		;Third, if there's data entry, change the GetSQLValueString function to use mysqli. Specifically, noting that mysqli_real_escape_string takes the connection, not the value, as the first argument, and the value as the second argument. Also, I add this function declaration to the Connection file, removing it from all the page files, thus making them neater:
	$theValue = function_exists("mysqli_real_escape_string")		$theValue = function_exists("mysqli_real_escape_string")
	? mysqli_real_escape_string($ConnectionName,$theValue) : mysql_escape_string($theValue);		? mysqli_real_escape_string($ConnectionName,$theValue) : mysql_escape_string($theValue);
Line 42:		Line 42:
	:That can be matched by this:		:That can be matched by this:
	(\$\w)\s=\smysql_query\((\$\w),\s(\$\w)\)\sor\sdie\(mysql_error\(\)\);		(\$\w)\s=\smysql_query\((\$\w),\s(\$\w)\)\sor\sdie\(mysql_error\(\)\);
	:And that can be replaced with this, using regex back-references:		:And that can be replaced with this, using regex back-references. Just go to the find dialog, select Search>Source Code and select Use regular expression, enter the above code in Find and the below code in Replace:
	if(!$1 = mysqli_query($3, $2)) die(mysqli_error($3));		if(!$1 = mysqli_query($3, $2)) die(mysqli_error($3));
	;Fifth, note that getting a row and counting rows are pretty similar, except the row count may depend on whether the entire result is pre-loaded or buffered or not:		;Fifth, note that getting a row and counting rows are pretty similar, except the row count may depend on whether the entire result is pre-loaded or buffered or not:
Line 53:		Line 53:
	mysqli_free_result($rsRecordsetName);		mysqli_free_result($rsRecordsetName);
	mysqli_close($ConnectionName);		mysqli_close($ConnectionName);
			;If you know that these are the only mysql_ commands in the page file, you can replace the commands in steps 5, 6, and 7 using Find/Replace looking for mysql_ and replacing with mysqli_ .

	====For future web pages====		====For future web pages====

← Older revision		Revision as of 21:00, 29 April 2013
Line 28:		Line 28:
	printf("Connect failed: %s\n", mysqli_connect_error());		printf("Connect failed: %s\n", mysqli_connect_error());
	exit();		exit();
	}		}
	;Second, if there's data entry, change the GetSQLValueString function to use mysqli. Specifically, noting that mysqli_real_escape_string takes the connection, not the value, as the first argument, and the value as the second argument:		;Second, since the mysqli version of connection selects the database, you can remove the db-selecting command that appears before every query, looking like this:
			mysql_select_db($database_ConnectionName, $ConnectionName);
			:Those can be found with the following regular expression, and replaced with nothing:
			mysql_select_db(\s$\w\s,\s$\w\s)\s*;
			;Third, if there's data entry, change the GetSQLValueString function to use mysqli. Specifically, noting that mysqli_real_escape_string takes the connection, not the value, as the first argument, and the value as the second argument:
	$theValue = function_exists("mysqli_real_escape_string")		$theValue = function_exists("mysqli_real_escape_string")
	? mysqli_real_escape_string($ConnectionName,$theValue) : mysql_escape_string($theValue);		? mysqli_real_escape_string($ConnectionName,$theValue) : mysql_escape_string($theValue);
	;~~Third~~, change the query call and error check to this:		;Fourth, change the query call and error check to this:
	if(!$rsRecordsetName = mysqli_query($ConnectionName,$query_rsRecordsetName)) {die(mysql_error());}		if(!$rsRecordsetName = mysqli_query($ConnectionName,$query_rsRecordsetName)) {die(mysql_error());}
	:It's pretty easy to change the from the old format by using a regular expression search and replace. Originally Dreamweaver set a query to look like this:		:It's pretty easy to change the from the old format by using a regular expression search and replace. Originally Dreamweaver set a query to look like this:
	$resultname = mysql_query( $querystring, $connectionname) or die(mysql_error());		$resultname = mysql_query( $querystring, $connectionname) or die(mysql_error());
	:That can be matched by this:		:That can be matched by this:
	(\$\w)\s?=\s?mysql_query\((\$\w),\s?(\$\w)\)\s?or\s?die\(mysql_error\(\)\);		(\$\w)\s=\smysql_query\((\$\w),\s(\$\w)\)\sor\sdie\(mysql_error\(\)\);
	:And that can be replaced with this, using regex back-references:		:And that can be replaced with this, using regex back-references:
	if(!$1 = mysqli_query($3, $2)) die(mysqli_error($3));		if(!$1 = mysqli_query($3, $2)) die(mysqli_error($3));
	;~~Fourth~~, note that getting a row and counting are pretty similar, except the row count may depend on whether the entire result is pre-loaded or buffered or not:		;Fifth, note that getting a row and counting are pretty similar, except the row count may depend on whether the entire result is pre-loaded or buffered or not:
	$row_rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName);		$row_rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName);
	$totalRows_rsRecordsetName = mysqli_num_rows($rsRecordsetName);		$totalRows_rsRecordsetName = mysqli_num_rows($rsRecordsetName);
	;~~Fifth~~, iterating through rows is also very similar:		;Sixth, iterating through rows is also very similar:
	<?php } while ($rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName)); ?>		<?php } while ($rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName)); ?>
	;~~Sixth~~, as usual, you need to free the result at the end, but you also should close the connection:		;Seventh, as usual, you need to free the result at the end, but you also should close the connection:
	mysqli_free_result($rsRecordsetName);		mysqli_free_result($rsRecordsetName);
	mysqli_close($ConnectionName);		mysqli_close($ConnectionName);

← Older revision		Revision as of 16:58, 29 April 2013
Line 22:		Line 22:
	====My way of converting existing web pages====		====My way of converting existing web pages====
	I change all the functions to their mysqli equivalents, converting arguments to their proper order and place, and I add the required procedures such as mysqli_close(). Here's how I convert a typical page that lists rows of data from a database:		I change all the functions to their mysqli equivalents, converting arguments to their proper order and place, and I add the required procedures such as mysqli_close(). Here's how I convert a typical page that lists rows of data from a database:
	:First change the connect-function in the connection file to this:		;First change the connect-function in the connection file to this:
	$ConnectionName = mysqli_connect($hostname_ConnectionName,		$ConnectionName = mysqli_connect($hostname_ConnectionName,
	$username_ConnectionName, $password_ConnectionName,$database_ConnectionName);		$username_ConnectionName, $password_ConnectionName,$database_ConnectionName);
Line 29:		Line 29:
	exit();		exit();
	}		}
	:Second, if there's data entry, change the GetSQLValueString function to use mysqli. Specifically, noting that mysqli_real_escape_string takes the connection, not the value, as the first argument, and the value as the second argument:		;Second, if there's data entry, change the GetSQLValueString function to use mysqli. Specifically, noting that mysqli_real_escape_string takes the connection, not the value, as the first argument, and the value as the second argument:
	$theValue = function_exists("mysqli_real_escape_string")		$theValue = function_exists("mysqli_real_escape_string")
	? mysqli_real_escape_string($ConnectionName,$theValue) : mysql_escape_string($theValue);		? mysqli_real_escape_string($ConnectionName,$theValue) : mysql_escape_string($theValue);
	:Third, change the query call and error check to this:		;Third, change the query call and error check to this:
	if(!$rsRecordsetName = mysqli_query($ConnectionName,$query_rsRecordsetName)) {die(mysql_error());}		if(!$rsRecordsetName = mysqli_query($ConnectionName,$query_rsRecordsetName)) {die(mysql_error());}
	:Fourth, note that getting a row and counting are pretty similar, except the row count may depend on whether the entire result is pre-loaded or buffered or not:		:It's pretty easy to change the from the old format by using a regular expression search and replace. Originally Dreamweaver set a query to look like this:
			$resultname = mysql_query( $querystring, $connectionname) or die(mysql_error());
			:That can be matched by this:
			(\$\w)\s?=\s?mysql_query\((\$\w),\s?(\$\w)\)\s?or\s?die\(mysql_error\(\)\);
			:And that can be replaced with this, using regex back-references:
			if(!$1 = mysqli_query($3, $2)) die(mysqli_error($3));
			;Fourth, note that getting a row and counting are pretty similar, except the row count may depend on whether the entire result is pre-loaded or buffered or not:
	$row_rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName);		$row_rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName);
	$totalRows_rsRecordsetName = mysqli_num_rows($rsRecordsetName);		$totalRows_rsRecordsetName = mysqli_num_rows($rsRecordsetName);
	:Fifth, iterating through rows is also very similar:		;Fifth, iterating through rows is also very similar:
	<?php } while ($rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName)); ?>		<?php } while ($rsRecordsetName = mysqli_fetch_assoc($rsRecordsetName)); ?>
	:Sixth, as usual, you need to free the result at the end, but you also should close the connection:		;Sixth, as usual, you need to free the result at the end, but you also should close the connection:
	mysqli_free_result($rsRecordsetName);		mysqli_free_result($rsRecordsetName);
	mysqli_close($ConnectionName);		mysqli_close($ConnectionName);