Jump to content

plodos

Members
 View Profile  See their activity

  • Posts

    212

  • Joined

  • Last visited

 Content Type 

Posts posted by plodos

    MySQL UPDATE tables problem

    in MySQL Help

    Posted

    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?

    [SOLVED] TELL A FRIEND problem

    in PHP Coding Help

    Posted

    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 == '');
}

    PHP vs Javascript ???

    in PHP Coding Help

    Posted

    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)

    htmlentities()

    in PHP Coding Help

    Posted 

    <?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?

    database design question?

    in PHP Coding Help

    Posted

    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?

    redeclare function !!!

    in PHP Coding Help

    Posted

    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 ?

    in PHP Coding Help

    Posted

    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?

    NOOB - RSS problem

    in PHP Coding Help

    Posted

    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..

    NOOB - RSS problem

    in PHP Coding Help

    Posted

    <?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

    NOOB - RSS problem

    in PHP Coding Help

    Posted

    <?

    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 ???

    html form and php ?

    in PHP Coding Help

    Posted

    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? :)

    html form and php ?

    in PHP Coding Help

    Posted

    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]

    html form and php ?

    in PHP Coding Help

    Posted

    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!

    link error/s ?

    in PHP Coding Help

    Posted

    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

     

     

     

    link error/s ?

    in PHP Coding Help

    Posted

    addnotices.php

    <form action="savenotices.php" method="post">
<table border="0" bgcolor="#ececec" cellspacing="5">

<tr>
<td valign="top">Notices</td><td><textarea name="notices" cols="100" rows="10" id="notices" ><?php echo $_GET['notices'];?></textarea>
</td>
</tr>

<tr>
<td><input name="Submit" type="submit" value="Send"/><font face="arial" size="1">  </font></td>
</tr>
</table>
</form>

     

    sendnotices.php

    <?php
$notices = $_REQUEST['notices'];

echo " <br >output is <br><br> 
$notices";

echo "<br><a href=\"addnotices.php?notices=$notices\"> edit! go back to form </a> <br><br>";
?>

    problem is, when I click ""<a href=\"addnotices.php?notices=$notices\"> edit notices! </a>"" , addnotices.php page is not showing the content..thats very difficult to explain for me...if you check it your local server you will see the error!

     

    for example write the form,

    more information <a href="http://www.google.com">Search Google!</a>

    and click the send button, you will see what happened!

     

    if I write the link in the textarea and if I click the Send button, everything is mixing,

    but if I write normal sentences everything is clear :S

     

    it must work like that but not working ... addnotices.php?notices=http://www.google.com ...

     

     

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.