plodos
-
Posts
212 -
Joined
-
Last visited
Everything posted by plodos
-
MyDatabase CREATE TABLE department ( dept_id INT NOT NULL, dept_name TEXT, PRIMARY KEY (dept_id) ); DROP TABLE IF EXISTS proficiency; CREATE TABLE proficiency ( p_id INT NOT NULL, p_name TEXT NOT NULL, PRIMARY KEY (p_id) ); DROP TABLE IF EXISTS doctor; CREATE TABLE doctor ( d_id INT NOT NULL PRIMARY KEY, d_name varchar(50) NOT NULL, d_surname VARCHAR(50) NOT NULL, d_add TEXT NOT NULL, SSN INT NOT NULL, d_tel INT NOT NULL, d_bdate DATETIME NOT NULL, # 2003-03-31 11:22:12 p_id INT NOT NULL, dept_id INT NOT NULL, FOREIGN KEY (dept_id) REFERENCES department (dept_id), FOREIGN KEY (p_id) REFERENCES proficiency (p_id) ); Problem is starting here $_u ="UPDATE doctor dr, proficiency p, department d SET dr.d_name='$_d_name', dr.d_surname='$_d_surname', dr.d_add='$_d_add', dr.SSN='$_SSN', dr.d_tel='$_d_tel', dr.d_bdate='$_d_bdate', d.dept_name='$_dept_name', p.p_name='$_p_name' WHERE dr.d_id ='$id' AND dr.dept_id = d.dept_id AND dr.p_id = p.p_id ;"; I want to UPDATE doctor departments and doctor informations, but i dont know how to write multiple querys.... how can I do that?
-
how to invite ALL of contacts from Google, Yahoo & MSN
plodos replied to plodos's topic in PHP Coding Help
How can I find the GMAIL & YAHOO invite your friends free php script? -
I have a script to invite ALL MSN friends..just write your msn adress and password, its automaticly sending..like a tell your friend.... but how can I find the APIs or SCRIPTs for GMAIL and YAHOO?
-
SOLVED!!!
-
When I click to send in the newWindow, there is not sending the emails and there is no error when I click to send that makes refresh... if I click the " click here ", script calls w4ftell.js and sendpage.php from the main directory and also I used in the form action="<?php echo $_SERVER['PHP_SELF']; ?> but everything is same.. what can be the errors!!! footer.php <script language="JavaScript" src="../w4ftell.js"></script> To send a link <a href="javascript:newWindow('../sendpage.php?'+document.location.href,'tell',400,300,'')">click here.</a> sendpage.php <html><head> <style type="text/css"> <!-- td { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; } body { margin: 0px; padding: 0px; } .menu { color: #FFFFFF; text-decoration: underline; } --> </style> <script language="JavaScript" src="w4ftell.js"></script> </head> <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <?php if (!$friendemail1) { ?> <br> <form action="" method=POST> <table width="390" border="0" cellspacing="0" cellpadding="3"> <tr> <td width="95" align="right" valign="top"> </td> <td width="1"> </td> <td width="100">Name: </td> <td width="194"> E-mail:</td> </tr> <tr> <td align="right" valign="top"><b>I am:</b></td> <td> </td> <td> <input type="text" name="name" size="15"> </td> <td> <input type="text" name="email" size="20"> </td> </tr> <tr> <td align="right" valign="top"><b>Friend 1:</b></td> <td> </td> <td> <input type="text" name="friendname1" size="15"> </td> <td> <input type="text" name="friendemail1" size="20"> </td> </tr> <tr> <td align="right" valign="top"><b>Friend 2:</b></td> <td> </td> <td> <input type="text" name="friendname2" size="15"> </td> <td> <input type="text" name="friendemail2" size="20"> </td> </tr> <tr> <td align="right" valign="top"><b>Message:</b></td> <td> </td> <td colspan="2"> <textarea name="text" cols="35" rows="6"> I found this great website and I believe you would be interested. Click here to visit the page: <?php echo $QUERY_STRING ?> </textarea> </td> </tr> <tr> <td align="right"><b></b></td> <td> </td> <td> <input type="submit" value=" Send " name="Submit" onClick="MM_validateForm('name','','R','email','','RisEmail','friendname1','','R','friendemail1','','RisEmail','friendemail2','','NisEmail','friendemail3','','NisEmail','text','','R');return document.MM_returnValue"> </td> <td> </td> </tr> </table> </form> <?php } else { if ($friendemail1) { mail( $friendemail1, "Message from $name", "$friendname1, \n\n".$text ."\n\nYour friend,\n $name", "From: $email"); } if ($friendemail2) { mail( $friendemail2, "Message from $name", "$friendname2, \n\n".$text ."\n\nYour friend,\n $name", "From: $email"); } echo "<center><br><br>Thank you. Your friends have been notified.<br><br><hr=size=1> <br><br><a href='javascript:window.close();'>Close this window</a>"; } ?> </body> </html> f4ftell.js function newWindow(mypage,myname,w,h,features) { if(screen.width){ var winl = (screen.width-w)/2; var wint = (screen.height-h)/2; }else{winl = 0;wint =0;} if (winl < 0) winl = 0; if (wint < 0) wint = 0; var settings = 'height=' + h + ','; settings += 'width=' + w + ','; settings += 'top=' + wint + ','; settings += 'left=' + winl + ','; settings += features; win = window.open(mypage,myname,settings); win.window.focus(); } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_validateForm() { //v4.0 var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments; for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]); if (val) { nm=val.name; if ((val=val.value)!="") { if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@'); if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n'; } else if (test!='R') { num = parseFloat(val); if (isNaN(val)) errors+='- '+nm+' must contain a number.\n'; if (test.indexOf('inRange') != -1) { p=test.indexOf(':'); min=test.substring(8,p); max=test.substring(p+1); if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n'; } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; } } if (errors) alert('The following error(s) occurred:\n'+errors); document.MM_returnValue = (errors == ''); }
-
I can call other php pages inside of the php pages like index.php <?php include(header.php); include(frontPage.php); include(footer.html); ?> but how can I call, for example .inc .html pages inside of the HTML pages ? Who knows the javascript code ? index.html Javascipt(footer.inc) Javascript(header.html)
-
thank you...
-
<?php echo ' htmlentities(<a href=\"http://www.xxxxx.com\">XXXXX.ORG!</a>) '; ?> the output must be like this <a href=\"http://www.xxxxx.com\">XXXXX.ORG!</a> but htmlentities function is not working..whats wrong?
-
user will upload the paper and databse will save the file path.., and reviewer can see the the related papers in the website part.. but comment and upload tables, i didnt make any relation, im new for dbase design...
-
i want to design a database, it will work like that... 1) there will be a user registration page, after the registration, user will select the article type(for ex, engineering, database, mechanic) and upload file...after the upload, if user select the for example "mechanic", script will send message all the mechanic reviewers... 2) there will be review registaration page and after registration, if the reviewer select the mechanic, reviewer will see the mechanic papers, and reviewer will check the papers, maybe will write some comments about the paper, maybe reviewer will upload the same paper to show whats wrong on the paper..also user can write some comments, user and reviewer can talk about the paper... 3) users will upload the files inside of FTP,at first i think to store each file in the mysql but some times one paper size can be 1MB or 3MB, thats very big size to store in the databse, and very difficult to backup....and also database must store FTP link like http://aa.com/upload/user2.doc CREATE TABLE user( user_id title mr/ms firstname lastname college email ..... ) CREATE TABLE writer( writer_id title fname lastName department email ... reviewer_permisssion( if the reviewer select mechanic and software or only engineering, must not see the database papers ) ) CREATE TABLE upload( upload_id upload_link ) CREATE TABLE comments( ??// reviewer 1, reviewer 2 can write comments for user15 paper.. also user15 can write comments for paper ) user can write the comments and maybe writer can write the comments also maybe user will upload another file and will write some comments maybe wirter will upload another file and will write some comments thats very diffiulcult to make a relation between tables like upload and comments for me:S who can help me to design this database?
-
if(!function_exists('conv_function')){ ................................ } very usefull function..thnx for help me!
-
rss.php <? include "dbconfig.php"; header("Content-type: text/xml\n\n"); echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?> <rss version=\"2.0\"> <channel> <title>World</title> <description>Open</description> <copyright>Copyright 2008, http://www.worlds.org</copyright> <link>http://www.worlds.org/notice/rss.php</link> <language>ENG</language> "; ?> <? $a=mysql_query("select * from notice_table ORDER BY user_id DESC LIMIT 10") or die(mysql_error()); while ( $data = mysql_fetch_array($a) ) { $id = $data['user_id']; $title=$data['title']; $date=$data['date']; $notice=$data['notice']; ?> <?php function conv_function($convert) { $convert = str_replace('"',""",$convert); $convert = str_replace(">",">",$convert); $convert = str_replace("<","<",$convert); return $convert; } ?> <item> <title><? echo $title; ?></title> <pubDate><? echo $date; ?></pubDate> <description><? echo conv_function($notice); ?></description> <link>http://www.worlds.org/notices.php?exploit=<? echo $id; ?></link> </item> <? } echo " </channel> </rss>"; ?> code is working but for only lastest data... RSS reader gives that error: Fatal error</b>: Cannot redeclare conv_function() (previously declared in /home/.wings/worlds.org/notice/rss.php:26) in <b>/home/.wings/world/notice/rss.php</b> on line 26 how can I redeclare conv_function() this function?
-
rss.php <? include "dbconfig.php"; header("Content-type: text/xml\n\n"); echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?> <rss version=\"2.0\"> <channel> <title>World</title> <description>WAS</description> <copyright>Copyright 2008, http://www.worldofsc.org</copyright> <link>http://www.worldofsc.org/notice/rss.php</link> <language>ENG</language> "; ?> <? $a=mysql_query("select * from notice_table ORDER BY user_id DESC LIMIT 10") or die(mysql_error()); while ( $data = mysql_fetch_array($a) ) { $id = $data['user_id']; $title=$data['title']; $date=$data['date']; $notice=$data['notice']; ?> <item> <title><? echo $title; ?></title> <pubDate><? echo $date; ?></pubDate> <description><? echo $notice; ?></description> <link>http://www.worldofsc.org/notice/?exploit=<? echo $id; ?></link> </item> <? } echo " </channel> </rss>"; ?> I create a rss.php file, I write this script.. by the help of FTP, I upload the web... When I click this link http://www.worldofsc.org/notice/rss.php It shows nothing, no input no output.. but when I look in the Firefox "show page source code", I can see the information like that <item> <title>Coca Cola</title> <pubDate>01.03.2090</pubDate> <description>For more info <a href="http://www.cocacola.com">GO!</a> <br><br> <link>http://www.worldofsc.org/notice/?exploit=61</link> But how can I see the output in the rss.php page?
-
when I use <?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?> like that Zend is underlying another sentences and version word...anyway.. Have you working script like that, could you give me! Maybe I can modify the another script..
-
<?xml version="1.0" encoding="ISO-8859-1" ?> im using zend 5.5.1 for run the script... and Zend is making red underline for these words version and encoding also it gives an error Parse error: syntax error, unexpected T_STRING in /home/.wings/world/rss.php on line 7
-
Parse error: syntax error, unexpected T_STRING in /home/.wings/xxxxxxx/rss.php on line 6 line 6 : <?xml version="1.0" encoding="ISO-8859-1"?>
-
<? include "dbconfig.php"; header("Content-type: text/xml\n\n"); echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?> <rss version=\"2.0\"> <channel> <title>World</title> <description>WAS</description> <copyright>Copyright 2008, xxx.com</copyright> <link>http://www.xxx.com/rss.php</link> <language>ENG</language> "; ?> <? $a=mysql_query("select * from notice_table ORDER BY user_id DESC LIMIT 10"); while ( $data = mysql_fetch_array($a) ) { $id = $data['user_id']; $title=$data['title']; $date=$data['date']; $notice=$data['notice']; ?> <item> <title><? echo $title; ?></title> <pubDate><? echo $date; ?></pubDate> <description><? echo $notice; ?></description> <link>http://www.xxx.com/?exploit=<? echo $id; ?></link> </item> <? } echo " </channel> </rss>"; ?> It doenst work..why ???
-
savanotices.php <?php //echo ' <br> output is ' . htmlentities($notices) . '<br> echo ' <br> output is ' . $notices . '<br> ?> I just modfiy the output, I delete the htmlentities() function, now I see the output of the original link. I dont know how to thank you, this problem took my 2 days:) And can I ask one more question? I didnt understand your solution way?
-
Still it is not working... im writing this sentence <a href="http://www.w3schools.com/">Visit W3Schools!</a> and if I click to the edit link, textarea output is <a href=\\\"http://www.w3schools.com/\\\">Visit W3Schools!</a>[code] [/code]
-
Still I didnt solve this problem... Who will help me
-
there are only 4 lines HTML code and 3 lines PHP code.. addnotices.php?notices=AAAAAAAA aaaaaaaaaaaa AAAAAAAAAAAAA -> this is working addnotices.php?notices=http://www.phpfreaks.com -> this is working addnotices.php?notices=<a href="http://www.w3schools.com/">Visit W3Schools!</a> this is not working:) like a joke:) I didnt understand.....
-
try this, but also it depends on your server time!!! $now = time(); $date = date("d/m/Y H:i:s",$now);
-
addnotices.php <form action="savenotices.php" method="post"> <textarea name="notices" cols="100" rows="10" id="notices" ><?php echo $_GET['notices'];?></textarea><br /> <input name="Submit" type="submit" value="Send"/> </form> savenotices.php <?php $notices = $_REQUEST['notices']; echo " <br> output is $notices <br> "; echo "<br><a href=\"addnotices.php?notices=$notices\"> Edit! </a> <br><br>"; ?> user will check the output of the notice, if there is a mistake user will click this link to TURN BACK <a href=\"addnotices.php?notices=$notices\"> Edit! </a> when I wrote a HTML code inside of the text area everything is mixing for example http://img219.imageshack.us/img219/938/74077155fx3.jpg, this is my form and when I click the Send button output is like that http://img219.imageshack.us/img219/5840/96262361xw8.jpg If I wrote normal sentences, sciprt is working.. Do you know why???? Whats wrong?? Also please run to your localserver, you will see the error clearly!
-
well, pls write in the textarea <a href="http://www.google.com"> Search Google! </a> like that and click the send button... and when you click yhe edit link, it must wotk like that addnotices.php?notices=http://www.google.com but i didnt do that:S
-