date search

in the full code, i we combined both magento + php code to display all rows, but i need to get "number of rows count" by php code..... sorry i am new to this coding world.....

Vijaya Vignesh Kumar

ok no problem

echo the $order in your code and paste the output here

abcd

okay

i am gettting "Notice: Undefined variable: order " when i tried "echo $order;" at end of the file

Vijaya Vignesh Kumar

no echo the order after the end of following code line
$order = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('designer_id', array(
'nin' => '0'
));

abcd

sorry , i treid as you said , but it didt displayed any results......

Vijaya Vignesh Kumar

ok

i got

order is an array so

after this line

foreach($order as $orderData)

sorry sorry

before this line

abcd

7:26 AM

okay

Vijaya Vignesh Kumar

foreach($order as $orderData)

print_r($order);exit;

abcd

i tried, now table disappeared

link

Vijaya Vignesh Kumar

delete the exit;

abcd

okay

deledted exit, still table not displaying

Vijaya Vignesh Kumar

try this

var_dum($order);

sory var_dump($order);

abcd

7:31 AM

same result when i used var_dump($order); - table disappeared

if you see [link](http://sbdev2.kidsdial.com:81/php/site6/orders1.php) you can see multiple columns in table.

until column " DEsigner" its fetching values from "magento db" & and other columns resuts fetching from "php db"

Vijaya Vignesh Kumar

ok man

abcd

if i try this code , i can able to display all values from "order_details" table : w3schools.com/php/showphpfile.asp?filename=demo_db_select_oo

w3schools.com/php/showphpfile.asp?filename=demo_db_select_oo

Vijaya Vignesh Kumar

do you have the query that you fetching the records from php db

abcd

yes, just a min

$stmt = $user_home->runQuery("SELECT * FROM order_details");
$stmt->execute(array(":uid" => $_SESSION['userSession']));
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$stmt->execute();

Vijaya Vignesh Kumar

yeah correct

now replace the following query

SELECT *,count( * ) as Total_count FROM order_details

abcd

7:37 AM

is this correct ?

$stmt = SELECT count( * ) as Total_count ,* FROM order_details;

$stmt = SELECT *,count( * ) as Total_count FROM order_details;

Parse error: syntax error, unexpected ','

Vijaya Vignesh Kumar

$stmt = $user_home->runQuery("SELECT *, count( * ) as Total_count FROM order_details");

abcd

updated your code and hided below lines

//print_r($order);
//var_dum($order);

table displaying

Vijaya Vignesh Kumar

yeah

have you got the result

abcd

no of rows : not displaying

Vijaya Vignesh Kumar

go to localhost/phpmyadmin

and select your db

abcd

7:40 AM

okay i will send scrrenshot

Vijaya Vignesh Kumar

ok

execute this query in phpmyadmin

SELECT *, count( * ) as Total_count FROM order_details

abcd

i got above result

Vijaya Vignesh Kumar

wait a min

ok dude i got it

abcd

okay

Vijaya Vignesh Kumar

group by dorder_id at the end of the query

SELECT *, count( * ) as Total_count FROM order_details group by dorder_id

abcd

7:47 AM

i want to inform from and to date results are coming with respect to "ORderDate" column, "order date " column is in magento db , not in php db .....

Vijaya Vignesh Kumar

ok

can you increment the value?

abcd

soory, i didt got......

is i need to try this : UPDATE order_details SET ID = ID + 1; ?

lunch break now, please be here.... i will come at 2.30......

Vijaya Vignesh Kumar

8:06 AM

ok

Vijaya Vignesh Kumar

8:39 AM

i Have work so shall we chat in tonight ? after 10.pm?

Vijaya Vignesh Kumar

8:56 AM

Hi dude

i have one solution on same mysql query

select *,(SELECT count( dorder_id ) FROM order details) as Total_count from order details

it should count exactly what you want

so you can use Total_count in your code

yeah finally we got it

from this query you get the same count in each and every row while execute this query in phpmyadmin

congrats dude

abcd

hi, sory for delay, i went for lunch , i will try......

Vijaya Vignesh Kumar

its ok

now my lunch time starts

abcd

okay, you can carry on......

Vijaya Vignesh Kumar

but now i'm waiting for the result

just excute and share the screenshot here

right now..

abcd

syntax error

i am tryingto resolve

Vijaya Vignesh Kumar

9:04 AM

what the error

abcd

select *,(SELECT count( dorder_id ) FROM order details) as Total_count from order details;

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order details) as Total_count from order details' at line 1

Vijaya Vignesh Kumar

SELECT *, (SELECT count( dorder_id ) FROM order details) as Tot FROM order details

abcd

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order details) as Tot from order details' at line 1

Vijaya Vignesh Kumar

wait a min

abcd

i replaced "Total" by "Tot",

okay

Vijaya Vignesh Kumar

9:08 AM

select *,(SELECT count( * ) FROM orderdetails) as Tot from orderdetails

hey man

check the table name

order_details

abcd

okay , sorry

Vijaya Vignesh Kumar

select *,(SELECT count( * ) FROM order_details) as Tot from order_details

abcd

got above result

Vijaya Vignesh Kumar

ok

done?

abcd

no i want to display in site - count

Vijaya Vignesh Kumar

9:10 AM

ok

abcd

please help me for that

Vijaya Vignesh Kumar

you can get the value of this

how you get and display the records from this table?

same as you can do

abcd

but number of count is more right ? because all rows are fetching from magento db.....

now we are trying query in php db

Vijaya Vignesh Kumar

get the value of Tot column after the query execution

abcd

can you please tell what code i need to modify ?

Vijaya Vignesh Kumar

9:14 AM

what are the values you passing in the arrays

abcd

$orderData->getIncrementId() ,
$orderData->getIncrementId() ,
$orderitemsarray[$k],
$productdetail->getName() ,
$designerName,
$orderData['status'], // magento [ pending / processing/complete]
$orderData['grand_total'], // magento
$orderData['customer_email'], // magento
$commission,
$paid_status,
$delivery_status,
$due_date,
$sDate // mage

Vijaya Vignesh Kumar

ok let us continue at 5p.m

abcd

okay sure, thanks .......

Vijaya Vignesh Kumar

its ok

you from?

abcd

bangalore......

Vijaya Vignesh Kumar

9:16 AM

home town?