PHP SQL වැඩකාරයො ඒන්න

[Tharakadj]

PHP SQL වැඩකාරයො ඒන්න

Machanla mata me query eka run karala me process eka wena ona. Price average ekak penana system ekak tiyenne SQL AVG use karane natuwa. data base eke data tiyenakota aulak natuwa penanawa. data empty unama NAN kiyala error ekak enawa.

$Select_total_earning1="SELECT SUM(ORDER_TOTAL_PRICE) FROM orders WHERE SP_ID='$userID' AND ORDER_STATUS='COMPLETED'";

$Select_total_orders="SELECT COUNT(ORDER_ID) FROM orders WHERE SP_ID='$userID' AND ORDER_STATUS='COMPLETED'";

$result_total_earning1=$conn->query($Select_total_earning1); $result_total_orders=$conn->query($Select_total_orders);

$rowprice = $result_total_earning1->fetch_assoc();
$roworder = $result_total_orders->fetch_assoc();

$tot_price=(float)$rowprice["SUM(ORDER_TOTAL_PRICE)"];
$tot_order=(float)$roworder["COUNT(ORDER_ID)"];
(mama metanata float kiyala dame pase eka hari giyet na)

$avg=$tot_price/$tot_order;
(meka tamai line 204)

echo $avg;

methiyenne error eka
"Warning: Division by zero in C:\xampp\htdocs\test\test1\test.php on line 204
Rs. nan

"

mama net eke search karama nam awe nan kiyane numeric value ekak nemei unama ena error ekak kiyala.

dana kenek help ekak karana. bump ekak wat dala yanna.

 

[kavindagk]

Machanla mata me query eka run karala me process eka wena ona. Price average ekak penana system ekak tiyenne SQL AVG use karane natuwa. data base eke data tiyenakota aulak natuwa penanawa. data empty unama NAN kiyala error ekak enawa.

$Select_total_earning1="SELECT SUM(ORDER_TOTAL_PRICE) FROM orders WHERE SP_ID='$userID' AND ORDER_STATUS='COMPLETED'";

$Select_total_orders="SELECT COUNT(ORDER_ID) FROM orders WHERE SP_ID='$userID' AND ORDER_STATUS='COMPLETED'";

$result_total_earning1=$conn->query($Select_total_earning1); $result_total_orders=$conn->query($Select_total_orders);

$rowprice = $result_total_earning1->fetch_assoc();
$roworder = $result_total_orders->fetch_assoc();

$tot_price=(float)$rowprice["SUM(ORDER_TOTAL_PRICE)"];
$tot_order=(float)$roworder["COUNT(ORDER_ID)"];
(mama metanata float kiyala dame pase eka hari giyet na)

$avg=$tot_price/$tot_order;
(meka tamai line 204)

echo $avg;

methiyenne error eka
"Warning: Division by zero in C:\xampp\htdocs\test\test1\test.php on line 204
Rs. nan

"

mama net eke search karama nam awe nan kiyane numeric value ekak nemei unama ena error ekak kiyala.

dana kenek help ekak karana. bump ekak wat dala yanna.

Mama hithanwa oya me dala thiyana queries SQL wala kisi awulak anthiwa wada karanwa athi kiyala

oya menna me dewal check kalada ?

1. $userID kiyana variable ekata pass karana value eka hari widiyata php walin capture wenawada kiyala (echo $userID wage use karala)

2. SQL and PHP wala data types baluwada ? (Ex : $userID kiyana eka SQL wala int ekak thiyeddi oya php walin String wage pass karaddi final output value eka NULL wennea puluwan kamk thiyanwa)


3. Mama recommend karanne isselllama value hard cord karala PHP code eka test karanne , then parameters pass karala try karanne

Select_total_orders="SELECT COUNT(ORDER_ID) FROM orders WHERE SP_ID='100' AND ORDER_STATUS='COMPLETED'"


mama hithanwa me guidelines walin goda daganne labei kiyala , oyage SQL data thiyana widiya gana idea ekak nathiwa amarui bro help karanne

 

[Franklin EK]

..B U M P..​

 

[dot.Net]

tot_order = 0 wenna ati. 0 walin wena value divide karanna bane.

ekko if condition ekak dapan $tot_order != 0 walata. nathnam exception catch karapan.

 

[LazyLizard]

"data empty unama NAN kiyala error ekak enawa" ඩේට නැත්තන් ඉතින් අවුලක් වෙනවනේ නේද කොහොමත් NAN එන්නේ රිසල්ට් එකේ එක රෝ එකක්වත් නැතිවුනාම ලු

 

[Tharakadj]

Mama hithanwa oya me dala thiyana queries SQL wala kisi awulak anthiwa wada karanwa athi kiyala

oya menna me dewal check kalada ?

1. $userID kiyana variable ekata pass karana value eka hari widiyata php walin capture wenawada kiyala (echo $userID wage use karala)

2. SQL and PHP wala data types baluwada ? (Ex : $userID kiyana eka SQL wala int ekak thiyeddi oya php walin String wage pass karaddi final output value eka NULL wennea puluwan kamk thiyanwa)


3. Mama recommend karanne isselllama value hard cord karala PHP code eka test karanne , then parameters pass karala try karanne

Select_total_orders="SELECT COUNT(ORDER_ID) FROM orders WHERE SP_ID='100' AND ORDER_STATUS='COMPLETED'"


mama hithanwa me guidelines walin goda daganne labei kiyala , oyage SQL data thiyana widiya gana idea ekak nathiwa amarui bro help karanne

tot_order = 0 wenna ati. 0 walin wena value divide karanna bane.

ekko if condition ekak dapan $tot_order != 0 walata. nathnam exception catch karapan.

"data empty unama NAN kiyala error ekak enawa" ඩේට නැත්තන් ඉතින් අවුලක් වෙනවනේ නේද කොහොමත් NAN එන්නේ රිසල්ට් එකේ එක රෝ එකක්වත් නැතිවුනාම ලු

hari machan if ekak dala wade goda dagatha thanx. aula enne data base empty ekata.
thanks udau kara seratama.