converting mysql to mysqli

5/15/2019 9:50 pm | #1 Jamie

am just trying to convert some old code to mysqli (attached txt files) and pretty sure that the repeat regions on lines 6 and 22 are causing the page not to work but unsure what I should be replacing them with

Cheers

Jamie

Attached Files

mysql.txt

mysqli.txt

5/16/2019 12:02 pm | #2 Ray BorduinWebAssist

Yes. I think at this point you should probably just delete the old repeat region code and apply the MySQLi repeat region manually in its place.

So remove the first instance of the line:

php:

<?php do { ?>

and then remove the lines:

php:

<?php mysql_free_result($ProductOptions); //mysql_free_result($OptionGroups); ?>

              <?php } while ($row_OptionGroups = mysql_fetch_assoc($OptionGroups));

            mysql_data_seek($OptionGroups, 0);

            $row_OptionGroups = mysql_fetch_assoc($OptionGroups);?>

and select the code in-between and apply the mysqli repeat region using the OptionGroups recordset.

Then it looks like you also have a dynamic select list that wasn't updated to MySQLi. To fix that, delete this code:

php:

<?php do { ?>

                  <option value="<?php echo $ProductOptions->getColumnVal('OptionID')?>"<?php if (!(strcmp($lastSel, $ProductOptions->getColumnVal('OptionID')))) {echo "selected=\"selected\"";} ?>><?php echo $ProductOptions->getColumnVal('OptionName')?> <?php echo ($ProductOptions->getColumnVal('OptionIncrement')?" (+ £".(number_format($ProductOptions->getColumnVal('OptionPrice'),2)).")":""); ?></option>

                  <?php

} while ($row_ProductOptions = mysql_fetch_assoc($ProductOptions));

  $rows = mysql_num_rows($ProductOptions);

  if($rows > 0) {

      mysql_data_seek($ProductOptions, 0);

      $row_ProductOptions = mysql_fetch_assoc($ProductOptions);

  }

?>

Then highlight the select list and add dynamic attributes from the properties window to make the select list dynamically populated from the ProductOptions recordset. Just choose any column for the option title and value.

Once it is back on the page, then delete the <option> tag added and put back in your custom one by copying and pasting the value from before:

php:

<option value="<?php echo $ProductOptions->getColumnVal('OptionID')?>"<?php if (!(strcmp($lastSel, $ProductOptions->getColumnVal('OptionID')))) {echo "selected=\"selected\"";} ?>><?php echo $ProductOptions->getColumnVal('OptionName')?> <?php echo ($ProductOptions->getColumnVal('OptionIncrement')?" (+ £".(number_format($ProductOptions->getColumnVal('OptionPrice'),2)).")":""); ?></option>

I think that should fix the page.

Did this help? Tips are appreciated...

5/20/2019 1:39 pm | #4 Ray BorduinWebAssist

I found a few issues with missing brackets and I think a bad IF statement, but I think they are fixed now. Please download the page and test to see if everything works now with other products.

Did this help? Tips are appreciated...

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

converting mysql to mysqli

5/15/2019 9:50 pm | #1 Jamie