a_bains

my second CURL POST is already there, echo curl_exec($ch); // process security question

I am trying to login to the website in the below example. This script logs in using a username and password but then is directed to a page with a security question. This is where the problem is, I am unable to POST my answer on this page. The result of my output is just the page with the security question. $username = 'XXXX'; $password = 'XXXX'; $loginUrl = 'https://www.dandh.ca/v4/dh'; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $loginUrl); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, 'Login='.urlencode($username).'&PW='.urlencode($password).'&Request=Login&formName=Login&jsEnabled=0&queryString=&Platform=Full&btLogin='.urlencode('Log In')); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1); curl_setopt($ch, CURLOPT_COOKIEJAR, "/tmp/cookies.txt"); curl_setopt($ch, CURLOPT_COOKIEFILE, "/tmp/cookies.txt"); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_exec($ch); // process main login curl_setopt($ch, CURLOPT_POSTFIELDS, 'securityAnswer=XXXX&Request=postForm&formName=loginChallengeValidation&btContinue=Continue'); echo curl_exec($ch); // process security question curl_close($ch); Here is the source code of the security question HTML form: <form name="securityForm" id="secForm" method="post" action="/v4/dh"> <input type="hidden" name="Request" value="postForm"><input type="hidden" name="formName" value="loginChallengeValidation"> <table border="0" align="center" cellpadding="10" cellspacing="0"> <tr> <td><span style="font-weight:bold;">Security Response</span> <br> <p> Please answer the following security question. Once the answer is confirmed you can continue. </p> <p style="margin-left: 20px;"> Question: What is the name of your best friend from childhood?</p> <p style="margin-left: 20px;"> Answer: <input type="text" id="securityAnswer" name="securityAnswer" size="50" maxlength="50"> </p> <p style="margin-left: 20px;"> <input type="submit" name="btContinue" value="Continue"> </p> <p> <i>If you do not know the answer to the security question, please email <a href="mailto:[email protected]">[email protected]</a> and they will send you a temporary password. <a href="/v4/dh?Request=postForm&formName=LogOut">Click here</a> to return to login page.</i> </p> </td> </tr> </table> </form>

Hello, I have 3 tables consisting of products from suppliers, I am trying to merge all my supplier tables into one table. In the merged products table every product should be unique (all having different mfgpartno). Some suppliers carry the same product having the same mfgpartno as another supplier. The merged products table needs to only have the product containing the lowest price of all the 3 tables. In example, I need the entire row of the product with the lowest price between all 3 tables in the merged table. Here is an example based on the table below, the product with mfgpartno HA-MODEMCOM from table #3 would end up in the merged products table because it has the lowest price of all. Table #1 +----------------------+--------------+--------------+-------------------------------+-------+------+-------+ | mfgpartno | manufacturer | vendorpartno | description | price | msrp | stock | +----------------------+--------------+--------------+-------------------------------+-------+------+-------+ | HA-MODEMCOM | Asrock | HA-MOD | ASROCK AMR MODEM/COM PORT | 6.3 | 0 | 0 | | DUAL LOW PROFILE BRA | Asus | DUAL-L | LOW PROFILE BRACKET SUPPORT | 9.6 | 0 | A | | AS/IO-PLATE | Asus | IO-PLA | ASUS UNIVERSAL IO PLATE | 12.6 | 0 | A | | 13-010041000 | Touch | K8N-DR | ASUS CPU RETENTION MODULE FOR | 16.1 | 0 | 0 | | 319110 | Touch | SILVER | ARCTIC SILVER 5 HEAT COMPOUND | 28.6 | 0 | A | +----------------------+--------------+--------------+-------------------------------+-------+------+-------+ Table #2 +----------------------+--------------+--------------+-------------------------------+-------+------+-------+ | mfgpartno | manufacturer | vendorpartno | description | price | msrp | stock | +----------------------+--------------+--------------+-------------------------------+-------+------+-------+ | HA-MODEMCOM | Asrock | HA-MOD | ASROCK AMR MODEM/COM PORT | 9.6 | 0 | 0 | | DUAL LOW PROFILE BRA | Asus | DUAL-L | LOW PROFILE BRACKET SUPPORT | 43.6 | 0 | A | | AS/IO-PLATE | Asus | IO-PLA | ASUS UNIVERSAL IO PLATE | 51.6 | 0 | A | | 13-010041000 | Touch | K8N-DR | ASUS CPU RETENTION MODULE FOR | 26.1 | 0 | 0 | | 319110 | Touch | SILVER | ARCTIC SILVER 5 HEAT COMPOUND | 18.6 | 0 | A | +----------------------+--------------+--------------+-------------------------------+-------+------+-------+ Table #3 +----------------------+--------------+--------------+-------------------------------+-------+------+-------+ | mfgpartno | manufacturer | vendorpartno | description | price | msrp | stock | +----------------------+--------------+--------------+-------------------------------+-------+------+-------+ | HA-MODEMCOM | Asrock | HA-MOD | ASROCK AMR MODEM/COM PORT | 4.2 | 0 | 0 | | DUAL LOW PROFILE BRA | Asus | DUAL-L | LOW PROFILE BRACKET SUPPORT | 63.6 | 0 | A | | AS/IO-PLATE | Asus | IO-PLA | ASUS UNIVERSAL IO PLATE | 41.6 | 0 | A | | 13-010041000 | Touch | K8N-DR | ASUS CPU RETENTION MODULE FOR | 26.1 | 0 | 0 | | 319110 | Touch | SILVER | ARCTIC SILVER 5 HEAT COMPOUND | 38.6 | 0 | A | +----------------------+--------------+--------------+-------------------------------+-------+------+-------+

Hello, I am new to Curl but I just have a simple question. The below script logs into a website and then downloads a PDF from the downloads folder. I have no problem building a login script and checking authentication on each php page but the downloads folder is different and could contain PDF files. I am wondering why I couldn't just download a PDF straight away without logging in. I want to know how I would go about protecting files like that. I have heard about .htaccess but I am unsure if that is what I should use. For my business I would like to give only my customers access to a file on my server requiring the same authentication as the login.php page (which would verify against a mysql database). I intend for them to use a script like below, but I am unsure of how to protect the downloads folder. Thanks! <?php // INIT CURL $ch = curl_init(); // SET URL FOR THE POST FORM LOGIN curl_setopt($ch, CURLOPT_URL, 'http://www.external-site.com/Members/Login.php'); // ENABLE HTTP POST curl_setopt ($ch, CURLOPT_POST, 1); // SET POST PARAMETERS : FORM VALUES FOR EACH FIELD curl_setopt ($ch, CURLOPT_POSTFIELDS, 'fieldname1=fieldvalue1&fieldname2=fieldvalue2'); // IMITATE CLASSIC BROWSER'S BEHAVIOUR : HANDLE COOKIES curl_setopt ($ch, CURLOPT_COOKIEJAR, 'cookie.txt'); # Setting CURLOPT_RETURNTRANSFER variable to 1 will force cURL # not to print out the results of its query. # Instead, it will return the results as a string return value # from curl_exec() instead of the usual true/false. curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); // EXECUTE 1st REQUEST (FORM LOGIN) $store = curl_exec ($ch); // SET FILE TO DOWNLOAD curl_setopt($ch, CURLOPT_URL, 'http://www.external-site.com/Members/Downloads/AnnualReport.pdf'); // EXECUTE 2nd REQUEST (FILE DOWNLOAD) $content = curl_exec ($ch); // CLOSE CURL curl_close ($ch); ?>