Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>they may be handing you a session cookie upon first pageload</p> <p>try making a request with CURLOPT_COOKIEJAR and then make the login request using CURLOPT_COOKIEFILE and CURLOPT_COOKIEJAR</p> <p>also for the hell of it, this is a function i make to make requests look cleaner</p> <pre><code>function curl_http_request ($url, $options) { $handle = curl_init($url); curl_setopt_array($handle, $options); ob_start(); $buffer = curl_exec($handle); ob_end_clean(); curl_close($handle); return $buffer; } </code></pre> <p>example of use</p> <pre><code>$options = array( CURLOPT_RETURNTRANSFER =&gt; TRUE ); curl_http_request($url, $options); </code></pre> <p>this should work</p> <pre><code>// set global curl options $curloptions = array( CURLOPT_USERAGENT =&gt; 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6', CURLOPT_TIMEOUT =&gt; 60, CURLOPT_COOKIEJAR =&gt; $cookie, CURLOPT_COOKIEFILE =&gt; $cookie, CURLOPT_REFERER =&gt; 'http://www.meetup.com/' ); // set userinfo $username = 'bobsmit@gmail.com'; $password = 'bobsmit@gmail.com'; $cookie = 'cookie.txt'; // clear cookie.txt (fresh session) $handle = fopen($cookie, 'w'); fclose($handle); // make a dummy request to generate a session curl_http_request('http://www.meetup.com/login/', $curloptions); // login curl_http_request('http://www.meetup.com/login/', array( CURLOPT_POSTFIELDS =&gt; 'email=' . urlencode($username) . '&amp;password=' . urlencode($password) . '&amp;rememberme=on&amp;submitButton=Login&amp;returnUri=http%3A%2F%2Fwww.meetup.com%2F&amp;op=login', CURLOPT_POST =&gt; TRUE ), $curloptions ); //example request echo curl_http_request('http://www.meetup.com/account/', array( CURLOPT_FOLLOWLOCATION =&gt; TRUE, CURLOPT_RETURNTRANSFER =&gt; TRUE ), $curloptions ); function curl_http_request ($url, $moreoptions = array(), $options = array()) { foreach ($moreoptions as $k =&gt; $v) $options[$k] = $v; $handle = curl_init($url); curl_setopt_array($handle, $options); ob_start(); $buffer = curl_exec($handle); ob_end_clean(); curl_close($handle); return $buffer; } </code></pre> <p>hope this one works :)</p>
    singulars
    1. This table or related slice is empty.
    1. POLogging in to meetup.com with Curl
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USChad Scira
    1. USChad Scira
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks Chad, I tried (at least I think I did it correctly) to add the line you suggested but no joy. I would be very grateful if you can perhaps try it out for yourself with www.meetup.com and let me know if you can get it to work. Thanks so much!
      singulars
      1. PO
      1. USJonathan Lyon
    2. COthe above works for me, like i said they use a session. So to successfully login you will need to make a dummy page request with CURLOPT_COOKIEJAR file set to make the site give you session cookies. Then actually post a login. :)
      singulars
      1. PO
      1. USChad Scira
    3. COHi Chad - awesome! That worked a treat with one smallish issue. when I try and navigate to another page it loses the login. Is there a way to retain the login status? For example I run the script from http/mydomain.com/testlogin.php which is successful and displays the meetup page but if I click on a link it goes to http://meetup.com/link-I-clicked but not with me logged in. Any ideas? I really appreciate the help!
      singulars
      1. PO
      1. USJonathan Lyon
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload