Learn VBA & Macros in 1 Week!

PHP - Moved: Javascript Function Not Called In Php

Full Excel VBA Course - Beginner to Expert

Moved: Javascript Function Not Called In Php	View Content

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=346692.0

Full Excel VBA Course - Beginner to Expert

Function Not Being Called

Similar Tutorials

View Content

I have 2 forms on a page, 1 with a selection of newly registered accounts and another that displays the information on the user. What I need to happen is when a user is selected from the first form, the second form is populated with the data. I'm trying to do this with a combination of php and javascript, however whenever a user is selected the function isn't being called at all as far as I can tell. Can anyone help me get this working please?

Code: [Select]
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Fearless Bandits :: Admin Control Panel</title>
</head>

<body>
<?php
//Check for config file and initiate session.
require("config.php");
session_start();

//Connect to DB
if(!$con)
die('Could not connect: ' . mysql_error());
mysql_select_db("$dbname") or die("Cannot select DB");

//Check user authorisation
if(!isset($_COOKIE['user'])) {
echo "Error: Cookies must be enabled. Please enable cookies in your browser and try again.<br>";
return;
}
else {
$user=$_SESSION['user'];
$sql="SELECT * FROM users WHERE username='$user' and access='2'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if($count == 0) {
echo "Error: Unauthorised access detected.";
return;
}
}

include("header.php");
echo "Admin Control Panel<br>";
//Check for mode, if no mode set to 0
if(isset($_GET['mode']))
$mode=$_GET['mode'];
else
$mode=0;

//Display information based on mode
switch($mode){
//Check for new applications
case 1:
echo "<a href=\"admin.php?mode=0\">Back</a><br>";
$sql="SELECT * FROM users WHERE newreg='1'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
$newuser = NULL;
$newuid = NULL;
$newapi = NULL;
$newmember = 0;
//If there is more than one load results into an array
if($count > 0) {
echo "There is at least 1 new user:<br>";
$i = 0;
while($row=mysql_fetch_array($result)) {
$newaccounts[$i] = $row['username'];
$i++;
}
for($i=0; $i < $count; $i++) {
echo "User " . $i . ": " . $newaccounts[$i] . "<br>";
}
//Select user
echo "<form name=\"selectuser\" action=\"\">";
echo "<select name=\"username\" onChange=\"newaccntsUpdate(this);\">";
echo "<option value=\"\" selected=\"selected\"></option>";
for($i=0; $i < $count; $i++) {
echo "<option value=\"" . $newaccounts[$i] . "\">" . $newaccounts[$i] . "</option>";
}
echo "</select><br>";
echo "</form>";

//Output array into form.
echo "<form name=\"newaccnts\" method =\"post\" action=\"verify_admin.php?form=1\">";
echo "Username: <input name=\"newuser\" type=\"text\" id=\"newuser\" value=\"" . $_SESSION['newuser'] . "\">";
echo "UID: <input name=\"newuid\" type=\"text\" id=\"newuid\" value=\"" . $_SESSION['newuid'] . "\">";
echo "API: <input name=\"newapi\" type=\"text\" id=\"newapi\" value=\"" . $_SESSION['newapi'] . "\">";
if($newmember == 0)
echo "Member: <input name=\"newmember\" type=\"checkbox\" id=\"newmember\" value=\"1\"><br>";
else
echo "Member: <input name=\"newmember\" type=\"checkbox\" checked= \"checked\" id=\"newmember\" value=\"1\"><br>";
echo "<input name=\"submit\" type=\"submit\" value=\"Submit\">";
echo "</form>";
}
break;
//Select a mode
default:
echo "Please select a function below:<br>";
echo "<ul>";
echo "<li><a href=\"admin.php?mode=1\">Check for new applications</a></li>";
echo "<li><a href=\"admin.php?mode=2\">Modify an existing account</a></li>";
echo "<li><a href=\"admin.php?mode=3\">Reset a password</a></li>";
echo "<li><a href=\"admin.php?mode=4\">Delete an account</a></li>";
echo "<ul>";
break;
}
mysql_close($con);

//Update newaccnts function. Pull user info from databse and then run javascript
function newaccntsUpdate() {
echo "newaccntsUpdate executed<br>"; //Error checking
//Identify username
$newuser=identifyUser();
//If username is NULL or blank return
if($newuser == NULL || $newuser == "")
return;
$sql = ("SELECT * FROM users WHERE username='$newuser'");
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$_SESSION['newuser'] = $newuser;
$_SESSION['newuid'] = $row['uid'];
$_SESSION['newapi'] = $row['api'];
$_SESSION['newmember'] = $row['member'];
//Update form with details
updateForm();
return;
}
?>

<script language = "Javascript">
//Identify which user has been selected
function identifyUser() {
$newuser = document.selectuser.username.value;
alert('identifyUser executed'); //Error checking
return($newuser);
}

//Update form
function updateForm() {
document.newaccnts.newuser.value = $newuser;
document.newaccnts.newuid.value = $_SESSION['newuid'];
document.newaccnts.newapi.value = $_SESSION['newapi'];
alert('updateForm executed'); //Error checking
return;
}
</script>
</body>
</html>
I apologise if I've butchered the code, I'm still learning.

Php Function Not Being Called

Similar Tutorials

View Content

Here's some of my code. The fault is when AJAX sends the dataString to sendpm.php, it should call the function. But nothing is happening. If i put the sendprivatemessage query in sendpm.php page, the data is sent to mysql. What is the solution, so i don't have to put the query on sendpm.php?

jquery - some of it
Code: [Select]
$.ajax({
type: "POST",
url: "/sendpm.php",
data: dataString,
success: function() {
window.location.href = 'http://www.stackway.com/cp/messages=outbox';
}

});
sendpm.php
Code: [Select]
include "database.php";

$to = $_POST['to'];
$from = $_POST['from'];
$subject = $_POST['subject'];
$body = $_POST['body'];

$database2 = new Database();
$database2->opendb();
$database2->sendprivatemessage($to,$from,$subject,$body);
$database2->closedb();

sendprivatemessage function
Code: [Select]
function sendprivatemessage($to,$from,$subject,$body) {

$insert = mysql_query("INSERT INTO privatemessage VALUES ('','$subject','$body','$to','$from','1',NOW(),'','','')",$this-connect);

}

Php Function Called From Onmouseover

Similar Tutorials

View Content

Getting a bit desperate as I've tried a lot of things, so any help very appreicated!

The concept im struggling with works like this:
1.) There are graphics of people on a page. There is a textbox to the right of the screen which outputs data that corresponds to the tutor.
2.) What i want is that when a user rolls his mouse over the picture, the data in the textbox immediately updates, which is done via php
3.) The issue is thus calling a php function within onmouseover="" from a javascript command.
4.) The function only changes the values that should be displayed (but doesnt work anyway) - is there a way to test whether a php function is being called correctly? And do i need to include some kind of page refresher?

Thanks a lot for your help

******************************************

The code as I have it currently is this.

...

Code: [Select]
// Default setting to display a random persons data at page startup
<?

$username="removedforprivacy";
$password="removedforprivacy";
$database="tutors";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tutors";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=rand(0,5);

$id=mysql_result($result,$i,"id");
$name=mysql_result($result,$i,"name");
$degree=mysql_result($result,$i,"degree");
$ib=mysql_result($result,$i,"ib");
$subjects=mysql_result($result,$i,"subjects");
$experience=mysql_result($result,$i,"experience");
$style=mysql_result($result,$i,"style");
$pic=mysql_result($result,$i,"pic");

?>

//This bit outputs all the graphics. Only the first immage calls the php updater function. $whichpic defines the flag for the person, which is passed to the updater function.
</p>
<p class="bodytext"><a href="" onclick="" onmouseout="MM_swapImgRestore()" onmouseover="<? php updater($whichpic=1); ?>"><img src="../Tutors/Photos/tim2.gif" name="Image15" width="100" height="100" border="0" id="Image15" /></a><a href="max.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image16','','../Tutors/Photos/max1.gif',1)"><img src="../Tutors/Photos/max2.gif" alt="max" name="Image16" width="100" height="100" border="0" id="Image16" /></a><a href="nico.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image17','','../Tutors/Photos/nico1.gif',1)"><img src="../Tutors/Photos/nico2.gif" alt="nico" name="Image17" width="100" height="100" border="0" id="Image17" /></a><a href="sasha.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image18','','../Tutors/Photos/sasha1.gif',1)"><img src="../Tutors/Photos/sasha2.gif" alt="sasha" name="Image18" width="100" height="100" border="0" id="Image18" /></a>
</p>

//Where the php data is output
<p class="sideheader">FEATURED TUTOR</p>
<p><img src="<? echo " $pic"; ?>" width="200" height="200"></p>
<p><strong>Name: </strong> <? echo "$name"; ?></p>
<p><strong>Degree: </strong> <? echo "$degree"; ?></p>
<p><strong>IB: </strong> <? echo "$ib"; ?></p>
<p><strong>Subjects Taught: </strong> <? echo "$subjects"; ?></p>
<p><strong>Teaching Experience: </strong> <br /> <? echo "$experience"; ?>
</p>
<p><strong>Teaching Style:<br /> </strong><? echo "$style"; ?>
.</strong> </p>
<p></p>
</div>

// The updater function to call, which changes the information displayed
<?
php

function updater($whichpic)
{

$i = $whichpic;

$id=mysql_result($result,$i,"id");
$name=mysql_result($result,$i,"name");
$degree=mysql_result($result,$i,"degree");
$ib=mysql_result($result,$i,"ib");
$subjects=mysql_result($result,$i,"subjects");
$experience=mysql_result($result,$i,"experience");
$style=mysql_result($result,$i,"style");
$pic=mysql_result($result,$i,"pic");
}
?>

Function Called On A Non-object

Similar Tutorials

View Content

ERROR 0 Fatal error: Call to a member function execute() on a non-object ...

i've tested the $mysqli and $stmt, both are objects, i have other requests that work well and are built the same way (copy - paste)

all vars on the query are also ok.

There are working functions over and under this part of my code, if i remove it everything works fine.

Code: [Select]

$query2 = "INSERT INTO TABLE_NAME(accountSmtp, passwordSmtp, merchantID, adsPrice, adsWidth, adsHeigh, adsAmount, email, emailFrom, adsSense) VALUES('$gmailUser', '$gmailPassword', '$merchantID', '$prix', '$width', '$height', '$adsAmount', '$email', '$from', '$sense')";
if (!$stmt = $mysqli->prepare($query2)) {
printf("Erreur : %d.\n", $stmt->errno);
print_r($query2);
}

/* execute statement */
$stmt->execute();

//close statement
$stmt->close();

Moved: Calling A Javascript Function

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=316624.0

Moved: Passing Three Textbox Values To A Javascript Function

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=348942.0

Moved: Passing Multiple Values To Javascript Function From Onclick() Action

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=359130.0

Call Javascript Function From Php Function

Similar Tutorials

View Content

Hi all, I want to call a javascript function from a php function like this:

public function Buscar()
{
$HoraInicio = $_POST['edtHoraInicio'];
$HoraFin = $_POST['edtHoraFin'];
$FechaInicio = $_POST['edtFec1'];
$FechaFin = $_POST['edtFec2'];

$FechaMax = $FechaFin." ".$HoraFin.":00";
$FechaMin = $FechaInicio." ".$HoraInicio.":00";

$_GET["FechaMax"] = $FechaMax;
$_GET["FechaMin"] = $FechaMin;

echo $FechaMin;

echo "<script language=javascript>alert('Hi.')</script>";

}

but the function Buscar never show the alert but shows the $FechaMin

I hopu u guys can help me out with this probem

Thanks,

Siddhartha

Moved: How To Use This Function?

Similar Tutorials

View Content

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=346709.0

Moved: Search Function Help

Similar Tutorials

View Content

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=346179.0

Moved: Help With Preg_match() Function

Similar Tutorials

View Content

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=317682.0

Moved: Include Function

Similar Tutorials

View Content

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=346775.0

Moved: Help With A Orderby In Function...

Similar Tutorials

View Content

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=316081.0

Moved: Delete Function

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=328704.0

Moved: Help With Failure Function

Similar Tutorials

View Content

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=352833.0

Moved: Php Mail() Function

Similar Tutorials

View Content

This topic has been moved to PHP Installation & Configuration.

http://www.phpfreaks.com/forums/index.php?topic=313336.0

Moved: Insert Substring Function

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=308768.0

Moved: Google Maps Function

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=328756.0

Moved: Simple Function Problem

Similar Tutorials

View Content

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=344481.0

Moved: Onchange Function Will Change The Value Of Php

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=330989.0