1,080,623 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?

Posts by jacob21

query execution time in mongodb in MySQL

1 Week Ago
0

Hi,
I am executing below query.
db.leads.find();
How to get execution time(in milli seconds) it take.

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

Re: Mongodb vs mysql in MySQL

2 Weeks Ago
0

Thanks.
I am doing research on mongodb and mysql comparison.
Can you give some Direction(some points ) to find out the differences b/w above databases.

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

Mongodb vs mysql in MySQL

2 Weeks Ago
0

Hi Experts,

Which database is better acc to Performance factor.
Need Suggestions..

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

Re: How to make HTML Page Full screen in JavaScript / DHTML / AJAX

5 Months Ago
0

Hi,
Need your suggestions for below problem..
On clicking practice button it should open a new HTML page(new.html) which should be full screen sized.

HTML PAge
<!DOCTYPE html>
<html>
    <head>

    </head>

    <body>

        <div class="container">      
            <section class="main-content">
                                    <a href="http://www.google.co.in"><button id="view-fullscreen">Practice</button></a>
                                           <script src="js/base.js"></script>
                                           </section>
</div>

    </body>
</html>


JS Code

(function () {
    var viewFullScreen = document.getElementById("view-fullscreen");
    if (viewFullScreen) {
        viewFullScreen.addEventListener("click", function () {
            var docElm = document.documentElement;
            if (docElm.requestFullscreen) {
                docElm.requestFullscreen();
            }
            else if (docElm.mozRequestFullScreen) {
                docElm.mozRequestFullScreen();
            }
            else if (docElm.webkitRequestFullScreen) {
                docElm.webkitRequestFullScreen();
            }
        }, false);
    }

    })();
jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0
jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

Re: How to make HTML Page Full screen in JavaScript / DHTML / AJAX

5 Months Ago
0

I can use any code(JS/HTML) to make HTML page full screen like youtube video full screen option

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

How to make HTML Page Full screen in PHP

5 Months Ago
0

How to make HTML Page Full screen??
With "full screen" I mean that it should take all the space of user's screen,just like when we watch a video with the full screen model. I do not want the task bar/menu bar of the browser window display.

Any suggestions??

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

google table charts not showing tooltip in JavaScript / DHTML / AJAX

6 Months Ago
0

Hi,
I am working on google charts.Below code is showing tooltip in case of core graph.
I am trying to show tooltip in case of Table chart.
need sugestions

corechart code:
    <html>
      <head>
        <script type="text/javascript" src="https://www.google.com/jsapi"></script>
        <script type="text/javascript">
          google.load("visualization", "1", {packages:["corechart"]});
          google.setOnLoadCallback(drawVisualization);
        function drawVisualization() {

        data = new google.visualization.DataTable()
        data.addColumn('string', 'Date');
        data.addColumn('number');
        data.addColumn({type:'string',role:'tooltip'});
        data.addRow();
        base = 10;
        data.setValue(0, 0, 'Datapoint1');
        data.setValue(0, 1, base++);
        data.setValue(0, 2, " hello ");

        data.addRow();
        data.setValue(1, 0, 'Datapoint2');
        data.setValue(1, 1, base++);
        data.setValue(1, 2, "sourav here");

        // Draw the chart.
        var chart = new google.visualization.BarChart(document.getElementById('visualization'));
        chart.draw(data, {legend:'none', width:600, height:400});
    }

        </script>
      </head>
      <body>
        <div id="visualization" style="width: 900px; height: 500px;"></div>
      </body>
    </html>

Table code:


    <html>
      <head>
        <script type="text/javascript" src="https://www.google.com/jsapi"></script>
        <script type="text/javascript">
          google.load("visualization", "1", {packages:["Table"]});
          google.setOnLoadCallback(drawVisualization);
        function drawVisualization() {
        data = new google.visualization.DataTable()
        data.addColumn('string', 'Date');
        data.addColumn('number');
        data.addColumn({type:'string',role:'tooltip'});
        data.addRow();
        base = 10;
        data.setValue(0, 0, 'Datapoint1');
        data.setValue(0, 1, base++);
        data.setValue(0, 2, " hello ");

        data.addRow();
        data.setValue(1, 0, 'Datapoint2');
        data.setValue(1, 1, base++);
        data.setValue(1, 2, "sourav here");

        // Draw the chart.
        var chart = new google.visualization.Table(document.getElementById('visualization'));
        chart.draw(data, {legend:'none', width:600, height:400});
    }

        </script>
      </head>
      <body>
        <div id="visualization" style="width: 900px; height: 500px;"></div>
      </body>
    </html>
jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

Re: PHP MYSQL CSV reader in PHP

7 Months Ago
0

Hi,
I read from my csv and getting below array

Array ( [0] => CBSE [1] => Sourav [2] => Maths ) Array ( [0] => HBSE [1] => pankaj [2] => drupal ) Array ( [0] => GBSE [1] => Vinod [2] => PHP ) Array ( [0] => abcd [1] => SDS [2] => DFS )

I am trying to extract like below i.e end of the csv
[0][0] [array 1][CBSE]
[0][1] [array 1][sourav]
[0][2] [array 1][maths]
[0][3] ........

[1][0] [array 1][HBSE]
[1][1] [array 1][Pankaj]
[1][2] [array 1][drupal]

need suggestions

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

PHP MYSQL CSV reader in PHP

7 Months Ago
0

Hi,
i am inserting data from CSV file in mysql.
I am trying to skip ist row of CSV file as it contains headings.
need suggestions??

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

read csv from second row & insert in to mysql in PHP

8 Months Ago
0

Hi,

I am using below PHP script for insertion in mysql table from CSV file.
Below code is working fine but i am trying to leave first row of CSV as it contains heading
for data.
need suggestions as it is reading from very first row.

 <?php 
//connect to the database
$connect = mysql_connect("localhost","root","");
mysql_select_db("test",$connect); //select the table
//

if ($_FILES[csv][size] > 0) {

    //get the csv file
   //echo $_FILES[csv][size];
   $file = $_FILES[csv][tmp_name];
    $handle = fopen($file,"r");

    //loop through the csv file and insert into database
    do {
        if ($data[0]) {
             $data[0];
             $data[1];
             $data[2];
             $data[3];

              mysql_query("INSERT INTO contacts (contact_first, contact_last, contact_email ,contact_qual) VALUES
                (
                    '".addslashes($data[0])."',
                    '".addslashes($data[1])."',
                    '".addslashes($data[2])."',
                    '".addslashes($data[3])."'
                )
            ");
        }
    } while ($data = fgetcsv($handle,1000,",","'"));
    //

    //redirect
    header('Location: import.php?success=1'); die;

}

?>

<!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=iso-8859-1" />
<title>Import a CSV File with PHP & MySQL</title>
</head>

<body>

<?php if (!empty($_GET[success])) { echo "<b>Your file has been imported.</b><br><br>"; } //generic success notice ?>
<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1">
  Choose your file: <br />
  <input name="csv" type="file" id="csv" />
  <input type="submit" name="Submit" value="Submit" />
</form>

</body>
</html>
jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

Re: link showing a shadow in Web Design, HTML and CSS

8 Months Ago
0

futor.com and click on login button and then close the light box.login button has some rectangular shadow

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

link showing a shadow in Web Design, HTML and CSS

8 Months Ago
0

Hi,

when i click on a link,its showing an extra shadow after clicking on linking text.
Need suggestions.

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

Re: PHP/mysql Query execution time in PHP

8 Months Ago
0

Thanks pritaeas,
I am using shared webhost.
Is there any (accurate)method to find out query execution time.??

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

PHP/mysql Query execution time in PHP

8 Months Ago
Show Comments
1

Hi,
I want to check query execution time.
I used microtime(),time() but not getting accurate result.
I also read about mysql slow_query_log but not able to find how to change settings in PHPmyadmin.
Need suggestions

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

Website Hacked in PHP

9 Months Ago
0

Hi,
my website svnnews.in is hacked yesterday.
Now its showing some hackers messages.
I need my website back.Need suggestion to make my website hack free.

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

Need information regarding work from home in PHP

10 Months Ago
0

Hi,
I need to know is there any real website which offer online work to earn money.
Need suggestions

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

Excel sheet upload & show content in PHP

11 Months Ago
0

Hi,
I wannt to upload an excel sheet & display the excel sheet content on that page
after uploading.
Need Help/suggestions

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

Covert Kruti font into Unicode in PHP

1 Year Ago
0

Hi,

I am using below linked converter to convert kruti hindi font in to unicode font.
But i am not exactly getting same data(in unicode) as in my document(in kruti font).
Click Here
http://svnnews.in/convertor.htm
Below is attached document of kruti font which i want to convert & above link is converter link.

Attachments 8-5-12.doc (39KB)
jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0

ascii to unicode conversion in PHP

1 Year Ago
0

Hi,
I have text in kruti dev 011hindi font. I wish to display it on web page
using unicode mangal hindi font in utf-8 format.
Need Help

jacob21
Posting Whiz in Training
251 posts since Feb 2011
Reputation Points: 10
Solved Threads: 1
Skill Endorsements: 0
 
© 2013 DaniWeb® LLC
Page generated in 0.1448 seconds using 2.67MB