[PHP-DB] Urent please
maybe this is more a javescripy problem...but its related to my php code: how can i open a new window with javacript and pass to it php variables?? thanks guys alot. Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] template problem!!!
i have asimple problem: can i put php code in the site template??-i'm using dreamweaver. and if yes will i save it as php or as .dwt?? thanks guys Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Date problem
i get $postdate from my mysql database,the problem is that i want to increase that date by 6 months?? its stored in mysql as date field - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] selected problem
i have the file: edit_profile.php in it i have a form field like this: select name=location OPTION selected value=Choose City/OPTION OPTION value=10-Ramadan10-Ramadan/OPTION OPTION value=15 May15 May/OPTION OPTION value=6-October6-October/OPTION OPTION value=Abou RedesAbou Redes/OPTION OPTION value=Abou-ZabalAbou-Zabal/OPTION OPTION value=Al ArishAl Arish/OPTION OPTION value=Al MahalaAl Mahala/OPTION OPTION value=Al TourAl Tour/OPTION OPTION value=Al-NatrounAl-Natroun/OPTION OPTION value=AlexandriaAlexandria/OPTION OPTION value=AsuitAsuit/OPTION OPTION value=AswanAswan/OPTION OPTION value=BaderBader/OPTION OPTION value=Bani-SweifBani-Sweif/OPTION OPTION value=BelbisBelbis/OPTION OPTION value=Berkeit sabbBerkeit sabb/OPTION OPTION value=CairoCairo/OPTION OPTION value=DahabDahab/OPTION OPTION value=DamanhourDamanhour/OPTION OPTION value=DisoukDisouk/OPTION OPTION value=DumiatDumiat/OPTION OPTION value=Ein SoukhnaEin Soukhna/OPTION OPTION value=El- ManieaEl- Maniea/OPTION OPTION value=FayedFayed/OPTION OPTION value=FayoumFayoum/OPTION OPTION value=High DamHigh Dam/OPTION OPTION value=HurghadaHurghada/OPTION OPTION value=InshasInshas/OPTION OPTION value=IsmaeliaIsmaelia/OPTION OPTION value=Kafr Al ShiekKafr Al Shiek/OPTION OPTION value=KatamiaKatamia/OPTION OPTION value=LuxorLuxor/OPTION OPTION value=MansouraMansoura/OPTION OPTION value=MarabellaMarabella/OPTION OPTION value=MaraquiaMaraquia/OPTION OPTION value=Marsa matrouhMarsa matrouh/OPTION OPTION value=Met GhamrMet Ghamr/OPTION OPTION value=MonofiaMonofia/OPTION OPTION value=MoustorodMoustorod/OPTION OPTION value=NubiehNubieh/OPTION OPTION value=Oubour CityOubour City/OPTION OPTION value=Port SayedPort Sayed/OPTION OPTION value=Qanater El Khiraya Qanater El Khiraya/OPTION OPTION value=QliubQliub/OPTION OPTION value=QuanaQuana/OPTION OPTION value=QuesnaQuesna/OPTION OPTION value=RafahRafah/OPTION OPTION value=Ras SidrRas Sidr/OPTION OPTION value=Sadat CitySadat City/OPTION OPTION value=SaqaraSaqara/OPTION OPTION value=Sedi KrierSedi Krier/OPTION OPTION value=Sharm el ShiekSharm el Shiek/OPTION OPTION value=Shebin Al KoumShebin Al Koum/OPTION OPTION value=SuhagSuhag/OPTION OPTION value=SuiezSuiez/OPTION OPTION value=TabaTaba/OPTION OPTION value=TantaTanta/OPTION OPTION value=TebinTebin/OPTION OPTION value=ZafranaZafrana/OPTION OPTION value=ZagazikZagazik/OPTION /select as you can see there is many options:) and i got from my database: $location=Alexandria so i wanted to appear selected,how can i do this?? Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] newsletter
hi guys, i wanna make a news letter as follows: i sell items within certain categories,so whenever a buyer is registered he choose some categories to contribute to my newsletter with: whenever a new item is added within this category i send him an email with that. i'm storing the mails in database. does anyone have something like this that can help me?? i tried in my script that whenever an item is added i send aletter to all who is subscribed under this category,but i need to know the ID of this item that is added first,so i faild to do that Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] newsletter
hi guys, i wanna make a news letter as follows: i sell items within certain categories,so whenever a buyer is registered he choose some categories to contribute to my newsletter with: whenever a new item is added within this category i send him an email with that. i'm storing the mails in database. does anyone have something like this that can help me?? i tried in my script that whenever an item is added i send aletter to all who is subscribed under this category,but i need to know the ID of this item that is added first,so i faild to do that Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] insert into javascript php
script c=document.forms[0].category.options[document.forms[0].category.selectedIndex].text ?php $x=c; ? /script but the php doesn't understand this c variable Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] login problem wasn't solved
i have sell.php page which requires loggin so i put in it:
?
session_start();
if(!(session_is_registered(valusername)))
{
$page=$PHP_SELF;
session_register(page);
header(Location:http://$HTTP_HOST/auction/login.php;);
exit();
}
?
then in login.php i have;
$sql = SELECT * FROM registration WHERE username = '$username' and
password='$password';
$result = mysql_query($sql,$conn);
if(mysql_num_rows($result) 0)
{
$row = mysql_fetch_array($result);
$valusername=$row[username];
session_register(valusername);
mysql_close($conn);
if(session_is_registered(page))
{
header(location:http://$HTTP_HOST/.$page);
session_unregister(page);
}
else
header(location:http://$HTTP_HOST/auction/index.php;);
exit();
}
else
{
echo p align='center'font face='Comic Sans MS' size='6'
color='#FF'Sorry!!/font/p
p align='center'font color='#80' size='4'You entered either a wrong username or
password.bra href='login.php'try again/a/font/p;
}
and yes it goes to sell.php page but the url is:
http://localhost//php/php.exe/auction/seller/sell.php
and i tried instead:
if(session_is_registered(page))
{
header(location:http://$HTTP_HOST/.$$HTTP_REFERRER);
session_unregister(page);
}
but it goes to
http://localhost
anyhelp?
Rehab M.Shouman
-
Express yourself with a super cool email address from BigMailBox.com.
Hundreds of choices. It's free!
http://www.bigmailbox.com
-
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] sql problem
i want an sql statment that select from table where prefer has the word auction or cash i tried: $sql=select * from products where prefer like '%cash%' ; and it worked biut i tried: $sql=select * from products where prefer like '%cash%' or prefer like '%auction%' ; but didn't work !!! Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] increase date()
i have: $nowdate=date(Y-m-d); and i want to increase it by 6 months,how can i do that?? Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] need help guys
i have this select name=category option value='Arts'Antiques Arts/option then i pass this to next page: script c=document.forms[0].category.options[document.forms[0].category.selectedIndex].text location.href=additems.php?category=+c /script in url it shows like this: http://localhost/auction/seller/additems.php?category=Antiques%20%20Arts but in additems.php when i say echo $category it give me only Anticues Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] menues problem
i have 3 drop down menues the first 2 are statics and third i want it to retrive from databse can i do this with javascript and php or i have to reload page 3 times??? Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] login
there is a page that when user go to need to be looged in,so it automaticaly go back with him to loggin page but after login i want him to go back to the page he was in.how? using history()? and how. thanks guys Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] databse tables!!!
does anyone know the max number of tables the mysql can support and still work efficient??? -- 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] multiple selection!!! urgent guys
i made in form list menu with multiple select: select size=4 name=media multiple optionEnvelopes/option optiontransparencies/option optiongreeting cards/option optionlabels/option optionplain paper/option optioniron-on transfers/option optionphoto paper/option optionbanners/option optionglossy coated paper/option optionglossy photo paper/option optionglossy photo film/option optionfabric/option /select but in php script when i make echo $ media; it only print the last item selected,not all items i selected. ??what should i do? -- 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] javascript
hi there.does anyone know how to pass a variable value to the new window i opened with open() of javascript? -- 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] guys here is my problem in a simpler way:)
hi there, i have a similar problem which is driving me crazy and i hope u can help
with:
i have a form whith a normal button when clicked ,i open a new window through
javascript(this window have a php script)
which i wanna pass to it a form field:
input name=category
but as i told u there is no submission for the form so i can't pass for example a
hidden field or $category
script
function test()
{
x=document.forms[0].subcategory.selectedIndex
y= document.forms[0].subcategory.options[x].text
if(y==Printers)
open(store1.php,newwindow)
}
/script
form
input name=category
input type=button onClick=test()
--
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] Multiple upload
is there a way i can upload more than one file in the same page -ofcourse in 2 different form fields-??? -- 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] Grant statement
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON database_name.* TO username@localhost IDENTIFIED BY 'password'; do i write this is my php file??? and is this its right syntax just put it like this??as i know i put like this when using the command line..but in my php file!!i don't know. my host created the databse for me and gave me a username and password i used them in my scripts...do i still have to use GRANT??? -- 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] .htaccess
i wanna include auto_prepend_file in .htaccess how can i write the path to file ??? -- 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] access denied
Warning: MySQL Connection Failed: Access denied for user: 'rehab@localhost' (Using password: YES) in /home/sites/site92/web/mall/confirmregistration.php on line 14 Error connecting to host localhost, by user rehab should i use this: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON mall.* TO rehab@localhost IDENTIFIED BY 'mall'; or what??? and how should i write this grant statment??? just put it there or like: mysql_query(grant select...)??? -- 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] .htaccess
where i can find info abour .htaccess and .htpasswd files and what should be the code inside them its urgent please guys -- 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] Limit problem
i wanna limit the result for 10 records per page. if anyone have a script doing this. if i said for example limit 0,10 how in next page i'll get next ten? -- 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] log out
?php session_start(); session_destroy(); header(location:http://$HTTP_HOST/mall/menu.php;); ? i wanna make this my log out page. it works without the: header(location:http://$HTTP_HOST/mall/menu.php;); i tried to put it befor session_destroy() but still didn't work??? -- 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] access my cgi-bin
here is my folders tree: (i'm on windows) c:/apache/cgi-bin/test.php c:/apache/htdocs/click.html i want to call test.php from click.html. what is the syntax? is it something like: ../cgi-bin/test.php? -- 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] mysql driver
i was told to upload my database to server,i do it in access and then extract it and do so i need ODBC driver for MySql. is that true?did anyone tried this befor..and is there any other way? if anyone used it..from where can i get the driver? -- 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] session problem
here is my code,u only have to care for the session part:
this is the login page:
?php
session_start();
$adminname = emad;
$serverpassword = omda;
$servername = localhost;
$dbname = mall;
$sql = SELECT * FROM registration WHERE username = '$username' and
password='$password';
if($username != ):
$conn = mysql_connect($servername, $adminname, $serverpassword);
mysql_select_db($dbname, $conn);
$result = mysql_query($sql, $conn);
if(@mysql_num_rows($result) != 0)
{
$row = mysql_fetch_array($result);
$valusername = $username;
session_register(valusername);
mysql_close($conn);
header(location:http://$HTTP_HOST/mall/menu.php;);
exit();
}
else
{
echo h2Sorry,you entered either a wrong User Name or Password./h2Try
againBR;
echo a href='login.php'Back/a;
}
else:
?
html
head
titleLogin Page/title
/head
body background=o3b.gif onLoad=document.myForm.username.focus();
FONT color=#fdf8db
table
form name=myForm method=post action=login.php
trtd align=rightFONT color=#fdf8dbbUser Name/btdinput type=text
name=username size=40
trtd align=rightFONT color=#fdf8dbbPassword/btdinput type=password
name=password size=40
trtd colspan=2 align=centerinput type=Submit value=Login
/form
trtda href=forgetpass.phpFONT size=-1Forgot your password?/a
/table
/body
/html
?php
endif;
?
and now this is the menu page(when login is correct):
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTML
HEAD
META name=GENERATOR content=IBM WebSphere Homepage Builder V5.0.1 for Windows
TITLECocktail bar/TITLE
/HEAD
?php
?php
session_start();
if(!(session_is_registered(valusername)))
{
header(Location:http://$HTTP_HOST/mall/login.php;);
exit();
}
?
?
BODY link=#99ff00 vlink=#99cc66 alink=#00
TABLE border=1 width=100% height=100%
TBODY
TR
TD height=298 width=591/TD
TD height=298 rowspan=2 background=blue5b.gif width=158 valign=middle
align=centerA href=add.phpFONT color=#ffAdd/FONT/AFONT
color=#ffBR
A href=delete.phpDelete/ABR
/FONTA href=update.phpFONT color=#ffUpdate/FONT/ABR
A href=editinfo.phpEdit you Info/A/TD
/TR
TR
TD height=12 width=591/TD
/TR
/TBODY
/TABLE
/BODY
/HTML
when i login and i'm in the menu page this error show:
Warning: Cannot add header information - headers already sent by (output started at
C:\apache\htdocs\mall\menu.php:7) in C:\apache\htdocs\mall\validate.php on line 4
can anyone help?
--
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] session
Cannot send session cache limiter - headers already sent (output started at C:\apache\htdocs\mall\menu.php:9) in C:\apache\htdocs\mall\menu.php on line 10 this message appear when i make session_start() on a page?? -- 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] putting MySql database on server
what do i need to change in my MySql databse when i upload it to server to work correctly -- 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] Are u using phpmyadmin to create your database?
Are u using phpmyadmin to create your database? or u do it from command prompt ,and do i have a databse driver so my database works when i upload it to server? -- 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] how to enter cgi-bin folder?
i want to access the file: test.php and its located in cgi-bin folder. and my form file is :form.html and its in htdocs folder. how can i access test.php? i tried: method= ../cgi-bin/test.php -- 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] does MySql needs driver
i didn't use a driver just inserted data directly throw phpmyadmin. do i need a driver?if yes from where can i get it? -- 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] Grant statement
do i need to write thr Grant statement to allow users to a have access to database(mysql)? -- 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]
