web_designer

Hi dear, how are you doing, I hope you are doing great and thank you a lot for your fast reply, it worked like a charm I could access the cpanal now. and the reason is I was using an old link (http://forums.xisto.com/no_longer_exists/) they should changed now. And that proves how along I was away from here so sad. I hope to be more active but I am fully taken away with life. But It is always relieving to have someone like you here to help and support. Well done dear, and thanks again.

Hi,How are you all? I hope you doing great. I have a website hosted on a server here, usually I can enter the cpanal right away to edit my files but it was been a while since I did that. So, when I tried to open the cpanal, it kept on loading and nothing comes up. I was wondering what is going on? and how to fix it. I need to edit files as soon as possible so please any help will be appreciated. Thanks in advance.

Thanks for the suggestion jlhaslip, I really appreciate your help. but the issue is resolved, I was working on it the past few days, and it seems that it is only a matter of organizing error, because I was trying to insert data to the chapters table where I didn't insert a book first :Ptherefore I got this error, because as I said before, the whole database is related in many to many relationship. Thanks for your help again.

Hi everyone, I have this error message appears when I try to insert data to my database through a form, here is the error message: I checked everything and it looks fine, here is the code for inserting the data: <form id="form2" name="form1" method="POST" action="<?php echo $editFormAction; ?>"> <p> <label for="chapter">Chapter</label> <input type="text" name="chapter" id="chapter" /> </p> <p> <label for="pages">Pages</label> <input type="text" name="pages" id="pages" /> </p> <p> <label for="startDate">Start Date</label> <input type="text" name="startDate" id="startDate" /> </p> <p> <label for="needsBy">Needs By</label> <input type="text" name="needsBy" id="needsBy" /> </p> <p> <label for="completed">Completed</label> <input type="text" name="completed" id="completed" /> </p> <p> <input name="hiddenField" type="hidden" id="hiddenField" value="<?php echo $row_rsChapters['bookID']; ?>" /> </p> <p> <input type="submit" name="button" id="button" value="Submit" /> </p> <p> <input type="hidden" name="MM_insert" value="form1" /> </p> <p> <a href="<?php echo $logoutAction ?>">Log out</a></p> </form> and this is the php code for the insertion method: $bookVar = $_GET['bID'];if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO chapterstatus (bookID, chapter, pages, startDate, needsBy, completed) VALUES (" .$bookVar. ", %s, %s, %s, %s, %s)", GetSQLValueString($_POST['chapter'], "int"), GetSQLValueString($_POST['pages'], "text"), GetSQLValueString($_POST['startDate'], "text"), GetSQLValueString($_POST['needsBy'], "text"), GetSQLValueString($_POST['completed'], "text")); mysql_select_db($database_connWill, $connWill); $Result1 = mysql_query($insertSQL, $connWill) or die(mysql_error()); $insertGoTo = "addChapters2.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo));}mysql_select_db($database_connWill, $connWill);$query_rsStudent = "SELECT * FROM students";$rsStudent = mysql_query($query_rsStudent, $connWill) or die(mysql_error());$row_rsStudent = mysql_fetch_assoc($rsStudent);$colname_rsBooks = "-1";if (isset($_GET['bID'])) { $colname_rsBooks = $_GET['bID'];} so where is the error I really don't know, so any ideas why I got this error message? thanks in advance for any help.

Hi everyone, I have this problem with my new battery for Dell Inspiron 1520, I just bought it two weeks ago and it should work better than that. The whole problem is, every time it reaches 66%, the whole computer sleeps even if it plugs to power, I mean it is charging, and I even couldn't turn it on until few seconds more. I know it is not that big thing, but it is really annoying, sometimes it sleeps when I was working on something really important, so it bothers me a lot. I checked the settings but couldn't find something weird, so any suggestion on what to do?Thanks in advance.

Here is the PHP code for the whole page: <?php require_once('../../../Connections/connWill.php'); ?><?php//initialize the sessionif (!isset($_SESSION)) { session_start();}//session_register("studentID");//$studentID = $HTTP_POST_VARS['txtStudent'];// ** Logout the current user. **$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){ $logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);}if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){ //to fully log out a visitor we need to clear the session varialbles $_SESSION['MM_Username'] = NULL; $_SESSION['MM_UserGroup'] = NULL; $_SESSION['PrevUrl'] = NULL; unset($_SESSION['MM_Username']); unset($_SESSION['MM_UserGroup']); unset($_SESSION['PrevUrl']); $logoutGoTo = "../index.php"; if ($logoutGoTo) { header("Location: $logoutGoTo"); exit; }}?><?phpif (!isset($_SESSION)) { session_start();}$MM_authorizedUsers = "";$MM_donotCheckaccess = "true";// *** Restrict Access To Page: Grant or deny access to this pagefunction isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { // For security, start by assuming the visitor is NOT authorized. $isValid = False; // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. // Therefore, we know that a user is NOT logged in if that Session variable is blank. if (!empty($UserName)) { // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. // Parse the strings into arrays. $arrUsers = Explode(",", $strUsers); $arrGroups = Explode(",", $strGroups); if (in_array($UserName, $arrUsers)) { $isValid = true; } // Or, you may restrict access to only certain users based on their username. if (in_array($UserGroup, $arrGroups)) { $isValid = true; } if (($strUsers == "") && true) { $isValid = true; } } return $isValid;}$MM_restrictGoTo = "../accessDenied.php";if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) { $MM_qsChar = "?"; $MM_referrer = $_SERVER['PHP_SELF']; if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&"; if (isset($_SERVER['QUERY_STRING']) && strlen($_SERVER['QUERY_STRING']) > 0) $MM_referrer .= "?" . $_SERVER['QUERY_STRING']; $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer); header("Location: ". $MM_restrictGoTo); exit;}?><?phpif (!function_exists("GetSQLValueString")) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""){ if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue;}}$editFormAction = $_SERVER['PHP_SELF'];if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);}if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) { $insertSQL = sprintf("INSERT IGNORE INTO textbooktable (authorLastName, authorFirstName, title, edition, isbn, publisher, pages, format, subject, amx) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['authorLastName'], "text"), GetSQLValueString($_POST['authorFirstName'], "text"), GetSQLValueString($_POST['title'], "text"), GetSQLValueString($_POST['edition'], "text"), GetSQLValueString($_POST['isbn'], "int"), GetSQLValueString($_POST['publisher'], "text"), GetSQLValueString($_POST['pages'], "int"), GetSQLValueString($_POST['format'], "text"), GetSQLValueString($_POST['subject'], "text"), GetSQLValueString($_POST['amx'], "text")); mysql_select_db($database_connWill, $connWill); $Result1 = mysql_query($insertSQL, $connWill) or die(mysql_error()); $insertGoTo = "requestChapters.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); $studentVar = $_SESSION['studentID']; mysql_select_db($database_connWill, $connWill);$sql="INSERT INTO tblstudentbookjunc (studentID, bookID)VALUES(" .$studentVar. ",LAST_INSERT_ID())";if (!mysql_query($sql,$connWill)) { die('Error: ' . mysql_error()); }echo "1 record added"; }mysql_select_db($database_connWill, $connWill);$query_rsStudents = "SELECT * FROM students";$rsStudents = mysql_query($query_rsStudents, $connWill) or die(mysql_error());$row_rsStudents = mysql_fetch_assoc($rsStudents);$totalRows_rsStudents = mysql_num_rows($rsStudents);?>

Hi, I work on a project right now and I got stuck in some where, the database that I am working on right now is a many to many relationship database, it is a book order database that allows students to order books and admin to control their orders. So what I have is four tables (books, students,admins, and bookstudentsconjunction), the bookstudentsconjunction is made to allow the many to many relationship, and I set everything using PHPMyAdmin. the problem that I countered is, I need to use the session variable to determine a certain student to insert a book to both tables (books and bookstudentsconjunction) and this is my MYSQL query: $sql="INSERT INTO tblstudentbookjunc (studentID, bookID)VALUES($_SESSION[studentID],LAST_INSERT_ID())"; but I can't get the desired effect, so any ideas where is the error?? thanks in advance.

hi Dyson,welcome to Xisto, you will find a lot of interesting and usful topics here. you can have friends, and have fun, just keep on posting and be active and enjoy. good luck.

well i am not sure of what region you are or what country you are from?? but here in america i see there are equal advantages and disadvantages of putting our children in public schools.the advantages are, the education, the experience, personally i see the level of education here is much more better than other countries, but still depending of the student itself and his or her family.and the disadvantages are, the chance of being influnced by the weong person and affecting by them and consequently they will learn bad habits and morals, but also that depends on his or her family to stop that effect. and i really think that private schools have the same advantages and disadvantages but in a different level depending on that school.all in all, we are, the families should pay attention more if we don't want our children to be affected by their community.