Re: How to display the image in html - Linux, Apache, MySQL, PHP Discussion Boards

Re: Auto Change Selection in Combo Box [modified]

enhzflep30-Jul-10 16:26

30-Jul-10 16:26

Sure, you can use the onChange event of the combos to trigger some script.

I'd initially thought you'd have to use ajax, though now I'm not so sure.

If you only want to use the fonts on the client machines, you could use something like this:

<html>
<head>
<script type="text/javascript">
function byId(e){return document.getElementById(e);}
function setFont()
{
	var tgt;
	                 
			 tgt = byId("output");
	       tgt.innerHTML = byId("textInput").value;
	tgt.style.fontFamily = byId("fontCombo").value;
	  tgt.style.fontSize = byId("sizeCombo").value;
	     tgt.style.color = byId("colCombo").value;
}
</script>
<style>
body { background-image: url(darkbg2.jpg);}
</style>
</head>
<body onLoad="setFont();">

<select id="colCombo" onChange="setFont();">
	<option value="#000000">Black</option>
	<option value="#FF0000">Red</option>
	<option value="#00FF00">Green</option>
	<option value="#0000FF">Blue</option>
	<option value="#FFFFFF">White</option>
</select>
	
<select id="sizeCombo" onChange="setFont();">
	<option value="5mm">5mm</option>
	<option value="1cm">10mm</option>
	<option value="15mm">15mm</option>
	<option value="2cm">20mm</option>
	<option value="1in">25mm</option>
	<option value="3cm">30mm</option>
</select>
	
<select id="fontCombo" onChange="setFont();">
	<option value="arial">Arial</option>
	<option value="courier">Courier</option>
	<option value="impact">Impact</option>
	<option value="tahoma">Tahoma</option>
	<option value="wingdings">Wing Dings</option>
</select>

<br>

<input type="text" id="textInput" size=33 value="Enter text here.." onKeyUp="setFont();" onChange="setFont();"/>

<div id="output"></div>

</body>
</html>

Though, since you use an image in your implementation this may be unsuitable. In that instance, I'd just
use an image and give it an id. Then, in the setFont function you can just do something like:

url = "http://www.sew-n-print.co.uk/render/font.php"
url += "?text="+byId("textInput").value; 
url += "&font="+byId("fontCombo").value;
url += "&color="+byId("colCombo").value;
url += "&size="+byId("sizeCombo").value;
url += "&vadj=50&hadj=25";
byId("myImgId").src = url;

I think that'll work.

<edit>
Yup, that works. Interesting (yet understandable) to see the lag for the image-based text.

Just make sure to remove the units from the size combo box, also the hashes from the colours.
Apologies for the total lack of formatting of the example code output.
</edit>

modified on Saturday, July 31, 2010 7:44 AM

MYSQL connect through PHP

offroaderdan30-Jul-10 0:23

offroaderdan

30-Jul-10 0:23

Hi,

I have an email through my web hosting service which has told me my database details.

they go
MySQL Hostname: 99.99.999.999
MySQL Username: xxx xxx
MySQL Passwor: aaaaahh
MySQL Server: MySQL 1

I was able to connect to a differnet database which did not have mysql server on it by using the following code

$hostname = "99.99.999.999"; <br />
       $password = "aaaaahh"; <br />
       $username = "xxx xxx"; <br />

Now i thought that this was simply going to be adding a $server variable on underneath so the complete code would look like this

$hostname = "99.99.999.999"; <br />
       $password = "aaaaahh"; <br />
       $username = "xxx xxx"; <br />
 $server = "MySQL 1"; <br />
<br />
$connection = mysql_pconnect($hostname, $server, $username, $password);<br />
<br />
if (!$connection)<br />
  {<br />
  die('Could not connect: ' . mysql_error());<br />
  }<br />
<br />
echo 'Connected successfully';<br />
mysql_close($connection)<br />
<br />
?><br />

However this doesn't seem to do anything?

Any help would be great

Many Thanks

Dan

Re: MYSQL connect through PHP

Graham Breach30-Jul-10 21:40

Graham Breach

30-Jul-10 21:40

Server and hostname usually mean the same thing - the address of the server. In any case, you have the arguments to mysql_pconnect[^] wrong, it should be:

$connection = mysql_pconnect($hostname, $username, $password);

This is assuming the server name is in the $hostname variable.

I suspect $server is actually the database name, so you should select this after connection using mysql_select_db[^].

if(!mysql_select_db($server, $connection)) { ...

Re: MYSQL connect through PHP

Shamit Kumar Tomar9-Aug-10 18:28

Shamit Kumar Tomar

9-Aug-10 18:28

Hi,

You are doing it wrong. The correct syntax of mysql_pconnect is:

$connection = mysql_pconnect($server, $username, $password, $client_flags);

So, if you have the hostname, you must use it instead of using ServerName. So, all you have to do is use this piece of code:

$hostname = "99.99.999.999"; 
$password = "aaaaahh"; 
$username = "xxx xxx"; 
$server = "MySQL 1";

$connection = mysql_pconnect($hostname, $username, $password);

if (!$connection)
{
die('Could not connect: ' . mysql_error());
}

echo 'Connected successfully';
mysql_close($connection);

See, I have not used $server anywhere. Not needed. Give it a try.
Enjoy.

Procrastination and Improvisation are my two swords to fight life.

My Portfolio Website

Re: MYSQL connect through PHP

Rockyonfire15-Aug-10 11:48

Rockyonfire

15-Aug-10 11:48

Server isnt a accepted value in the connection string.

How to display the image in html

sarang_k26-Jul-10 20:52

sarang_k

26-Jul-10 20:52

Hi all,

In the MySQL database i have stored the image as BLOB datatype.Now i want to display that image on the HTML page using the PHP coding.How can i do ?

Thanks in advance.

Re: How to display the image in html

Peace ON27-Jul-10 0:45

Peace ON

27-Jul-10 0:45

Let's say we store image in our mysql db with auto generated id. Then in following code
we are using image id to retrieve image and display it on html.

// just so we know it is broken
error_reporting(E_ALL);
// some basic sanity checks
if(isset($_GET['image_id']) && is_numeric($_GET['image_id'])) {
    //connect to the db
    $link = mysql_connect("localhost", "username", "password") or die("Could not connect: " . mysql_error());

    // select our database
    mysql_select_db("testblob") or die(mysql_error());

    // get the image from the db
    $sql = "SELECT image FROM testblob WHERE image_id=0";

    // the result of the query
    $result = mysql_query("$sql") or die("Invalid query: " . mysql_error());

    // set the header for the image
    header("Content-type: image/jpeg");
    echo mysql_result($result, 0);

    // close the db link
    mysql_close($link);
}
else {
    echo 'Please use a real id number';
}

Find more information click this[^] link.

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Re: How to display the image in html

bishtharish27-Jul-10 23:09

bishtharish

27-Jul-10 23:09

Simply use the select query to get the image field in the variable then use
print($variablename);
it will print the image
use the block within the HTML page to view the image as it cann't work in HTML tags.

How to convert from pdf to doc in php

sarang_k26-Jul-10 18:52

sarang_k

26-Jul-10 18:52

Hi all,

Can any one tell me how can i convert a file from pdf to doc using PHP code.

Thanks in advance.

Postmaster Redirect - Mailsystem Failure Delivery

Jayapal Chandran26-Jul-10 7:59

Jayapal Chandran

26-Jul-10 7:59

When a mail is bounced it has a standard subject.
Is it possible to change with a custom subject or the subject which we gave or with a dynamic subject?
I am building a simple system in php to count all send and not sent mails with the help of bounced mails.
So i need to parse the body of the bounced mail to find the email address to which the mail was not sent.
If there could be any other less overhead option then that could be nice. We can reduce the processing time to parse.

Today's Beautiful Moments are
Tomorrow's Beautiful Memories

choosing a opensource cart

duta25-Jul-10 5:06

duta

25-Jul-10 5:06

Hi there

During the last 6 months I've put some time into learn and building simple web based apps using the cakephp framework. At this moment, a friend is asking me to build a website with shopping cart support. I was thinking to use a magento or oscommerce, but after some digs I've find some cakephp plugins for that:
infinitas[^] and kaching-php[^].

It is a hard choose for me, because I'll like to be a long term choose. Do you have any idea, which of those cakephp based apps has a better written code?

How to embedded the image in doc using php

sarang_k23-Jul-10 1:04

sarang_k

23-Jul-10 1:04

Hi all,

how can i embedded an image in to the doc file using php ?

Thanks in advance.

Re: How to embedded the image in doc using php [modified]

enhzflep24-Jul-10 21:17

enhzflep

24-Jul-10 21:17

<?php
	$wordApp = new COM("Word.Application");
	$wordApp->visible = true;
	$wordApp->Documents->Add();
	$wordApp->Selection->TypeText("Code Project - PHP Office Automation Example - enhzflep: \n");
	$wordApp->Selection->InlineShapes->AddPicture("http://s.codeproject.com/App_Themes/Std/Img/logo225x90.gif");
	$wordApp->ActiveDocument->SaveAs("CP - php example");
	$wordApp->Quit();
	unset($wordApp);
?>

Hint: Try recording a macro in word and then checking out the generated vba code. Smile | :)

modified on Sunday, July 25, 2010 3:23 AM

Re: How to embedded the image in doc using php

sarang_k26-Jul-10 20:57

sarang_k

26-Jul-10 20:57

ya my friend i have tried this code.
But the problem is the function TypeText allows only Text data,but in the doc file i have to print data from database + from a .html file + an image.

How can i do it ? Is there any solution ?

Thanks in advance.

Re: How to embedded the image in doc using php

enhzflep27-Jul-10 12:34

enhzflep

27-Jul-10 12:34

I would argue that the code functions perfectly well & answers the question.
The problem it seems, is that the question doesn't match desired outcome.

I've answered the question and you still don't have what you want. Perhaps you could consider making the question actually relate to your query?

Exporting data to a doc file in php

sarang_k22-Jul-10 21:21

sarang_k

22-Jul-10 21:21

hi all,

Can any one tell me how can i export data to MS-Word i.e., to a .doc file or .docx file using php ?

Thanks in advance.

Re: Exporting data to a doc file in php

senorbadger18-Aug-10 3:38

senorbadger

18-Aug-10 3:38

Have a look at using word ml (word xml) format, then just push out all your data as xml text which can be read in word. (Just push it to the http stream with application/msword content type).

Hope this helps, not done this in PHP but the concept remains the same

Displaying entire row into different text boxes

rashmin8820-Jul-10 5:30

rashmin88

20-Jul-10 5:30

hi
I am working on a website & i am new to php i want to extract the entire details from a row in the database on to different text boxes. Is it possible to do so.

Any help would be great for me.
Thanks in advance. Thumbs Up | :thumbsup:

Re: Displaying entire row into different text boxes

cjoki21-Jul-10 8:23

cjoki

21-Jul-10 8:23

I guess you mean you will extract a row of data with each column being placed into a text field?

if so it would kinf of look like this

$fld1 = '';
$fld2 = '';
$fld3 = '';

$sql = "select * from aTable";
$rst = mysql_query($sql);
if(mysql_num_rows($rst)>0)
{
   $fld1 = $row['col1'];
   $fld2 = $row['col2'];
   $fld3 = $row['col3'];
}

echo "<input type='text' value='".$fld1."'>";
echo "<input type='text' value='".$fld2."'>";
echo "<input type='text' value='".$fld3."'>";

Hope that helps =)

Re: Displaying entire row into different text boxes

rashmin8822-Jul-10 19:14

rashmin88

22-Jul-10 19:14

That helped thanks cjoki Thumbs Up | :thumbsup:

How to export to doc in php

sarang_k20-Jul-10 0:48

sarang_k

20-Jul-10 0:48

Hi all,

I am having once problem that is i have exported all the date to the doc in php but i am not able to export the image to doc.

Can any one tell me how can i export images and data to a doc ?????

Thanks in advance.

Re: How to export to doc in php

Peace ON20-Jul-10 1:11

Peace ON

20-Jul-10 1:11

A colleague of mine came up with phpLiveDocx[^], a Zend Framework component and can read and write DOC and DOCX files in PHP on Linux, Windows and Mac.

But I haven't worked with it, might be helpful to you.

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Re: How to export to doc in php

sarang_k20-Jul-10 1:38

sarang_k

20-Jul-10 1:38

its something about mail merge...

Re: How to export to doc in php

Jayapal Chandran26-Jul-10 8:29

Jayapal Chandran

26-Jul-10 8:29

Oov.

. That could be nice.
So those people has played with the docx file format and has developed a script to generate a word document.
Hmm... like html2pdf conversions.

If people need to use in all platforms then why not convert it to a PDF.
There are lots of open sources written in simple php to convert so including images.
for all the users FYI. DOMPDF.com.

Today's Beautiful Moments are
Tomorrow's Beautiful Memories

PHP/SQL -> Duplicate data on Insert when Page is refreshed

lgmanuel19-Jul-10 22:53

lgmanuel

19-Jul-10 22:53

Hi guys., am having with duplicate entry on the DB when the Page is refreshed..

any solution please,. what am trying to do is when the data is added, the portion of the page loads, not the whole page, am using AJAX to load potion of the page..

help guys, thanks..

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.