Jump to content

Tejpal

Members
  • Posts

    33
  • Joined

  • Last visited

Posts posted by Tejpal

  1. How To show category wise posts using custom fields

     

    i am use acf plugin and i want show custom fields page i have 3 custom fields 1 album 2 artist 3 lyrics and 2 category 1st remix 2nd top song

    i want creat deffrant page for all 3 fields

    like 1st page album where i can show all album with 1st category with paging

    See Below Attached file For Best Understanding

    post-183068-0-26077900-1467724520_thumb.jpg

  2. Done


    <?php

    $pst = date('m');


    if($pst>4) {

    $y=date('Y');

    echo $dtt=$y."-04-01<br/>";

    $pt = date('Y', strtotime('+1 year'));

    echo $ptt=$pt."-03-31";

    }

    else {

    $y=date('Y', strtotime('-1 year'));

    echo $dtt=$y."-04-01<br/>";

    $pt =date('Y');

    echo $ptt=$pt."-03-31";

    }

    ?>


  3. Hello Every One

    I Want Show all USer last Useges Data From date of Last Recharge to To Date and condition With user owner by

     

    i Have 3 Table

    invoice - Need data from column date(need last invoice Last Recharge date For Below Table Condition Start ),username( Uniq In all table)

    acct - > Need data from column acctstarttime( For Start Date ),SUM( acct.acctinputoctets + acct.acctoutputoctets ) AS data(For Sum Of Useges Data ),SUM( acct.acctsessiontime ) AS acctsessiontime,username(Uniq In all table)

    users - > Need data from column username( Main Table Match username on this table base),owner,lastlogoff,expiration,uptimelimit,comobolimit,

     

    My Code is Here But Not working

    SELECT DATE( `acctstarttime` ) AS acctstarttime, SUM( acct.acctinputoctets + acct.acctoutputoctets ) AS data, acct.username, SUM( acct.acctsessiontime ) AS acctsessiontime, users.username, users.owner, users.lastlogoff, users.expiration, users.uptimelimit, .comblimit, users.enableuser,invoices.date
    FROM invoices,acct
    JOIN users ON acct.username = rm_users.username
    WHERE users.owner = 'admin' and acctstarttime between 'invoice.date' and 'users.expiration'
    GROUP BY MONTH( `acctstarttime` ) , acct.username
    ORDER BY invoices.date DESC
    LIMIT 0 , 30
    I Think Problem in Where condition i want acctstarttime between 'invoice.date(Desc or User last recharge Date)' and 'users.expiration'
    I m very Confused How I dow Any One Can Help Thanks in Extra
  4. Hello everyone

    I want Show Some Recorded according financial year

    For Example from 01-04-2016 to 31-3-2017

    01-04-2017 to 31-03-2018

    my Code

     

    $pst = date('Y');
    $pt = date('Y', strtotime('+1 year'));

    $sql="SELECT *FROM mytable where date BETWEEN CAST('$pst-04-01' AS DATE) AND CAST('$pt-03-31' AS DATE)";

     

    Anyone Can explain how i done this

  5. I want to show online user in my project where 2 field in mysql table

    1st onlinestoptime and 2nd onlinestarttime

    when user login and online show in mysql onlinestoptime value null

    and onlinestarttime value is timestamp (show time when user online like 09/04/2016 12:01:02)

    my code here but not working

    so How i done and show online user

    <?

    date_default_timezone_set('Asia/Kolkata');
    $dt=date('Y-m-d h:i:s ');
    echo $sql="SELECT *FROM mytable where onlinestoptime like '%%' and onlinestarttime<'$dt' ";
    $val=mysql_query($sql);
    ?>
    Thanks in advance
  6. Hello Everyone

     

    I M in Problem i Am creat my 1st project for client so plesese help me that how i done

    i need how i calculate field in php

    like this Pic total of Credit total of debit and pending balance and grand total

    So tell Me how i done

    Below i attecthed

    example.jpg

  7. You need to configure MySQL to allow remote connections, make sure that firewalls aren't going to block anything, and then you can connect with the IP or host name.

    Thanks Dear justsomeguy Sir plz fully describe its becuase its not on any other compny used server its my local server made by me so plz tell me how i done all its

  8. Hello Every one I need help plz help me

    How i done this

    User can Pay Half payment in WooCommerce and user can edit payment before pay

    exam any item prince 600rs user can edit for payment 500 pending 100rs user can payment aftr 30day etc

    and User my acount show All transection credit or debit total and Show Pending Ammount etc

     

    Plz help me

×
×
  • Create New...