Lowyat.NET: Latest topics by jessica91

excel experts come in please

jessica91 — Thu, 13 Feb 2014 09:48:08 +0800

Hi. I am working on an excel file that was sent to me by someone else. The file does not allow copy and paste action. How do I enable copy paste without touching the codes in vba. Is there any way to do this. Your suggestions are very much appreciated. Thank you in advance

Data is not being fetched from database

jessica91 — Sun, 15 Dec 2013 15:47:00 +0800

i have this file quiz index.php. once i click on the "click to begin button" my questions from my database do not appear. Working on a quiz engine btw. below are the other files

<?php
$msg = ""; //initializing msg variable
if(isset($_GET['msg'])){
$msg = $_GET['msg'];
$msg = strip_tags($msg);
$msg = addslashes($msg);

}

?>
<html>
<head>
<title>Quiz Start</title>
<script>
function QuizStart(url){
window.location = url;
}
</script>
</head>
<body>
<?php echo $msg; ?>
<h2>Click on the button below when you are ready!</h2>
<button onclick="QuizStart('quiz.php?questions=1')">Click To Begin!</button>

</body>
</html>

this is quiz.php

<?php

session_start();

$msg = ""; //initializing msg variable
if(isset($_GET['msg'])){
$msg = $_GET['msg'];
$msg = strip_tags($msg);

}

if(isset($_GET['questions'])){
$questions = preg_replace('/[^0-9]/',"",$_GET['questions']);
$next = $questions + 1;
$prev = $questions - 1;

if(!isset($_SESSION['qid_array']) && $questions != 1){
$msg = "You are not allowed to do that. You have to start all over again!";
header("location:quiz_index.php?msg=$msg");
exit();
}
if(isset($_SESSION['qid_array']) && in_array($questions, $_SESSION['qid_array'])){ //check to see if something is in the array
$msg = "You are not allowed to do that. You have to start all over again!";
unset($_SESSION['answer_array']); //unset answer array
unset($_SESSION['qid_array']); // unset question array
header ("location:quiz_index.php?msg=$msg");
exit();
}
if(isset($_SESSION['lastQuestion']) && ($_SESSION['lastQuestion'] != $prev)){
$msg = "Cheating is not allowed";
unset($_SESSION['answer_array']);
unset($_SESSION['qid_array']);
session_destroy(); //last question session is no longer there
header("location:quiz_index.php?msg=$msg");
exit();
}

}

?>

<html>
<head>

<title>Quiz Page</title>

<script type="text/javascript">
function countDown(secs,elem){
var element = document.getElementById(elem);
element.innerHTML="You have "+secs+" seconds remaining";
if(secs < 1){
var xhr = new XMLHttpRequest();
var url = "user_question_answer.php";
var vars = "radio=0"+"&qid"+ <?php echo $questions; ?>;
xhr.open("POST",url,true);
xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xhr.onreadystatechange = function() {
if(xhr.readyState == 4 && xhr.status ==200){
alert("You did not answer the question in the alloted time. It will be marked as incorrect");
clearTimeout(timer);
}
}
xhr.send(vars);
document.getElementById('counter_status').innerHTML = "";
document.getElementById('btnSpan').innerHTML = '<h3>Timer Up</h3>';
document.getElementById('btnSpan').innerHTML += '<a href="quiz_index.php?questions=<?php echo $next; ?>">Click here </a>';

}
secs--;
var timer = setTimeOut('countDown('+secs+',"'+elem'")',1000);
}
</script>
<script>

function getQuestions(){
var hr = new XMLHttpRequest();
hr.onreadystatechange = function(){
if (hr.readyState==4 && hr.status==200){
var response = hr.responseText.split("|");
if(response[0] == "done"){
document.getElementById('status').innerHTML = response[1];
}
var nums = hr.responseText.split(",");
document.getElementById('questions').innnerHTML = nums[0];
document.getElementById('answer').innerHTML = nums[1];
document.getElementById('answer').innerHTML += nums[2];
}
}
hr.open("GET","questions1.php?questions=" + <?php echo $questions; ?>, true);
hr.send();
}

</script>
<script>
function x() {
var rads = document.getElementByName("rads");
for (var i=0; i < rads.legth; i++){
if (rads[i].checked){
var val = rads[i].value;
return val;
}
}
}
function post_answer(){
var p = new XMLHttpRequest();
var id = document.getElementById('qid').value;
var url = "user_question_answer.php";
var vars = "qid="+id+"&radio="=+x();
p.open("POST",url,true);
p.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
p.onreadystatechange = function(){
if(p.readyState == 4 && p.status ==200) {
document.getElementById("status").innerHTML = '';
alert("Thank you, your answer is submitted"+ p.responseText);
var url = 'quiz.php?questions=<?php echo $next;?>';
window.location = url;
}
}
p.send(vars);
document.getElementById("status").innerHTML = "processing....";
}
</script>
<script>
windows.oncontextmenu = function(){
return false;
}
</script>

</head>

<body onLoad="getQuestions()">
<div id="status">
<div id="counter_status"></div>
<div id="questions"></div>
<div id="answer"></div>
</div>
<script type="text/javascript">countDown(20,"counter_status");</script>
</body>
</html>

this is questions1.php

<?php
session_start();
require_once("questions_connect.php");
$arrCount = "";
if(isset($_GET['questions'])){
$questions = preg_replace('/[^0-9]/',"",$_GET['questions']);
$output = "";
$answer = "";
$q = "";
$sql = mysql_query("SELECT id FROM questions");
$numQuestions = mysql_num_rows($sql);
if(!isset($_SESSION['answer_array']) ||( $_SESSION['answer_array'] < 1)){
$currQuestions = "1";
} else {
$arrCount = count($_SESSION['answer_array']);
}
if($arrCount > $numQuestions){
unset($_SESSION['answer_array']);
header("location:quiz_index.php");
exit();
}
if($arrCount >= $numQuestions){
echo 'done|<p>There are no more questions Enter your username and click next</p>
<form action = "user_question_answer.php" method ="POST">
<input type="hidden" name="done" value="true">
<input type = "text" name="username">
<input type = "submit" value = "next">
</form>';
exit();
}
$singleSQL = mysql_query("SELECT * FROM questions WHERE id='$questions' LIMIT 1");
while($row = mysql_fetch_array($singleSQL)){
$id = $row['id'];
$thisQuestions = $row['questions'];
$type = $row['type'];
$questions_id = $row['questions_id'];
$q = '<h2>'.$thisQuestions.'</h2>';
$sql2 = mysql_query("SELECT * FROM answers WHERE questions_id = '$questions' ORDER BY rand()");
while($row2 = mysql_fetch_array($sql2)){
$answer = $row2['answer'];
$correct = $row2['correct'];
$answer .= '<label style="cursor:pointer;*><input type="radio" name="rads"value="'.$correct.'">'.$answer.'</label>
<input type = "hidden" id="qid" value="'.$id.'" name="qid"><br /><br />';

}
$output =''.$q.','.$answer.'<span id = "btnSpan"><button onclick="post_answer()">Submit</button></span>';
echo $output;

}

}

?>

this is user_question_answer.php

<?php
session_start();
if(isset($_POST['radio']) && $_POST['radio'] !=""){
$answer = preg_replace('/[0-9]/',"", $_POST['radio']);
if(!isset($_SESSION['answer_array']) || count($_SESSION['answer_array']) <1){
$_SESSION['answer_array'] = array($answer); //user answer array
} else{
array_push($_SESSION['answer_array'], $answer); //add answer to array
}
}
if(isset($_POST['qid']) && $_POST['qid'] != ""){
$qid = preg_replace('/[0-9]/',"",$_POST['qid']);
if(!isset($_SESSION['qid_array']) || count($_SESSION['qid_array']) < 1){
$_SESSION['qid_array'] = array($qid);
} else {
array_push($_SESSION['qid_array'], $qid);
}
$_SESSION['lastQuestion'] = $qid;
}

?>
<?php
require_once("questions_connect.php");
$response = "";
if(!isset($_SESSION['answer_array']) || count($_SESSION['answer_array']) < 1) { //if answer array has not been set or no of elements in array is less than 1
$response = "You have not answered any questions so far";
echo $response;
exit();
} else{
$countCheck = mysql_query("SELECT id FROM questions") or die(mysql_error()); // will return no of ids from this query
$count = mysql_num_rows($countCheck);
$numCorrect = 0;
foreach($_SESSION['answer_array'] as $current){
if($current ==1){ //if the answer is equal to 1 then add numcorect one each time it loops
$numCorrect++;
}
}
$percent = $numCorrect / $count * 100; //numCorrect is however many questions are correct
$percent = intval($percent); //intval will round up decimal score
if(isset($_POST['done']) && $_POST['done'] == "true"){
if(!isset($_POST['username']) || $_POST['username'] == ""){
echo "There was an error. Sorry";
exit();
}
$username = $_POST['username'];
$username = mysql_real_escape_string($username);
$username = strip_tags($username);
if(!in_array("1",$_SESSION['answer_array'])){
$sql = mysql_query("INSERT INTO user_question_answer (username, percentage, date_time) VALUES ('$username','0', now())") or die (mysql_error());
echo "Try again. Your score is $percent%";
unset($_SESSION['answer_array']);
unset($_SESSION['qid_array']);
session_destroy();
exit();

}
$sql = mysql_query("INSERT INTO user_question_answer (username, percentage, date_time) VALUES ('$username','$percent',now())") or die (mysql_error());
echo "Thank you for taking the quiz. Your score is $percent%";
unset($_SESSION['answer_array']);
unset($_SESSION['qid_array']);
session_destroy();
exit();

}
}

?>

Quiz engine

jessica91 — Wed, 11 Dec 2013 12:39:53 +0800

Hi, I have a question on the project that I'm working on. Before that I'll describe what my project is all about. Its more like an online quiz engine/website where users get to answer a set of quiz and then they check their score. I have other features too but they're not really important. This is the most part of my website. So my question here is, how am i gonna store my questions in the database? How is my table for questions gonna look like? Btw, I am using php and phpmyadmin.

Thank you in advance.

lets say, this is one of question,

- Sample code
#include <stdio.h>
/* function declaration happens here.*/
void swap ( int p1, int p2);
int main ()
{
int a = 10;
int b = 20;
printf (“Before : Value of a = %d and value of b = %d\n”, a ,b);
swap (a,b);
printf(“After : Value of a = %d and value of b = %d\n”, a,b);
}
void swap (int p1, int p2)
{
int t;
t = p2;
p2 = p1;
p1 = t;
printf (“Value of a (p1) = %d and value of b (p2) = %d\n”, p1, p2);
}

Based on the coding given above, what is the value of a (p1) and b (p2) ?
A. a (p1) = 20 , b (p2) = 10
B. a (p1) = 10 , b (p2) = 20
C. a (p1) = 30 , b (p2) = 40

php people come in please

jessica91 — Thu, 05 Dec 2013 13:53:15 +0800

Can someone here recommend me a site where I can learn how to code an admin's page in php?

Thanks in advance

php experts come in please

jessica91 — Tue, 03 Dec 2013 00:26:19 +0800

Can someone tell me what went wrong here. When i enter 2 different password, it does not echo out the message "you password do not match."

<?php
echo "<h1><center>C Prog Intelligent Tutoring System's Registration Page</h1></center>";

$submit = isset($_POST['submit']);
$fullname = isset($_POST['fullname']);
$username = isset($_POST['username']);
$password = isset($_POST['password']);
$confirmpassword = isset($_POST['confirmpassword']);
$email = isset($_POST['email']);
$contact_no = isset($_POST['contact_no']);
$date = ("Y-m-d");

if (isset($submit))
{

if($fullname&&$username&&$password&&$confirmpassword&&$email&&$contact_no)
{
$password = md5($password);
$confirmpassword = md5($confirmpassword);

if($password==$confirmpassword)
{
if(strlen($username)>25||strlen($fullname)>25)
{
echo "length of username or password is too long";
}
else
{
//check password length
if(strlen($password)>25||strlen($password)<6)
{
echo "Password must be between 6and 25";
}
else
{
echo "success!";
}
}
}
else
echo "your password do not match";

}
else
{
echo "Please fill in all fields!";
}
}

?>
<p>
<html>
<p>
<form method="post"action="register.php" >
<table width="274" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td colspan="2">
<div align="center">
</tr>
<tr>
<td width="95"><div align="right">Fullname:</div></td>
<td width="171"><input type="text" name="fname" id="fname"/></td>
</tr>
<td><div align="right">Username:</div></td>
<td><input type="text" name="username" id="username" /></td>
</tr>
<td><div align="right">Password:</div></td>
<td><input type="text" name="password" id="password" /></td>
</tr>
<td><div align="right">Confirm Password:</div></td>
<td><input type="text" name="confirmpassword" id="password" /></td>
</tr>
<tr>
<td><div align="right">Email:</div></td>
<td><input type="text" name="email" id="email" /></td>
</tr>
<tr>
<tr>
<td><div align="right">Contact No.:</div></td>
<td><input type="text" name="contact" id="contact"/></td>
</tr>
<tr>

<tr>

<tr>
<td><div align="right"></div></td>
<td><input name="submit" type="submit" value="Submit" /></td>
</tr>
</table>
</form>
</body>

</html>

phpmyadmin and mysql problem

jessica91 — Sun, 10 Nov 2013 16:53:33 +0800

Can someone tell me what went wrong here. I am getting this warning/error whatsoever on my page that says " Notice: Undefined index: username in C:\xampp\htdocs\tutorial\comm.php on line 9" and whatever that i'm entering here doesn't appear in my tables in phpmyadmin. Is my connection to the database correct?
Below is my coding. Please take a look.

<?php
$host = '';
$user = 'root';
$pass = '';
$db = 'login';

mysql_connect($host,$user,$pass);
mysql_select_db($db);
$username=$_POST['username'];
$comment=$_POST['comment'];
$submit=$_POST['submit'];

if($submit)
{
if($username && $comment)
{

$insert=mysql_query ("INSERT INTO `comment`( `name`, `comment`) VALUES ([$username],[$comment])");

}
else
{

echo "Please fill in all fields";
}

}

?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>

<body>

<form action = "comm.php" method = "POST">

<p class = 'wrap'>
<table class = 'wrap' width = "400" border = "0">
<tr><td> username: </td>
<td> <input type = "text" name = "name size = "25"/></td></tr>
<tr>
<td> Comment: </td>
<td><textarea rows = "9" name = "comment" cols = "50"></textarea> </td></tr>
<tr><td colspan="2"><input name = "submit" value = "Submit" type="image" src="images/submit_button 3.gif" height = "50" width = "120" boder = "0"/></td></tr>

</table>
</form>
</body>
</html>

Project help

jessica91 — Sun, 27 Oct 2013 23:17:37 +0800

Hi

I am a final year student doing computer science and i need some guidance on the programming part for this project.
My project is more like an online tutoring system and i am using php and mysql to connect to database. However, i get stuck most of the time not knowing
where to continue and what to do next so this is why i need some guidance. If anyone here is willing to help please do inbox me.

Thanks

Project help

jessica91 — Sun, 27 Oct 2013 18:29:26 +0800

I need recommendations!

jessica91 — Fri, 08 Mar 2013 20:14:44 +0800

Hi.
Can someone tell me which is a good dell or lenovo laptop?
Budget : 3 - 3.5k
Thank you

Help!

Thu, 01 Jan 1970 07:30:00 +0800

Help!

jessica91 — Sat, 02 Mar 2013 23:03:41 +0800

hi
can someone good at programming help me out here? I'm using netBeans Ide 7.3 for java programming and there's always an error whenever I do object creation. Can someone tell me what is this due to?
Thanks.

Tattoo

jessica91 — Thu, 20 Dec 2012 18:35:23 +0800

hi /k/
Anywhere in KL u people know where i can go and get a tattoo?
Place that's hygienic

Is your love life fading away?

jessica91 — Sun, 04 Nov 2012 15:42:32 +0800

so people, tell me is your love life fading away? if yes, what makes you think so ?

need help

jessica91 — Fri, 24 Aug 2012 00:16:00 +0800

hi /k/
can anyone tell me where can i get statistics from, e.g. number of hospitals in Malaysia.
thanks

Guys help me

Thu, 01 Jan 1970 07:30:00 +0800

Guys help me

jessica91 — Sun, 12 Aug 2012 19:16:48 +0800

anyone know how to make chart/graph for breakeven analysis? pm me please

biodiesel incorporated

jessica91 — Tue, 19 Jun 2012 15:45:34 +0800

hi
i didn't know where exactly to post this so i'm just posting this here. i need some ideas from u ppl out there on an assignment that i'm working on. The title is biodiesel incorporated. The scenario is such, there's a team working on replacing whats currently in market which is petroleum,coal, natural gases in short non- renewable resources into biodeisel. In other words, it is to find a form of fuel or technology that can mitigate the current negative effects on the environment of petrol-based fuel while utilizing the existing infrastructure. so now, if these people were to propose this idea, what market drivers should they research and be aware of? what type of financing should they use if the choose to go foward with this? what type of distribution channels should they go into? some ideas from u ppl would do alot.
thanks

biodiesel incorporated

jessica91 — Mon, 18 Jun 2012 21:45:57 +0800

deleting thread

jessica91 — Sun, 29 Apr 2012 20:08:15 +0800

hi /k/
i'm still new on LYN and i wanna know how to delete a thread that i've open

thank you

is ur partner bored of you?

jessica91 — Sat, 28 Apr 2012 13:25:31 +0800

so girls, tell me is ur bf bored of you after you've had sex with him? Is this a normal thing in every other relationship? he doesn't talk to you like how he used to? he doesn't say nice things about u anymore? he doesn't come see u that often anymore? Other things seems more important than you now? did he say that he's bored of you now?

please share, tell me the way u feel. Tell me if this is what you're going through in your relationship as well