Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › code updating 3

code updating 3

Thread began 8/16/2017 8:36 am by Christopher West | Last modified 8/16/2017 1:21 pm by Ray Borduin | 396 views | 3 replies |

8/16/2017 8:36 am | #1 Christopher WestCommunity Expert

code updating 3

Hi Ray, I have the following old code (using old mysql server behaviours) and which to change it to mysqli

Im stuck on this old code changing to mysqi

php:

<?php

    $_GET['OptionGroupID'] = $row_ItemOptions['OptionGroupID'];

$colname_ItemGroupOptions = "-1";

if (isset($_GET['OptionGroupID'])) {

  $colname_ItemGroupOptions = $_GET['OptionGroupID'];

}

mysql_select_db($database_dinkydb, $dinkydb);

$query_ItemGroupOptions = sprintf("SELECT * FROM options WHERE OptionGroupID = %s ORDER BY OptionPrice, OptionName", GetSQLValueString($colname_ItemGroupOptions, "int"));

$ItemGroupOptions = mysql_query($query_ItemGroupOptions, $dinkydb) or die(mysql_error());

$row_ItemGroupOptions = mysql_fetch_assoc($ItemGroupOptions);

$lowPrice = $row_ItemGroupOptions["OptionPrice"];

?>

I got as far as this:

php:

<?php

$rsItemGroupOptions = new WA_MySQLi_RS("rsItemGroupOptions",$ecartdb,0);

$rsItemGroupOptions->setQuery("SELECT * FROM options WHERE OptionGroupID = ? ORDER BY OptionPrice, OptionName");

$rsItemGroupOptions->bindParam("s", "".(isset($_GET['OptionGroupID'])?$_GET['OptionGroupID']:"")  ."", "-1"); //colname

$lowPrice = $rsItemGroupOptions["OptionPrice"];                   

$rsItemGroupOptions->execute();

?>

But when I run the code, it doesnt like: $lowPrice = $rsItemGroupOptions["OptionPrice"]; inside the recordset.

and I am stuck on $_GET['OptionGroupID'] = $row_ItemOptions['OptionGroupID']; which I need to place in the mysqli bindParam section.

Chris

8/16/2017 11:41 am | #2 Ray BorduinWebAssist

I think you want:

php:

<?php

$rsItemGroupOptions = new WA_MySQLi_RS("rsItemGroupOptions",$ecartdb,0);

$rsItemGroupOptions->setQuery("SELECT * FROM options WHERE OptionGroupID = ? ORDER BY OptionPrice, OptionName");

$rsItemGroupOptions->bindParam("s", "".(isset($_GET['OptionGroupID'])?$_GET['OptionGroupID']:"")  ."", "-1"); //colname

$rsItemGroupOptions->execute();

$lowPrice = $rsItemGroupOptions->getColumnVal("OptionPrice");                   

?>

Did this help? Tips are appreciated...

8/16/2017 12:15 pm | #3 Christopher WestCommunity Expert

Thank you Ray, I appricate the help. I am a little wiry of these code changes I am making, but are essential as the more recent ecommerce code I created a while ago is more robust and easier to maintain. The code is pretty easy to adapt but of course the only challenge is ensuring that the product options (custom code that you did for me) is updated to use MySQLi references...the next challenge would be to directly edit the eCart_PHP.php file manually and to add in all the product option code line by line. I no longer use Dreamweaver (I cancelled my subscription) so I am having to hand code using Brackets IDE. Scary stuff.

Chris

8/16/2017 1:21 pm | #4 Ray BorduinWebAssist

Good luck.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.