PHP issue

8 More Discussions You Might Find Interesting

1. Red Hat

Update php 4.3 RPM to php 5.3.3 php

Dear All, My redhat version is: # cat /etc/redhat-release Red Hat Enterprise Linux AS release 4 (Nahant Update 4) # # uname -a Linux cotapplication3.cot.com 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:32:02 EDT 2006 x86_64 x86_64 x86_64 GNU/Linux # I want to update my php from: # php...

2. Shell Programming and Scripting

Variable value substitution issue with awk command issue

Hi All, I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command. The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The...

3. Shell Programming and Scripting

Need assistance with a file issue and a terminal issue

Hello everyone, I'm in need of some assistance. I'm currently enrolled in an introductory UNIX shell programming course and, well halfway through the semester, we are receiving our first actual assignment. I've somewhat realized now that I've fallen behind, and I'm working to get caught up, but for...

4. UNIX for Dummies Questions & Answers

ISSUE and ISSUE.NET files

In LINUX(CentOS, RedHat) is there a way to have the banner statement appear before the logon instead of after the logon? In UNIX and Windows the banner appears before a person actually logs on, what I'm seeing in LINUX is that it appears after the login(ftp, telnet, SSH). Thanks

5. UNIX for Dummies Questions & Answers

Linux PHP Executable Output Issue with IE

I have developed a PHP web page that executes a batch file and pipes the output to a file. It works fine when using Firefox, Safari, etc. However, when using IE, it does not work. $execute = `batch.bat $var1 $var2 | tee /batch.output`; print "<pre>$execute</pre>"; When the page is run in...

6. Shell Programming and Scripting

Unix Arithmatic operation issue , datatype issue

Hi, I have a shell scripting. This will take 7 digit number in each line and add 7 digit number with next subsequent lines ( normal addition ). Eg: 0000001 0000220 0001235 0000022 0000023 ........... ......... ........ Like this i am having around 1500000 records. After adding...

7. UNIX for Dummies Questions & Answers

PHP-MySQL: POST issue

I am moving from a shared hosting environment to a dedicated box. The migration also involves a mySQL database managed using a web-based PHP interface. I can read the contents of the db (connection is good) but when I try to administer, the form variables aren't going from step 1 (add) to step 2...

8. UNIX for Advanced & Expert Users

solaris 9 php-4.3.4 make issue

compiling 4.3.4 i'm running into the following error: quote: -------------------------------------------------------------------------------- Undefined first referenced symbol in file uncompress /usr/local/mysql/lib/libmysqlclient.a(my_compress.o) compress...

LEARN ABOUT PHP

pdo_mysql-dsn

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)

Linux