Re: [PHP] Freelance PHP development in India
Dear Ryan, Wolf. Apologies for asking from India only. No offence meant. It is because I am from India and I can personally meet and discuss with the programmers. Cost is also an issue. Mine is a startup and the finances are low. :-( Apologies. Denis - Original Message - From: Ryan S [EMAIL PROTECTED] To: Wolf [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: PHP General php-general@lists.php.net Sent: Monday, July 14, 2008 8:34 PM Subject: Re: [PHP] Freelance PHP development in India snip Dear friends. I am looking for freelance web developers in India. Can contact me? Why just in India? There are a number of us available via the world. Wolf /snip I'm guessing because he wants a REAL cheap solution... what you (probably) charge for 5-7hrs work would probably be the same that someone in india charges for a day or two or the whole project. HTH Cheers! R -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Freelance PHP development in India
Dear friends. I am looking for freelance web developers in India. Can contact me? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] counting hyperlink clicks in php
Dear friends. I have a site where I have news headers. I wish to count the clicks on the news headers so that I can see how many times each of the the news has been viewed. This way I can show the most viewed news. Can one of you please advise hwo this can be done? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Month display calendar
Dear friends. Can anyone please show me calendar scripts to make a calendar with a monthly display as shown in http://www.easyphpcalendar.com/ ? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Very good jobs site script?
Hi friends. There are so many job site scripts out there, so cannot decide. Can anyone suggest a great software? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] pls suggest a good and tested B2B software
Hi. I am looking for a good tried and tested B2B software like Alibaba. Can anyone please suggest if they have tried and running any? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Meed a multiple merchant shopping cart please
Hi. I am looking for a shopping cart where we can have teh following : 1. Multiple vendors on our site, 2. Have accounts for all these vendors on how much sales, profits etc for each seller. 3. Have a delivery module 4. Warehouse inventory 5. Customer complaints Can anyone suggest a good PHP software for this please? Thanks in advance. DM -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Scripts for customer - service provider web available?
Hello friends. I am in a hurry to make a website where suppliers can advertise their products and services and customers can place their requirements so the requirements can be matched with the service providers. Also vistors should be able to seek suppliers and customers. Can anyone tell me where I could find a ready made scripts program that does the above? Thanks denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] training material on PHP + MySQL + IIS + Windows 2000
Hello friends, Does anyone have a training course that can be bought or licensed for training PHP and WAMP? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Website to fax
Hello friends. I am trying to make a restaurant website where we can order on the net. However, since the waiters cannot watch emails, I want to convert the mail() messages from the webpage to a fax using an appropriate gateway. We want one gateway to server many web sites. Is there such a possibility? If yes, can someone please tell me how to start? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Website to fax
yes, but we plan to route the faxes based on the zip code to various outlets in the city. Thanks Denis Randum Ian [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Won't converting it to a printer be simpler and cheaper? Hello friends. I am trying to make a restaurant website where we can order on the net. However, since the waiters cannot watch emails, I want to convert the mail() messages from the webpage to a fax using an appropriate gateway. We want one gateway to server many web sites. Is there such a possibility? If yes, can someone please tell me how to start? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Randum Ian [EMAIL PROTECTED] CBDagency Web Consultant http://www.cbdagency.com DancePortalGlobal Webmaster http://www.danceportalglobal.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] scrolling tables within a page
Hello friends. My query output is about 20 to 30 records only. Instead of making the visitors scroll the whole page, can I make a scrolling table with the page such that the visitor scroll the results output table only? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] pdf problem
Hello friends. I was checking for creation of pdf document on the server. But i was getting Call to undefined function: pdf_new() in /home/andsales/public_html/sap/getpdf.php on line 2. Can anyone te;ll me a solution? Is there some problem with compilation of PHP with PDFLIB libraries? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] a good PHP free forum?
Hello friends. Can someone suggest a very good and easy to customise forum? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] isset function problem
I have the following code :
Quote:
if (isset($SenderEmailAddress)){
mail($mailTo, $mailSubject, $Message);
}
Unquote
All I want to do is that , if the $SenderEmailAddress is not entered, the
mail() function should not run. However,
if the $senderEmailAddress variable is not set, the error I get is No
recipient addresses found in header
Can someone help and tell me why I get this error?
Thanks
Denis
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] variable shortened in hidden fields?
Hello friends. I am passing a variable of two word like communications software from one form to the other. The variable passes as communications%20software . This is okay for some purpose, but not for the hidden text field that I want. The hidden text field gets the value communications only instead of communications software. Is there a way to solve this? Thanks Denis --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 6/18/2003 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Variable from hidden fields shortens.
I have a form called feedback which has a hidden field as follows : ?php Printinput type=\text\ name=\SubCategoryName\ value=\$SubCategoryName\; ? I send this hidden field as a variable in form2 which sends an email with the following code : ?php // Build up email header fields $mailFrom = $SenderName; $mailTo = [EMAIL PROTECTED]; $mailSubject = Message form mydomain.com; $link=Please follow this link .http://www.mydomain.com/findbymember.php?SubCategoryName=.$SubCategoryNa me; $Message=$SenderName had searched for '$SubCategoryName'. His/her details are as follows : .\n.Telephone number : .$SenderTelNumber.\n; $Message=$Message.Mobile number : .$SenderMobNumber.\n.Email address : .$SenderEmailAddress.\n; $Message=$Message.Address : .$SenderAddress; // Send email to member company mail($mailTo, $mailSubject, $Message,$link); ? When my variable in form 1 is Large Format Print, the mail that arrives is as follows : Please follow this linkhttp://www.findusnow.com/findbymember.php?SubCategoryName=Large Format Print Jack had searched for 'Large Format Print'. His/her details are as follows : Telephone number : 454588445 Email address : 989855564 Address : some address1, some home, some street, some city As you can see the link does not show the full variable at the end and shows only the word large instead of large Format Print can any of you help? Thanks denis --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 6/18/2003 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] php javascript problem
Hello friends.
I need to control the users viewing from one location so that when I change the URL
string in a text file, the viewers page which has a timer automatically reads the URL
on the text pages and goes to that page.
Updating the textfile is ok. But below is the script onthe page which I want to reload
every 10 seconds and display the name of the new page and go there.
There are two problems, when the page reloads, the PHP script that gets the new URL
from the text file does not seem to run.
Can someone please tell me where I am wrong?
Thanks very much.
Denis
?php
$fo=fopen(currenttext.txt,r+);
$currenturl=fgets($fo,128);
$currenturl=\.$currenturl.\;
Print $currenturl;
Printform name=\frmurl\;
Printinput type=\hidden\ name=\currenturl\ size=\4\ value=$currenturl ;
Print input type=\text\ name=\clock\ size=\4\;
Printform;
fclose($fo);
?
html
head
SCRIPT LANGUAGE=Javascript
!--
var x = 10
var y = 1
var url= document.frmurl.currenturl.value;
function startClock(){
x = x-y
document.frmurl.clock.value = x
setTimeout(startClock(), 1000)
if(x==0){
location=url
//window.location.reload()
//document.frmurl.clock.value = 10
//x=10;
}
}
//--
/script
Re: [PHP] PHP and IIS
Hi, Just a thought. Have u put all the dlls in the system32 forlder? Denis - Original Message - From: Beauford.2002 [EMAIL PROTECTED] To: PHP General [EMAIL PROTECTED] Sent: Sunday, March 23, 2003 8:03 AM Subject: [PHP] PHP and IIS I just installed Win2k server and IIS (need it for a project I am doing) and get the following error after installing PHP. All permissions are set correctly. This appears to be a common problem as a search comes up with hundreds of the same problem - funny though - no answers. Any help is appreciated. Technical Information (for support personnel) a.. Background: You have attempted to execute a CGI, ISAPI, or other executable program from a directory that does not allow programs to be executed. b.. More information: Microsoft Support -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Changing pages on another PC remotely?
Hello friends. This is a difficult one, but I need to try for my project. Can I have make a script where, pressing a button on one page in one PC causes a webpage change on another PC which is also on the internet? Thanks Denis
[PHP] Creating graphs with PHP?
hello friends, Is there a possibility to create graphs on a web page using PHP? I have loooked through the PHP manual but cannot find anything. Thanks very much. Denis
Re: [PHP] Re: Creating graphs with PHP?
Thanks guys for the help. I went to see JP graph. But what I cannot find out is how I can install jpgraph and GD libraries if I am hosting my site on a shared server with an ISP(one of those USD 24.95 per month with 200Mb space kind of thing). Please help. Denis - Original Message - From: Joseph Szobody [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 20, 2003 9:24 PM Subject: [PHP] Re: Creating graphs with PHP? Dennis, Try this: http://www.aditus.nu/jpgraph/ Joseph Denis L. Menezes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hello friends, Is there a possibility to create graphs on a web page using PHP? I have loooked through the PHP manual but cannot find anything. Thanks very much. Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Win XP prof + Mysql + Php + IIS
Hello friends.
This is the first time I am trying this combination : Win XP prof + Mysql + Php + IIS.
When I click submit in the test1.php page, the page goes to test2.php, but shows the
following error :
Notice: Undefined variable: StudentLastName in c:\inetpub\wwwroot\test\test2.php on
line 12
Notice: Undefined variable: StudentFirstName in c:\inetpub\wwwroot\test\test2.php on
line 12
Notice: Undefined variable: StudentTelNumber in c:\inetpub\wwwroot\test\test2.php on
line 12
error adding row
Can someone tell me what is wrong? My code is shown below.
test1.php :
=
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body
form name=form1 method=post action=test2.php
table width=800 border=0 cellspacing=0 cellpadding=0
tr
td width=244 bgcolor=#99strongfont color=#00 size=2
face=Arial, Helvetica, sans-serifLast
name/font/strong/td
td width=556input name=StudentLastName type=text
id=StudentLastName/td
/tr
tr
td bgcolor=#99strongfont color=#00 size=2 face=Arial,
Helvetica, sans-serifFirst
name/font/strong/td
tdinput name=StudentFirstName type=text id=StudentFirstName/td
/tr
tr
td bgcolor=#99strongfont color=#00 size=2 face=Arial,
Helvetica, sans-serifTelephone
number/font/strong/td
td input name=StudentTelNumber type=text id=StudentTelNumber/td
/tr
tr
tdfont color=#CCnbsp;/font/td
tdinput type=submit name=Submit value=Submit/td
/tr
/table
/form
pnbsp;/p
/body
/html
test2.php :
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body
?php
$query=INSERT INTO tblstudents (StudentLastName,StudentFirstName,StudentTelNumber)
VALUES ( '$StudentLastName','$StudentFirstName','$StudentTelNumber' ) ;
IF (mysql_query($query)){
print Congratulations ! Your data has been noted in the students database;
} else {
print error adding row;
}
?
/body
/html
[PHP] Microsoft access + php
Sorry folks, This question must have been asked many times before, and I must have missed it. Can someone please lead me to some tutorial where I can PHP and Microsoft Access? thanks Denis
[PHP] pagination help
Hello friends. My records on one page are bout 200. So I wish to paginate them and show only about 20 records per page with the page numbers at the bottom of the records table and also the previous and next links. I mean, something line Google's searcg results page numbering system. Can someone give me a link to some help files? Thanks Denis
[PHP] mail() function
Hello friends, Can the mail() function send emails to multiple addresses which are formatted as follows : [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED] etc with a comma or a semicolon between them? Thanks Denis
[PHP] strange problem
Hello friends, Following is the part html output of my page got from View-source in IE. The problem is that I gate a big blank gap on the output page from the top until about 10 lines height and only then the table is displayed. As you see I have no BR tags here. Can someone tell me why I get blank space? Quote : html head titleUntitled Document/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body table width=800 border=0 cellspacing=0 cellpadding=0 tr td colspan=6 STRONGThe Whatson database has found the following 15 students :/STRONG /td /tr tr td width=106nbsp;/td td width=570nbsp;/td td width=30nbsp;/td td width=30nbsp;/td td width=30nbsp;/td td width=34nbsp;/td /tr tr td Unquote Thanks Denis
[PHP] Deciding the directory for the uploaded file?
Hello friends. I have seen some php scripts for uploading files. They all mention thet the file goes to a temporary folder. How can I upload the file to a particular folder that I have created? Thanks very much. Denis
[PHP] editing field value using selectbox with options
Hello friends. In an edit form, I need the following select box. select name=MemPicSalutation id=MemPicSalutation option value=Mr.Mr./option option value=Ms.Ms./option option value=Mrs.Mrs./option option value=Dr.Dr./option option value=Capt.Capt./option /select My problem is : since I am getting the selected value from the database and showing it (for editing the option value and later updating), I do not know how to show the selected value(value of the option from the existing field value in the database) in the edit form(when opening the edit form) along with the other option values. Can someone help? I am using PHP and $row. Thanks denis
Re: [PHP] Send mail with hidden copy.
Or just make another mail() function with new variables. Denis - Original Message - From: Wico de Leeuw [EMAIL PROTECTED] To: Skyhawk [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:41 PM Subject: Re: [PHP] Send mail with hidden copy. add an etra header (see mail function) and use the bcc: email header Gr At 11:39 25-2-03 -0300, Skyhawk wrote: How do I make to I send mail with hidden copy? What the correct sintax?? thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Splitting a date string
Hello friends, I have a date string in the format -mm-dd in the MySQL database. In my edit form I need to split this date string to get $Year as , $month as mm and $day as dd . Can someone please help me with the code? Thanks Denis
Re: [PHP] PHP running on Win 2000 and IIS
Hello John. Thanks. Do you mean you run win 2000 + PHP + MySQL? For MySQL to run properly, will the standard binary downloaded from the website suffice or do I need to purchase some other version of MySQL? Also is there a good MySQL GUI for Windows machines? Thanks very much. Denis Thanks denis - Original Message - From: John W. Holmes [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, February 22, 2003 1:43 PM Subject: RE: [PHP] PHP running on Win 2000 and IIS I wish to run PHP on a Win 2000 server, MS SQL and IIS. Can someone please guide me to some place where there are some tutorials on how to install and run the above? The PHP manual has an installation channel the works. Also are there any problems by running PHp on Win 2000, MS SQL and IIS? Not that I've noticed. I use all that except for MSSQL, thankfully. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] flashing text possible on PDA?
Hello friends. I am developing some light pages on the web basically for access by PDAs. I need to put and alert for some members so that as soon as they log in, the next page will show a flashing alert on the page. Can anyone suggest how I can make text flash on a PDA considering that the PDA browsers do not support many Javascript commands? Thanks Denis
[PHP] PHP running on Win 2000 and IIS
Hello friends, I wish to run PHP on a Win 2000 server, MS SQL and IIS. Can someone please guide me to some place where there are some tutorials on how to install and run the above? Also are there any problems by running PHp on Win 2000, MS SQL and IIS? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] RE: PHP-based SMS solution
I use an international mail-to-sms service provider. I generate emails and they send them as sms messages internationally for a fee per message which I record in a database and charge the customer as value added service. Denis - Original Message - From: YC Nyon [EMAIL PROTECTED] To: php [EMAIL PROTECTED] Sent: Wednesday, February 12, 2003 9:50 PM Subject: [PHP] RE: PHP-based SMS solution I am developing a web-based GPS vehicle tracking solution using php. I'm looking on how php can communicate with a SMSC using Smpp to issue AT commands. Development platform is windows 2000. Thanks Nyon --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Help to make tables please.
Hello friends.
I want the output of my quesry to be formatted such that afdter every 7th output, the
8th one should start on a new row in ythe tabel. I have written the following code but
does not work. Can someone please help?
Quote :
?php
while($row=mysql_fetch_array($result)){
$i=$i+1;
if ($i==7){
Print /trtr;
Printtd width=\150\ w;
Print a href=\findbycategory.php?.CategoryId=.$row[CategoryId] .\font
color=\#40\ size=\2\$row[CategoryName]/font/a. ;
Print /td;
}else{
Print tr;
Printtd width=\150\ w;
Print a href=\findbycategory.php?.CategoryId=.$row[CategoryId] .\font
color=\#40\ size=\2\$row[CategoryName]/font/a. ;
Print /td;
if ($i==6){
Print /tr;
}}
}
?
Unquote
Thanks
Denis
[PHP] need help with a table please - sorry
Hello friends.
Sorry I sent the wrong code in my last mail. Here is my correct code.
I want the output of my query to be formatted such that after every 7th output, the
8th one should start on a new row in the table. I have written the following code but
does not work. Can someone please help?
Quote :
table width=800 border=0 cellspacing=0 cellpadding=3
tr
?php
$i=0;
while($row=mysql_fetch_array($result)){
$i=$i+1;
if ($i==7){
Print /trtr;
Printtd width=\150\ ;
Print a href=\findbycategory.php?.CategoryId=.$row[CategoryId] .\font
color=\#40\ size=\2\$row[CategoryName]/font/a. ;
Print /td;
}else{
Print tr;
Printtd width=\150\ ;
Print a href=\findbycategory.php?.CategoryId=.$row[CategoryId] .\font
color=\#40\ size=\2\$row[CategoryName]/font/a. ;
Print /td;
if ($i==6){
Print /tr;
}}
}
?
div align=centernbsp;/div/td
/tr
/table
Unquote.
Thanks very much.
Denis
[PHP] A scrollable area within a page?
Hello friends, Can anyone please suggest me some lnks orhelp me with some info on how to make 2 scrollable areas inside one webpage? Also, can I put dynamic data output into these areas? Thanks very much. Denis
[PHP] Date and time problem
Hello friends. The follwing code displays the date on my webpage : echo date (l dS of F Y h:i:s A); However, I need to add 12 hrs to this date befor displaying on the webpage. Can someone please help me to modify the above code? Thanks Denis
[PHP] Listbox variable
Hello friends.
I have the following code :
The code works fine and the listbox is populated. But when I select a category and
press the Search button, the variable $CategoryName is not passed to the page
findbycategory.php. Can you please tell me where I am wrong?
Quote
form name=form3 method=post action=findbycategory.php
select name=CategoryName id=select
?php
//connecting to the database
$link = mysql_connect(localhost,mydomain,mypass);
if ($link){
Print ;
} else {
Print No connection to the database;
}
if (!mysql_select_db(mydomain_com)){
Print Couldn't connect database;
} else {
Print .br\n;
}
$sql=SELECT DISTINCT CategoryName From Categories ORDER BY CategoryName;
$result=mysql_query($sql);
While($Category=mysql_fetch_array($result))
{
Print( OPTION VALUE=\$Category[0]\$Category[0]\n);
}
?
/select
input type=submit name=Submit3 value=Search
/form/td
Unquote
Thanks
Denis
[PHP] question on listbox.
Hello friends.
I have a listbox which I populate from a query with the database. It is working fine.
But additinally, I want the first item to be Select category. Can someone please
help me how to modify by below written code to do the above?
My code : Quote :
?php
//connecting to the database
$link = mysql_connect(localhost,MyDomain,MyPass);
if ($link){
Print ;
} else {
Print No connection to the database;
}
if (!mysql_select_db(MyDomain_com)){
Print Couldn't connect database;
} else {
Print .br\n;
}
$sql=SELECT DISTINCT CategoryName From Categories ORDER BY CategoryName;
$result=mysql_query($sql);
While($Category=mysql_fetch_array($result))
{
Print(OPTION VALUE=\$Category[0]\$Category[0]\n);
}
?
Unquote
Thanks very much
Denis
[PHP] Strange problem
Hello friends.
I have the following script. Both the errors show green font when actually the first
error should give a red font. Am I doing something wrong here?
Quote:
if($CategoryName==){
Print font color=\#FF\You have not entered the category name. Please go
back and enter the category name./font;
Exit;
}
if($password==){
Print font color=\#00FF00\You have not entered the password. Please go back and
enter the password./font;
Exit;
}
Unquote
Thanks
Denis
Re: [PHP] question on listbox.
Thanks Jason.
Looks like I am too dumb. I still cannot do it. can u please help me
further?
Thanks
Denis
- Original Message -
From: Jason Wong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 01, 2003 8:21 PM
Subject: Re: [PHP] question on listbox.
On Saturday 01 February 2003 19:08, Denis L. Menezes wrote:
Hello friends.
I have a listbox which I populate from a query with the database. It is
working fine. But additinally, I want the first item to be Select
category. Can someone please help me how to modify by below written
code
to do the above?
My code : Quote :
?php
//connecting to the database
$link = mysql_connect(localhost,MyDomain,MyPass);
if ($link){
Print ;
} else {
Print No connection to the database;
}
if (!mysql_select_db(MyDomain_com)){
Print Couldn't connect database;
} else {
Print .br\n;
}
echo option ...;
$sql=SELECT DISTINCT CategoryName From Categories ORDER BY
CategoryName;
$result=mysql_query($sql);
While($Category=mysql_fetch_array($result))
{
Print(OPTION VALUE=\$Category[0]\$Category[0]\n);
}
?
Unquote
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
If you are good, you will be assigned all the work. If you are real
good, you will get out of it.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] MySQL - setting relationships
hello friends, I am a newbie at MySQL. In MS Access we specifically set relationships. In MySQL, I have found no documentation regarding setting relationships. Is is that we do not need to set the relationships in MySQl and only matching the Field IDs in respectyive tables is suffecient? Thanks Denis
[PHP] Reporting tools for PHP?
hello Friends? Is there any reporting toold for PNH/MySQL like there is Crystal Reports etc? Thanks denis
[PHP] A rather strange problem.
hello friends,
I run some queries and output the database fields in a form with text boxes for the
purpose of editing by the administrator. My problem is that if my field value is of 2
words or more, my output text box shows only the first work. e.g. if the field is
Jane Enterprises, the textbox shows only jane. My code is below. Can someone
please tell me what it is I am doing wrong?
Quote :
?php
while($row=mysql_fetch_array($result)){
print form name=\form1\ method=\post\ action=\update.php\;
print input name=\OrgName\ type=\text\ id=\OrgName\ size=\30\
value=$row[OrgName];
print /form;
}
?
Unquote
Thanks
denis
[PHP] textarea problem
Thanks Marek. Could you help me with this piece of code? ?php Print 'textarea name=OrgAddress cols=44 rows=5 id=textarea value='.htmlspecialchars($row['OrgName']).'/textarea'; ? Thanks denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Thanks Marek, Jon, Ernest
Thanks Marek, Jon, Ernest. Denis
[PHP] Minor email problem
hello friends, I am hosted with an ISP called Apexon. I have written php scripts to send mail from a webpage. When I send this mail, the from address becomes [EMAIL PROTECTED] . Their website says that the variable sendmail_from is [EMAIL PROTECTED] . I want to force my own from address in this. I also want to change the sender's name to my name rather than my website name. I have tried many ways, but not successful. Can someone help me? Please help. Thanks denis
[PHP] A simple question please.
Hello friends. I need to add a part of html (the banner, top menus and the logo) in all pages dynamically. I made this part of the html and converted same to php code using Print command. Now, how do I add this code in the other pages? Should I inclue require or include command? if yes? should I include after the body tag itself? Thanks denis
[PHP] Generating formatted reports
hello friends. I have a MYSql database and also a php application on the web. I need to generate formatted reports from the database - something like a report card with table, marks, aggregate etc. - Something like Crystal Reports for MS Visual Basic. Can this be done with PHP or are there any tools available to do this? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Making alternate rows of different colour
Hello friends. I put the output of the database query in a table. It works fine. Now I have a need to make the alternate rows of a different color. Can someone please help me with the code? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Alternate row colours - what is wrong with this code?
Hello Guys,
I want alternating colours in the output table. Can someone tell me what is wrong with
this code? I get the data but no alternating colours.
Quote :
?php
$cols = array('#ff','#00ff00');
$i = 0;
while($row=mysql_fetch_array($result)){
echo 'tr bgcolor='.$cols[$i++%2].'';
Print td width=\12%\ align=\center\ height=\6\ bgcolor=\#bf\font
face=\Tahoma\ color=\#00\ ;
Print b font size=\2\ color=\ff\ $row[OrgName] /b/font;
print /font nbsp;/td;
Print td width=\12%\ align=\center\ height=\6\ bgcolor=\#bf\font
size=\2\ face=\Tahoma\ color=\#00\ ;
Print $row[Country];
print /font nbsp;/td;
Print td width=\12%\ align=\center\ height=\6\ bgcolor=\#bf\font
size=\2\ face=\Tahoma\ color=\#00\ ;
Print $row[Date];
print /font nbsp;/td;
Print td width=\12%\ align=\center\ height=\6\ bgcolor=\#bf\font
size=\2\ face=\Tahoma\ color=\#00\ ;
Print $row[Number];
print /font nbsp;/td;
Print td width=\12%\ align=\center\ height=\6\ bgcolor=\#b7b700\font
size=\2\ face=\Tahoma\ color=\#00\ ;
Print form action=\fullmarks.php\ method=\post\;
PrintINPUT TYPE=\submit\ value=\View details\ Name=\Details\;
Printinput type=\hidden\ name=\SelectedItemNumber\ value= $row[Id];
print /td;
Print /form;
Print /tr;}
}
?
Unquote.
Thanks
Denis
[PHP] sending sms messages from the webpages
Hello friends. Any idea which is the best way to send many sms messages from a web page? Any good gateways or service providers? Thanks Denis
[PHP] Redirecting
Hello friends. I want ot redirect users to another page after successful login. Can someone please help me with the PHP code for redirecting? Or point me to some help page? thanks denis
[PHP] Redirecting - here is the code
I tried. But I get an error as follows :
Warning: Cannot add header information - headers already sent by (output
started at /usr/local/www/virtual2/66/175/19/84/html/maintenance.php:11) in
/usr/local/www/virtual2/66/175/19/84/html/maintenance.php on line 30
My code is as follows:
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body bgcolor=#CC
table width=70% border=0
tr
td height=67 colspan=3 bgcolor=#330066
div align=centerfont color=#00 face=Arial, Helvetica,
sans-serifstrongfont size=5Site
maintenance page?php
//connecting to the database
$link = mysql_connect(localhost,mydomain,somepass);
if ($link){
Print ;
} else {
Print No connection to the database;
}
if (!mysql_select_db(mydomain_com)){
Print Couldn't connect database;
} else {
Print .br\n;
}
$sql=SELECT AdminFirstName,AdminLoginId,AdminPassword FROM Administrators
where
AdminLoginId = '$AdminLoginId' and AdminPassword ='$AdminPassword';
if ($result=mysql_query($sql)) {
$numofrows=mysql_num_rows($result);
if ($numofrows==0){
header(Location: http://www.php-faq.com/;);
Print STRONGfont color=\#FF\size=\3\We are
sorry./STRONG/FONT;
}
if ($numofrows==1){
Print font size=\3\ color=\#ff\Welcome
.$AdminFirstName.Font;
}
if ($numofrows1){
Print STRONGSomething wrong/STRONG;
}
while($row=mysql_fetch_array($result)){
PrintFont size=\3\$row[AdminFirstName]/font;
}
}
?/font/strong/font/div/td
/tr
/table
/body
/html
Unquote.
Line no. 30 is the one with the line : header(Location:
http://www.php-faq.com/;);
Can you please tell me what is wrong?
thanks
denis
Re: [PHP] Redirecting - here is the code
I ahve tried everything jason. It says that there should be no output before the header(). I cannot still find the error. Can you please help in locating the error? thanks Denis - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 17, 2003 1:10 AM Subject: Re: [PHP] Redirecting - here is the code On Friday 17 January 2003 01:07, Denis L. Menezes wrote: I tried. But I get an error as follows : Warning: Cannot add header information - headers already sent by (output Try searching the archives on the above error. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Stenderup's Law: The sooner you fall behind, the more time you will have to catch up. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error in variable when looping
Hello Tim.
Could you help me a little further and tell me exactly where to put this?
Thanks
Denis
- Original Message -
From: Tim Ward [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 5:16 PM
Subject: Re: [PHP] Error in variable when looping
you're not differentiating between form elements on different rows.
all the hidden elements have the same name and are in the same
form so only the last one will be available as all the submit buttons
are in the same form.
you need to put form ../form tags around each submit/hidden
pair.
Tim Ward
http://www.chessish.com
mailto:[EMAIL PROTECTED]
- Original Message -
From: menezesd [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 12:21 AM
Subject: [PHP] Error in variable when looping
Hello friends,
I have made the following table of data and a button on every row to
view
the details. The code is working fine and the table is displayed with the
buttons.
The problem I have is that the $SelectedItemNumber posted to the next
page
remains the same number no matter which row button I click. I have my
relevant code below. Please help me. I know I am making a mistake
somewhere
but I cannot figure out where.
Quote :
le($row=mysql_fetch_array($result)){
Print tr ;
Print td width=\12%\ align=\center\ height=\6\
bgcolor=\#bf\font face=\Tahoma\ color=\#00\ ;
Print b font size=\2\ color=\ff\ $row[OrgName]
/b/font;
print /font nbsp;/td;
Print td width=\12%\ align=\center\ height=\6\
bgcolor=\#bf\font size=\2\ face=\Tahoma\ color=\#00\ ;
Print $row[OrgCountry];
print /font nbsp;/td;
Print td width=\12%\ align=\center\ height=\6\
bgcolor=\#bf\font size=\2\ face=\Tahoma\ color=\#00\ ;
Print $row[OrgNumber];
print /font nbsp;/td;
Print td width=\12%\ align=\center\ height=\6\
bgcolor=\#bf\font size=\2\ face=\Tahoma\ color=\#00\ ;
Print $row[Orgaddress];
print /font nbsp;/td;
Print td width=\12%\ align=\center\ height=\6\
bgcolor=\#bf\font size=\2\ face=\Tahoma\ color=\#
00\ ;
Print $row[OrgChief];
print /font nbsp;/td;
Print td width=\12%\ align=\center\ height=\6\
bgcolor=\#b7b700\font size=\2\ face=\Tahoma\ color=\#00\ ;
PrintINPUT TYPE=\submit\ value=\View details\ Name=\Details\;
print /td;
Printinput type=\hidden\ name=\SelectedItemNumber\ value=
$row[Id];
Print /tr;}
}
?
Unquote
Thanks
Denis
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Amount of data in the database
Thanks Lars. Sorry, then I have another question. How do I find the size of the record? Thanks Denis - Original Message - From: Lars Olsson [EMAIL PROTECTED] To: Denis L. Menezes [EMAIL PROTECTED] Cc: PHP general list [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 9:36 PM Subject: [PHP] Re: Amount of data in the database A pretty easy way of doing it is to add a size field to the table. Whenever you INSERT INTO or UPDATE the table, update this field to contain the size of the data for the current record. Then, whenever you need to check the amount of data for a particular user, just use this query: SELECT SUM(size) FROM sometable WHERE user=someuser Hope this helps /Lars Olsson ([EMAIL PROTECTED]) PS. Ive done this in a file upload script I created a while ago. If you want, I can mail you the relevant bits and bytes. DS. Denis L. Menezes wrote: Hello friends. I have a need for checking how much data(in kb) exists of each of the user members in the MySQL so that when they upload more data I can restrict/warn them of the amount of data they have on the server at present. can anyone please tell me how to check the amount of data on the mysql for each record? thanks very much Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Sorry, PHP HTML
Hello friends. I have a database from which I take 2 variables as follows : $CompanyWebsite $CompanyLogo I want to dynamically show two GIFs and when the user clicks on these, they should go to http://www.hotmail.com and http://www.yahoo.com respectively. I have problem only with the displaying(the error is parse error on the lines containing a tags), for which I use the folowing code. Please tell me where I am wrong. ?php Print Organisation address : .$row[CompanyAddress]. br\n.; Print Organisation website : .$row[CompanyWebsite].br\n. ; // I am displaying this when testing only. Print Organisation logo : .$row[CompanyLogo].br\n. ;? // I am displaying this when testing only. Print a href=http://www.hotmail.com;img src=logos/constr12.gif width=100 height=100 border=0/a; Print a href=http://www.yahoo.com;img src=logos/constr12.gif width=100 height=100 border=0/a; ? Thanks Denis
[PHP] Some help on PHP HTML please
HGello friends. I have a database from which I take 2 variables as follows : $CompanyWebsite $CompanyLogo I want to dynamically show two GIFs and when the user clicks on these, they should go to http://www.hotmail.com and http://www.yahoo.com respectively. I have problem only with the displaying(the error is parse error on the lines containing a tags), for which I use the folowing code. Please tell me where I am wrong. ?php Print Organisation address : .$row[CompanyAddress]. br\n.; Print Organisation website : .$row[CompanyWebsite].br\n. ; // I am displaying this when testing only. Print Organisation logo : .$row[CompanyLogo].br\n. ;? // I am displaying this when testing only. a href=http://www.hotmail.com;img src=logos/constr12.gif width=100 height=100 border=0/a a href=http://www.yahoo.com;img src=logos/constr12.gif width=100 height=100 border=0/a ? Thanks Denis
[PHP] displaying in the table problem
Hello Firends.
I have the following code. I am getting the query results but they are not displaying
in the table. I presume there is something wrong with a } in the while statement.
Can someone please tell me where I am wrong?
Quote :
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body
pnbsp;/p
pnbsp; /p
?php
require 'common.inc';
if(!($link=mysql_pconnect($DB_SERVER,$DB_LOGIN,$DB_PASSWORD))){
DisplayErrMsg(sprintf(internal error %d:%s\n,
mysql_errno(),mysql_error()));
return 0;
}
if ($link){
Print ;
} else {
Print No connection to the database;
}
if (!mysql_select_db(MyDomain_com)){
Print Couldn't connect database;
} else {
Print .br\n;
}?
table width=75% border=1
tr bgcolor=#006600
tdstrongfont color=#FF size=2 face=Arial, Helvetica,
sans-serifCompany's
name/font/strong/td
tdstrongfont color=#FF size=2 face=Arial, Helvetica,
sans-serifCompany's
address/font/strong/td
tdstrongfont color=#FF size=2 face=Arial, Helvetica,
sans-serifCompany's
website/font/strong/td
tdstrongfont color=#FF size=2 face=Arial, Helvetica,
sans-serifCompany's
logo/font/strong/td
/tr
?PHP
$sql=select * from CompanyData ;
if ($result=mysql_query($sql)) {
$numofrows=mysql_num_rows($result);
}
while($row=mysql_fetch_array($result)){
?
tr
td width=12% align=center height=6font face=Tahoma
color=#00?php Print $row[CompanyName] ;?/font nbsp;/td
td width=12% align=center height=6font face=Tahoma color=#00?php
Print $row[CompanyAddress] ;?/font nbsp;/td
td width=12% align=center height=6font face=Tahoma
color=#00?php Print $row[Companywebsite] ;?/font nbsp;/td
td width=12% align=center height=6font face=Tahoma
color=#00?php Print $row[Companytel] ;?/font nbsp;/td
/tr
/table
pnbsp;/p
/body
/html
Unquote
Thanks very much
denis
Re: [PHP] Amount of data in the database
Thanks Timothy. I want to find the amount of data for each member in the database using PHP and displaying in a web page. I know how to query records of a member and also know to display. Only I need to know the command for finding the size(in bytes or kb) for each of these records :Something like seeing the file sizes of each email in hotmail. Thanks Denis - Original Message - From: Timothy Hitchens (HiTCHO) [EMAIL PROTECTED] To: 'Denis L. Menezes' [EMAIL PROTECTED]; 'PHP general list' [EMAIL PROTECTED] Sent: Sunday, January 12, 2003 1:29 PM Subject: RE: [PHP] Amount of data in the database Give this a go.. for each of the databases use: SHOW TABLE STATUS FROM xx; That will return a huge amount of size etc data!! Timothy Hitchens (HiTCHO) Open Platform Consulting e-mail: [EMAIL PROTECTED] -Original Message- From: Denis L. Menezes [mailto:[EMAIL PROTECTED]] Sent: Sunday, 12 January 2003 2:58 PM To: PHP general list Subject: [PHP] Amount of data in the database Hello friends. I have a need for checking how much data(in kb) exists of each of the user members in the MySQL so that when they upload more data I can restrict/warn them of the amount of data they have on the server at present. can anyone please tell me how to check the amount of data on the mysql for each record? thanks very much Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] need some javascript code
Hello friends, Can someone please redirect me to some source with javascript for following? 1. Checking if a text box is populated before going to the next page. 2. To check if any item is selected in a listbox before posting data to the next page. 3. to check if a radio button is selected before posting data to the next page. Many thanks denis
[PHP] Date problem
Hello friends. Happy New Year to you all. Our school holds many seminars of varying durations and dates. I want to make a page which says What's on today which will show all the seminars that are on today. However the entry in the database will show two fields Commencing Date and Ending date. Is there a routine in PHP I can use to find if today's date fits between the commencing date and the ending date? Thanks Denis
[PHP] php+html help
Hello friends, I have the following php output line that works fine : Print Organisation name : .$row[OrgName].br\n.; However, I want this line to be in bold, red and size=5. I tried the following code but fails. Can someone please tell me what is wrong? Print Organisation name : font color=#FF size=5.$row[OrgName].FONTbr\n.; Thanks Denis
[PHP] Formatting text
Hello friends, I have to put results of various departments in our school website. All results will go in the Mysql database. The problem is formatting the output. I have output something like this where the numbers shown are student marks : Quote Passed with Grade A : Adm nos : 8177 9822 1750 0059 Passed with Grade B : Adm nos : 6614 8375 0837 1647 5490 3758 7388 7799 Passed with Grade C : Adm nos : 9968 0298 1297 1254 4208 4911 6194 9903 Unquote I made a multiline textboxes and used PHP script and input this in a LONGTEXT field in MySQL. Then I used PHP to output this field in a webpage. The formatting, carriage return, tabs etc are lost. Formatting is very essential in this document for us. Can someone tell me how to do this? Thanks Denis
Re: [PHP] Formatting text
Thanks John and Michael.
Please note that the following is my code :
Quote :
if ($result=mysql_query($sql)) {
$numofrows=mysql_num_rows($result);
Print Greengrass database has found the following result that matches
your search;
print br\n;
print br\n;
while($row=mysql_fetch_array($result)){
Print Identity : .$row[GGID].br\n. ;
Print Organisation name : .$row[OrgName]. br\n.;
Print Organisation country : .$row[OrgCountry]. br\n.;
Print Organisation Address : .$row[OrgAddress].br\n. ;
Print Results : .$row[Results].br\n;
print br\n;
print br\n;
}
Unquote.
In the above code, I want to format the text in only one field and that is
the field named Results.
Where do I put the PRE /PRE tags for formatting the text contained in
the mysql field Results?
Thanks
Denis
- Original Message -
From: John W. Holmes [EMAIL PROTECTED]
To: 'Denis L. Menezes' [EMAIL PROTECTED]; 'PHP general list'
[EMAIL PROTECTED]
Sent: Monday, December 30, 2002 12:13 AM
Subject: RE: [PHP] Formatting text
I have to put results of various departments in our school website.
All
results will go in the Mysql database. The problem is formatting the
output. I have output something like this where the numbers shown are
student marks :
Quote
Passed with Grade A :
Adm nos : 8177 9822 1750 0059
Passed with Grade B :
Adm nos : 6614 8375 0837 1647 5490 3758 7388 7799
Passed with Grade C :
Adm nos : 9968 0298 1297 1254 4208 4911 6194 9903
Unquote
I made a multiline textboxes and used PHP script and input this in a
LONGTEXT field in MySQL. Then I used PHP to output this field in a
webpage. The formatting, carriage return, tabs etc are lost.
Formatting is
very essential in this document for us.
Your problem is that HTML does not recognize newline or tab characters.
The easy fix is to just surround the line by pre which will cause the
newline and tab elements to show up.
The hard fix, but nicer looking one, is to output your data in a table.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Populating a list box from a database
Hello Friends, Two days ago I had asked how to do this. Thanks for the replies. I have done the required code and I can see the html output(Under view- source in the IE browser) and see the option values for the listbox are acheived. But the listbox in the browser is very thin and does not show the values. Can someone tell me what is wrong? Thanks denis
[PHP] Populating a list box from a database - The code
select name=OrgName[] size=5 id=OrgName
?php
//connecting to the database
$link = mysql_connect(localhost,lodestone,trypass);
if ($link){
Print ;
} else {
Print No connection to the database;
}
if (!mysql_select_db(catapult_com)){
Print Couldn't connect database;
} else {
Print .br\n;
}
$sql=SELECT OrgName From TableResults ORDER BY OrgName;
$result=mysql_query($sql);
While($Organisation=mysql_fetch_array($result))
{
Print(OPTION VALUE=\$Organisation[0]\$Organisation[1]\n);
}
?
/select
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Populating a list box from a database - The code
Thanks Maciek.
With the code that you gave me, I am getting the error :
Parse error: parse error in
/usr/local/www/virtual2/66/184/35/184/html/findresults.php on line 114.
My lines are as follows :
$content.= option
value=\.$orgData['OrgName'].\.$orgData['OrgName']./option\n);
Can u help me a little bit more?
Thanks
denis
- Original Message -
From: Maciek Ruckgaber Bielecki [EMAIL PROTECTED]
To: Denis L. Menezes [EMAIL PROTECTED]
Cc: Justin French [EMAIL PROTECTED]; PHP general list
[EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 1:41 AM
Subject: Re: [PHP] Populating a list box from a database - The code
be carefull with the results of mysql_fetch_array, array names are DB
field names, for easier access =)
?php
//connecting to the database
$link = mysql_connect(localhost,lodestone,trypass);
if(!$link)
Print No connection to the database;
if (!mysql_select_db(catapult_com)){
Print Couldn't connect database;
$sql=SELECT OrgName From TableResults ORDER BY OrgName;
//get result or show what happened
$result=mysql_query($sql)or die(mysql_error());
//start the select
$content = select name=\organization\;
while($orgData=mysql_fetch_array($result))
{
// note that OrgName is the field name in the database.
// for value you may use the org_id instead, if you have one in the
DB
$content .= option
value=\.$orgData['OrgName'].\.$orgData['OrgName']./option\n);
}
$content .=/select\n;
echo $content;
?
hope it helps :-)
--
Few are those who see with their own eyes and feel with their own
hearts.
Albert Einstein
-
Maciek Ruckaber Bielecki
On Sun, 29 Dec 2002, Denis L. Menezes wrote:
select name=OrgName[] size=5 id=OrgName
?php
//connecting to the database
$link = mysql_connect(localhost,lodestone,trypass);
if ($link){
Print ;
} else {
Print No connection to the database;
}
if (!mysql_select_db(catapult_com)){
Print Couldn't connect database;
} else {
Print .br\n;
}
$sql=SELECT OrgName From TableResults ORDER BY OrgName;
$result=mysql_query($sql);
While($Organisation=mysql_fetch_array($result))
{
Print(OPTION VALUE=\$Organisation[0]\$Organisation[1]\n);
}
?
/select
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Directing to a URL from a radio group
Hello friends. Somehow, I cannot find the right code here. I have a radio group with options as follows: value1 = orgname value2=orgcity value3=orgsize value4=orghead When the user chooses orgname he must be redirected to the page ../orgname.php When the user chooses orgcity he must be redirected to the page ../orgcity.php ...and so on. Can you please help me with the code? Thanks Denis
[PHP] language internationalisation
Hello friends, As the subject suggests I am looking for language capabilitie on my php webpages. Can someone please tell me which is a good way? I thought that I could have a database, but if so, can MySQL: handle multiple languages in the fields(like chinese language)? if this is possible, what about the html output : does the user need to install some fonts etc ? Thanks very much Denis
[PHP] Populating textboxes and listboxes from a query result of a database table
Hello friends, Can someone please tell me where I can find sample scripts for populating textboxes and listboxes on a form(when the form opens) using the data from fields in a table? Thanks Denis
[PHP] Photos and logos in MySQL + PHP
Hello friends, I am making a website for our school. My requirement is that when any student searched for a particular club, the logo of the club abd the chairperson's phot should automatically be shown dynamically on the top of the page. For this to be done, I have three questions, if any of you could please help me : 1. Can I place these photos and logos in the MySQL database, If so, what field type? 2. How can I make the admin page upload the photos and logos to the database? 3. How do I display these photos dynamically on the output webpage? I know I am asking many questions, but none of the PHP books I own have the solutions for this. best regards Denis
[PHP] remembering variables between many forms.
Hello friends. Pls excuse me if this is too simple a question. I have a mysql database running with PHG scripts for member registration, find members etc which is running well. Now I want to make a system to send the username and passwords to members if they have lost them. the way I am doing it is : when the user logs in on the 1st page with his email address, I take him to the second page where I ask the favourite question from the database for which he must answer, then I check that the answer is correct in a third page and send his email. My problem is that I do not know how to remember the variable between the 1st and the third page. I can manage between two pages but not between three pages. Can someone help how I can remember the email address between the above three pages? Thanks very much Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] eregi(mail)
Hello friends,
I use the following code, but it does not work. Is there something wrong?
If
(ereg('^[-!#$%\'*+\\./0-9=?A-Z^_`a-z{|}~]+'.'@'.'[-!#$%\'*+\\/0-9=?A-Z^_`a
-z{|}~]+\.'.'[-!#$%\'*+\\./0-9=?A-Z^_`a-z{|}~]+$',
$email_address))
){
Print (Sorry, the email address seems to be invalid.);
exit;
}
Please help.
Denis
- Original Message -
From: Steve Buehler [EMAIL PROTECTED]
To: Kevin Stone [EMAIL PROTECTED]
Cc: PHP [EMAIL PROTECTED]
Sent: Saturday, May 11, 2002 2:45 AM
Subject: Re: [PHP] eregi(mail)
Either Google is wrong (probably) or they are now allowing things like
spaces into an email address. There are actually several things that are
not allowed in a standard email address. Here is the code that I use.
ereg('^[-!#$%\'*+\\./0-9=?A-Z^_`a-z{|}~]+'.'@'.'[-!#$%\'*+\\/0-9=?A-Z^_`a-
z{|}~]+\.'.'[-!#$%\'*+\\./0-9=?A-Z^_`a-z{|}~]+$',
$subarray))
I am honestly not sure where I got this code, but it has always worked for
me and I have not found any YET that are good address that this kills. I
have also not found any bad ones YET that this lets through (unless the
domain or user doesn't exist, of course).
Steve
At 01:26 PM 5/10/2002, you wrote:
I had always been suspicious about email validators so I did a big long
search on Google about standard address formats. It turns out that aside
from the @ symbol emails have no standard format whatsoever. So
ereg('@',
$email) is really the only functional email validator.
You also have to think about what kind of email validation you need. Do
you
really need to control the format of the emails being stored in your
database? Or do you need to control the validity of the emails being
stored
in your database? There is a big difference. A valid email address
isn't
necessarily one that is formated in the way you expect. It is one that
is
active and can be mailed to. There are a number of techniques you can
use
to determine that.
Well.. anyway sorry for going off on a tangent there. In your search for
an
email validator you got a bit more information than you expected. I hope
it
was useful in some tiny miniscule sort of way. :)
--
Kevin Stone
[EMAIL PROTECTED]
- Original Message -
From: Analysis Solutions [EMAIL PROTECTED]
To: PHP List [EMAIL PROTECTED]
Sent: Friday, May 10, 2002 10:59 AM
Subject: Re: [PHP] eregi(mail)
Hi Liam:
On Fri, May 10, 2002 at 09:48:58AM -0700, Liam Gibbs wrote:
Does anyone have a decent eregi statement for
validating e-mail addresses?
eregi('^[a-z0-9_.=+-]+@([a-z0-9-]+\.)+([a-z]{2,6})$', $Email);
Enjoy,
--Dan
--
PHP classes that make web design easier
SQL Solution | Layout Solution | Form Solution
sqlsolution.info | layoutsolution.info | formsolution.info
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] populating textboxes list boxes from database fields
Hello friends, Can someone please tell me where I can find sample scripts for populating textboxes and listboxes on a form(when the form opens) using the data from fields in a table? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Help on master detail
Hello friends, 1. Can u guys provide any links on php script master details forms? 2. data grids? Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Newbie Book Database Question
I have done php only and not cold fusion. Just out of curiosity, why are you
trying to do php? Isn't Coldfusion good enough?
Denis
- Original Message -
From: David Garcia Aristegui [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 25, 2002 9:20 PM
Subject: Re: [PHP] Newbie Book Database Question
Try PHP and MySQL Web Development, by Luke Welling and Laura Thompson;
only one thing, maybe you'll have troubles with the form variables, put this
code at the beginning of all book examples
foreach (array_merge($_POST,$_GET) as $key=$val)
{
global $$key;
$$key=$val;
}
Code made by Alok K. Dhir ;-)
At 08:02 25/04/2002 -0500, you wrote:
Howdy,
I have been developing with ColdFusion for nearly five years and want to
learn PHP. For someone who has never done anything with PHP before, what
*one* book would you recommend as a good primer to get started learning
PHP?
Also, do most PHPers use MySQL as your database when building dynamic web
sites, or do you prefer alternative databases like Postgres? From what I
have seen from afar, MySQL seems to be the dominant one, but I have read
that Postgres is more robust.
Thanks in advance and cheers from San Antonio,
Chris Montgomery[EMAIL PROTECTED]
Airtight Web Services http://www.airtightweb.com
Web Development, Web Project Management, Software Sales
210-490-3249/888-745-7603
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Simple IF question
Hello friends, I have a registration form with a salutation field in a listbox, in which I want that the registrant must choose a value other than the default value of please select. So I wrote : If ((!$salutation=Please select) Print (Sorry, please select a value in the salutation box); However, it does not work. Can someone please help? Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Simple IF question
Hello Jason.
You are right, but it still does not work.
Could it be a trim word problem?
Thanks
Denis
- Original Message -
From: Jason Wong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 7:34 PM
Subject: Re: [PHP] Simple IF question
On Saturday 20 April 2002 18:35, Tom Rogers wrote:
Hi again
You can also write it as:
If (($salutation != Please select)
Print (Sorry, please select a value in the salutation box);
Tom
Also the logic seems to be wrong, shouldn't it be:
if (($salutation == Please select) {
print (Sorry, please select a value in the salutation box); }
else {
...
}
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Men often believe -- or pretend -- that the Law is something sacred, or
at least a science -- an unfounded assumption very convenient to
governments.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Simple IF question
Thanks Gentlemen.
After many experiments, I found the answer. It should be = = and not =.
thanks for all yr help.
Denis
- Original Message -
From: Miguel Cruz [EMAIL PROTECTED]
To: Denis L. Menezes [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, April 21, 2002 12:10 AM
Subject: Re: [PHP] Simple IF question
Why don't you print out $salutation and see what you're getting?
miguel
On Sun, 21 Apr 2002, Denis L. Menezes wrote:
Hello Jason.
You are right, but it still does not work.
Could it be a trim word problem?
Thanks
Denis
- Original Message -
From: Jason Wong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 7:34 PM
Subject: Re: [PHP] Simple IF question
On Saturday 20 April 2002 18:35, Tom Rogers wrote:
Hi again
You can also write it as:
If (($salutation != Please select)
Print (Sorry, please select a value in the salutation box);
Tom
Also the logic seems to be wrong, shouldn't it be:
if (($salutation == Please select) {
print (Sorry, please select a value in the salutation box); }
else {
...
}
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
*
/*
Men often believe -- or pretend -- that the Law is something sacred,
or
at least a science -- an unfounded assumption very convenient to
governments.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Checking database for a value
hello friends, I am looking into 4 books in front of me but somehow cannot find the following : I have a field userid which the user fills in at registration. Before entering the data into the database, I want to check if the userid exists in the database. Can someone tell me the name of the function I must use, I will look for the rest in the php dictionary. Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Simple IF question
Yes Jason, You are right. However, I missed the == in my over-enthusiasm. Thanks and sorry. Denis - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 21, 2002 1:06 AM Subject: Re: [PHP] Simple IF question On Sunday 21 April 2002 00:27, Denis L. Menezes wrote: Thanks Gentlemen. After many experiments, I found the answer. It should be = = and not =. Surely you mean ==, which more than one person has already pointed out? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Some people have a great ambition: to build something that will last, at least until they've finished building it. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Cannot enter single quotation marks in fields
Hello friends , I cannot enter single quotation marks in fields. Is this a standard feature ? Is there a workaround? I am using mysql + php4 on unix. Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] intelligent mailing list?
Hello friends. I do not think I have put the right term in the subject of this message. What I wish to do is develop a mailinmg list which , among the normal functions, can give a list of failed email messages. Can anyone please help me find such an application code? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] simple question
Hello friends. I am able to add and query my database using php. I now wish to build webpages with textboxes and search the database with criteria from the textboxes. Can someone tell me the resources for building these pages? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Please help with code
Hello friends,
can someone tell me what is wrong with this code :
form name=form1 method=post action=
p
input type=text name=newsid
/p
p
input type=text name=title
/p
p
input type=text name=author
/p
p
input type=text name=body
/p
p
input type=submit name=Submit value=Submit
/p
/form
/body
?php
$link=mysql_connect(localhost,myid,mypassword);
if ($link){
print link id is $link;
} else {
print error connecting to database;
}
$posted=time();
$query=INSERT INTO news (newsid,title, author, body, posted)
VALUES($newsid,$title, $author, $body, UNIX_TIMESTAMP());
IF (mysql_query($query)){
print Row added to table;
} else {
print error adding row;
}
?
It gives the link ID. But then gives error adding row
Thanks in advance
Denis
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Please help with code
Should I change the position of the php code?
Thanks
denis
- Original Message -
From: Andrew Brampton [EMAIL PROTECTED]
To: Denis L. Menezes [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, April 02, 2002 12:31 AM
Subject: Re: [PHP] Please help with code
You are not actually posting the form to a page with your PHP on... so its
trying to insert that form into your DB before u actually fill it out.
either check if the form has been posted before running your PHP, or split
this into 2 pages
Andrew
- Original Message -
From: Denis L. Menezes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 5:08 PM
Subject: [PHP] Please help with code
Hello friends,
can someone tell me what is wrong with this code :
form name=form1 method=post action=
p
input type=text name=newsid
/p
p
input type=text name=title
/p
p
input type=text name=author
/p
p
input type=text name=body
/p
p
input type=submit name=Submit value=Submit
/p
/form
/body
?php
$link=mysql_connect(localhost,myid,mypassword);
if ($link){
print link id is $link;
} else {
print error connecting to database;
}
$posted=time();
$query=INSERT INTO news (newsid,title, author, body, posted)
VALUES($newsid,$title, $author, $body, UNIX_TIMESTAMP());
IF (mysql_query($query)){
print Row added to table;
} else {
print error adding row;
}
?
It gives the link ID. But then gives error adding row
Thanks in advance
Denis
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Can anyone help?
Hello friends. I have two files as follows :
1. The test.htm is as follows :
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body bgcolor=#FF text=#00
form name=form1 method=post action=testphp1.php
p
input type=text name=newsid
/p
p
input type=text name=title
/p
p
input type=text name=author
/p
p
input type=text name=body
/p
p
input type=submit name=Submit value=Submit
/p
/form
/body
/html
2. The testphp1.php is as follows:
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body bgcolor=#FF text=#00
?php
$link=mysql_connect(localhost,myid,Mypassword);
if ($link){
print link id is $link;
} else {
print error connecting to database;
}
$posted=time();
$query=INSERT INTO news (newsid,title, author, body, posted)
//VALUES($newsid,'$title','$author', '$body', $posted);)
//Newsid is an INT, title is a VARCHAR author is a VARCHAR, body is a
VARCHAR
IF (mysql_query($query)){
print Row added to table;
} else {
print error adding row;
}
?
/body
/html
Explanation : I run the test.htm and then the testphp1.php executes well.
The databse is connected, but the error
error adding row appears all the time.
Can someone tell me my error in SDyntax?
Thanks
Denis
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Websites on help for building PHP database sites
Hello friends, can anyone give me the links to websites who have instructions on developing interactive webiste using MySQL and PHP? I have 2 books, but I need to know some things which are not in these books. Thanks denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Auto password generation
Hello friends, I have a form for registering by the users. This runs on php/mysql. Can someone tell me how I could include auto password generation and emailing of this password to users? Thanks denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Need help
Hello friends.
I am a newbie to php. I am trying to connect to mysql with php.
I have a website called www.abcresources.com
The mysql database set up by the hosting company is called
abc_resources.com
I have a table called addressbook
I log in into the admin page with my username as user and password as
12345. After that I do not use any username and password. So I am not sure
if I need a username and password in the connection string.
I have this line to connect :
if (!($link=mysql_connect($hostname,$username,$password))){
displayerr(sprintf(internal error %d:%s\n,
mysql_errno(), mysql_error()));
What should $hostname, $username and $password be in the globals.php file?
Thanks for help.
Denis
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Please help
I am a newbie and need some help. I have a form with three textboxes named firstname, lastname and description My table is called addressbook Please tell me the INSERT statement. Also please tell me whether I should include the insert statement with a php tag. Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Creating forums in php
Hello friends, I am running a website having php and mysql support on which I want to set up a discussions forum. Can someone advise me any web resources for building a php-mysql forum? Thanks denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Making a simple borderless pop up window with a Close button
Hello friends. I am making a database website where I need to add a small help button for every field on the form. Whenever the user clicks the small help button, I wish to show a titleless popup window containing the help text and a close button. Can someone help me with the php script for this. Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] mysql question
Hello friends, Can someone tell me what is wrong with the foll script? CREATE TABLE `sailordata` (`sailorid` INT(8) DEFAULT '' NOT NULL, `lastname` VARCHAR NOT NULL, `firstname` VARCHAR NOT NULL, `middlenames` VARCHAR NOT NULL, `dob` VARCHAR NOT NULL, `telephone` VARCHAR NOT NULL, `fax` VARCHAR NOT NULL, `email` VARCHAR NOT NULL, .(some more code) Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] mysql - php help
Hello firends, I have three fields(input boxes) in a php form as follows : $name $rank $age My MySQL table is called tblAddress. I know how to connect, but I do not know the Insert statement. Can someone please advise me how I can insert the above values in the tables tblAdddress in columns name, Rank, age respectively? Thanks Denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] POST against GET
Hello friends. I am running PHP4 on an Intel Win NT server 4 sp6 machine. When I use POST the feedback form does not work but itw works when I use GET. Can anyone advise why this is so? The data that I am using are only 2 string variables of one word each. thank you denis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
