₦airaland Forum

Hello landers,
Am working on a membership attendance system, i have build the application but needed to integrate fingerprint scanner into the application just like jamb did on there website, i made some research online and came across some some fingerprint scanner and sdk but my problem is if am using sdk how do integrate it into my php application, or how else can i do this?

Hello Every one,

Am building a browser base application with php, this application is to run on a local network ( intranet ). I want to hide the browser address bar so i use javascript ( window.open("userlogin.php","null","width=600,height=500,toolbar=no,location=no,directories=no ,status=yes,menubar=no,scrollbars=no,resizable=yes"; )

it hide others but could not hide location bar on modern browser. So How else can one hide the browser location bar? thought of using jquery or ajax but got no result. How can i hide the browser location bar in mordern browser?

Hello landers

Am trying to include a php page when function is been call so i use this code



document.getElementById("content".innerHTML = "<?php include('file.php'); ?>";

It didn't work for me.

pls any help will be grateful

hello landers

Am trying to integrate an sms gateway on my php site, just to send the sms from my site only. I do have some couple of gateway with me, they send d sms but could not redirect the user back to my site.
pls can anybody recomend a good sms API that ll redirect the user back to my site after succesfull submission?

Thanks in advance

HELLO ALL
Am building a POS (inventory system) with PHP and i wish to incorporate a barcode system, pls how do i go about it?

Is there any way i can read and input the value in my form field?

the DB

Hello landers
Am good in checking the existence of one data in a table using phpmysql but
I will be grateful if some one could help me on this one.

this is what i want to do
I have a table of 100 records (rows) already, I now have another 50 records in excel to be added. but i want to check againts duplication and flag those that already exist first
so i want to check this 50 names simultaneously
in either of this ways
PHP read the excel that contains new 50 records and write those that duplicate in another excel sheet
or
one copy the names of the new 50 records and past in a form field (text area) seperated by comma and click check and php compare and display those duplicate, or write to excel those duplicate


HOPE IS EXPLANATORY

have downloaded jquery plugins and jquery 1.4.2.min.js
Am trying to use a jquery menu but i can't call it up
HOW DO CALL IT to display it where i want?
pls any help or link will be welcome

thank you in advance

have just added http:// to the link and is working now

but the images is not still working!

Hello Landers!

I do use smtp to send mail on my site, at this point i wanted send mail with images (logo) but my smtp sent mail as plan text and not HTML. I try to alter the header with Content-Type = text/HTML and MIME VERSION = 1.0 in order to send mail with images but nothing work. Now I've turn to PHPMailer thinking that will make it easier (yes the mail is sent) but the image or logo is not showing instead it display an image icon. secondly the body contain a link (it change the color and underline it) but the link is not working on click. here is the code

require("class.phpmailer.php";
require("class.smtp.php";

$mail = new PHPMailer();

$mail->IsSMTP(); // set mailer to use SMTP
$mail->Host = "smtp.mydomain.com"; // specify main and backup server
$mail->SMTPAuth = true; // turn on SMTP authentication
$mail->Username = "name@mydomain.com"; // SMTP username
$mail->Password = "password"; // SMTP password

$mail->From = "name@mydomain.com";
$mail->FromName = "PRODUCT";
$mail->AddAddress("$email", "$surn";
//$mail->AddAddress("ellen@example.com"; // name is optional
//$mail->AddReplyTo("info@example.com", "Information";

$mail->WordWrap = 50; // set word wrap to 50 characters
//$mail->AddAttachment("/var/tmp/file.tar.gz"; // add attachments
//$mail->AddAttachment("/tmp/image.jpg", "new.jpg"; // optional name
$mail->IsHTML(true); // set email format to HTML

$mail->Subject = "PRODUCT REGISTRATION";
$mail->Body = "

<img src=', /img/jpy/nddclogo.jpg'/> \n\n

my msg after the logo

";
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";

if(!$mail->Send())
{
echo "Message could not be sent. <p>";
echo "Mailer Error: " . $mail->ErrorInfo;
exit;
}

echo "Message has been sent";

?>


any help will be gratefull

I just added the content-type and MIME VERSION just like below

$headers = array ('From' => $from,
'To' => $to,
'Subject' => $subject,
'MIME-Version' => 1.0,
'charset' => "iso-8859-1",
'Content-Type' => text/html);

yet is not showing the image

Hello landers!!

PHP is what i use. have been using smtp to send mail and it works fine but now i want to add an image ( logo) as part of the msg
with my script when received, the email display the image code (<img src=', /img/logo.jpg' /> ) instead of the image

here is my smtp code


<?php
require_once "Mail.php";

$from = "Main product <name@mydomain.com>";
$to = "$surn <$email>";//variable for the receiver name and email
$subject = "Thank you: registration ok!";
$body = "<img src=', /img/jpy/nddclogo.jpg'/> \n\n Congratulation $surn Your registration for our product has just begun.\n\n To complete your registration click on link below,\n\n <a href='www.mydomain.com/regform1.php?mail=$email'>examingscholarships.com.md_rand(10000000,99999999).complete registration for product</a> \n\n Remember, Double Registration will automatically disqualified you, dont use your email for another registration.\n\n
MAIN PRODUCT\n\n
…. today opportunity for a better tomorrow.\n\n
\n\n
\n\n
\n\n
Regard\n\n
main product\n\n
enquiries@mydomain.com \n\n
www.mydomain.com\n\n


";

$host = "smtp.mydomain.com";
$username = "name@mydomain.com";
$password = "password";

$headers = array ('From' => $from,
'To' => $to,
'Subject' => $subject);
$smtp = Mail::factory('smtp',
array ('host' => $host,
'auth' => true,
'username' => $username,
'password' => $password));

$mail = $smtp->send($to, $headers, $body);

if (PEAR::isError($mail)) {
echo("<p>" . $mail->getMessage() . "</p>";
}
/*else {
echo("<p>Message successfully sent!</p>";
}
*/
?>

Before than i try using mysql because am pretty good with mysql but i have not use it on a local network b4
if i install the mysql (wamp) on the computer that serve as the main server on the network, what will be the hostname (kalutech or localhost of apache)?

(the network hostname is kalutech)

<?php
$host = "localhost";
$link = mysql_connect("localhost", "username", "password";


if (!$link) {
die('could not connect to MYSQL');
}
?>

HELLO NAIRALANDERS

I have about 10 computer on a local network of which one is the server (MSSQL SERVER 2005)
Am writing an application on one system with php
i want to connect to the MSSQL database on the server with php so on my connection page i have this script


<?php

$server = 'kalustech\SQLEXPRESS';

$link = mssql_connect($server, 'username', 'password');

if (!$link) {
die('Could not connect to MSSQL');
}

?>



i try it but it did not connect to it, is that script correct? or how should i put it

<?php require_once("condb.php";?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php
$emp = mysql_query("SELECT E_ORG_NAME FROM register"or die (mysql_error()); //mysql_query("SELECT * FROM jobcat" or die (mysql_error());

$Num_rows=mysql_num_rows($emp);
?>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style32 {color: #00CC99}
-->
</style>
</head>

<body>
<table width="567" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="567" height="289" valign="top"><form id="dployform" name="dployform" method="post" action="">
<table width="559" height="95" border="0" cellpadding="0" cellspacing="0" bgcolor="#00CC99">
<!--DWLayoutTable-->
<tr>
<td colspan="2"><label>
<input name="textfield" type="text" size="15" />
</label></td>
<td width="67" bgcolor="#00CC99">&nbsp;</td>
<td><label>
<select name="employer" id="employer">
<?php if($Num_rows >=1){while($emprow = mysql_fetch_array($emp) or die (mysql_error()))
{
echo "<option value = \"{$emprow['E_ORG_NAME']}\">{$emprow['E_ORG_NAME']} </option>";
}
}else{
echo "<option> {$emprow['E_ORG_NAME']} </option>";
}
?>
</select>
</label></td>
<td width="4" bgcolor="#00CC99"><!--DWLayoutEmptyCell-->&nbsp;</td>
<td width="155"><label>
<input name="textfield3" type="text" size="15" />
</label></td>
</tr>
<tr class="styleone">
<td colspan="2">Employer ID </td>
<td bgcolor="#00CC99">&nbsp;</td>
<td>Employer Name </td>
<td bgcolor="#00CC99"><!--DWLayoutEmptyCell-->&nbsp;</td>
<td>Supervisor</td>
</tr>
<tr>
<td width="165" height="26"><input name="textfield4" type="text" size="15" /></td>
<td colspan="2" bgcolor="#00CC99"><label></label></td>
<td><input type="text" name="textfield82" /></td>
<td bgcolor="#00CC99"><span class="style32">
<label>SSSSS</label>
</span></td>
<td>&nbsp;</td>
</tr>
<tr class="styleone">
<td height="26" colspan="2">Participant ID </td>
<td bgcolor="#00CC99">&nbsp;</td>
<td>Trainee Name </td>
<td bgcolor="#00CC99"><!--DWLayoutEmptyCell-->&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="26" colspan="2"><label>
<input type="text" name="textfield6" />
</label></td>
<td bgcolor="#00CC99"><label></label></td>
<td><label>
<input type="text" name="textfield7" />
</label></td>
<td bgcolor="#00CC99"><!--DWLayoutEmptyCell-->&nbsp;</td>
<td><input type="text" name="textfield8" /></td>
</tr>
<tr class="styleone">
<td height="13" colspan="2">Job Categories </td>
<td bgcolor="#00CC99">&nbsp;</td>
<td>Date of Deployment</td>
<td bgcolor="#00CC99"><!--DWLayoutEmptyCell-->&nbsp;</td>
<td>Date of Commencment</td>
</tr>
<tr>
<td height="14" colspan="2">&nbsp;</td>
<td bgcolor="#00CC99">&nbsp;</td>
<td>&nbsp;</td>
<td bgcolor="#00CC99"><!--DWLayoutEmptyCell-->&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="14" colspan="2">&nbsp;</td>
<td bgcolor="#00CC99">&nbsp;</td>
<td>&nbsp;</td>
<td bgcolor="#00CC99"><!--DWLayoutEmptyCell-->&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="14" colspan="2">&nbsp;</td>
<td bgcolor="#00CC99">&nbsp;</td>
<td>&nbsp;</td>
<td bgcolor="#00CC99"><!--DWLayoutEmptyCell-->&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="14" colspan="2">&nbsp;</td>
<td bgcolor="#00CC99">&nbsp;</td>
<td><input type="submit" name="Submit" value="Deployed Trainee" /></td>
<td bgcolor="#00CC99"><span class="style32">
<label></label>
</span></td>
<td>&nbsp;</td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style32 {color: #00CC99}
-->
</style>
</head>

<body>
<table width="567" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="567" height="289" valign="top"><form id="dployform" name="dployform" method="post" action="">
<table width="559" height="95" border="0" cellpadding="0" cellspacing="0" bgcolor="#00CC99">
<!--DWLayoutTable-->
<tr>
<td colspan="2"><label>
<input name="textfield" type="text" size="15" />
</label></td>
<td width="67" bgcolor="#00CC99">&nbsp;</td>
<td><label>
<select name="employer" id="employer">
<option value = "INTERLINK">INTERLINK </option><option value = "LAPTOP SHOP">LAPTOP SHOP </option><option value = "Technosprings">Technosprings </option><option value = "Computer Shop">Computer Shop </option>

Yes when i preview and view the source code, i discover that the tag ( </select> ) which suppose to close the select tag is not there, that probably is where the problem is coming from. but when i view the script on the system the clossing tag is there

this is the source code of the browser( view source page):

<select name="employer" id="employer">
<option value = 'INTERLINK'>INTERLINK </option><option value = 'LAPTOP SHOP'>LAPTOP SHOP </option><option value = 'Technosprings'>Technosprings </option><option value = 'Computer Shop'>Computer Shop </option>


The </select> is not there.

Now this is the code on my machine

<form id="trainee" name="trainee" method="post" action="">
<table width="508" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="83">Deploye</td>
<td width="152"><label>
<input type="text" name="textfield2" />
</label></td>
<td width="31">To</td>
<td width="139"><label>
<select name="employer" id="employer">
<?php if($Num_rows >=1){while($emprow = mysql_fetch_array($emp) or die (mysql_error()))
{
echo "<option value = '{$emprow['E_ORG_NAME']}'>{$emprow['E_ORG_NAME']} </option>";
}
}else{
echo "<option> No Employee Selected </option>";
}
?>
</select>
</label></td>
<td width="142"><label>
<input type="submit" name="Submit2" value="Get Participant" />
</label> </td>

</tr>
</table>
</form>

So i dont still know why the closing tag is not showing on the browser.

Yes When i preview and view the source code on a browser, i discover that the closing tag ( </select> ) is not there
But the closing tage is showing on my mechine

Hello Every body

Am not hundred percent Good in Php but i like using it for my web, However i encounter this challenge

I have a form that contain dropdownlist and other form object,
I populate the dropdown from mysql table and it's working fine but it make other form element even the button to be hidden Why?
when i preview the dropdown and element befor the dropdown is showing but other element after the dropdown including the button did not show.

i dont know if i make myself clear, here is the code


<form id="trainee" name="trainee" method="post" action="">
<table width="508" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="83">Deploye</td>
<td width="152"><label>
<input type="text" name="person" />
</label></td>
<td width="31">To</td>
<td width="139"><label>
<select name="employer" id="employer">
<?php if($Num_rows >=1){while($emprow = mysql_fetch_array($emp) or die (mysql_error()))
{
echo "<option value = '{$emprow['E_ORG_NAME']}'>{$emprow['E_ORG_NAME']} </option>";
}
}else{
echo "<option> {$emprow['E_ORG_NAME']} </option>";
}
?>
</select>
</label></td>
<td width="142"><label>
<input type="submit" name="Submit2" value="Get Participant" />
</label> </td>

</tr>
</table>
</form>


the button is not showing only the select input