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