[PHP-DB] problem with regular expression
i have a script to identify if the input is a combination of letters and numbers if (eregi("[a-zA-Z0-9][0-9]+[a-zA-Z][0-9a-zA-Z]",$fieldvalue)) print "alphanumeric" } else { not an alphanumeric } my problem is, when the string ends with a number, for example hello123, it says "not an alpanumeric" ... it works fine when the number is placed before the letters or in between letters ... why is that? i would really appreciate your help, thanks very much :)
[PHP-DB] problem with " "
hello, i'm having problems with " " ... when i'm using stripslashes ... the word is cut after the quotation marks ... for example This is the sample "sentence" ... the output will be ... This is the sample it works fine if i will not use stripslashes however the apostrophe will the one to encounter problems... hope someone could help... thanks very much :)
[PHP-DB] alphanumeric
the ctype_alnum is experimental. is there an easy way wherein i can identify if the input is an alphanumeric? thanks for your help.
[PHP-DB] problem with form
hello, hope anyone has an idea on how to fix this... even i click on the edit button, it will still go to submit.php page, why is that? thanks -- PHP Database 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]
[PHP-DB] SQL error:
hello!!! i'm getting this error. what does this mean? hope someone can help. i'm using sql7 in NT4 server Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_DEPT'., SQL state S0002 in SQLExecDirect in F:\Web
[PHP-DB] zend
do i need a different zend compiler for different operating system? thanks
[PHP-DB] delay script
hello! does anyone knows how to delay a display of a certain page ... for example, if i will click on "logout" button, it will show a page which will say "logging out" then after 5 seconds it will redirect to the login page. thanks =)
[PHP-DB] delay script
hello! does anyone knows how to delay a display of a certain page ... for example, if i will click on "logout" button, it will show a page which will say "logging out" then after 5 seconds it will redirect to the login page. thanks =) -- PHP Database 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]
[PHP-DB] mssql_fetch_array - still not working fine
Thanks for all your answers, but, they still seem not to work. In my query, the value of countryname is retrieved as expected but the value of countryid is not. There seems to be no value retrieved for countryid. I am using PHP4 on IIS4 on an NT machine with SQL Server 7 as the database. "countryname" is of type varchar while "countryid" is type int, indentity, auto_increment. I tried listing them by printing the resultset but countryid still does not have any value. This could be a quirk that some of you experienced and I sure would like to hear how you overcame this. I am posting again the code snippet below: "; } } ?> Thanks. -- PHP Database 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]
Re: [PHP-DB] mssql_fetch_array problem
Thanks for all your answers, but, they still seem not to work. In my query, the value of countryname is retrieved as expected but the value of countryid is not. There seems to be no value retrieved for countryid. I am using PHP4 on IIS4 on an NT machine with SQL Server 7 as the database. "countryname" is of type varchar while "countryid" is type int, indentity, auto_increment. I tried listing them by printing the resultset but countryid still does not have any value. This could be a quirk that some of you experienced and I sure would like to hear how you overcame this. I am posting again the code snippet below: "; } } ?> Thanks. -- PHP Database 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]
[PHP-DB] mssql_fetch_array problem
Thanks for all your answers, but, they still seem not to work. In my query, the value of countryname is retrieved as expected but the value of countryid is not. There seems to be no value retrieved for countryid. I am using PHP4 on IIS4 on an NT machine with SQL Server 7 as the database. "countryname" is of type varchar while "countryid" is type int, indentity, auto_increment. I tried listing them by printing the resultset but countryid still does not have any value. This could be a quirk that some of you experienced and I sure would like to hear how you overcame this. Thanks. I am posting again the code snippet below: "; } } ?> -- PHP Database 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]
[PHP-DB] mssql_fetch_array problem
hello all, hope someone could help me it seems that the mssql_fetch_array did not work as it should when the data type to be fetch is an integer ... is there any work around for this? Below is my script ... $country_sql = "select countryname, countryid from TBL_COUNTRY"; if ($country_query = mssql_query($country_sql)) { while ($myrow = mssql_fetch_array($country_query)) if ($country == $myrow["countryid"]) { print "" . $countryid . ""; } else { print "" . $countryid . ""; } } } Thanks! -- PHP Database 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]
[PHP-DB] Backup Database
hello all, what will i do to have a realtime backup of my database? thanks :)
[PHP-DB] IMPORT DATA
hello all, did anyone know on how to import data from one database to another using Mysql? Thanks
[PHP-DB] nobody header
hello, i hope you could help me with this, the script below gives me a from header = "Nobody"; and the $from which is supposed to be the header has been included in the body of the email. How can i make the $from to be placed in the header? $from = "[EMAIL PROTECTED]"; $subject = "Changes on employee's personal data\n\n"; $message = $message."Changes on Employee's Personal Data since the last evaluation\n\n"; $message = $message."Employee's Name: $emplname, $empfname, $empmname\n"; $message = $message."Address: $address\n"; $message = $message."Telephone Number: $telno\n"; $message = $message."Civll Status: $civilstatus\n\n"; $message = $message."Name/s and Birthday/s of children born within the last 6 months\n"; $message = $message."Name: $name1 $name2 $name3\n"; $message = $message."Birthday: $bday1 $bday2 $bday3\n"; mail("[EMAIL PROTECTED]", "$subject", "$message","$from"); thanx :)
[PHP-DB] Can't recognize new line
It works! Thanks for the help! Anyway, I hope you won't mind if I'll ask you another question, when the text type is pulled out from the MySQL database into my display script it can't recognize the new line. It diplays the text continuously. Ex. < Has He increased his knowledge in his field, the business and its operations since his last evaluation? Has He acquired new skills; upgraded his skills or improved his competence level since his last evaluation? > it displays < Has He increased his knowledge in his field, the business and its operations since his last evaluation? Has He acquired new skills; upgraded his skills or improved his competence level since his last evaluation? > Jen =) -- PHP Database 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]
[PHP-DB] PROBLEM IN INSERTING TEXT WITH SINGLE QUOTE
Hello all, I am having a problem in inserting text with apostrophe to mysql database. When a user fills out a form field that includes an apostrophe , the verify screen shows it as and it is then input into the database as - automatically adding the backslash. The problem is that when the record is pulled out of the MySQL database into my display script it also shows up as - with the backslash - but I want viewers to see it as - without the slash. Then, if I modify the record and don't take out the slash, it adds an additional slash so I wind up with . Can someone help me with my problem? Thanks in advance, Jen