Jump to content

themistral

Members
 View Profile  See their activity

  • Posts

    301

  • Joined

  • Last visited

 Content Type 

Posts posted by themistral

    Rewrite Url But Keep One Querystring Parameter

    in Apache HTTP Server

    Posted · Edited by themistral

    Hi guys,

     

    I'm working on an old version of osCommerce with a mod that rewrites URLs to SEO friendly ones.

    This is not a site I have built and as such am unfamiliar with the mod.

     

    .htaccess is setup with the following rewrite rule:

    RewriteRule ^(.*).html$ root.php?$1.html&%{QUERY_STRING}

     

    This works absolutely fine, except for the fact that when we use this from Adwords, we lose the gclid which means that conversion data is being lost.

     

    Is there a way to check for the gclid parameter and parse that as a query string?

     

    I was thinking something like

    RewriteCond %{QUERY_STRING} (^|&)gclid($|&)
RewriteRule ^(.*).html?{QUERY_STRING}$ root.php?$1.html&%{QUERY_STRING} [QSA]

    I've tried this but it's not working.

     

    Utlimately want I want to achieve is

    page_uri.html?gclid=status

     

    Is this even possible, and if so, can someone point me in the right direction?

     

    Thanks :happy-04:

    Google Merchant Centre feed

    in PHP Coding Help

    Posted

    Hi guys,

     

    I am using PHP to create an XML data feed for Google Merchant Centre.

     

    However, the database contents are stored as ISO-8859-1 but the GMC feed needs to be in UTF8 (as far as I can tell).

    It works fine if I leave the description out, but when I add in the description, the feed fails.

     

    I am presuming this is because of the difference in character encoding.

     

    I've tried utf8_encode and iconv, neither of which worked.

     

    There are characters such as bullets in the description so could this be the problem?

     

    Can someone please point me in the right direction to solve this?

    Thanks!

    REDIRECT_URL vs REQUEST_URI

    in PHP Coding Help

    Posted

    Hi guys,

     

    I'm having a strange problem.

    I'm working on somebody else's website and they track every page that is visited for their own records, using their own script.

    Fine. The script currently uses $_SERVER['REDIRECT_URL'] and records everything fine.

     

    Each page is dynamically generated so the pages do not physically exist on the server.

     

    The problem comes with a custom 404 page.

    Currently, the htaccess is set to redirect back to the homepage if the page is not found.

     

    I have setup a custom 404 page and changed the htaccess file to reflect that, and even when the website is showing a valid page, the tracker records it as the custom 404 page.

     

    I tried changing the tracking script to use $_SERVER['REQUEST_URI'] but the same is still happening.

     

    Can anyone shed any light on why a page might be showing correctly to the user, but the webserver thinks the request is generating a 404 error?

     

    Thanks  :)

    Rewrite old URLs

    in Apache HTTP Server

    Posted

    Hi guys,

     

    I am working on a website whereby the URL structure has changed, and these old urls are still showing up in Google.

    I therefore would like to create an .htaccess rule to redirect them.

     

    The new URLs are created via PHP and the whole lot is parsed to a querystring, so I can't just take the parts I need and create a new rule.

    index.php?url=dir/the-new-url&id=1

     

    The old URL structure was

    /item1-item2-item3-item4-item5.html

    The new URL structure is

    /item4/item1-item2-item3-item5.html

     

    Ideally I would like to check if the GET[id] variable is equal to 1, then rewrite the rule

    RequestMethod GET 
RewriteRule ^(.*)/(.*)-(.*)-(.*)-(.*).html$ $2-$3-$4-$1-$5.html

     

    Obviously, all this is going to do is check if there are GET variables, and I've no idea if my rule would even work.

    How do I check the value of GET[id]?

     

    I am going along the right path, or is regex going to be needed...?

     

    If someone could point me in the right direction, that would be great!  :D

    Complex SQL statement

    in MySQL Help

    Posted

    Thanks JustLikeIcarus,

     

    This looks promising!

    It works brilliantly for one set of case statements.

    However, I need to use 6 of these statements in order to combine various other columns.

     

    Is this something I can do?

    I've tried using a comma after the END but it produces an error.

    Complex SQL statement

    in MySQL Help

    Posted

    Hi guys,

     

    I am trying to create a query and could do with some direction.

     

    SELECT id FROM table

     

    Nice and easy right?

     

    Well, here comes the hard bit!

    There are numerous columns within the table. They are essentially boolean values.

    I need to export data from these columns but the mapping has changed from how it used to be.

     

    Before, it was one column mapped to one export column.

    Now the mapping requires that a true value from any of 4 columns could produce a true export value in one column.

     

    e.g a query result of

    id

    col1

    col2

    col3

    col4

    1

    [/td]

    true

    used to produce an export file of

    id

    col1

    col2

    col3

    col4

    1

    true

    [td]

    Now it needs to produce an export file of

    id

    new_col

    1

    true

     

    I have tried

    SELECT id, (SELECT col1 FROM table UNION SELECT col2 FROM table UNION SELECT col3 FROM table UNION SELECT col4 FROM TABLE) as new_col FROM table

    but I get the error

    Subquery returns more than 1 row

     

    I hope I've explained what I need to achieve clearly enough.

    Any direction anyone can offer would be greatly appreciated - even if you tell me what I'm trying to do is not possible in one query.

     

    Thanks  :D

    Robots.txt order

    in PHP Coding Help

    Posted

    Cheers .josh

     

    That's great to know as it explains a few things!

    They implemented this as they were getting hammered by bots - it's an ecom site so I would guess a shopping bot was the problem.

     

    Yep I know bad bots will ignore robots.txt, and some pages of the site are included in Google's index, so I would guess that at best, the robots.txt file is confusing bots at the moment.

    Robots.txt order

    in PHP Coding Help

    Posted

    Hi guys,

     

    I am evaluating a site currently and the Robots.txt file has the following code:

    User-agent: Googlebot
Allow: /

User-agent: Slurp
Crawl-delay: 120
Allow: /

User-agent: Msnbot
Allow: /

User-agent: ia_archiver
Allow: /

User-agent: *
Disallow: /

     

    I use a tool to check various things and it flagged up that robots was disallowing bots.

     

    I would like to check if the order makes any difference - does that final command override the bot-specific rules?

     

    Thanks  :D

    Exclude root domain from trailing slash code

    in Apache HTTP Server

    Posted

    Hi guys,

     

    I need some help with a redirect.

     

    I currently have the following to add a trailing slash to the end of my URL.

     

    RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} !^(.*)/$
RewriteCond %{REQUEST_URI} !^(.*).(css|CSS|js|JS|png|PNG|jpg|JPG|jpeg|JPEG|gif|GIF|zip|ZIP|xml|XML|pdf|PDF|html|HTML|php|PHP|txt|TXT)$
RewriteRule ^(.*)$ /$1/ [QSA,R=301,L]

     

    This works fine.

     

    However, when using the google UTM code appended to the homepage, the URL breaks, so I need to remove the trailing slash.

    I've tried a number of things but nothing is working.

     

    Can anyone advise how I exclude the homepage in the above code?

     

    I was thinking

    RewriteCond %{REQUEST_URI} !^$

    but that's not working

    Worldpay callbacks

    in PHP Coding Help

    Posted

    Hi guys,

     

    This is driving me mad, and I'm wondering if it will be resolved when I set the site live.

     

    I have a form with a hidden field containing the callback URL. The form is submitted to Worldpay.

     

    I am creating a new site in Wordpress although the callback file is a normal php file (ie not Wordpress).

    However, a successful payment results in staying at the standard Worldpay success pay instead of redirecting to the callback.

    This is being hosted on a temporary domain.

     

    I've tried the following combinations:

    Form on temp website to callback on current site - works OK.

    Form on temp website to callback on temp site - callback doesn't work.

    Form on current website to callback on current site - works OK.

    Form on current website to callback on temp site - callback doesn't work.

     

    If I take the form and put it on the domain I will be using, the callback seems to operate as I would expect.

     

    The other thing is that currently the site is on a dedicated server, and the temporary site is on a shared server - and will be staying there.

     

    Is this something that sounds like it will be resolved when the new site is hosted on the proper domain?

     

    Thanks!

    Check if shell_exec is successful

    in PHP Coding Help

    Posted

    Hi guys,

     

    I'm running the following code:

    $result = shell_exec("su user; scp /path/to/file/text.txt  user@domain:/path/to/file/text.txt");

     

    Now, the file get's transferred correctly.

    However, I need to put in place a check to check if the transfer was successful.

     

    $result seems to return the same whether the transfer was successful or not.

     

    I want to send an email to state whether the file transfer was successful so what do I need to do to check this?

     

    Thanks!

    PHP above the root

    in PHP Coding Help

    Posted

    Hi guys,

     

    I've got a simple script that I'm running from a folder above the root (as a cron job).

     

    I've tried the script in the httpdocs folder and it works fine.

     

    mail('email@example.com', 'Before include', '', 'From:<email@example.com>');

// include the myriad class
include($_SERVER['DOCUMENT_ROOT'].'/path/to/class');

mail('email@example.com', 'After include', '', 'From:<email@example.com>');

// initiate and instance of our class
$obj = new class_name;

$email = $obj->email;

$file = $obj->file_name;

mail('email@example.com', 'End of file', $email.' & '.$file, 'From:<email@example.com>');

     

    If I run this file in httpdocs, it's fine and I get all emails.

     

    If I run this from 1 folder above the root (from a cron job), I get the first 2 emails but not the last one, suggesting that the include hasn't worked.

     

    Could this be a permissions problem?

    I have tried running the cron job as both root and apache and changed the owner/group of the script to match.

     

    Is there a reason why includes won't work above the root?

    Group BY and NOT IN

    in MySQL Help

    Posted

    OK I think I need to explain this a bit better.

     

    My data can contain the same details multiple times over.

    If an ID exists in tbl_processed that references one instance of a user, I don't want that user to show up again in my results.

     

    So, in my basic example, if ID 4 exists in tbl_processed, I don't want IDs 4 or 5 to be returned by my query because they are the same data.

     

    I hope that makes it a little clearer.

     

    Thanks!

    Group BY and NOT IN

    in MySQL Help

    Posted

    Hi there,

     

    I have 2 tables.

     

    tbl_data

    id

    email

    firstname

    lastname

    4

    email@example.com

    Lizbeth

    Salander

    5

    email@example.com

    Lizbeth

    Salander

     

    The second table just contains a record id. This record id relates to the record id in tbl_data

    tbl_processed

    id

    4

     

    I run a query to get the ids from tbl_processed and store them in an array

     

    So, the raw query I am running is

    SELECT * FROM tbl_data WHERE id NOT IN ('4') GROUP BY email, lastname, firstname;

     

    If I run this, id 5 is still returned.

     

    The behaviour I want to see is that if there is a matching ID in the grouping, no result is returned.

     

    I am not sure I am using the correct logic, and I hope this makes sense!

     

    Basically, I want to group my data, then if there are any matches in the NOT IN statement within that grouping, I don't want to return a result for that group.

    Sending data between servers

    in PHP Coding Help

    Posted

    Hi there,

     

    Everyday I run a php script on a database to extract certain information I need and save to a text file.

    I then need to be able to send this file to another server without needing for manual intervention.

    i.e. the script will integrate sending the file to another server.

     

    Can anyone point me in the right direction to get started?

     

    Thanks!

    Complex data required for SoapParams

    in PHP Coding Help

    Posted

    Hiya,

     

    I was cruising along with SOAP nicely until I needed to parse more complex xml in a soapcall.

    I am using non-wdsl if that makes any difference.

     

    I need to create XML in the following structure:

     

    <Body>
  <SOAP_updateCreateContactMarketingRule>
    <Contact_ID xsi:type="xsd:int">1</Contact_ID>
    <MarketingRule_ID xsi:type="xsd:int">1</MarketingRule_ID>
    <MarketingQuestions>
      <MarketingQuestion>
        <MarketingQuestion_ID xsi:type="xsd:int">1</MarketingQuestion_ID>
        <Answer xsi:type="xsd:string">No</Answer>
      </MarketingQuestion>
      <MarketingQuestion>
        <MarketingQuestion_ID xsi:type="xsd:int">2</MarketingQuestion_ID>
        <Answer xsi:type="xsd:string">Yes</Answer>
      </MarketingQuestion>
    </MarketingQuestions>
  </SOAP_updateCreateContactMarketingRule>
</Body>

     

     

    So, I set my parameters up as follows:

     

    $params[] = new SoapParam("1", "Contact_ID");

    $params[] = new SoapParam("1", "MarketingRule_ID");

    $params[] = new SoapParam(array("MarketingQuestion"=>array("MarketingQuestion_ID"=>1, "Answer"=>"Yes")), "MarketingQuestions");

     

    And I am getting the following XML generated when I use __getLastRequest()

     

    <SOAP-ENV:Body>
<ns1:SOAP_updateCreateContactMarketingRule>
	<Contact_ID xsi:type="xsd:string">1</Contact_ID>
	<MarketingRule_ID xsi:type="xsd:string">1</MarketingRule_ID>
	<MarketingQuestions SOAP-ENC:arrayType="ns2:Map[1]" xsi:type="SOAP-ENC:Array">
		<item xsi:type="ns2:Map">
			<item>
				<key xsi:type="xsd:string">MarketingQuestion_ID</key>
				<value xsi:type="xsd:int">8</value>
			</item>
			<item>
				<key xsi:type="xsd:string">Answer</key>
				<value xsi:type="xsd:string">Yes</value>
			</item>
		</item>
	</MarketingQuestions>
</ns1:SOAP_updateCreateContactMarketingRule>
</SOAP-ENV:Body>

     

     

    Clearly my third parameter is not set up correctly - can anyone help with this?

     

    Thanks  :D

    Jquery focus

    in Javascript Help

    Posted

    Hi guys,

     

    I am using jquery to add a class to an input box on a focus event.

     

    $('input').focus(function() {
$(this).addClass("focus");   
});

     

    It works but only if I tab to the input box - if I click in the box the code doesn't work.

    I've tried changing the code to

     

    $('input').click(function() {
$(this).addClass("focus");   
});

     

    but that isn't working either.

     

    Can anyone shed any light?

    PHP and SOAP

    in PHP Coding Help

    Posted

    The internal server has been setup and I have been given a list of SOAP calls with what is required and returned.

    Essentially, I don't need to know anything about that side of things.

     

    What I need to understand is how to use a SOAP call within the PHP website.

     

    I understand the concept of SOAP in that it is essentially an translating interface between 2 separate systems.

    I understand all the SOAP calls I've been given, but I don't understand how the hell PHP can use it.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.