ilqcho

I will talk to them. Thanks a lot for your time and help :).

Actually yes.. I will try to explain it the best I can. I made this script becouse I am trying to migrate the registers of the table 'beneficios' to that API through the POST method, and I am doing it by loads of 500 registers per time (you can see an example of the data that I pass to the API REST at the top of this thread) as there are a lot of registers and I don't want to get TimeOut error at navigator. My client gave me access to his database so I could check if the data is being effectively loaded BUT when i run the script and check the database no data is being loaded and I am getting no errors at the script or at the POST method. Here is my full script file"index.php" (I commented the code so it is easier to read): <?php include 'config.php'; function api($url,$data) { //API REST $fields_string = http_build_query($data); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, "http://lumia.mx/proyectodata/api/$url.php"); curl_setopt($ch, CURLOPT_POST, true); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $resp = curl_exec($ch); curl_close($ch); echo "<p>server response: $resp</p>"; } //id of the promo $promo = 33; //number of registers to transfer per load $cant = 50; //to restart process if (isset($_GET['inicio'])) { $_SESSION['indexp'] = 0; api('clean',array('promo'=>$promo)); } if (isset($_SESSION['indexp'])) { for ($i=0;$i<10;$i++) { $ini = intval($_SESSION['indexp']); //registers to process during this load $registers = $sql->query("SELECT * FROM beneficios LIMIT $ini,$cant"); $_SESSION['indexp'] = $ini+$cant; //printing migration info echo "<p>ini: $ini / users: $registers->num_rows</p>"; $todos = array(); while ($user = $registers->fetch_object()) { //set of general data $data = array('id' => $user->id, 'participacion' => $user->participacion, 'beneficio' => $user->beneficio,'fecha' => $user->fecha, 'promo' => $promo); echo $sql->error; //added to an array for the data load array_push($todos,$data); } //call to API api('bulk',$todos); } ?> <script> //script for automatic reload setTimeout(function() { window.location.reload(); },10000); </script> <?php } else { echo 'session out'; } And this is my config.php file: <?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "golalazo_sites_golalazo"; // Create connection global $sql; $sql = new mysqli($servername, $username, $password, $dbname); session_start(); // Check connection if ($sql->connect_error) { die("Connection failed: " . $sql->connect_error); }else { echo "<p>Welcome to PHP</p>"; } ?> I will also attach an image of the database my client gave me (it is the one with id = 33). The column 'usuarios' should show the number of registers uploaded and there is only 1 at the moment (I really don't know why). Really sorry for the long post but I wanted you to see the big picture of what I am trying to do here.

Great, now I am getting this data from CURLOPT_VERBOSE but it seems there are no errors at the request: * Trying 2606:4700:3031::6815:4ce7:80... * Connected to lumia.mx (2606:4700:3031::6815:4ce7) port 80 (#0) > POST /proyectodata/api/bulk.php HTTP/1.1 Host: lumia.mx Accept: */* Content-Length: 5947 Content-Type: application/x-www-form-urlencoded * Mark bundle as not supporting multiuse < HTTP/1.1 200 OK < Date: Thu, 10 Nov 2022 16:25:43 GMT < Content-Type: text/html; charset=UTF-8 < Transfer-Encoding: chunked < Connection: keep-alive < Expires: Thu, 19 Nov 1981 08:52:00 GMT < Cache-Control: no-store, no-cache, must-revalidate < Pragma: no-cache < Set-Cookie: PHPSESSID=ecf9ae840373293c61f7fb0aedd10b12; path=/ < Vary: User-Agent < CF-Cache-Status: DYNAMIC < Report-To: {"endpoints":[{"url":"https:\/\/a.nel.cloudflare.com\/report\/v3?s=xWuIst400vHvKPQspvSApJk2f8Lm59TPKyqUdBm0dypSjst3yguydjV7pXMSJndNjMFr84v3EknKr03s77KsYEs%2FknIsdDGltEoVm%2BphykA2qOSPrN1LW%2BGRuEpMSjJWY1hi%2FXuyqQ%3D%3D"}],"group":"cf-nel","max_age":604800} < NEL: {"success_fraction":0,"report_to":"cf-nel","max_age":604800} < Server: cloudflare < CF-RAY: 76802549bbeaba71-EZE < alt-svc: h3=":443"; ma=86400, h3-29=":443"; ma=86400 < * Connection #0 to host lumia.mx left intact

Hi @kickenwould you mind giving me an example on how to enable CURLOPT_VERBOSE. I've been trying this way but i get no response: function api($url,$data) { //API REST $fields_string = http_build_query($data); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, "http://lumia.mx/proyectodata/api/$url.php"); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string); curl_setopt($ch, CURLOPT_VERBOSE, 1); $resp = curl_exec($ch); curl_close($ch); //var_dump($resp).'<br/>'; echo "<p>server response: $resp</p>"; }

Thanks for the info, I'm going to try it.

Hi, I'm trying to post some data to an API with curl. I always get '1' as response but the endpoint is not being called as my network console doesn't show anything. This is an example of my curl setup code: function api($url,$data) { //API REST $fields_string = http_build_query($data); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, "http://proyectodata/api/$url.php"); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string); $resp = curl_exec($ch); curl_close($ch); //var_dump($resp).'<br/>'; print_r($resp); } The `$data` variable contains an array like this one but larger: Array ( [0] => Array ( [id] => 6403 [participacion] => 13614 [beneficio] => cine [fecha] => 2018-04-16 12:27:44 [promo] => 33 ) [1] => Array ( [id] => 6404 [participacion] => 13612 [beneficio] => spor [fecha] => 2018-04-16 12:28:11 [promo] => 33 ) And when parsed with `http_build_query()` it converts to this type of data: 0%5Bid%5D=6653&0%5Bparticipacion%5D=6936&0%5Bbeneficio%5D=cine&0%5Bfecha%5D=2018-04-16+14%3A41%3A59&0%5Bpromo%5D=33&1%5Bid%5D=6654&1%5Bparticipacion%5D=3318&1%5Bbeneficio%5D=payp&1%5Bfecha%5D=2018-04-16+14% I am getting no errors here but the enpoint is never called as seen in the network console nor the data is being posted. I am printing the post response in the navigator (it shows multiple responses as I am calling the function multiple times)

Hello, I need to do a migration of data by posting it from my tables database to an API. I am trying to use curl for the REST setup. Here is an example of my code: <?php include 'config.php'; function api($url,$data) { //API REST $fields_string = http_build_query($data); print_r($fields_string); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, "http://proyectodata/api/$url.php"); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string ); $resp = curl_exec($ch); curl_close($ch); var_dump($resp).'<br/>'; } //id of the promo $promo = 33; //number of registers to transfer per load $cant = 50; if (isset($_SESSION['indexp'])) { for ($i=0;$i<10;$i++) { $ini = intval($_SESSION['indexp']); //registers to process during this load $registers = $sql->query("SELECT * FROM beneficios LIMIT $ini,$cant"); $_SESSION['indexp'] = $ini+$cant; //migration info echo "<p>ini: $ini / users: $registers->num_rows</p>"; $todos = array(); while ($user = $registers->fetch_object()) { //set of general data $data = array('id' => $user->id, 'participacion' => $user->participacion, 'beneficio' => $user->beneficio,'fecha' => $user->fecha, 'promo' => $promo); echo $sql->error; //added to an array for the data load array_push($todos,$data); } //call to API api('bulk',$todos); } ?> The $data variable contains the data I need to post to the API but when I check the network ar my programmers tool the API is never called. When I print_r the variable $fields_strin at my api() function I get the following warning message Warning: Undefined array key "indexp" on line 12. My config.php file has the database config plus the initialization of the session like this: session_start(); $_SESSION['indexp']; Sorry for the long post and code but I am new at PHP and was given this task with an example function (similar to this one that I edited) to do the migration.