mysql to mysqli

Hey Jason

Being a complete dope here and cant remember (or find) how to change this old mysql version

<?php echo(str_replace("http://", "", $row_RSName['ColumnName'])); ?>

to mysqli syntax.....and include https:// to be removed

many thanks

Jamie

in MySQL, the code for a recordset value is:

$row_RSName['ColumnName']

in MySQLi, the corresponding code would be:

$RSName->getColumnVal("ColumnName")

so your code would be:

<?php echo(str_replace("http://", "", $RSName->getColumnVal("ColumnName"))); ?>

to also remove https, create an array of the values to remove:

<?php echo(str_replace(array("http://",https://"), "", $RSName->getColumnVal("ColumnName"))); ?>

Thank you Jason....that's exactly what I thought but it doesn't work.....

I am using it in an <a href> to put a url in from the databse and to remove the http ot http a if the user has entered it.

If I make it just for http it shows the url and opens the page as it should,...adding in the 2nd parameter stops the link linking to the page

You can see it in action here: http://clients.motley.co.uk/wheels - if you look to the little logos at the bottom left of each page, 2 of them have a link associated with them but aren't working

it looks like there is a space between the http:// and the address what is the full code you are using for the link.

It's

<a href="http://
<?php echo(str_replace(array("http://","https://"), "", $SponsorLogos->getColumnVal("SponsorLogosURL"))); ?>
" target="_blank"><?php } ?><img src="images/sponsor-logos/<?php echo($SponsorLogos->getColumnVal("SponsorLogosImage")); ?>" width="" height="30"><?php if ("".($SponsorLogos->getColumnVal("SponsorLogosURL"))  ."" != "") { ?></a><?php } ?>

looks like you have the code on 2 lines.

change:

<a href="http://
<?php echo(str_replace(array("http://","https://"), "", $SponsorLogos->getColumnVal("SponsorLogosURL"))); ?>
" target="_blank">

to:

<a href="http://<?php echo(str_replace(array("http://","https://"), "", $SponsorLogos->getColumnVal("SponsorLogosURL"))); ?>" target="_blank"

so it's all one line

Hmmmm thought I had ... Currently on a tablet so it's hard to see.

Have just tested it and it works great....as ever thanks for your input

Have a great weekend

Jamie

you're welcome.