Jump to content

rajeshkr

Members
  • Posts

    37
  • Joined

  • Last visited

Posts posted by rajeshkr

  1. Hi,
    I want to capture the information below from all sessions (including buying sessions & non-buying sessions.) of a website.
    Please give me a suggestion that how to create a report in the backend that would allow us to pull this information for a certain time period. 

    Information to include:

    IP Address
    Device
    Operating System
    Operating System Version
    Browser
    Browser Version
    Entry Page
    Exit Page
    User Agent String

    Thanks

  2. Hi,

    I am just start using code igniter and i donot have much knowledge of it.

    I recently get a project to view built in codeigniter. i put this folder in www of wamp and start execution.

    first i got error related phpadmin i solved that but now i could not able to go further of this page message.

     

    "Welcome to CodeIgniter!

     

    The page you are looking at is being generated dynamically by CodeIgniter.

     

    If you would like to edit this page you'll find it located at:

    application/views/welcome_message.php

     

    The corresponding controller for this page is found at:

    application/controllers/welcome.php

     

    If you are exploring CodeIgniter for the very first time, you should start by reading the User Guide.

    ".

     

    I just want to know how to come out of this and start viewing my website pages.

     

    Thanks

    rkrathor

     

  3. hi,
    I am using fixed-header code for my table on vertical scroll, its working fine for all column name except last two (balance and pay status) because they are going out side page (horizontally). and when i scroll from bottom to see the last two columns values , the fixed header only show the columns till advance, fixed header not showing last two remaining columns that go out side page horizontally.
    Check the screen shots for better understanding.
    img-1 you can see all column till pay status.
     
    img -2 you can see vertical scroll working fine till advance column.
     
    Img -3 but in this you can see after full horizontal scroll towards right side, it only showing column till advance, instead of balance and pay status.
    Here is the full code 
     
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Untitled Document</title>
    <script language="javascript" type="text/javascript" src="js/jquery.min.js"></script>
    <script>
    $(document).ready(function()
    {
    function moveScroll(){
    var scroll = $(window).scrollTop();
    var anchor_top = $("#maintable").offset().top;
    var anchor_bottom = $("#bottom_anchor").offset().top;
    if (scroll>anchor_top && scroll<anchor_bottom) {
    clone_table = $("#clone");
    if(clone_table.length == 0){
    clone_table = $("#maintable").clone();
    clone_table.attr('id', 'clone');
    clone_table.css({position:'fixed',
    'pointer-events': 'none',
    top:0});
    clone_table.width($("#maintable").width());
    $("#table-container").append(clone_table);
    $("#clone").css({visibility:'hidden'});
    $("#clone thead").css({visibility:'visible', 'pointer-events':'auto'});
    }
    } else {
    $("#clone").remove();
    }
    }
    $(window).scroll(moveScroll);
    });
    </script>
    <style>
    thead {
    background-color:white;
    }
    </style>
    </head>
    <body>
    <div id="table-container">
    <table border="1" align="center" cellpadding="0" cellspacing="0" class="display" id="maintable">
    <thead>
    <tr class="heading">
    <td width="37" align="center">S.No.</td>
    <td width="56" align="center">Booking Date</td>
    <td width="55" align="center">Delivery Date</td>
    <td width="41" align="center">Order No.</td>
    <td width="65" align="center">Customer Name</td>
    <td width="47" align="center">Status</td>
    <td width="27" align="center">P.R.</td>
    <td width="40" align="center">Cover</td>
    <td width="25" align="center">Size</td>
    <td width="75" align="center">Accessories</td>
    <td width="32" align="center">Bag</td>
    <td width="50" align="center">Packing</td>
    <td width="39" align="center">Paper</td>
    <td width="61" align="center">Coating</td>
    <td width="32" align="center">G Total</td>
    <td width="54" align="center">Advance</td>
    <td width="48" align="center">Balance</td>
    <td width="57" align="center">Pay Status</td>
    
    </tr>
    </thead>
    
    <tr>
    <td>1</td>
    <td >12-02-2014</td>
    <td >16-02-2014</td>
    <td >1234</td>
    <td >Rajesh Kumar Rathor</td>
    <td >pending</td>
    <td >80</td>
    <td >ultra cover</td>
    <td >200</td>
    <td >Flip flop cover</td>
    <td >Jute bag</td>
    <td > Box packing</td>
    <td >Thick matt</td>
    <td > Matt lamination</td>
    <td >2000</td>
    <td >1000</td>
    <td >1000</td>
    <td >Paid</td>
    
    </tr>
    <tr>
    <td>1</td>
    <td >12-02-2014</td>
    <td >16-02-2014</td>
    <td >1234</td>
    <td >rkr</td>
    <td >pending</td>
    <td >80</td>
    <td >ultra cover</td>
    <td >200</td>
    <td >Flip flop cover</td>
    <td >Jute bag</td>
    <td > Box packing</td>
    <td >Thick matt</td>
    <td > Matt lamination</td>
    <td >2000</td>
    <td >1000</td>
    <td >1000</td>
    <td >Paid</td>
    
    </tr>
    <tr>
    <td>1</td>
    <td >12-02-2014</td>
    <td >16-02-2014</td>
    <td >1234</td>
    <td >rkr</td>
    <td >pending</td>
    <td >80</td>
    <td >ultra cover</td>
    <td >200</td>
    <td >Flip flop cover</td>
    <td >Jute bag</td>
    <td > Box packing</td>
    <td >Thick matt</td>
    <td > Matt lamination</td>
    <td >2000</td>
    <td >1000</td>
    <td >1000</td>
    <td >Paid</td>
    
    </tr>
    </table>
    <div id="bottom_anchor"></div>
    </div>
    
    </body>
    </html>
    

    Please check this and if found give me the solution for this.
    thanks in Advance

  4. hi,

    I am using fixed-header code for my table on vertical scroll, its working fine for all column name except last two (balance and pay status) because they are going out side page (horizontally). and when i scroll from bottom to see the last two columns values , the fixed header only show the columns till advance, fixed header not showing last two remaining columns that go out side page horizontally.

    Check the screen shots for better understanding.

    image-1 you can see all column till pay status.

     

    [ATTACH=CONFIG]64973[/ATTACH]

    image -2 you can see vertical scroll working fine till advance column.

    [ATTACH=CONFIG]64974[/ATTACH]

    Image -3 but in this you can see after full horizontal scroll towards right side, it only showing column till advance, instead of balance and pay status.

    [ATTACH=CONFIG]64975[/ATTACH]

     

    Here is the full code




    Untitled Document


    $(document).ready(function()
    {
    function moveScroll(){
    var scroll = $(window).scrollTop();
    var anchor_top = $("#maintable").offset().top;
    var anchor_bottom = $("#bottom_anchor").offset().top;
    if (scroll>anchor_top && scroll

    Please check this and if found give me the solution for this.

    thanks in Advance

    post-130533-99702_thumb.jpg

  5. hi,

    I have six tables each having a column field (order_no), now i want to match that something like this.

     

    1- select order_no from table 1 where order_no != with order_no present in all other six tables.

     

    Can any one suggest which join query or which query i should use to achieve this?

    thanks

  6.  

    But you are storing the same information to different table, just with different values. Table1, Table2 etc all have the same format.

     

    Or am I being misled by a poor naming in the question and they are supposed to be the press, prepress, postpress, qc, binding and dispatch (six) tables in your query? Why not say so if that is the case?

     

    Assuming that is the case the ambiguity is caused by your use of order_no in the WHERE clause without a qualifying table name. Don't use that syntax for table joins, use more efficient explicit joins

    SELECT order_no 
    FROM prepress
        INNER JOIN press ON press.order_no=prepress.order_no
        INNER JOIN postpress ON postpress.order_no=prepress.order_no
        INNER JOIN qc ON qc.order_no=prepress.order_no
        INNER JOIN binding ON binding.order_no=prepress.order_no
        INNER JOIN dispatch ON dispatch.order_no=prepress.order_no 
    
    

    thanks that's because there are several other value will be in all six tables. but these two values will be same to check.

    and i get the solution as you provide

    SELECT prepress.order_no 
      FROM prepress
    INNER
      JOIN press
        ON press.order_no = prepress.order_no 
    INNER
      JOIN postpress
        ON postpress.order_no = prepress.order_no 
    INNER
      JOIN qc
        ON qc.order_no = prepress.order_no 
    INNER
      JOIN binding
        ON binding.order_no = prepress.order_no 
    INNER
      JOIN dispatch 
        ON dispatch.order_no = prepress.order_no
     WHERE prepress.order_no ='$order_num'";
    

    thanks

  7. Hi, 
    I have multiple table 
    Table -1 
    order_no name 
    1 raj 

    table -2 
    order_no name 
    1 raj 

    table 3 
    order_no name 
    1 raj 

    table 4 
    order_no name 
    1 raj 

    table 5 
    order_no name 
    1 raj 

    I want a query to check if the id (one) is present in all tables or not, 
    i create this. 


    select order_no from prepress, press, postpress, qc, binding, dispatch where order_no=prepress.order_no AND order_no=press.order_no AND order_no=postpress.order_no AND order_no=qc.order_no AND order_no=binding.order_no AND order_no=dispatch.order_no 
    but the ambiguous error for order_no. 

    how to achieve this can anyone suggest me? 
    thanks

  8. Hi,
    I am little bit confuse with the result of num_rows that i used in my code.
    My table invoice have no value in current because i want to check if no value in the table.
    Here is my code
     
    code 1 gives $rowc value as 0 that is correct.
    $fetch1="select * from invoice"; 
    $val1=$con->query($fetch1); 
    $rowc=$val1->num_rows; 
    echo $rowc;  
    

    Code 2 gives $rowc value as 1 that is incorrect.

    $fetch1="select max(id) as id, order_no from invoice"; 
    $val1=$con->query($fetch1); 
    $rowc=$val1->num_rows; 
    echo $rowc;  
    

    I just want to know why the result giving two different values.
    Thanks

     

  9. I'm still not sure what are you trying to do? Do you want users to transfer files from one server to another or what?

     

    If not, why are you doing it in PHP? You can do it in CPanel, just make sure (as they said above) with server admins what's the limit.

     

     

    20a6z4w.jpg

    Hi,

    1- I have a registration page for user.

    2- After registration in page , they will login into page.

    3- There will be a simple browse (upload button) and php code into server 1 suppose, mysite.com. but this is a shared server so i am not able to upload a file more then 20MB of size and after lot of code changes , i couldn't able to do into this server.

    4- So i have an other server 2 myserver.com as dedicated server, where there is no limit to upload.

    5- Now i want could i user server 1 to upload into server 2.

     

    Hope you understand what i want.

    Thanks

  10. I am facing a problem, Below is the code
    HTML Code

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Untitled Document</title>
    </head>
    
    <body>
    <form id="abc" name="abc" action="" method="post">
    <table>
    <tr>
    <td>
    Name: <input id="name" name="name" type="text" />
    </td>
    <td>
    Id:  <input id="id" name="id" type="text"
    </td>
    </tr>
    <tr>
    <td>
    <input type="submit" name="save" id="save" value="Save" />
    </td>
    <td>
    </td>
    </tr>
    
    </table>
    </form>
    </body>
    </html>
    

    PHP Code

    <?php   
    if(isset($_POST['save']))   
    {   
    $name=$_POST['name'];   
    $id=$_POST['id'];   
     echo "<script type='text/javascript'>alert('check message: $name :- $id');</script>";    
    }   
    else   
    {   
    }   
    
    ?>
    

    Step 1- Fill form and press save.
    Step 2- Get a alert message. press ok
    Step 3- Now Press F5 (Refresh).

    Problem- Every time when i press F5 for refresh i am getting the old alert message, even before i fill the form and press save button.
    Can anyone tell me why this happening or is there any solution to get out of this?
    Thanks

  11. no, you didn't mention that in this thread. you cannot assume anyone reading your thread knows anything about your previous threads or problems or how this tread relates to any previous thread or problem.

     

    have you checked with your web host to find the proper method of changing the upload file size limits on their server? you cannot set them in your .php file because php uses the settings before your php script is even executed. you can only set them in a .htaccess file when php is running as an Apache Server Module (you get a server if you try.) you can set them in a local php.ini when php is running as a cgi/fastcgi application. if your upload script is in a folder, you will likely need to have a php,ini file in the same folder where the script is at. some web hosts use a different name for the php.ini file, such as php5.ini.

     

    you must find out if your web host allows you to change the two settings at all (both post_max_size and upload_max_filesize must be change and they must be set to realistic and valid values) and where and how to change them.

    Hi mac_gyver,

    First of all sorry for inconvenience,

    My host server is bluehost. i am using php.ini file (5.4 as per control panel of bluehost).

    Earlier i was getting error because there was mas 10 MB set for upload limit, then i change into php.ini file to 512 MB for both post_max_size and upload_max_filesize and change the max_execution time limit too.

    but now after changing it too, i only able to upload 20 MB not more than that.

    I have try everything but it dosen't seem to help me.

    i will only left with what you said use php.ini file in same folder.

    Let me check with this also and will reply if it worked

     

    Thanks

  12. most of the functions you have in your code won't work using the http:// protocol, and even if they did, what you are doing would be uploading the file to the first server, then moving it to the second server. this would use double your file transfer bandwidth on the first server.

     

    so, what exact problem are you trying to solve.

    Hi mac_gyver,

    as i mention , i am trying to give user permission to upload files that may be more than 300Mb size but as i increase sizes in php.in, in my php file and in .htaccess file also but it only able to take 20Mb not more than that, so i was thinking if i could transfer to any other server using any mode like you said ftp, 

    thank i could able to achieve my goal.

     

    Thanks

  13. Hi,
    I am using a unlimited server for uploading some files but after using so many code , i am not able to achieve my goal.
    So now i want i use my current server to php code and upload my files into another server, where limit will not be any issue.
     
    Example.
    Let's say i have two server ( www.rajesh.com and www.rathor.com),
     
    now i am using below code into www.rajesh.com
     
    if (file_exists("http://www.rathor.com/demo/rajesh/" . $_FILES["uploadedfile"]["name"]))
    	 {
          echo $_FILES["uploadedfile"]["name"] . " already exists. ";
        }
    	 else
    	  {
          move_uploaded_file($_FILES["uploadedfile"]["tmp_name"],
          "http://www.rathor.com/demo/rajesh/" . $_FILES["uploadedfile"]["name"]);
          echo "Stored in: " . "http://www.rathor.com/demo/rajesh/" . $_FILES["uploadedfile"]["name"];
        }
    

    So i just want to know, is it possible to do?
    if yes then how i can achieve this?

    Thanks

     

  14. If you look at the manual under $_FILES there is a user-added note concerning exactly this issue.  Apparently you haven't provided a file to be uploaded, so the FILEs array isn't created.

    Hi ginerjm,

    Is your answer for Undefined index: then it is solved now by simply increasing the size in php.ini.

    but the main 500 server error still coming.

    Thanks

  15. hi,

    I have change the php.ini from 5.2 to 5.4 and change display error on

    then i am getting this error.

     

    Notice: Undefined index: uploadedfile in /home1/proalbu1/public_html/file-upload-progress-bar/video_upload.php on line 14

     

    this is the line no 14 contains

    $temp_name = $_FILES['uploadedfile']['tmp_name'];

     

    Can you please suggest what to do now?

     

    Thanks

  16. 1 - I wonder why you suppress the outcome of your ini-set statements?  What are you hiding from yourself / the user?  If anything, during development you WANT to see if there is an unexpected outcome, no?

     

    2 - this line:

    ini_set('upload_max_filesize', '1024000000000M'); 
    

    is asking for an inordinately HUGE filesize.  The M indicates megabytes already, so why so many zeros?  Don't you just want

    ini_set('upload_max_filesize', '20M');   
    

    I wonder if #1 is preventing you from seeing an error message caused by #2? 

    Hi,

    This is the error,

     

    500 Server Error

    A misconfiguration on the server caused a hiccup. Check the server logs, fix the problem, then try again. 

    ​secondly 

    I want to upload between 300 MB to 500 MB file. not 20 MB. its was just to give maximum file size that's why so many zeros , i put there.

     

    Thanks

  17. Do you have control over the web server's (Apache?) configuration file? If so, study the LimitRequestBody parameter.

     

    Be aware that too many players in this process hold filesizes and limits in an integer field. So some of these (ridiculously large) limuts will be ignored because they are greater than what a 32-bit integer can hold.

    Can you please tell me what is the name of that file, i have access to my control panel. and as i said i have changed my php.ini file as said in forums and where i search for solution but still no luck.

    Thanks

  18. Hi,
    I create a simple code to upload file using php code.

    index.php
    
    <?php
    @ini_set('upload_max_filesize', '1024000000000M');
    @ini_set('post_max_size', '1024000000000M');
    @ini_set('max_input_time', 3600000000000);
    @ini_set('max_execution_time', 3600000000000);
    ?>
    <!doctype html>
    <head>
    <title>Proalbum: File Upload </title>
    <style>
    body { padding: 30px }
    form { display: block; margin: 20px auto; background: #87bb2f; border-radius: 10px; padding: 15px }
    
    .progress { position:relative; width:400px; border: 1px solid #ddd; padding: 1px; border-radius: 3px; background:#FF0000;}
    .bar { background-color:#87bb2f; width:0%; height:20px; border-radius: 3px;  }
    .percent { position:absolute; display:inline-block; top:3px; left:48%; }
    </style>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    </head>
    <body>
        <h1>Select a File to Upload</h1>
            <form action="video_upload.php" method="post" enctype="multipart/form-data">
            <input type="file" name="uploadedfile"><br>
            <input type="submit" value="Upload File">
            <input type="hidden" name="MAX_FILE_SIZE" value="99999999"/>
        </form>
    
        <div class="progress">
            <div class="bar"></div >
            <div class="percent">0%</div >
        </div>
    
        <div id="status"></div>
    
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.js"></script>
    <script src="http://malsup.github.com/jquery.form.js"></script>
    <script>
    (function() {
    
    var bar = $('.bar');
    var percent = $('.percent');
    var status = $('#status');
    
    $('form').ajaxForm({
        beforeSend: function() {
            status.empty();
            var percentVal = '0%';
            bar.width(percentVal)
            percent.html(percentVal);
        },
        uploadProgress: function(event, position, total, percentComplete) {
            var percentVal = percentComplete + '%';
            bar.width(percentVal)
            percent.html(percentVal);
        },
        complete: function(xhr) {
            bar.width("100%");
            percent.html("100%");
            status.html(xhr.responseText);
        }
    }); 
    
    })();       
    </script>
    
    </body>
    </html>
    
    video_upload.php
    
    <?php
    @ini_set('upload_max_filesize', '1024000000000M');
    @ini_set('post_max_size', '1024000000000M');
    @ini_set('max_input_time', 3600000000000);
    @ini_set('max_execution_time', 3600000000000);
    //$upload_dir = $_SERVER['DOCUMENT_ROOT'] .  dirname($_SERVER['PHP_SELF']);
    $upload_dir='rajesh';
    $upload_url = '/';
    
    	$temp_name = $_FILES['uploadedfile']['tmp_name'];
    	$file_name = $_FILES['uploadedfile']['name'];
    			
    	$file_path = $upload_dir.$upload_url.$file_name;
    	
    	
    	if(move_uploaded_file($temp_name, $file_path))
    	{
    		echo "File uploaded Success !";
    	}
    
    ?>
    

    and 
    php.ini
    max_execution_time: 3600000000000
    max_input_time 3600000000000
    post_max_size 1024000000000M
    upload_max_filesize 1024000000000M

    and in .htaccess file
    php_value max_execution_time 3600000
    php_value max_input_time 3600000
    php_value post_max_size 1024000M
    php_value upload_max_filesize 1024000M

    But still can't able to upload file more than 20 mb.
    Can anyone please help me in this.
    Thanks

  19. Hi,

    I working on a html table and want to get row wise information of that. please check the attachment.

    this is my code



    <?php
    //if(isset($_POST['submit']))
    // {
    include ("db.php");
    $query_for_result=mysql_query("SELECT * FROM pro_production ORDER BY production_id");
    $num=mysql_numrows($query_for_result);
    //echo <<<end
    //<table align="right" >
    //<tr>
    //<td bgcolor="#6f0d00" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; padding:3px 5px 3px 5px; color:#FFFFFF;" >Total Result Search</td><td> </td><td bgcolor="#000000" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; padding:3px 5px 3px 5px; color:#FFFFFF;">$num</td>
    //</tr>
    //</table>
    //end;
    mysql_close();
    ?>
    <div id="main" style="width: 100%; float:left; border:solid #CCCCCC; background-color:#FFFFFF; overflow:scroll; height:500px;">
    <table width="1800" align="center" border="1" cellspacing="0" cellpadding="0" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; color:#000000; border:solid #d6d4d5; border-width:1px; margin-top:0px;">
    <tr>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >S.No.</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Booking Date</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Delivery Date</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Order Number</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Customer Name</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Status</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Product Range</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Cover</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Size</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Accessory</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Bag</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Packing</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Delivery</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Paper</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Coating</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Priority</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Advance</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >G Total</td>
    <td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Balance</td>
    </tr>
    <?php
    $i=0;
    while ($i < $num)
    {
    $f1=mysql_result($query_for_result,$i,"production_id");
    $f2=mysql_result($query_for_result,$i,"booking_date");
    $f3=mysql_result($query_for_result,$i,"delivery_date");
    $f4=mysql_result($query_for_result,$i,"order_no");
    $f5=mysql_result($query_for_result,$i,"salutation");
    $f6=mysql_result($query_for_result,$i,"customer_name");
    $f7=mysql_result($query_for_result,$i,"status");
    $f8=mysql_result($query_for_result,$i,"product_range");
    $f9=mysql_result($query_for_result,$i,"cover");
    $f10=mysql_result($query_for_result,$i,"size");
    $f11=mysql_result($query_for_result,$i,"accessory");
    $f12=mysql_result($query_for_result,$i,"bag");
    $f13=mysql_result($query_for_result,$i,"packing");
    $f14=mysql_result($query_for_result,$i,"delivery");
    $f15=mysql_result($query_for_result,$i,"coating");
    $f16=mysql_result($query_for_result,$i,"priority");
    $f17=mysql_result($query_for_result,$i,"advance");
    $f18=mysql_result($query_for_result,$i,"gtotal");
    $f19=mysql_result($query_for_result,$i,"balance");
    $f20=$f5.$f6;
    $f21=mysql_result($query_for_result,$i,"paper");

    $id=$i+1;
    ?>
    <!--<tr onclick="myFunction(this)">-->
    <tr >
    <!--<td valign="top" style="font-size:11px; " align="center" ><?php echo htmlentities($f1); ?></td>-->
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $id; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f2; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f3; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f4; ?></td>
    <!--<td valign="top" style="font-size:11px; " align="center" ><?php echo $f5; ?></td>-->
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f20; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f7; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f8; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f9; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f10; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f11; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f12; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f13; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f14; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f21; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f15; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f16; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f17; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f18; ?></td>
    <td valign="top" style="font-size:11px; " align="center" ><?php echo $f19; ?></td>

    </tr>
    <?php
    $i++;

    }

    ?>

    </table>
    </div>


    What i want that if i select row first and the click on any of the bottom buttons then i could get the whole information of that row.

    I have done lot of search but i only able to get the data when click on the row itself but not when i clicked on the bottom button, 

     

    So if any one can help me in this regard then i will be very thankful.

     

    thanks

  20. hi,

    I have a loop on my code, i know it will show message everytime that code will run but i want that the message only show on the final count.

    for ($i = 0; $i < $post_count; $i++)
    {
    $sql[] = "INSERT INTO pro_customer_album_price(customer_id, customer_name, customer_user_name, sl_no, album_name, paper, finish, price, vat, total_amt, date, time) VALUES ('$customer_id','$customer_name','$customer_user_name','".$sl_no[$i]."','".$album_name[$i]."','".$paper_used[$i]."','".$finishing[$i]."','".$price[$i]."','".$vat[$i]."','".$total_amt[$i]."','$date','$time')";

    }
    foreach ($sql as $query)
    {

    $data = mysqli_query($con, $query);
    if(!$data)
    {
    echo "
    Error".mysqli_error($con);
    }
    else
    {
    echo "Inserted!"; /// this is the message coming everytime but i want this message only show when the loop complete or in last count.
    }

    }

    Thanks

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.