get_charset_collate();
$wpdb->query(“CREATE TABLE IF NOT EXISTS {$wpdb->prefix}siparisler (
id INT AUTO_INCREMENT PRIMARY KEY,
tarih DATE,
sube VARCHAR(100),
urun VARCHAR(150),
adet INT,
tutar DECIMAL(10,2)
) $charset”);
$wpdb->query(“CREATE TABLE IF NOT EXISTS {$wpdb->prefix}irsaliyeler (
id INT AUTO_INCREMENT PRIMARY KEY,
siparis_id INT,
irsaliye_no VARCHAR(50),
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
) $charset”);
});
/* FRONTEND SHORTCODE */
add_shortcode(‘siparis_formu’, function () {
if (isset($_POST[‘siparis_gonder’])) {
global $wpdb;
$wpdb->insert(
$wpdb->prefix . ‘siparisler’,
[
‘tarih’ => date(‘Y-m-d’),
‘sube’ => sanitize_text_field($_POST[‘sube’]),
‘urun’ => sanitize_text_field($_POST[‘urun’]),
‘adet’ => intval($_POST[‘adet’]),
‘tutar’ => floatval($_POST[‘tutar’])
]
);
$siparis_id = $wpdb->insert_id;
$wpdb->insert(
$wpdb->prefix . ‘irsaliyeler’,
[
‘siparis_id’ => $siparis_id,
‘irsaliye_no’ => ‘IRS-‘ . time()
]
);
echo “
Sipariş alındı
“;
}
ob_start(); ?>
get_results(”
SELECT s.*, i.irsaliye_no
FROM {$wpdb->prefix}siparisler s
LEFT JOIN
