mysql - cURL and PHP displaying "1" -


i have php script want read servers database , connect them curl. servers responds results sql query. problem script after each respond server displays number 1. ouput looks this:

server 1: results

1server 2: results

1server 3: results

1

here code reads servers database , connects them:

<?php  $mysql_id = mysql_connect('localhost', 'ms', 'pass'); mysql_select_db('servers', $mysql_id); mysql_query("set names utf8");  $query = "select * svr"; $result = mysql_query($query); $num = mysql_num_rows($result); while ($data = mysql_fetch_assoc($result)) {     $server[] = $data; }  mysql_close($mysql_id);  $i = 0; while($i < $num) {     $dealer = $server[$i]['dealer'];      echo $dealer . "<br />";      $data = "val=a"; //just testing                                                                          $ch = curl_init();     curl_setopt($ch, curlopt_url, $url);     curl_setopt($ch, curlopt_customrequest, "post");                                                                          curl_setopt($ch, curlopt_postfields, $data);         curl_setopt($ch, curlopt_httpheader, array(                                                                                                                                                                'content-type: text/html; charset=utf-8')                                                                            );                                                                                                                                                                                         $result = curl_exec($ch);     echo $result;     $i++; }  ?>

i discovered 1 displayed "echo $result;" , code creating response this:

<?php  $mysql_id1 = mysql_connect('localhost', 'ms', 'pass'); mysql_select_db('servers', $mysql_id1); mysql_query("set names utf8");      $query2 = "select * data";     $result2 = mysql_query($query2);     $num2 = mysql_num_rows($result2);     while ($data2 = mysql_fetch_assoc($result2))     {         $deli[] = $data2;     }     $i1 = 0;     $space = "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";     while ($i1 < $num2) {         echo $space . $deli[$i1]['id'] . " ";         echo $deli[$i1]['artikel'] . " ";         echo $deli[$i1]['znamka'] . " ";         echo $deli[$i1]['model'] . " ";         echo $deli[$i1]['letnik'] . " ";         echo $deli[$i1]['cena'] . " € ";         echo $deli[$i1]['zaloga'] . "<br />";         $i1++;     }     echo "<br />";     mysql_close($mysql_id1); ?>

please me

use curlopt_returntransfer option. otherwise curl automatically echo data , return true (which converted 1 echo).

curl_setopt($ch, curlopt_returntransfer, true);

Comments

Post a Comment

Popular posts from this blog

jquery - Invalid Assignment Left-Hand Side -

i trying assign class tag via jquery, resulting in error through firebug says "invalid assignment left-hand side" on fourth line below. <cfoutput> $('.pngfix a').each(function(index) { var hreflink = $(this).attr("href"); if (hreflink.tolowercase() = '../audio.cfm') { $(this).addclass('audioimg'); } }); </cfoutput> looking around online, looks syntax problem, don't seem see it... any tips? thanks if (hreflink.tolowercase() = '../audio.cfm') that attempts assign value, rather check equality. change = operator == .
Read more

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more