Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

How to find out slow queries in MySQL?

Hello everyone, Please help me regarding the use of slow queries in MySQL. I want to know how can I find out slow queries in MySQL and What is optimal query time to query a single table of 3 Million records on Indexed column?? Thank you

passing id from function to another in php?

I have PHP MySQL functions and I need to pass the id number from one function to another and each function are called in different page. I'm using the URL to pass the variable. I don't know if that is possible but can I use session to pas...

MySQL query to retrieve data of past two months

 I have a table with name and createDate, please tell me the query to retrieve the user data of past two months. Thanks in Advance

set the correct answers equal to 1?

i'm working in query to insert answer into answers table and i need to set to correct answer equal to 1 and the incorrect answer equal to 0 for that i'm using radio buttons to assigned value into the answer but every time when i run the q...

how to choose correct answers from multiple choices questions ?

how to choose correct answers from multiple choices questions using php and mysql i don't know if i'm doing in the right way because i'm still new in programming world  1- i'm using an array to store the questions  ...

how to avoid duplicate data in php mysql ?

i have this database which contain table for questions and other for answers how can i display each questions with the answers that belong to this question my problem is when i try to display the questions i get duplicated rows or all the answe...

update data using get method

update and delete using get method i have this code to update data from my database i have no error reporting but he's not updating  any data can you help me with that   my database and my code -- -------------------...

How to access the database with SQL PLUS?

Hello all, I am unable to access my SQL database as I forgot the login details. I have tried with some but getting error "ORA -12560: TNS : protocol adapter error." Kindly suggest me the way to retrieve the details. Is there any comm...

how to get questions with jquery,ajax,php

have a quiz script. My script contains quiz.js, getquestions.php, insertresults.php. In quiz.js: var i = 1; var sec = 20; var timetaken = 0; var answer; var points; var result = .5; var score = 0; var f = new Date(); var duration; var...

I'm getting import CSV error while uploading files in php

Hi i'm developing the panel where admin can import the csv file directly to mysql database. But I'm getting the error. My code is <?php //ENTER THE RELEVANT INFO BELOW $mysqlDatabaseName ='bilmos'; $mysqlUserName ='root'; $mysqlPasswor...

how can I use php to display question

how can I use php to display question stored in mysql database and choose the right answer for it and give grade if the answer is right and store it back in mysql database (sorry I don't speak English very well )

how to stick posts to their respective posts in php&mysql

Guys im trying to join a comments table to posts table using the following query in a method. public function feedView($session,$friend,$updateid) { $sql2=" select u.update&#95;body,u.author,u.time,u.title,u.account&#95;na...

Uploading captured image into the specific folder server using volley library

This is one of the famous question which is unanswered clearly. I have posted it on stackoverflow link as follow: http://stackoverflow.com/questions/33341069/uploading-captured-image-into-the-specific-folder-server-using-volley-library I wa...

errror come on run time to connect my android app with mysql

my code this AllProductsActivity Class public class AllProductsActivity extends ListActivity { // Progress Dialog private ProgressDialog pDialog; // Creating JSON Parser object JSONParser jParser = new JSONParser(); ArrayList<H...

Php WP how to send a mail to the admin from a logged user

Hello, I would like to know if in WP PHP is possible to make something like that: I need for the logged user a form which when compiled and submitted, send a mail to the admin with the all data of the user from db and the message he/she write. ...

Insert Data into MySQL database from HTML SubForms

Hello EveryOne, I have 2 HTML Forms: 1. Register/Login 2. After User gets Login, He used to update details of him. I used MySql database in order to save Login details of User. And also i have another table for updating details of him aft...

Entering Values in Second table with help of Primary Key of First Table

Hello EveryOne.... Here is the scenario., In MySql database, I have two tables.. User and UserDetails... In 'User' table, i had generated userID made it as a primaryKey. For Example, 101->user1.... 102->User2 Now I need...
Sign In
                           OR                           
                           OR                           
Register
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: