Jump to content

durgaprasadcs

Members
 View Profile  See their activity

  • Posts

    13

  • Joined

  • Last visited

durgaprasadcs's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. durgaprasadcs
    Hi all, I have records in my sql database which contains fields like ID, Name, Date I need Name Count grouped by Month using date field. Example : ID | Name | Date (mm/dd/yyyy) ----------------------- 1 John 01/01/2013 2 David 01/20/2013 3 Harry 02/10/2013 So when i get the count based on the above data, if should be like follow January - 2 February - 1 That is John and David falling in January Month Harry is falling in February Month How can i acheive this. Its like kind of excel pivot table.
  2. durgaprasadcs
    Hi, I have installed wamp server in Computer A. And its working fine in Computer A. But I would Like to view the website in Computer B which I created locally in Computer A. Both Computers A & B has been connected using LAN. How can i view the local site in Computer B. Thanks in Advance !
  3. durgaprasadcs
    Hello, I use urls like www.example.com/viewpost.php?ID=123 where i am passing ID parameter and then display records from sql in PHP. Later with help of this forum I can able to use MOD REWRITE functionality in .htaaccess and able to convert as dynamic seo friendly url like www.example.com/mp3playerforsale www.example.com/carforsale Now I have the requirement that I have two pages which have ID as parameter. But both has to displayed in two different pages. example : mp3players should go to page viewpost.php?ID=123 cars should go to page viewpost2.php?ID=123 when i tried both displayed in viewpost.php where I need to display cars category in different pages. any help appreciated !
  4. durgaprasadcs
    Hi, I understand the concept you explained. But however If i use the above code, my entire site shows as 500 Internal Server Error. Hi I tried the following code : just alone with ID. RewriteEngine On RewriteRule (.*)/$ load_page.php?&page_id=$1 it is working with slash in end of the url. ( http://www.example.com/384/) and not working without the slash in the end of the url. (http://www.example.com/384) any suggestions
  5. durgaprasadcs
    hi adding to that I would like to see similar to this website (http://forums.phpfreaks.com/topic/286451-php-add-some-string-to-filename-in-address-bar-and-display/) Where i see ID and my title of my post. This is my exact requirement.
  6. durgaprasadcs
    Hi Thanks for the reply. in my end both city name and is dynamic where city user enters. so I need to create the page in run time. So I see two possibilities here.. one is to create the filename entirely in runtime. second one is to have the filename already like $city-$id.php But i am not sure these are possible. Please let me know ...
  7. durgaprasadcs
    Hello , I have two fields in database (ID , CITYNAME ) like below ID | CITYNAME ---------------------- 123 | DELHI ---------------------- 124 | MAHARASHTRA ---------------------- 125 | PUNJAB ---------------------- I am trying to display records based on id number in a file called viewrecords.php. where i am passing ID parameter (http://www.example.com/viewrecords.php?ID=123) and display the record in viewrecords.php file. It simply displays the records where the corresponding id is matches. Now I have a requirement where i need to display a city field ( for example http://www.example.com/cityname-ID.php that is http://www.example.com/delhi-123.php) in the addressbar instead of viewrecords.php. any help appreciated.
  8. durgaprasadcs
    Hello, I have two different databases with each having one table. I wanted to display records from both databases in a single html page sort by Date. Both Database tables may have different columns. But some Columns names are same.Any idea on how to do this... Regards, Durgaprasad.
  9. durgaprasadcs
    Hello, I have 100 of html pages locally stored in a spefic format. I am trying to extract a line from that html pages using php. I can able to search the string and i can able to determine whether the search string is found or not. so far i achieved is <?php $url = 'mylocalpage.html'; $searchstring= 'itemtype'; $contents = file_get_contents($url); if(strpos($contents, $searchstring)!== false) { echo 'Item found'; } else { echo 'Item not found'; } ?> _____________________ Example mylocalpage.html <html> <body> <script> var itemtype = "Mobile"; </script> . . . ..... </body> </html> The next step i need is if it is found i need to copy the entire line from that page. That is if itemtype found I need to copy the entire line that is (var itemtype = "Mobile";) any help appreciated !
  10. durgaprasadcs
    Hello, I have a requirement that I need to access php include files from main domain to sub domain on the same server. I tried giving direct path to the file but still i didnt get. Ex : I have a file in following path: www.example.com/folder/includes/file1.php I need to include this file1.php in my subdomain in a index file that is www.subdomain.example.com/index.php Please help me to resolve this.
  11. durgaprasadcs
    Hi Thanks!!! your reply help me to solve the issue. The thing is i didnt escape the string before adding. so whenever users used special characters, its not worked. That's the issue. Thanks a lot !!!!
  12. durgaprasadcs
    Yes I have a column like FEATUES and I have tried echoing,the format and all perfect. Issue is if it is not working entirely I can able to find the root cause, but its sometimes working and sometimes not. That's the problem. Is there any problem with my host ? even I tried with them , but they said there is no problem in their server.
  13. durgaprasadcs
    Hello , I have a Query to insert values to database. The Query is working fine sometimes and sometimes not. Here is the Query I have $sql = "INSERT INTO snicyposts (MAKE,MODEL,VARIANT,YEAR,COLOUR,FUELTYPE,MILEAGECITY,MILEAGEHIGHWAY,KILOMETERS,TITLE,DESCRIPTION,FEATUES,PRICE,NEGOTIABLE,SCRATCH,OWNERTYPE,CITY,ACCIDENT,TYPE,POSTEDBY,PHONE,POSTEDBYEMAIL,POSTEDON,POSTEDBYUSERNAME,IPADDRESS,POWERSTEERING,POWERWINDOWS,INSURANCEVALIDITY,REGISTRATIONTYPE) VALUES ( '$make','$model','$variant','$year','$colour','$fueltype','$citymil','$highmil','$km','$title','$desc','$features','$price','$negotiable','$scratc','$owner','$city','$accidents','$type','$name','$phone','$email','$currenttime','$usernameposted','$ipadd','$powersteering','$powerwindows','isurance','$regtype')"; mysql_query($sql); Please help me to solve this
×
×
  • 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.