abhinavsingh89

Ok this is kind of a logical help which I need. I am writing a quiz script and I need to send and receive data from database on a timeout basis and I also want that when time finishes (of quiz) user must be moved to some other page. I basically need timeout based function if there are any and real time retrieval and storage of data. Thanks a lot

i have integrated arrow chat v0.30 and the problem when i click on chat it just shows loading.... can anyone tell me what is the problem??

Chat is working now but some modules like avchat, share screen and games are not working.. what should i do?? please guys help me.. its urgent and for my college project.. please help

i have just installed comet chat on my server but it is not working properly. when i click on someone who is online is not opening any window to chat... only chatrooms are working properly.... please help

i want to create a flash like this on website.. http://www.kdpmgi.com/ can anyone tell me what it is called??? and how can i develop this???

it is possible... language is not always about predefined function... we are working on it under constant constraints and will come up with solution dont worry.. now if you guys can help its really appreciable...

its not like it is impossible... whenever you scan your computer it calculates first that how long will the scanning going to take and then show the elapsed time and same with copying.. so it is definitely possible..

can we anyhow know the query's processing time before even executing the query... like if there is database of 400k records then how long will our query take for execution before even executing the query.. ie pre processing time?? for ex if a query takes .04 sec for execution then i need to know this time before even executing the query..

my new table looks like this.... i changed it as per your suggestion and this one is better... CREATE TABLE IF NOT EXISTS `words` ( `word` varchar(50) NOT NULL, `type` enum('0','1') NOT NULL, `stop_word` enum('0','1') NOT NULL, PRIMARY KEY (`word`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; so the row[0] is for words, row[1] is for type and row[2] is for stop_words... script is error free... now the problem is with speed.. like suppose the text area input is "films adapted from comic books have had plenty of success , whether they're about superheroes ( batman , superman , spawn ) , or geared toward kids ( casper ) or the arthouse crowd ( ghost world ) , but there's never really been a comic book like from hell before . for starters , it was created by alan moore ( and eddie campbell ) , who brought the medium to a whole new level in the mid '80s with a 12-part series called the watchmen . to say moore and campbell thoroughly researched the subject of jack the ripper would be like saying michael jackson is starting to look a little odd . the book ( or " graphic novel , " if you will ) is over 500 pages long and includes nearly 30 more that consist of nothing but footnotes . in other words , don't dismiss this film because of its source . if you can get past the whole comic book thing , you might find another stumbling block in from hell's directors , albert and allen hughes . getting the hughes brothers to direct this seems almost as ludicrous as casting carrot top in , well , anything , but riddle me this : who better to direct a film that's set in the ghetto and features really violent street crime than the mad geniuses behind menace ii society ? the ghetto in question is , of course , whitechapel in 1888 london's east end . it's a filthy , sooty place where the whores ( called " unfortunates " ) are starting to get a little nervous about this mysterious psychopath who has been carving through their profession with surgical precision . when the first stiff turns up , copper peter godley ( robbie coltrane , the world is not enough ) calls in inspector frederick abberline ( johnny depp , blow ) to crack the case . abberline , a widower , has prophetic dreams he unsuccessfully tries to quell with copious amounts of absinthe and opium . upon arriving in whitechapel , he befriends an unfortunate named mary kelly ( heather graham , say it isn't so ) and proceeds to investigate the horribly gruesome crimes that even the police surgeon can't stomach . i don't think anyone needs to be briefed on jack the ripper , so i won't go into the particulars here , other than to say moore and campbell have a unique and interesting theory about both the identity of the killer and the reasons he chooses to slay . in the comic , they don't bother cloaking the identity of the ripper , but screenwriters terry hayes ( vertical limit ) and rafael yglesias ( les mis ? rables ) do a good job of keeping him hidden from viewers until the very end . it's funny to watch the locals blindly point the finger of blame at jews and indians because , after all , an englishman could never be capable of committing such ghastly acts . and from hell's ending had me whistling the stonecutters song from the simpsons for days ( " who holds back the electric car/who made steve guttenberg a star ? " ) . don't worry - it'll all make sense when you see it . now onto from hell's appearance : it's certainly dark and bleak enough , and it's surprising to see how much more it looks like a tim burton film than planet of the apes did ( at times , it seems like sleepy hollow 2 ) . the print i saw wasn't completely finished ( both color and music had not been finalized , so no comments about marilyn manson ) , but cinematographer peter deming ( don't say a word ) ably captures the dreariness of victorian-era london and helped make the flashy killing scenes remind me of the crazy flashbacks in twin peaks , even though the violence in the film pales in comparison to that in the black-and-white comic . oscar winner martin childs' ( shakespeare in love ) production design turns the original prague surroundings into one creepy place . even the acting in from hell is solid , with the dreamy depp turning in a typically strong performance and deftly handling a british accent . ians holm ( joe gould's secret ) and richardson ( 102 dalmatians ) log in great supporting roles , but the big surprise here is graham . i cringed the first time she opened her mouth , imagining her attempt at an irish accent , but it actually wasn't half bad . the film , however , is all good . 2 : 00 - r for strong violence/gore , sexuality , language and drug content " The output is No of positives :443 No of highly positives : 0 No of Stop Words : 335 No of Not Found : 0 but it is taking some time.. i want to make it more efficient so that it must not take much time.. can you suggest anything for this?? i mean mainly the lookup is taking time....

i need help again.. These earlier things were used to create database.. Now the main thing is this <?php require_once("connection.php"); $msg=$_POST['textarea']; $words=explode(" ",$msg); $hpos=0; $pos=0; $nf=0; $stop=0; foreach ($words as $word) { $query="Select * from words where word='$word'"; $result=mysql_query($query); if($result) { $row=mysql_fetch_array($result); if($row[1]==1 && $row[2]==0) $hpos++; else if($row[1]==0 && $row[2]==0) $pos++; else if($row[2]==1) $stop++; else $nf++; } } echo "No of positives :$pos <br> No of highly positives : $hpos <br> No of Stop Words : $stop <br> No of Not Found : $nf"; ?> like i am taking a text as an input and verifying its words with the database.. now the lookup is again taking time.. can you suggest anything better??? i know you are a genius and will come up with something great

omg you are a genius.. great solution... the second one was best.. none of my file is more than 1mb and whole 36k records was inserted within few seconds only..... the strcmp problem was also spot on... now i am using str_replace to replace those \n \r immediately after words... also i have added my stop words in my main table only.... so thnx a lot for all the solutions... Regards Abhinav

Table structure for table `words` -- CREATE TABLE IF NOT EXISTS `words` ( `word` varchar(50) NOT NULL, `tye` enum('0','1') NOT NULL, PRIMARY KEY (`word`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Now i am adding words into that database from reading thousands of file and i have to analyze those words later also so that again reading from file and checking from the database.. All i want to do is create partitions on the basis of alphabets.. i.e partition a must contain words starting from a and so on.. And obviously the lookup is taking time.... <?php require_once("connection.php"); if ($handle = opendir('pos')) { //echo "Directory handle: $handle\n"; //echo "Files:\n"; while (false !== ($file = readdir($handle))) { if(strcmp($file,".")==0 || strcmp($file,"..")==0) continue; echo "$file<br>"; $work_file=fopen("pos/$file",'r'); /*$fdata = fread($work, filesize("pos/$file")); echo $fdata; */ while (!feof($work_file)) { set_time_limit(20); $c=fgets($work_file); //echo $c; $words = explode(" ",$c); //echo "<br><br>" ; $insword=""; foreach ($words as $word) { if(strcmp($word,".")==0||strcmp($word,",")==0||strcmp($word,"(")==0||strcmp($word,")")==0 || strcmp($word,"\n")==0 || strcmp($word,"\r")==0 || strcmp($word,"\r\n")==0) continue; $word=addslashes($word); $query="Select * from stop_words where stop_word='$word'"; $result=mysql_query($query) or die($query.mysql_error()); if(mysql_num_rows($result)>=1) continue; $query="Select * from words where word='$word'"; $result=mysql_query($query) or die($query.mysql_error()); if(mysql_num_rows($result)>=1) continue; $query="insert into words values('$word','0')"; $result=mysql_query($query); } } } closedir($handle); } ?>

I have a database of more than 35k words and because of that i am facing speed issues. Now i want to divide my database on partition basis i.e. partition A must have words starting from A only and so on.. I dont know how to apply partition by on varchars.. or if you can suggest a way to improve retrieval speed than that will be also fine...so kindly help ABhinav

got it... this will work for processing time but i need to know this time before even executing the query.. i mean i need to know this time before processing (pre processing time).. and thanx for the microtime() function i will use it to find the processing time....

I am currently working on a research based project and I need to know the processing time and pre- processing time for executing an query through PHP. I have a database which has several thousand values and i am entering a primary key value to fetch a record. Now i need to know the time before executing the query that how much processing time will the query take and then how much time it took to process query. Both will the same but i need to find the time before processing the query. Can anyone help me with that?? For processing time i think i will capture the time before executing the query and after execution, then i will subtract both the times to find out the processing time.. but main thing is i need to find this time before executing the query... so can anyone suggest anything... any help is appreciated... Thanking You, Abhinav

As per the client requirement he wants to read words from a file and want to insert them in database one by one . ie a confirmation is required whether he wants to insert is or not. I have developed the thing but the problem is when i am retrieving the words it asks for all the words. i will show u wat the problem is. My main query is i want to pause the exectution until user's input. <script type="text/javascript" src="jquery.js"></script> <script type"text/javascript"> function show() { document.getElementById('form#submit').fadeIn(); alert("Abhinav"); } $(document).ready(function(){ $("form#submit").submit(function() { // we want to store the values from the form input box, then send via ajax below var word = $('#word').attr('value'); var synonym = $('#synonym').attr('value'); $.ajax({ type: "POST", url: "ajax.php", data: "word="+ word + "&synonym=" + synonym, success: function(){ $('form#submit').hide(); //$('form#submit :input').val(""); $('div.success').fadeIn(); } }); return false; }); }); </script> <?php $file=fopen("welcome.txt","r") or exit("Unable to open file!"); @$word=""; @$c=""; while (!feof($file)) { $c=fgetc($file); if(strcmp($c," ")==0) { echo "". "<form id='submit' method='post' name='submit' action='' >". "<fieldset> ". "<legend>Enter Information</legend> ". " <label for='word'>Word:</label> ". "<input id='word' class='text' name='word' size='20' type='text' value='$word' > ". " <label for='Synonym'>Synonym:</label> ". "<input id='synonym' class='text' name='synonym' size='20' type='text'> ". " <button class='button positive' type='submit'> Add Client </button> ". " </fieldset> ". " </form> ". "<div class='success' style='display:none;'>Client has been added.</div> ". "</div>"; $word=""; } else $word=$word.$c; } fclose($file); ?> Now what i want is after user clicks add client then only next insertion box must be shown. please check the attached image to see the output. Guys pls help me over this. Thnx in advance [attachment deleted by admin]

guys i hv a table stock which consist of itemid,name, i have another table received which have itemid(foreignkey to stock itemid), qty.. nw in my last module what i have done is i allowed user to enter quantity which will sum up to the previous quantity.. for ex if i had 10 items nd user enter 12 then new amt of items will be 22.... but unfortunately i created a new record for that ... that is a new record will be entered with same itemid and qty 12....i submitted my that module also so cannot make any change in that... now when i apply join it shows redundant entries....now i just want to sum up all the records (i.e. qty) available for particular itemid and print the total qty available.. can anyone suggest a solution to this... thnx in advance...

no i dun... is there any other way??

<select name="status" id="status" onchange="chng();"> <option selected="selected">Incomplete</option> <option>Delivered</option> Now when the value is changed i want to update some values in database... so basically want to call a function or you can say want to execute a piece of code of php when the delivered option is selected... Now i want to know how can i achieve this...

hey guys...i am making a form and in that form i have select boxes in which the options of select boxes depend on each other..... for ex if SELECT BOX 1 [option1] then SELECT BOX 2 must show {op1,op2,op3} else if SELECT BOX [option 2] then SELECT BOX 2 must show {op4,op5,op6} i hope m pretty clear here what i want to do.... any help will be appreciated

and one more thing. The specials detail button is not working

http://24x7onlinestore.com/index.php I have this site based on Oscommerce. When the currency mode is USD it works fine for me but when i select INR the page gets distorted.. Can anyone tell me the reason and how can i solve this. thanx nd regards abhinav

jst echo out everything without using <br />... u will get everything in one line..

thnx a lot... problem solved

hey frnds!! i have a text field in my mysql database which contains paragraphs n includes new line (\n) characters. now when i echo that field it simply shows all the data in one line.. that is it doesnt take into account the new line characters and tab spaces. I have inserted the value with tab spaces and new line as it automatically takes the \n and \r. Now what i want to do is display the text properly and same as what i have inserted. so cn u guys help me.. Thnx in advance Abhinav