Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve from database..... this format (PRMRMDU402).
firstname= prabhu, lastname=kumar, city=madurai,
pincode=624402....
i want first name first two letters and last name last two
letters ... city first two letters ... pin code last three
letters....
- 2 Answers
- 4336 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gaurav
$record = mysql_fetch_array(".........");
$fn = substr($record['firstname'], 0, 2);
$ln = substr($record['lastname'], -2);
$ct = substr($record['city'], 0, 2);
$pc = substr($record['pincode'], -2);
$final = strtoupper($fn.$ln.$ct.$pc);
echo $final;
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / ajit
SELECT SUBSTRING(`firstname`,1,2) as 'firstname',SUBSTRING
(`lastname`,-2) as 'lastname',SUBSTRING(`city`,1,2) as
'city',SUBSTRING(`pincode`,-3) as 'pincode' FROM
`user_info` WHERE 1
| Is This Answer Correct ? | 0 Yes | 0 No |
What is php crud api?
How to get ip address of clients machine?
Which is used to maintain the value of a variable over different pages?
How can you compare objects in php?
Tell me what type of operation is needed when passing values through a form or an url?
What is the purpose of pear in php?
How can we encrypt the username and password using PHP?
13 Answers Avaria, HCL, TCS, Xpert,
at present am learning lamp course sir ..i want to know the carrer prospectus in php ...is there any companies recruiting freshers in chennai ..for freshers how much can i demand as a fresher in php ....?i finished my mca ..please sugggest me to face interview in php asking salary details and all please suggest me how much can i ask as a fresher in php ? and also tel is there any openings in chennai for recruting php freshers send their emails and company info please ? please send ur valuable suggestions to kiranpulsar2007@gmail.com i hope u wil reply to my question thank u guys bye take care see u soon all the best to everyone
How can php and javascript interact?
What are the functions used in php?
Why do we show php code in browser?
Tell me how can we pass the variable through the navigation between the pages?
PHP 
