User Profile

Collapse

Profile Sidebar

Collapse
ahmurad
ahmurad
Last Activity: Jan 28 '10, 08:53 AM
Joined: Aug 15 '07
Location: Bangladesh
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ahmurad
    started a topic INDEX Key to protect duplicate data insertion ?
    in MySQL

    INDEX Key to protect duplicate data insertion ?

    Dear Xperts,

    I am trying to insert huge data (csv format) to MySQL database by using php script. In database I've used INDEX Key of column f2 & f24 so that only f2 & f24 are same then data will be uploded. but here all data uploaded with duplicate entry.


    Indexes:
    Keyname Type Cardinality Action Field
    PRIMARY PRIMARY 20 SL
    sam_idx I ...
    See more | Go to post
    • ahmurad
      started a topic PHP File Location
      in PHP

      PHP File Location

      Dear Brothers,

      I am using a 'text file location' at my code to read the file contents- which is working fine in my local server. The web contents/php files and the specified txt file are at the same location at my own server.

      [CODE=php]$fc = file ('./sitedb.txt');[/CODE]

      Now I want to read the txt file from another ftp server (Exaple: ftp://10.10.10.100/File/sitedb.txt').

      For this purpose, I changed...
      See more | Go to post
      • ahmurad
        replied to Count numbers group wise according to identical time in PHP and MYSQL
        in MySQL
        Dear Brothers,

        I have simplified the problem. Please see the Present and Expected Output Status. Please give me a solution modifying the PHP/MYSQL code. I am not so familiar with group by, order by, having clauses.

        DB Table:

        Error_Code FC_No FC_Time

        Error:2 FC:10 00:15:13
        Error:2 FC:20 00:15:15
        Error:2 ...
        See more | Go to post

          Leave a comment:

        • ahmurad
          replied to Count numbers group wise according to identical time in PHP and MYSQL
          in MySQL
          Mysql Query:Count numbers group wise according to identical time

          Dear Xperts,

          In my MYSQL database table some fault code type records are inserted and the values are like bellows:

          Error:2/FC:10; 00:15:13 16/03/2009;
          Error:2/FC:20; 00:15:15 16/03/2009;
          Error:2/FC:30; 00:15:16 16/03/2009;
          Error:2/FC:40; 00:15:20 16/03/2009;

          Error:3/FC:3; 00:20:13 16/03/2009;
          ...
          See more | Go to post

            Leave a comment:

          • ahmurad
            replied to Count numbers group wise according to identical time in PHP and MYSQL
            in MySQL
            Count numbers group wise according to identical time

            Dear Xperts,

            In my database table some fault code type records are inserted and the values are like bellows:

            Error:2/FC:10; 00:15:13 16/03/2009;
            Error:2/FC:20; 00:15:15 16/03/2009;
            Error:2/FC:30; 00:15:16 16/03/2009;
            Error:2/FC:40; 00:15:20 16/03/2009;

            Error:3/FC:3; 00:20:13 16/03/2009;
            Error:3/FC:6; 00:20:15...
            See more | Go to post

              Leave a comment:

            • ahmurad
              started a topic Count numbers group wise according to identical time in PHP and MYSQL
              in MySQL

              Count numbers group wise according to identical time in PHP and MYSQL

              Dear Xperts,

              In my database table some fault code type records are inserted and the values are like bellows:

              Error:2/FC:10; 00:15:13 16/03/2009;
              Error:2/FC:20; 00:15:15 16/03/2009;
              Error:2/FC:30; 00:15:16 16/03/2009;
              Error:2/FC:40; 00:15:20 16/03/2009;

              Error:3/FC:3; 00:20:13 16/03/2009;
              Error:3/FC:6; 00:20:15 16/03/2009;
              Error:3/FC:9; 00:20:16 16/03/2009;
              ...
              See more | Go to post
              • ahmurad
                replied to Convert Date Time into desired format
                in PHP
                Yes !! your code is most efficient. I have done this task another 2 ways. But thats the most efficient, easiest solution !! I accepted.

                Thnx brother !!
                See more | Go to post

                  Leave a comment:

                • ahmurad
                  replied to Convert Date Time into desired format
                  in PHP
                  Dear Brother Atli,

                  Thank you very much. Really your reply was helpful for me. Here I had to do an additional task besides your advice to convert the DB time string in US time format (d-m-y to m-d-y) , as strtotime() expects m-d-y format.

                  Thanks the group members also.

                  Regards
                  Murad
                  See more | Go to post

                    Leave a comment:

                  • ahmurad
                    started a topic Convert Date Time into desired format
                    in PHP

                    Convert Date Time into desired format

                    Dear Brothers,

                    I am struggling the following four Date-Time type values which were inputted into MYSQL database in different tables. As
                    MYSQL Default Time Format: YYYY-MM-DD HH:MM:SS, So I used the MYSQL Tables DateTime Type as Text.

                    Time-formet 1. 04:02:27 16/01/2009
                    Time-formet 2. 16/01/2009 13:53:19
                    Time-formet 3. 00901E+13
                    Time-formet 4. Wed Jan 14 00:09:09 BDT 2009

                    I need...
                    See more | Go to post
                    • ahmurad
                      replied to Excell/CSV files type data need to insert in MySQL database using php
                      in PHP
                      Thanks a lot !! I have done huge data analyis tasks (CSV to MYSQL) using this help. Thanks again..!!
                      See more | Go to post

                        Leave a comment:

                      • ahmurad
                        started a topic XLS/CSV Data need to upload MYSQL database
                        in MySQL

                        XLS/CSV Data need to upload MYSQL database

                        Dear Brothers,

                        I want to upload XLS/CSV huge data (90,000 rows in a XLS/CSV file) into MYSQL database.

                        I want to use only Import option of phpmyadmin to upload XLS/CSV files. How can i to do/proceed such task using this graphical interface (without php script).

                        I am awaiting for your kind replyto do this urgent task.

                        Thanks!!

                        Murad
                        See more | Go to post
                        • ahmurad
                          started a topic Download Webpage Report in Excel Format- Urgent
                          in PHP

                          Download Webpage Report in Excel Format- Urgent

                          Dear Brothers,

                          I have created a report by using php and mysql. This report is changed according to various condition and gives output on the page. Now I need to add a download button on the page so that if anybody click on the download button the report displaying in the page will be downloaded in Excell format.

                          That means the report which is generated in the web page need to download in excel format.

                          ...
                          See more | Go to post
                          • ahmurad
                            started a topic .xls / csv files type data need to insert in MYSQL database
                            in MySQL

                            .xls / csv files type data need to insert in MYSQL database

                            Dear brothers,

                            I have some importnat files in MS Excell / CSV format. I know php. I want to insert these files into MYSQL database to generate reports.

                            What are the techniques to insert the MS Excell / CSV files into MySQL?

                            Your kind quick reply is highly appreciated.
                            See more | Go to post
                            • ahmurad
                              started a topic Excell/CSV files type data need to insert in MySQL database using php
                              in PHP

                              Excell/CSV files type data need to insert in MySQL database using php

                              Dear brothers,

                              I have some importnat files in MS Excell / CSV format. I know php. I want to insert these files into MYSQL database to generate reports.

                              What are the techniques to insert the MS Excell / CSV files into MySQL?

                              Your kind quick reply is highly appreciated.
                              See more | Go to post
                              • ahmurad
                                started a topic Count time upto click submit in the same page
                                in PHP

                                Count time upto click submit in the same page

                                Dear Brothers / Xperts,

                                I need to count time of a page upto click submit. When the user just enter the page the timer / start time is tracked . When the user submit the form then the end time is need to be measured.

                                The calculated time ($end - $start) is need to keep in a php variable and after then the form will be submitted.

                                I am trying to do this work using the below php technique...[php]$start =...
                                See more | Go to post
                                Last edited by ronverdonk; May 4 '08, 09:40 AM. Reason: code tags!
                                • ahmurad
                                  started a topic How can I protect mouce's right click?
                                  in Javascript

                                  How can I protect mouce's right click?

                                  Hi,
                                  I am a new user. I want to protect Mouce's Right button's click so that the internet user can not view my web's source code in a popup window. How can i do implement this security? Please help me giving such kind of idea. I am waiting for valued reply.
                                  See more | Go to post
                                  • ahmurad
                                    replied to Null value / non checked chexkbox value posting problem
                                    in PHP
                                    Thanks for your proper guide.

                                    is there any help so that when any checkbox is remaining to select then will crete a warning message specifying the related checkbox number.
                                    See more | Go to post

                                      Leave a comment:

                                    • ahmurad
                                      started a topic Null value / non checked chexkbox value posting problem
                                      in PHP

                                      Null value / non checked chexkbox value posting problem

                                      Dear all,
                                      I am fresh php programmer. I've spent much time to solve a checkbox related null value submission problem in php platform.

                                      I want to submit 4 checkbox value. if I checked all the checkbox, all the checked value is submitted properly. if checked any checkbox , the corresponding checkbox value is submitted properly.

                                      But I need to send the non checked value (please let non checked value is N ) with the...
                                      See more | Go to post
                                      • ahmurad
                                        started a topic Radio option null (not tached) value posting problem
                                        in PHP

                                        Radio option null (not tached) value posting problem

                                        Dear all,
                                        I am new group user, computer science graduate; just have joined this established group and thanks to all. I am working in network field but so much interested in web (PHP) field. Recently i am dealling with an educational project like online exam (MCQ) and i am facing some problems for sending radio values to the submitted page.

                                        Every question have 4 possible radio value. Questions are retrieved in the page by matching...
                                        See more | Go to post
                                        Last edited by ak1dnar; Oct 12 '07, 01:40 PM. Reason: added code=php tags
                                        No activity results to display
                                        Show More
                                        Working...