PHP - Php Live Countdown In Cli?

Hi there I'm a little bit of a newbie when it comes to PHP, and I have tried to find my answer on google and on other websites related to php development.    My question is what do I need to be researching / learning to automatically update a page with content.    For example, if I have a database field called breaking news and this text string is flashed at the bottom of the screen on a scrolling bar.   When the field changes value in MYSQL, I would like the page to automatically update the page without a need for a page refresh.   All I need is some advice on what I need to search for in order for me to learn the coding myself.   I'm thinking AJAX, but not too sure.    Thank you for reading.  

Hi everyone,   I'm hoping the someone can guide me in the right direction for what I need to do. Does anyone know of a really good tutorial and/or information about a plugin product that is available to do what I need? For example, what I need is to create a website that has the ability to allow video conferencing between a teacher and students. This what I envision - a college professor can log on to his website and display a live video feed of him. Also, as each of his students log on, their live video feed is then also supplied. Would prefer a already made plugin product but would also like to look at raw code in PHP to see how something like this could be accomplished. Thank you in advance.   Charles  

Are there any editors that will allow me to edit live on my server?

I'm looking for a free open source solution

Failing that: what recommended paid ones are there?

I'm using Vista so need a Windows version

Thanks


OM

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=346821.0

 

As we have been working on an eCommerce project, we want to add an option in the eCommerce, that user should have the live location tracking of delivery boy (as same as SWIGGY) in the website. Is there any chance to track the live location using PHP and JavaScript? Searched on the google but nothing resolved my problem? Please anyone suggest us to track the live location of the delivery boy. Thanks in advance

Hello,   I have a pretty basic two panel design, no code yet but it is pretty straight forward   What I'm concerned about is how a website can react to an orientation change, not simply be re sizing but by relocating items.    So in portrait mode, I have panel a, the top half say 50%, and panel b, 50% bottom half   I rotate it (the phone) to the left of my perspective (viewer) and the top panel goes to the left, and the bottom panel goes to the right.    In the meantime some scrolling animation is in play and the direction of the scroll changes, from sideways to up and down... Is that possible without refreshing the page? 
Edited by greenace92, 04 December 2014 - 04:53 AM.

I am using ajax live search to retrieve data from MySQL table. It works fine. However I noticed that it only returns a single result that matches the entire word instead of multiple results that match only the first couple letters.

For e.g.

DB Table

----------------

1. Foot

2. Foot Path

3. Football

----------------

If I type "foo" in the ajax search field, it won't return any results. But if I type "foot", it'll return "Foot". It won't return the other two results that contain the letters "Foot".

Here's my query

$param_term = $_POST["term"] . '%';

$get_data = $db->prepare("SELECT name FROM table WHERE title LIKE :param");
$get_data->bindParam(':param', $param_term);
$get_data->execute();

 

I was wondering how can I improve the above query so that it looks for all potential results based on partial matching of letters?

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=327780.0

Hi Everyone   I am new in PHP and when i was trying to see live preview of my one of the PHP site then it was not showing properly. all the formats, color, images were not showing, i don't know whats the problem.

i've use php-event-calender for showing event from table.when i click on event date, it's dispay table details for relevent date correctly in localhost.but it's didn't show details in live server.

hello sir,

            i  have to connect database to my live server using 

<?php

define('DB_HOST', 'localhost');
define('DB_NAME', 'oop_pdo_crud');
define('DB_USER', 'root');
define('DB_PASS', '');

?>

or 

 

Hi   I'm looking for some advice on how to parse an xml feed and display any odds on my site   Here is an example http://feed.youwincd...in_football.xml   and as you can see it is quite large so calling it every time would have an impact on the server.   I am looking at using many different feeds in the future so want to start this properly and in a scaleable way. I want to use php but open to any ideas on the best way to do this   Many thanks Sam

good day, hello dear community!


i am currently ironing out a little parser-script. I have some bits
 - but now i need to have some improved spider-logic. See the target-url http://192.68.214.70/km/asps/schulsuche.asp?q=e&a=50

This page has got more than 6000 results!

Well  how do i get all the results?

I tried out several things - but i dont helped. I allways got bad results.
See i have good csv-data - but unfortunatley no spider logic...  I need some bits to get there! How to get there!?

I use the module LWP::simple and i need to have some improved arguments that i can use in order to get all  the 6150 records




#!/usr/bin/perl
use warnings;
use strict;
use LWP::Simple;
use HTML::TableExtract;
use Text::CSV;

my $html= get 'http://192.68.214.70/km/asps/schulsuche.asp?q=n&a=50';
$html =~ tr/r//d;     # strip the carriage returns
$html =~ s/&nbsp;/ /g; # expand the spaces

my $te = new HTML::TableExtract();
$te->parse($html);

my @cols = qw(
    rownum
    number
    name
    phone
    type
    website
);

my @fields = qw(
    rownum
    number
    name
    street
    postal
    town
    phone
    fax
    type
    website
);

my $csv = Text::CSV->new({ binary => 1 });

foreach my $ts ($te->table_states) {
    foreach my $row ($ts->rows) {

trim leading/trailing whitespace from base fields
        s/^s+//, s/\s+$// for @$row;

load the fields into the hash using a "hash slice"
        my %h;
        @h{@cols} = @$row;

derive some fields from base fields, again using a hash slice
        @h{qw/name street postal town/} = split /n+/, $h{name};
        @h{qw/phone fax/} = split /n+/, $h{phone};

trim leading/trailing whitespace from derived fields
        s/^s+//, s/\s+$// for @h{qw/name street postal town/};

        $csv->combine(@h{@fields});
        print $csv->string, "\n";
    }
} 

Well - with this i have a good csv-output:- but unfortunatley no spider logic.


How to add the spider-logic here... !?

well i need some help

Love to hear from you

good evening dear community! Howdy,


at the moment i am debugging some lines of code...


purpose: i want to process multiple webpages, kind of like a web spider/crawler might. I have some bits - but now i need to have some improved spider-logic. See the target-url http://192.68.214.70/km/asps/schulsuche.asp?q=e&a=50

This page has got more than 6000 results! Well how do i get all the results? I use the module LWP::simple and i need to have some improved arguments that i can use in order to get all the 6150 records

Attempt: Here are the first 5 page URLs:

http://192.68.214.70/km/asps/schulsuche.asp?q=e&a=50&s=0 
http://192.68.214.70/km/asps/schulsuche.asp?q=e&a=50&s=50 
http://192.68.214.70/km/asps/schulsuche.asp?q=e&a=50&s=100 
http://192.68.214.70/km/asps/schulsuche.asp?q=e&a=50&s=150 
http://192.68.214.70/km/asps/schulsuche.asp?q=e&a=50&s=200

We can see that the "s" attribute in the URL starts at 0 for page 1, then increases by 50 for each page there after.  We can use this information to create a loop:





#!/usr/bin/perl  
use warnings;  
use strict;  
use LWP::Simple;  
use HTML::TableExtract;  
use Text::CSV;  
 
my @cols = qw(  
    rownum  
    number  
    name  
    phone  
    type  
    website  
);  
  
my @fields = qw(  
    rownum  
    number  
    name  
    street  
    postal  
    town  
    phone  
    fax  
    type  
    website  
);  
  
my $i_first = "0";   
my $i_last = "6100";   
my $i_interval = "50";   
   
for (my $i = $i_first; $i <= $i_last; $i += $i_interval) {   

my $html = get("http://192.68.214.70/km/asps/schulsuche.asp?q=e&a=50&s=$i");   

$html =~ tr/r//d;     # strip the carriage returns  

$html =~ s/&nbsp;/ /g; # expand the spaces  
  

my $te = new HTML::TableExtract();  

$te->parse($html);  
  

my $csv = Text::CSV->new({ binary => 1 });  
  

foreach my $ts ($te->table_states) {  

foreach my $row ($ts->rows) {  
 

#trim leading/trailing whitespace from base fields  

s/^s+//, s/\s+$// for @$row;  

 

#load the fields into the hash using a "hash slice"  

my %h;  

@h{@cols} = @$row;  
  

#derive some fields from base fields, again using a hash slice  

@h{qw/name street postal town/} = split /n+/, $h{name};  

@h{qw/phone fax/} = split /n+/, $h{phone};  
  

#trim leading/trailing whitespace from derived fields  

s/^s+//, s/\s+$// for @h{qw/name street postal town/};  
  

$csv->combine(@h{@fields});  

print $csv->string, "\n";  

}  

} 
}





i tested the code and  get the following  results: .- see below - the error message shown in the command line...

btw: here the lines 57 and 58:

#trim leading/trailing whitespace from derived fields  

s/^s+//, s/\s+$// for @h{qw/name street postal town/};  

what do you think?
 



 Sta&#65533;e
    please                                                                                                                                                                                                  
    Ot",,,Telefo,Fax,Schulat,Webseite                                                                                                                                                                    
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.                                                                                                                     
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.                                                                                                                     
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.                                                                                                                     
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.                                                                                                                     
"lfd. N.",Schul-numme,Schul,"ame                                                                                                                                                                         
    Sta&#65533;e                                                                                                                                                                                                
    please                                                                                                                                                                                                  
    Ot",,,Telefo,Fax,Schulat,Webseite                                                                                                                                                                    
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.                                                                                                                     
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.                                                                                                                     
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.                                                                                                                     
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.                                                                                                                     
"lfd. N.",Schul-numme,Schul,"ame                                                                                                                                                                         
    Sta&#65533;e
    please 
    Ot",,,Telefo,Fax,Schulat,Webseite
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.
"lfd. N.",Schul-numme,Schul,"ame
    Sta&#65533;e
    please 
    Ot",,,Telefo,Fax,Schulat,Webseite
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.
Use of uninitialized value $_ in substitution (s///) at bavaria_all_guru.pl line 58.
"lfd. N.",Schul-numme,Schul,"ame