Developer Community

Code. Debug. Build. Share.

Ask programming questions, share code, review projects, publish tutorials, and help other developers solve real problems.

Join the Community Browse Topics PS Pro Pricing 
// ProfoundSyntax
function community() {
  return [
    'ask',
    'learn',
    'build',
    'share'
  ];
}
Community Feed

Latest Discussions

New Hot Top Unanswered Following Saved
0
DiscussionDatabasesSQL

Parameterized queries in PHP, Python & Ruby: what is your default pattern for dynamic SQL?

0 replies

I work across PHP, Python, Ruby and plain SQL, and one thing I keep noticing in code reviews is that every stack has its own "safe" way to build queries, and people still end up concatenating strings when a query gets dynamic (search filters, ORDER BY, IN lists, etc.). [PSYOUTUBE|2eC8-9EnBPE] So I'm curious what everyone…

php
<?php
$stmt = $pdo->prepare('SELECT id, name FROM users WHERE email = :email');
$stmt->execute([':email' => $email]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
python
cur.execute("SELECT id, name FROM users WHERE email = ?", (email,))
user = cur.fetchone()
Join Discussion
0
QuestionWeb DevelopmentPHP

PHP API Request Times Out Even Though Endpoint Works

3 replies
php

<?php if (is_user_logged_in());

?>

I am trying to make a PHP request to an external API, but the request periodically times out even though the API endpoint itself appears to be online and responding normally when I test it directly. The problem does not happen on every request. Some requests complete in less than a second, while others wait…

php
<?php

$url = 'https://api.example.com/products';

$ch = curl_init();

curl_setopt_array($ch, [
    CURLOPT_URL => $url,
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_CONNECTTIMEOUT => 10,
    CURLOPT_TIMEOUT => 30,
    CURLOPT_FOLLOWLOCATION => true,
    CURLOPT_HTTPHEADER => <span class="text-token-text-primary cursor-text rounded-sm" data-placeholder-token="true">[
        'Accept: application/json',
    ]</span>,
]);

$response = curl_exec($ch);

if ($response === false) {
    echo 'cURL Error: ' . curl_error($ch);
} else {
    $data = json_decode($response, true);

    echo '<pre>';
    print_r($data);
    echo '</pre>';
}

curl_close($ch);
Join Discussion Answered
  1. c/Pancreas2 members
See more