Jump to content

mdarling

Members
  • Posts

    18
  • Joined

  • Last visited

    Never

Posts posted by mdarling

  1. Are you sure about this? Where are $playerWidth etc being defined if not from the query string?

     

    <iframe src="mysite.com/embed.php?fileid=13130590312747&vw=600px;&vh=400px;top:-400px;-%22" frameborder="0" scrolling="no" width="600" frameborder="0" height="400"></iframe>

     

    Yes so this calls the embeded file and someone has inserted the -%22 into it  ans it kills the  code because it inserts the " that is %22.

     

     

     

    What you need to do is swtich up to single quotes i think.

  2. ok so before i go coding some crazy Frankenstein like code i wanted to throw this question out and see if anyone has ever tackled this.

     

    i would like to include a php file(mostly html in the file) into another php file when a radio button is selected.

     

    is this possible? is ther an include like function in JS?  i know this is more for a JS forum but since it involves php i thought id post it here too!

  3. Actually, there is a Kerberos Module for Apache that might do the trick.  @TeNDoLLA - not really sure why you said that. You really didn't contribute anything did you? I was just thanking the guy and expressing my distaste for java and activeX - i am hoping for a mostly php solution. This is a php forum after all.

  4. i am able to create csv's and can do so with no trouble .. but what i am having difficulty with is being able to auto save the csv and then email it all in one script. anybody every dealt with something like this?

  5. no  the  view doesn't exist and even when i change the code it still doesn't  create the view.  as i said before i works properly but the moment i try to do it in the web page itself it doesn't work. i am extremely  competent when it comes to php/mysql coding. the whole site revolves around it. but the moment i introduced this into the code it chooses not to recognize the create or something.

  6. ok so i cant get the create veiw to work .... it will work in phpmyadmin and with dbforge but not in the site... here is the code

    my server version is 5.1.36

    the errors i get are: either the table comply is not there  or if i exclude the 2nd select statement i get no database selected  but i can run other query's just fine!... and all permissions are set for the user.

     

     

     

     

      $sql1=mysql_query(" CREATE VIEW comply AS

                      SELECT quiz_compliance.grade, quiz.title as 'quiz', course.title as 'course', quiz_compliance.finish, user.first, user.last, user.id

                      FROM $dbname.course_enrollments

                      INNER JOIN $dbname.course ON course_enrollments.course_id = course.id

                      INNER JOIN $dbname.user ON course_enrollments.user_id = user.id

                      INNER JOIN $dbname.quiz_compliance

                      INNER JOIN $dbname.quiz ON quiz.course_id = course.id AND quiz_compliance.quiz_id = quiz.id

                      WHERE quiz_compliance.user_id = user.id AND course.id = '7'

                      ");

                     

      $sql4=mysql_query("  SELECT user.id, user.`first`, user.`last`

                      FROM emscloud.user

                      LEFT OUTER JOIN emscloud.comply ON user.id = emscloud.comply.id

                      WHERE emscloud.comply.id IS NULL");             

     

      echo "\n\n";

      echo "User ID,Last,First,\n\n";

    if ($sql1){

      while($s=mysql_fetch_array($sql4)){

                $user_id = $s["id"];

                $Last_name = $s["last"];

                $first_name = $s["first"];

               

         

          echo $user_id.",".$Last_name.",".$first_name;

          echo "\n";

     

      }

      }else{ print mysql_error();}

  7. ok so i cant get the create veiw to work .... it will work in phpmyadmin and with dbforge but not in the site... here is the code

    my server version is 5.1.36

    the errors i get are: either the table comply is not there  or if i exclude the 2nd select statement i get no database selected  but i can run other query's just fine!... and all permissions are set for the user.

     

     

     

     

    $sql1=mysql_query(" CREATE VIEW comply AS

    SELECT quiz_compliance.grade, quiz.title as 'quiz', course.title as 'course', quiz_compliance.finish, user.first, user.last, user.id

    FROM $dbname.course_enrollments

    INNER JOIN $dbname.course ON course_enrollments.course_id = course.id

    INNER JOIN $dbname.user ON course_enrollments.user_id = user.id

    INNER JOIN $dbname.quiz_compliance

    INNER JOIN $dbname.quiz ON quiz.course_id = course.id AND quiz_compliance.quiz_id = quiz.id

    WHERE quiz_compliance.user_id = user.id AND course.id = '7'

    ");

     

    $sql4=mysql_query(" SELECT user.id, user.`first`, user.`last`

    FROM emscloud.user

    LEFT OUTER JOIN emscloud.comply ON user.id = emscloud.comply.id

    WHERE emscloud.comply.id IS NULL");

     

    echo "\n\n";

    echo "User ID,Last,First,\n\n";

    if ($sql1){

    while($s=mysql_fetch_array($sql4)){

    $user_id = $s["id"];

    $Last_name = $s["last"];

    $first_name = $s["first"];

     

     

    echo $user_id.",".$Last_name.",".$first_name;

    echo "\n";

     

    }

    }else{ print mysql_error();}

     

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