Firas Darwish

13 مارس 2021

بتاريخ 9 ساعات قال محمد الاهلي:

طيب بناء على كلام حضراتكم الاستعلام كان التالي


$main_page_query = $conn->query("SELECT clients.* FROM orders INNER JOIN clients ON orders.client_id = clients.id") or die($conn->error);

و ده الكود


<?php
while ($row = $main_page_query->fetch_assoc()) {

echo '
<tr>
<td class="text-center text-muted">' . $row['id'] . '</td>
<td>
<div class="widget-content p-0">
<div class="widget-content-wrapper">
<div class="widget-content-left mr-3">
<div class="widget-content-left">
<img width="40" class="rounded-circle" src="assets/images/clients/' . $row['image'] . '" alt="">
</div>
</div>
<div class="widget-content-left flex2">
<div class="widget-heading">' . $row['admin_id'] . '</div>
</div>
</div>
</div>
</td>
<td class="text-center">' . $row['progress'] . '</td>
<td class="text-center">
<div class="badge badge-warning"' . $row['general_info_id'] . '</div>
</td>
<td class="text-center">
<button type="button" id="PopoverCustomT-1"class="btn btn-primary btn-sm">التفاصيل</button>
</td></tr>';
											}
											?>

و واجهتني الاخطاء دي انه مش قادر يتعرف على المتغيرات


Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

استأذنكم تقولولي الخطأ فين مع الشكر

هل الاعمدة image, admin_id, progress, general_info_id موجودة في جدول clients ؟

بتاريخ 9 ساعات قال محمد الاهلي:

طيب بناء على كلام حضراتكم الاستعلام كان التالي


$main_page_query = $conn->query("SELECT clients.* FROM orders INNER JOIN clients ON orders.client_id = clients.id") or die($conn->error);

و ده الكود


<?php
while ($row = $main_page_query->fetch_assoc()) {

echo '
<tr>
<td class="text-center text-muted">' . $row['id'] . '</td>
<td>
<div class="widget-content p-0">
<div class="widget-content-wrapper">
<div class="widget-content-left mr-3">
<div class="widget-content-left">
<img width="40" class="rounded-circle" src="assets/images/clients/' . $row['image'] . '" alt="">
</div>
</div>
<div class="widget-content-left flex2">
<div class="widget-heading">' . $row['admin_id'] . '</div>
</div>
</div>
</div>
</td>
<td class="text-center">' . $row['progress'] . '</td>
<td class="text-center">
<div class="badge badge-warning"' . $row['general_info_id'] . '</div>
</td>
<td class="text-center">
<button type="button" id="PopoverCustomT-1"class="btn btn-primary btn-sm">التفاصيل</button>
</td></tr>';
											}
											?>

و واجهتني الاخطاء دي انه مش قادر يتعرف على المتغيرات


Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

Notice: Undefined index: image in C:\myserver\htdocs\kaka\index.php on line 139

Notice: Undefined index: admin_id in C:\myserver\htdocs\kaka\index.php on line 143

Notice: Undefined index: progress in C:\myserver\htdocs\kaka\index.php on line 148

Notice: Undefined index: general_info_id in C:\myserver\htdocs\kaka\index.php on line 150

استأذنكم تقولولي الخطأ فين مع الشكر

جرب الاستعلام التالي:

SELECT orders.*, clients.client_name FROM orders INNER JOIN clients ON orders.client_id =clients.id

13 مارس 2021

حسب المعايير القياسية المتبعة عالمياً, يعتبر دائماً اي request صادر من متصفح عبر كتابة الرابط او الضغط على رابط هو request من نوع GET

اما الانواع الاخرى مثل POST و PATCH وغيرها فهي ناجمة عن الضغط على زر Submit ضمن HTML Forms

لذلك فإما ان تكتب Route::get بدلاً من Route::post

او يمكنك انشاء دالة جديدة Route::get بنفس المسار ونفس دالة الـCallback وتبقي Route::post على حالها

او (الخيار الامثل) هو استخدام Route::any والذي يشير بقبول الـRequests من اي نوع سواء Post او Get او غيرها اذا كنت ترغب

13 مارس 2021

وعليكم السلام اخ محمد

عندما نحتاج لاستعلام معلومات من عدة جداول من قاعدة البيانات نستخدم عادة مايسمى بالـJoins

ويوجد لها 4 أنواع ولكل نوع استخدام مختلف حسب الحاجة

بالنسبة لسؤالك فالأنسب استخدام النوع Inner Join والذي من خلال نقوم بجلب معلومات من عدة جداول "وفق" عمود مرتبط بينهم

فإذا اردنا جلب كافة الطلبات واسم العميل لكل طلب

يوجد لدينا جدولين orders و clients

ويربط بينهما العمود client_id الموجود في جدول orders

ومايوافقه اي العمود id في جدول clients

فيكون الاستعلام كالآتي

SELECT orders.* , clients.client_name FROM orders
INNER JOIN clients ON orders.client_id = clients.id

والاستعلام السابق يقوم بجلب كافة الصفوف والاعمدة من جدول orders بالإضافة لعمود client_name من جدول clients

Firas Darwish

المساهمات

تاريخ الانضمام

تاريخ آخر زيارة

نوع المحتوى

ريادة الأعمال

البرمجة

التصميم

DevOps

التسويق والمبيعات

العمل الحر

البرامج والتطبيقات

آخر التحديثات

قصص نجاح

أسئلة وأجوبة

كتب

دورات

أجوبة بواسطة Firas Darwish

استخراج البيانات من اكثر من جدول mysql

منع ظهور خطأ عند طلب رابط من نوع post في لارافيل

استخراج البيانات من اكثر من جدول mysql

الرئيسية

تابعنا

دروس ومقالات

أسئلة وأجوبة

كتب

دورات

بطاقات هدية