http://209.61.142.197/forum/ Flash PHP Mysql Extension Support forum. en-US Fri, 18 May 2012 18:51:23 +0000 http://bbpress.org/?v=1.0.2 q http://209.61.142.197/forum/search.php http://209.61.142.197/forum/topic/does-your-product-work-only-with-myisam-or-can-it-work-with-innodb-tables#post-28 Wed, 26 Jan 2011 21:41:50 +0000 admin 28@http://209.61.142.197/forum/ <p>Just edit your db connect file to work with different types of databases. </p> http://209.61.142.197/forum/topic/getting-this-error-on-a-simple-insert-can-you-take-a-look#post-27 Wed, 26 Jan 2011 21:39:43 +0000 admin 27@http://209.61.142.197/forum/ <p>try using escape() in Flash around the vars that insert special characters. </p> http://209.61.142.197/forum/topic/prefix-used-in-scripts#post-26 Wed, 26 Jan 2011 21:37:44 +0000 admin 26@http://209.61.142.197/forum/ <p>The prefix is so that you can have multiple queries with different function names. </p> http://209.61.142.197/forum/topic/validation-of-fields#post-25 Wed, 26 Jan 2011 21:35:07 +0000 admin 25@http://209.61.142.197/forum/ <p>Possibly double check your db connect file. </p> http://209.61.142.197/forum/topic/getting-this-error-on-a-simple-insert-can-you-take-a-look#post-24 Tue, 11 Jan 2011 17:30:31 +0000 RMSinc 24@http://209.61.142.197/forum/ <p>Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query string containing name/value pairs.<br /> at Error$/throwError()<br /> at flash.net::URLVariables/decode()<br /> at flash.net::URLVariables()<br /> at flash.net::URLLoader/onComplete() </p> http://209.61.142.197/forum/topic/prefix-used-in-scripts#post-22 Wed, 05 Jan 2011 23:14:12 +0000 RMSinc 22@http://209.61.142.197/forum/ <p>When you assign a prefix does it matter when you create other Flash forms with different prefixes? Does it affect the PHP folder originally created when you have a new form? </p> http://209.61.142.197/forum/topic/does-your-product-work-only-with-myisam-or-can-it-work-with-innodb-tables#post-21 Mon, 03 Jan 2011 13:41:08 +0000 RMSinc 21@http://209.61.142.197/forum/ <p>I converted a table to InnoDB and now the code does not seem to work... </p> http://209.61.142.197/forum/topic/gsolo-error-for-md5as#post-20 Mon, 03 Jan 2011 13:36:10 +0000 RMSinc 20@http://209.61.142.197/forum/ <p>I found a new version that did not cause compiler errors </p> http://209.61.142.197/forum/topic/gsolo-error-for-md5as#post-19 Wed, 29 Dec 2010 12:21:47 +0000 RMSinc 19@http://209.61.142.197/forum/ <p>C:\wamp\www\TLC\com\gsolo\encryption\MD5.as, Line 78 Warning: 1112: Array(x) behaves the same as new Array(x). To cast a value to type Array use the expression x as Array instead of Array(x).</p> <p>Is there a new version of MD5.as for CS5 Flash? </p> http://209.61.142.197/forum/topic/validation-of-fields#post-18 Wed, 15 Dec 2010 21:20:35 +0000 RMSinc 18@http://209.61.142.197/forum/ <p>But now I am getting no records written...<br /> I changed from MyISAM to InnoDB would that cause some problems? </p> http://209.61.142.197/forum/topic/validation-of-fields#post-17 Sat, 04 Dec 2010 18:21:47 +0000 RMSinc 17@http://209.61.142.197/forum/ <p>I had to redo the loading of PHP for the flash component and it worked...<br /> no errors now... you can close this thread Thank you </p> http://209.61.142.197/forum/topic/validation-of-fields#post-16 Fri, 03 Dec 2010 05:19:45 +0000 RMSinc 16@http://209.61.142.197/forum/ <p>Thank you Quince! Thought that may be the case...<br /> I do have one problem<br /> When using the Insert...<br /> I am getting this error...</p> <p>Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query string containing name/value pairs.<br /> at Error$/throwError()<br /> at flash.net::URLVariables/decode()<br /> at flash.net::URLVariables()<br /> at flash.net::URLLoader/onComplete()</p> <p>Any suggestions on where to look for debugging? </p> http://209.61.142.197/forum/topic/validation-of-fields#post-15 Sun, 14 Nov 2010 16:29:54 +0000 admin 15@http://209.61.142.197/forum/ <p>Yes you would need to query against the <code>db Select email_address, user_name FROM user WHERE email_address='...@...' OR user_name='...'</code>.</p> <p>If no results are returned then the user name and email are okay if results are returned look to see if the user name is = to '...' or is it the email or both then you can return the info.</p> <p>Another thing you see people do is check the user name and email separately. you do this on deselect of the text area they enter the info in and give them live alerts when needed.</p> <p>Thanks!<br /> Quince Wyss<br /> Peak Studios </p> http://209.61.142.197/forum/topic/validation-of-fields#post-12 Tue, 26 Oct 2010 19:52:18 +0000 RMSinc 12@http://209.61.142.197/forum/ <p>I would like to validate fields before inserting into MySql database. Before using INSERT PHP can I use the SELECT PHP to validate fields within AS3? I want to be able to check if a User ID is already registered and / or an Email address already in the database. Would I just compare the flash text entered fields with the What to look for result from the SELECT PHP of the corresponding fields in the MySql database? The User ID would be the same as your Login Example but for a email address I would have to search every record. </p> http://209.61.142.197/forum/topic/tutorial-example-implementation-for-register-login#post-11 Wed, 20 Oct 2010 05:05:06 +0000 admin 11@http://209.61.142.197/forum/ <p>You're welcome, happy to help!</p> <p><a href="http://209.61.142.197/forum" title="Peak Studios Support">Peak Studios - Support</a> </p> http://209.61.142.197/forum/topic/tutorial-example-implementation-for-register-login#post-10 Tue, 19 Oct 2010 23:27:11 +0000 RMSinc 10@http://209.61.142.197/forum/ <p>I put it right before the</p> <p>include("db_connect.php");</p> <p>and got the Registration Complete... </p> <p>Will work on parsing the error for future...</p> <p>Thank you once again for your prompt responses! </p> http://209.61.142.197/forum/topic/tutorial-example-implementation-for-register-login#post-9 Tue, 19 Oct 2010 20:42:23 +0000 RMSinc 9@http://209.61.142.197/forum/ <p>// Turn off all error reporting<br /> error_reporting(0);</p> <p>this would go into the insertDB.php at one point in php file?</p> <p>&lt;?php<br /> //---------------Due to security concerns you must have this set on the server since flash can only md5 or sha encrypt data.<br /> include("db_connect.php");<br /> //---------------Set user vars--------------------<br /> $forCount = $_POST['selectRowsLength'];<br /> $ASCCount = $_POST['ASCLength'];<br /> $tableName = $_POST['table1'];<br /> error_reporting(0);</p> <p>//To run this function flash needs to pass in "fc and tn then tr[i] and trv[i]"<br /> $tableValues = "";<br /> $nextValue = "";<br /> $va = array();<br /> for ($ia=0; $ia&lt;$forCount; $ia++){<br /> if ($ia != 0){<br /> $tableValues .= ",'";<br /> }else{<br /> $tableValues .= "'";<br /> }<br /> $nextValue = 'valueRows'.$ia;<br /> $va[$ia] = $_POST[$nextValue];<br /> $tableValues .= "$va[$ia]";<br /> $tableValues .= "'";<br /> }</p> <p>//----------------<br /> //To run this function flash needs to pass in "fc and tn then tr[i] and trv[i]"<br /> $tableRows = "";<br /> $nextTr = "";<br /> $tra = array();</p> <p>for ($i=0; $i&lt;$forCount; $i++){<br /> if ($i != 0){<br /> $tableRows .= ", ";<br /> }<br /> $nextTr = 'selectRows'.$i;<br /> $tra[$i] = $_POST[$nextTr];<br /> $tableRows .= "$tra[$i]";<br /> }<br /> //---------------End set user vars----------------<br /> //------------------------------------------------</p> <p>//-------------add user function------------------<br /> mysql_query("INSERT INTO $tableName($tableRows) VALUES($tableValues)");<br /> // --start output string with number of entries--<br /> echo "insertAction=Complete";<br /> ?&gt; </p> http://209.61.142.197/forum/topic/tutorial-example-implementation-for-register-login#post-8 Tue, 19 Oct 2010 20:28:57 +0000 admin 8@http://209.61.142.197/forum/ <p>I used unescape() with your result and found it says, "<br /> &lt;b&gt;Notice&lt;/b&gt;: Undefined index: ASCLength in &lt;b&gt;C:\wamp\www\TLC\php\insertDB.php&lt;/b&gt; on line &lt;b&gt;6&lt;/b&gt;<br /> insertAction=Complete".</p> <p>I would simply turn off notices in your php.ini file. Then it will work fine for you. </p> <p>Instead of php.ini you can add a line of php to your insert.php file here's the info on <a href="http://php.net/manual/en/function.error-reporting.php">removing notices</a> </p> http://209.61.142.197/forum/topic/tutorial-example-implementation-for-register-login#post-7 Tue, 19 Oct 2010 19:50:59 +0000 RMSinc 7@http://209.61.142.197/forum/ <p>Thanks for the Prompt Response BTW I am running CS5 Flash</p> <p>Trace Result:<br /> %3Cbr%20%2F%3E%0A%3Cb%3ENotice%3C%2Fb%3E%3A%20%20Undefined%20index%3A%20ASCLength%20in%20%3Cb%3EC%3A%5Cwamp%5Cwww%5CTLC%5Cphp%5CinsertDB%2Ephp%3C%2Fb%3E%20on%20line%20%3Cb%3E6%3C%2Fb%3E%3Cbr%20%2F%3E%0AinsertAction=Complete</p> <p><a href="http://www.thelionslead.com/TestResultwithTrace.swf" rel="nofollow">video</a> </p> http://209.61.142.197/forum/topic/tutorial-example-implementation-for-register-login#post-6 Tue, 19 Oct 2010 19:35:32 +0000 admin 6@http://209.61.142.197/forum/ <p><code>function user_returnFunction(vars:URLVariables, functionStrings:Array){</code><br /> Add this line of code here <code>trace(vars.toString());</code><br /> <code>if(vars[&quot;insertAction&quot;]==&quot;Complete&quot;) {</code><br /> You should see a var like insertAction=Complete traced for you. I might look strange since it's urlencoded.</p> <p>Please, report back with the trace statement. </p> http://209.61.142.197/forum/topic/tutorial-example-implementation-for-register-login#post-5 Tue, 19 Oct 2010 19:19:03 +0000 RMSinc 5@http://209.61.142.197/forum/ <p>Here is the code I am using... each time I create a test swf... I get Registration Failed error... The only change I made was in the DB_connect Php for connecting to my DB and table.</p> <p>I get Test and the password is inserted into the database... yet I receive a Registration Failed...</p> <pre><code>function userInsert(user, pass) { var user_table = &quot;users&quot;; //--TableRow and rowValue arrays must be the same length. //--Array should be the table row names you wish to insert var user_tableRow:Array = new Array();&lt; user_tableRow[0] = &quot;Username&quot;; user_tableRow[1] = &quot;Password&quot;; //--Array should be the table row values you wish to insert var user_rowValue:Array = new Array(); user_rowValue[0] = user; user_rowValue[1] = pass; var user_functionStrings:Array = new Array(); user_functionStrings[0] = &quot;&quot;; var user_insert:InsertDB = new InsertDB(user_table, user_tableRow, user_rowValue, user_returnFunction, user_functionStrings, DB_loc); } //--Return function //you can seperate the values out using vars.the var you want. //you already know the returned values because you set them with the tableRow array (i.e. vars.message) function user_returnFunction(vars:URLVariables, functionStrings:Array){ if(vars[&quot;insertAction&quot;]==&quot;Complete&quot;) { statusTxt.text = &quot;Registration Complete&quot;; usernameTxt.text = &quot;&quot;; passwordTxt.text = &quot;&quot;; }else { statusTxt.text = &quot;Registration Failed&quot;; } }</code></pre> http://209.61.142.197/forum/topic/how-to-obtain-all-the-fields-in-a-mysql-table-as-a-unique-string#post-4 Wed, 25 Aug 2010 02:52:47 +0000 admin 4@http://209.61.142.197/forum/ <p>If you have labels on your datagrid you can click them to sort or you can search before you create a data grid. </p> <p>If you want to make more of a live search on the datagrid the you will need to write some custom sorting of the data provider then reset the data grid on text event. </p> http://209.61.142.197/forum/topic/how-to-obtain-all-the-fields-in-a-mysql-table-as-a-unique-string#post-3 Sat, 21 Aug 2010 02:43:30 +0000 compix 3@http://209.61.142.197/forum/ <p>I'm looking the way to make a datagrid searchable fron one reference field or a search while type.</p> <p>Any help??</p> <p>Thanks </p> http://209.61.142.197/forum/topic/posting-rules#post-2 Wed, 12 May 2010 22:38:27 +0000 admin 2@http://209.61.142.197/forum/ <p>You must have purchased our the <a title="Flash PHP MySQL" href="http://209.61.142.197/products/">Flash PHP MySQL</a> extension to receive support from this forum. We may add more <a href="http://209.61.142.197/forum/forum/forum-rules">rules</a> at any time if necessary.</p> <ul> <li>No unrelated content will be allowed.</li> <li>Don't upload files of you code here send your files directly to <a href="mailto:support@209.61.142.197">support</a>.</li> <li>For your privacy don't post your DB_loc or db_config location, user or password when you are pasting code into your post.</li> </ul>