+ Reply
Results 1 to 6 of 6

Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.


Thread: Search function?

is a discussion within the

Native iPhone / iPod Touch App Discussion

forums, a part of the

3rd Party Apps For iPhone | iPod Touch

section;
I switched from a Treo, and one of the most useful functions I found was the Search feature. Many times, I would search my appointments to find info for a
...
  1. #1
    What's Jailbreak?
    Join Date
    Aug 2007
    Posts
    17
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Lightbulb Search function?
    I switched from a Treo, and one of the most useful functions I found was the Search feature. Many times, I would search my appointments to find info for a client I had seen many months earlier but never entered into contacts. I was reading the threads on Apache and had an idea.

    The contacts and calendar databases are sqlite. Using Apache, and PHP. (or maybe one of the other scripting languages, but I am more familiar with PHP), could a web page be created and hosted on the iPhone that would search and report results from the contacts & calendar dbs? I am sure it would be better to write an app to do this, but I don't possess the skills to do so. Any ideas? Comments?

    Thanks!

  2. #2
    What's Jailbreak?
    Join Date
    Sep 2007
    Posts
    11
    Thanks
    2
    Thanked 0 Times in 0 Posts

    I don't have your answer, but the other thing that my Treo had was that ability to create repeating appointments in the format "every second Monday of the month". Not available on my iPhone.

  3. #3
    iPhone? More like MyPhone
    Join Date
    Jul 2007
    Posts
    285
    Thanks
    3
    Thanked 28 Times in 25 Posts

    There is no copy and paste, so what you can do with the search results will be limited.
    Various 'Books old and new
    8 Giggity, Giggity, Gigg-it-y.

  4. #4
    Green Apple
    Join Date
    Sep 2007
    Posts
    45
    Thanks
    2
    Thanked 1 Time in 1 Post
    Ok everyone I got it (getting into the calendar through SQL php) now someone has to either help me make a webapp or wait. I will post a screen shot soon.

  5. #5
    What's Jailbreak?
    Join Date
    Aug 2007
    Posts
    17
    Thanks
    1
    Thanked 0 Times in 0 Posts

    My idea is to setup a webserver on the iphone (like lighttpd & php), then run the php pages from there. I am working on it as well. The idea for me is to be able to lookup past appts.

  6. #6
    Green Apple
    Join Date
    Sep 2007
    Posts
    45
    Thanks
    2
    Thanked 1 Time in 1 Post
    Please someone give me the PHP code to convert this integer

    213933600

    into this date:

    Friday, Oct. 12, 2007 10:00 PM

    I dont remember the conversion from integer format date and time to a normal date and time.

    Also, as a note to progess trying to access the DB straight from PHP kinda didnt let me (some encryption error, did anyone else have this??) I had to dump it reload into a db I made the query. I have the query and can read and write. Please help with the conversion of format above. Thank You
    It was:
    3 Test 213933600 for the $start_date

    I found a $start_date= date("l,F,j,Y g:i", $start_date);
    but it returns 3 Test Monday,October,11,1976 10:00 Etc/GMT+4 Monday,Oct,11,1976 11:00 0 1 0 0
    Last edited by joejoe123; 10-12-2007 at 12:54 PM. Reason: Addition

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts