Generating a CDR file using PHP scripts.


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Generating a CDR file using PHP scripts.
# 1  
Old 04-11-2006
Generating a CDR file using PHP scripts.

Hi,

I need to do croning in PHP to generate a CDR (Call Details Record) file daily from the mysql database.

The CDR file has to be named in a certain sequence such as xx00000xxx200604080850.cdr. A new file is written every day.

The generated CDR file is then ftp over to a server.

I am willing to pay for someone who is able to write the PHP scripts to perform the above mentioned job for me.

Cheers,
kurl
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check to see if a file is generating

Hi guys, I am pulling my hair out here. I have a file that comes in, once it finishes i want to move it to a new location. This sounds all very easy but my solution is failing and moves the file before it has finished generating. isrun=`ps -ef | grep -i filename | grep -v grep | wc -l` ... (8 Replies)
Discussion started by: twinion
8 Replies

2. Shell Programming and Scripting

Help with appending random sequence to huge CDR file

Hi, I am in a terrible emergency. I have multiple cdr files with line count >6000. I need to append |0| | | | | | | |random| to end of each line. The random number should never repeat. Please help with a shell script to process all cdr's in a directory with above requirement. (23 Replies)
Discussion started by: shiburnair
23 Replies

3. UNIX for Dummies Questions & Answers

Generating Dynamic Scripts

Hi, Please give me an idea on how to achieve the below using a unix script. From our source team we are getting files with in-proper delimiters because of which our data load is failing to avoid this we want to generate dynamic scripts as below. Read the no of delimiters(which is dynamic... (6 Replies)
Discussion started by: mora
6 Replies

4. Shell Programming and Scripting

CDR manupulation

Hello Friends, I need to examine a huge CDR file according to a complex (at least for me) condition like below and i couldnt write anything :( In CDR file there are more than hundreds of fields, I need to print the rows which matches the below condition: while $13 field of subsequent... (9 Replies)
Discussion started by: EAGL€
9 Replies

5. UNIX for Advanced & Expert Users

Running multiple php scripts into one php only, cron mail alert problem...

hi, while separated they produce the usual mail alert and i can see the output... if i write into the php script: <?php system('php -f /var/www/vhosts/domain.com/httpdocs/folder/script1.php'); system('php -f /var/www/vhosts/domain.com/httpdocs/folder/script2.php'); system('php -f... (0 Replies)
Discussion started by: 7stars
0 Replies

6. Shell Programming and Scripting

Performance issue in UNIX while generating .dat file from large text file

Hello Gurus, We are facing some performance issue in UNIX. If someone had faced such kind of issue in past please provide your suggestions on this . Problem Definition: /Few of load processes of our Finance Application are facing issue in UNIX when they uses a shell script having below... (19 Replies)
Discussion started by: KRAMA
19 Replies

7. Shell Programming and Scripting

Ksh - finding pattern in file and generating a new file

I am trying to find for the pattern in first 5 bytes of every line in a text file and then generate a new file with the pattern found. Example: expected pattern is '-' to be serached in first 5 bytes of file only. Input File ab-cd jan-09 ddddd jan09 cc-ww jan09 dsgdq jan-09 ... (2 Replies)
Discussion started by: net
2 Replies

8. Shell Programming and Scripting

parsing large CDR XML file

Dear Freind in the file attached how parse the data to be like a normal table :D (3 Replies)
Discussion started by: saifsafaa
3 Replies

9. Shell Programming and Scripting

Bash Scripts - File generating

Forgive the daft requests - I'm still a learner :D I need a script so that I can test another script (I'm confused already) The script I am looking for should generate a new file in the same directory (called newfile1 or what ever) and also generate text within the new file (Hello world? What... (1 Reply)
Discussion started by: JayC89
1 Replies

10. Filesystems, Disks and Memory

writing to a cdr drive.

ive looked around for software to do this in linux, but am still not sure how to. i want to be able to mount a cdr and write to it and be able to take the disk out and finish writing whatever i want to it at a later time. can we do this in linux? (4 Replies)
Discussion started by: norsk hedensk
4 Replies
Login or Register to Ask a Question
PDO_MYSQL-DSN(3)							 1							  PDO_MYSQL-DSN(3)

PDO_MYSQL DSN - Connecting to MySQL databases

	The PDO_MYSQL Data Source Name (DSN) is composed of the following elements:

	      o DSN prefix
		- The DSN prefix is mysql:.

	      o host - The hostname on which the database server resides.

	      o port - The port number where the database server is listening.

	      o dbname - The name of the database.

	      o unix_socket - The MySQL Unix socket (shouldn't be used with host or port).

	      o charset  - The character set. See the character set concepts documentation for more information.  Prior to PHP 5.3.6, this element
		was silently ignored. The same behaviour can be partly replicated with the PDO::MYSQL_ATTR_INIT_COMMAND driver option, as the fol-
		lowing example shows.

	      Warning

		      The  method  in  the  below  example  can only be used with character sets that share the same lower 7 bit representation as
		     ASCII, such as ISO-8859-1 and UTF-8. Users using character sets that have different representations (such as UTF-16 or  Big5)
		     must use the charset option provided in PHP 5.3.6 and later versions.

	      Example #1

		      Setting the connection character set to UTF-8 prior to PHP 5.3.6

		     <?php
		     $dsn = 'mysql:host=localhost;dbname=testdb';
		     $username = 'username';
		     $password = 'password';
		     $options = array(
			 PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
		     );

		     $dbh = new PDO($dsn, $username, $password, $options);
		     ?>

       +--------+-----------------------------------------------+
       |Version |						|
       |	|						|
       |	|		   Description			|
       |	|						|
       +--------+-----------------------------------------------+
       | 5.3.6	|						|
       |	|						|
       |	|  Prior to version 5.3.6, charset was ignored. |
       |	|						|
       +--------+-----------------------------------------------+
       Example #2

	      PDO_MYSQL DSN examples

	       The following example shows a PDO_MYSQL DSN for connecting to MySQL databases:

	      mysql:host=localhost;dbname=testdb

	      mysql:host=localhost;port=3307;dbname=testdb
	      mysql:unix_socket=/tmp/mysql.sock;dbname=testdb

       Note

	      Unix only:

	       When  the host name is set to "localhost", then the connection to the server is made thru a domain socket. If PDO_MYSQL is compiled
	      against libmysqlclient then the location of the socket file is at libmysqlclient's compiled in location. If  PDO_MYSQL  is  compiled
	      against mysqlnd a default socket can be set thru the  pdo_mysql.default_socket setting.

PHP Documentation Group 													  PDO_MYSQL-DSN(3)