Jump to content

rajeshkr

Members
 View Profile  See their activity

  • Posts

    37

  • Joined

  • Last visited

 Content Type 

Everything posted by rajeshkr

  1. rajeshkr
    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. rajeshkr
    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. rajeshkr
    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. http://www.sitepoint.com/forums/attachment.php?attachmentid=64973&d=1402046213 img -2 you can see vertical scroll working fine till advance column. http://www.sitepoint.com/forums/attachment.php?attachmentid=64974&d=1402046221 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. http://www.sitepoint.com/forums/attachment.php?attachmentid=64975&d=1402046226 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. rajeshkr
    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
  5. rajeshkr
    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. rajeshkr
    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. rajeshkr
    Hi, To store different information to different tables but order_no will same for each table. Thanks
  8. rajeshkr
    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
  9. rajeshkr
    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
  10. rajeshkr
    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
  11. rajeshkr
    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
  12. rajeshkr
    Hi bsmithe, The limit shown is upto 2 GB but i am not able to upload more than 20 MB. Thanks
  13. rajeshkr
    hi mac_gyver,, Still no luck same error. 500 Server ErrorA misconfiguration on the server caused a hiccup. Check the server logs, fix the problem, then try again. Thanks
  14. rajeshkr
    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
  15. rajeshkr
    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
  16. rajeshkr
    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
  17. rajeshkr
    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
  18. rajeshkr
    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
  19. rajeshkr
    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
  20. rajeshkr
    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
  21. rajeshkr
    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
  22. rajeshkr
    hi Please find the attachment for what i want to achieve. thanks
  23. rajeshkr
    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
  24. rajeshkr
    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
  25. rajeshkr
    Thanks Solved
×
×
  • 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.