Jump to content

olliemaitland

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

olliemaitland's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hey - I'm a PHP developer and have a client who would like to issue certificates to use on the website. Is there a way, using the open_ssl library, to generate client certificates and to read certificates when a client installs them in their browser? I have experience using them in Apache but not generating them in PHP or detecting them within PHP. Does httpd pass on any environmental variables to PHP relating to the certificate? Many thanks and I hope I get some answers :)
  2. I wrote a query which uses the union statement to search two tables... $q = mysql_query("SELECT sku. * FROM sku, pgr WHERE MATCH ( pgr.title, pgr.description, pgr.keyword ) AGAINST ( \'".$_POST[\'q\']."\' ) AND sku.pgr=pgr.pgr UNION SELECT sku. * FROM sku, sgr WHERE MATCH ( sgr.title, sgr.description, sgr.keyword ) AGAINST ( \'".$_POST[\'q\']."\') AND sku.sgr=sgr.sgr "); then modified it to work on mysql < 4.0.0 to mysql_query("CREATE TABLE temp_union TYPE=HEAP (SELECT sku. * FROM sku, pgr WHERE MATCH ( pgr.title, pgr.description, pgr.keyword ) AGAINST ( \'".$_POST[\'q\']."\' ) AND sku.pgr=pgr.pgr)"); mysql_query("INSERT INTO temp_union (SELECT sku. * FROM sku, sgr WHERE MATCH ( sgr.title, sgr.description, sgr.keyword ) AGAINST ( \'".$_POST[\'q\']."\') AND sku.sgr=sgr.sgr)"); $q = mysql_query("SELECT * FROM temp_union"); mysql_query("DROP TABLE temp_union"); however this doesn\'t work on servers which are 3.23.55 when the full text searching was added on 3.23.23 can anyone see the problem?
×
×
  • 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.