PHP - Reloading Data From Mysql

This could be PHP or MySql so putting it in PHP forum for now...
I have code below (last code listed) which processes a dynamically created Form which could have anywhere from 0 to 6 fields.  So I clean all fields whether they were posted or not and then I update the mySQL table.

The problem with this code below is that if, say, $cextra was not posted (i.e. it wasnt on the dynamically created form), then this code would enter a blank into the table for $cextra (i.e. if there was already a value in the table for $cextra, it gets overwritten, which is bad).

What is the best way to handle this?  I'm thinking i have to break my SQL query into a bunch of if/else statements like this...

Code: [Select]
$sql = "UPDATE cluesanswers SET ";
if (isset($_POST['ctext'])){
echo "ctext='$ctext',";
} else {
//do nothing
}
and so on 5 more times....

That seems horribly hackish/inefficient.  Is there a better way?

Code: [Select]
if (isset($_POST['hidden']) && $_POST['hidden'] == "edit") {

$cimage=trim(mysql_prep($_POST['cimage']));
$ctext=trim(mysql_prep($_POST['ctext']));
$cextra=trim(mysql_prep($_POST['cextra']));
$atext=trim(mysql_prep($_POST['atext']));
$aextra=trim(mysql_prep($_POST['aextra']));
$aimage=trim(mysql_prep($_POST['aimage']));


//update the answer edits
$sql = "UPDATE cluesanswers SET ctext='$ctext', cextra='$cextra', cimage='$cimage', atext='$atext', aextra='$aextra', aimage='$aimage'";
$result = mysql_query($sql, $connection);
if (!$result) {
die("Database query failed: " . mysql_error());
} else {
}

Hi I am trying to select and order data/numbers from a colum in a mysql data base however i run the code and it returns no value just a blank page no errors or any thing so i think the code is working right but then it returns no result? Please help thanks

Here is the code:

<?php
$host= "XXXXXX";
$mysql_user = "XXXXXX";
$mysql_password = "XXXXXX";
$mysql_database = "XXXXXXX";

$connection = mysql_connect("$host","$mysql_user","$mysql_password") or die ("Unable to connect to MySQL server.");
mysql_select_db($mysql_database) or die ("Unable to select requested database.");

$row = mysql_fetch_assoc( mysql_query( "SELECT XP FROM Game ORDER BY number DESC LIMIT 1" ) );
$number = mysql_result(mysql_query("SELECT XP FROM Game ORDER BY number DESC LIMIT 1"), 0);

echo "The the highest XP is $number";

?>

hi guys, im new to this forum

I'm new also to php, I need help from you guys:

I want to display personal information from a certain person (the data is on the mysql database) using his name as a link:

example:
               (index.php)
               names
                          1. Bill Gates
                          2. Mr. nice Guy
           
i want to click Bill Gates
 
   (output.php)
     Name: Bill Gates
     Country:xxxx
     Age: xx   
                 etc.

How can i make this or how to learn this?
   
                 

             
               

   
       

I have a form on our website that a user can fill out for custom product.  I want the form data to be 1) stored into a mysql database AND after storing said data, 2) email the same data to our sales department.

1)  The form data DOES get stored into mysql database (except for the first two fields, for some weird reason)

2) I added a "mail" section to the php file that stores the data into the database, but it is not working correctly.  I have stripped the email portion down to sending just one of the fields in the "message" to make it easier for troubleshooting

I have included here, both the form section of the html file, and the formdata.php file that processes the data for your  analysis.  I am relatively new to php so there are going to be some issues with security, but I can work on those after I get the store & email process to work correctly.  Please review my code and see if anyone can be of assistance.  I looked through the forums and couldn't find another issue that was the same as mine.  If I just overlooked, please tell me the thread post #.  Thanks

THE FORM WHICH COLLECTS THE DATA
*******************************
<form method=POST action=formdata.php>

                 
  <table width="640" border=0 align="center">
    <tr>
      <td align=right><b>First Name</b></td>
      <td><input type=text name=FName size=25></td>
      <td><div align="right"><b>Telephone</b></div></td>
      <td><input type=text name=Tel size=25></td>
    </tr>
    <tr>
      <td align=right><b>Last Name</b></td>
      <td><input type=text name=LName size=25></td>
      <td><div align="right"><b>Fax</b></div></td>
      <td><input type=text name=Fax size=25></td>
    </tr>
    <tr>
      <td align=right><b>Title</b></td>
      <td><input type=text name=Title size=25></td>
      <td><div align="right"><b>Email</b></div></td>
      <td><input type=text name=Email size=50></td>
    </tr>
    <tr>
      <td align=right><b>Company</b></td>
      <td><input type=text name=Comp size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Address</b></td>
      <td><input type=text name=Addr size=25></td>
      <td><div align="right"><b>Estimated Annual Volume</b></div></td>
      <td><input type=text name=EAV size=25></td>
    </tr>
    <tr>
      <td align=right><b>City</b></td>
      <td><input type=text name=City size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>State/Province</b></td>
      <td><input type=text name=SProv size=25></td>
      <td><div align="right"><b>Application</b></div></td>
      <td><input type=text name=Appl size=25></td>
    </tr>
    <tr>
      <td align=right><b>Country</b></td>
      <td><input type=text name=Ctry size=25></td>
      <td><div align="right"><b>Type of System</b></div></td>
      <td><input type=text name=Syst size=25></td>
    </tr>
    <tr>
      <td align=right><b>Zip/Postal Code</b></td>
      <td><input type=text name=ZPC size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td><div align="right"><strong><font color="#FFFF00" face="Arial, Helvetica, sans-serif">COIL
          DESIGN</font></strong></div></td>
      <td><font color="#FFFF00" face="Arial, Helvetica, sans-serif"><strong>PARAMETERS</strong></font></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Primary Resistance (ohms)</b></td>
      <td><input type=text name=Pres size=25></td>
      <td><div align="right"><b>Primary Inductance (mH)</b></div></td>
      <td><input type=text name=Pind size=25></td>
    </tr>
    <tr>
      <td align=right><b>Secondary Resistance (ohms)</b></td>
      <td><input type=text name=Sres size=25></td>
      <td><div align="right"><b>Secondary Inductance (H)</b></div></td>
      <td><input type=text name=Sind size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Peak Operating Current (Amps)</b></td>
      <td><input type=text name=POC size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Output Energy (mJ)</b></td>
      <td><input type=text name=Egy size=25></td>
      <td><div align="right"><b>Output Voltage (kV)</b></div></td>
      <td><input type=text name=Volt size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b># HV Towers per Coil</b></td>
      <td><input type=text name=TPC size=25></td>
      <td><div align="right"><b># of Coils per Package</b></div></td>
      <td><input type=text name=CPP size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th colspan=4><b>Please enter any additional information he </b></th>
    </tr>
    <tr>
      <th colspan=4><textarea name=Mess cols=50 rows=10 id="Message"></textarea></th>
    </tr>
  </table>
  </dl>
  <div align="center">
    <p>
      <input type=hidden name=BodyTag value="&lt;body  bgcolor=&quot;#484589&quot; text=&quot;#FFFFFF&quot; link=&quot;#FFFF00&quot; alink=&quot;#FFFFFF&quot; vlink=&quot;#FF7F00&quot;&gt;">
      <input type=hidden name=FA value=SendMail>
    </p>
    <p><font color="#FFFF00" face="Arial, Helvetica, sans-serif"><strong>PLEASE MAKE SURE ALL
      INFORMATION<br>
      IS CORRECT BEFORE SUBMITTING</strong></font></p>
    <p>
      <input type=submit value="Submit Form">
    </p>
  </div>
</form>
THE FILE THAT PROCESSES THE FORM DATA (formdata.php)
***********************************************
<?php
$con = mysql_connect("localhost","XXX","XXX");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("customform", $con);

$sql="INSERT INTO formdata (Fname, Lname, Title, Comp, Addr, City, SProv, Ctry, ZPC, Tel, Fax, Email, EAV, Appl, Syst, Pres, Pind, Sres, Sind, POC, Egy, Volt, TPC, CPP, Mess)
VALUES ('$_POST[Fname]','$_POST[Lname]','$_POST[Title]','$_POST[Comp]','$_POST[Addr]','$_POST[City]','$_POST[SProv]','$_POST[Ctry]','$_POST[ZPC]','$_POST[Tel]','$_POST[Fax]','$_POST[Email]','$_POST[EAV]','$_POST[Appl]','$_POST[Syst]','$_POST[Pres]','$_POST[Pind]','$_POST[Sres]','$_POST[Sind]','$_POST[POC]','$_POST[Egy]','$_POST[Volt]','$_POST[TPC]','$_POST[CPP]','$_POST[Mess]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Your Information Was Successfully Posted";

mysql_close($con);

$to = "recipient email address here"; 
$subject = "Custom Form"; 
$email = $_POST['Email'] ; 
$message = $_POST['Comp'] ; 
$headers = "From: $Email"; 
$sent = mail($to, $subject, $message, $headers) ; 
if($sent) 
{print "Your mail was sent successfully"; }
else 
{print "We encountered an error sending your mail"; }
?>

I am delete records using $_POST on the current page using isset() function. The records are deleting and the isset function is working but the corresponding record still appears in the list of records until the page is reloaded again.

I have a php generated image:

(number.txt contains a number 1 or 2)

pic.php
Code: [Select]
<?php
// Set the content-type
header('Content-type: image/bmp');
// Create the image
$im = imagecreatetruecolor(80, 80);

$count_my_page = ("number.txt");
$hits = file($count_my_page);


if ($hits[0] == 1) {
$im = imagecreatefrompng("image1.png");
$hits[0] ++;
$fp = fopen($count_my_page , "w");
fputs($fp , "$hits[0]");
fclose($fp);
}else{
$im = imagecreatefrompng("image2.png");
$hits[0] --;
$fp = fopen($count_my_page , "w");
fputs($fp , "$hits[0]");
fclose($fp);
}

// Create some colors
$white = imagecolorallocate($im, 255, 255, 255);
$black = imagecolorallocate($im, 1, 1, 1);

// Using imagepng() results in clearer text compared with imagejpeg()
imagepng($im);
imagedestroy($im);
?>
And I have another page

index.html
Code: [Select]
<img src="pic.php">
<img src="pic.php">

Basically, I need one of the images on the index page to be image1 and then the second image to be image2, but it must be contained within the php file because I am unable to edit index.html. Is there anyway to do this? The method I have now where it reads a file to see if it's value is 1 or 2 doesn't seem to compute each time the image is generated. I have tried
header("Cache-Control: no-cache");
header("Pragma: no-cache");
in the image code to force it not to cache but to no avail. Can anyone solve this?

hey guys im sure this is possible im wondering how a user can execute a mysql query by a click of a button but without the page reloading...thanks guys

So, I just don't know where to post this question. I've written a quiz program where 50 English vocab words are pulled from a dB and displayed on one page with the order scrambled. My students then type the Spanish translation for each. When they submit the form the next page grades their work. They have to get a 90 or better for the grade to be automatically recorded, so I want them to click the back button and go back and make corrections. The problem is when they use a Chrome browser and click the back button the program re-sorts the order of questions. It leaves the order of their answers the same. So what they answered for number 1 is still in the field for number 1, but the questions (the English vocab word) is different. Chrome does this consistently so I thought this was a Chrome issue only. Then one of my students said the same thing happened to her when using Safari.

So here is my question, how can I stop Chrome (or any other browser) from re-running my server-side PHP scripts (re-sorting the vocab array) when clicking the back button?

 

Here is the code for students taking the quiz:

<form method="post" action="portal.php?load=vquiz_grade" style="margin-left: 50px; line-height: 30px;">
<table>
    <?
    $count = 1;
    $query = "SELECT * FROM inno_memorize WHERE uname = 'admiralq' AND subject = '$subject' AND title = '$title' ORDER BY subject, title";
    $result= mysql_query($query) or die("Could not perform query: ".mysql_error());
    while ($row = mysql_fetch_array($result)){
        $ans[$count]['def'] = $row['definition'];
        $ans[$count]['word'] = $row['vocab_word'];
        $count++;
    }

    $max = $count-1;
    shuffle($ans);
    
    $count = 0;
    while ($count < $max){
    
        // Search for () and eliminate along with contents
        $loc1 = strpos($ans[$count]['word'], "(");
        $loc2 = strpos($ans[$count]['word'], ")");
        
        
        if ($loc1 != "" AND $loc2 != ""){
                
            // string length
            $length = strlen($ans[$count]['word']);
            // from loc2 to end
            $lcount = $length - $loc2;
            
            // Dump location points and all text inbetween
            $ans[$count]['word'] = substr($ans[$count]['word'], 0, ($loc1-1)).substr($ans[$count]['word'], ($loc2+1));
                        
        }
        print "<tr><td>".($count+1).". <textarea id=\"kelp".$count."\" cols=25 rows=1 name=\"answer".$count."\" style=\"resize: none;\" autocomplete=\"off\"></textarea>&nbsp;</td>";
        
        print "<td>".$ans[$count]['def']."</td>";
        
        print "<td><input type=\"hidden\" name=\"correct".$count."\" value=\"".$ans[$count]['word']."\"></td>";

        ?>
        <td>
            <span style="margin: 0px 0px 20px 50px;">
            <button type="button" onclick="insertAtCursor('kelp<?print $count?>', '&aacute;');">&aacute;</button>
            <button type="button" onclick="insertAtCursor('kelp<?print $count?>', '&eacute;');">&eacute;</button>
            <button type="button" onclick="insertAtCursor('kelp<?print $count?>', '&iacute;');">&iacute;</button>
            <button type="button" onclick="insertAtCursor('kelp<?print $count?>', '&oacute;');">&oacute;</button>
            <button type="button" onclick="insertAtCursor('kelp<?print $count?>', '&uacute;');">&uacute;</button>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <button type="button" onclick="insertAtCursor('kelp<?print $count?>', '&ntilde;');">&ntilde;</button>
            <button type="button" onclick="insertAtCursor('kelp<?print $count?>', '&iquest;');">&iquest;</button>
            <button type="button" onclick="insertAtCursor('kelp<?print $count?>', '&iexcl;');">&iexcl;</button>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            </span>
        </td>
        </tr>
        <?

        //print "<br>";
        $count++;
    }

    ?>
</table>

    <input type="hidden" name="max" value="<?print $max?>">
    <input type="hidden" name="title" value="<?print $title?>">
    <input type="hidden" name="subject" value="<?print $subject?>">
    <input type="hidden" name="vlist" value="<?print $vlist?>">
    <input type="hidden" name="lname" value="<?print $secure_lname?>">
    <input type="hidden" name="fname" value="<?print $secure_fname?>">
    <input type="hidden" name="secure_uname" value="<?print $secure_uname?>">
    <input type="hidden" name="key_code" value="<?print $key_code?>">
    <input type="hidden" name="vocab_quiz" value="1">
    <input type="hidden" name="id" value="<?print $id?>">
    <input type="submit">    
</form>
 

And here is the code showing them what they missed.

<?
$count = 0;
$wcount = 0;
$rcount = 0;

//    Total grade
while ($count < $max){
    if (trim(strtolower(${'answer'.$count})) == trim(strtolower(${'correct'.$count}))){$rcount++;}
    else {$wcount++;}
    $count++;
}

print "You missed ".$wcount." words.<br>";
$grade = $rcount / ($rcount+$wcount)*100;
print "Your grade: ".round($grade)."<br>";

$count = 0;
$wrong = 0;

print "<table>";
print "<tr><td height=\"10\"></td></tr>";
while ($count < $max){
    
    $tcolor = "0a0a0a";

    // Grade response and set color
    if (trim(strtolower(${'answer'.$count})) == trim(strtolower(${'correct'.$count}))){$tcolor = "ff7777";}
    else {$tcolor = "000000"; $wrong = 1;}

    if ($wrong == 1){
        print "<tr>";
        print "<td>".($count+1).".&nbsp;</td>";
        print "<td><span style=\"color: #".$tcolor.";\">".${'answer'.$count}."</span></td>";
        print "<td><span style=\"color: #ff5555;\"> - ".${'correct'.$count}."</span></td>";
        print "</tr>";
        $wrong = 0;
    }
    
    $count++;
    
}
print "</table>";

if ($grade >= 90){

    $query = "SELECT * FROM inno_vocab_assignments WHERE key_code = '$key_code' AND uname = '$secure_uname' AND teacher = '$teacher'";
    $result= mysql_query($query) or die("Could not perform query: ".mysql_error());
    if (mysql_num_rows($result) == 0){

        //    Prevent student from changing vocab list so as to do an easier list
        $query = "SELECT * FROM inno_grading_period WHERE uname = '{$_SESSION['student']['teacher']}' AND voc_title = '$title' AND subject = '$subject'";
        $result= mysql_query($query) or die("Could not perform query: ".mysql_error());
        if (mysql_num_rows($result) > 0){

            //    Insert grade
            $query = "INSERT INTO inno_vocab_assignments (uname, course_title, list_title, type, stamp, grade, key_code, course_id, teacher, lname, fname) VALUES ('$secure_uname', '$subject', '$title', 'typing', '".date("U")."', '$grade', '$key_code', '$course_id', '$teacher', '$lname', '$fname')";
            $result= mysql_query($query) or die("Could not perform query: ".mysql_error());
        
            print "<br><b>RESULT: Congratulations! Your quiz was recorded.</b><br><br><br><br>";
        }
        else{
            print "<span style=\"color: #ff5555; font-weight: bold;\">This vocab list was not assigned! The teacher has been notified of this attempt!<br>The assignment has NOT been recorded!</span>";
        }

    }
    else {print "<br><b>THIS HAS ALREADY BEEN RECORDED!<br>You cannot submit the same assignment more than once.</b>";}
    
}
else{
    
    print "<br><b>RESULT: Your score was below a 90 and so was not recorded. Click back to make corrections.</b><br><br><br><br><br>";
    
}

?>
 

 

Thank you!

 

 

Hi everybody

I am a PHP rookie for now, and
I want to reload the same dynamic page - it's content in several languages - by clicking little flags which are located at some point on the page - AND ITS NOT WORKING.

Clicking on the flag triggers a PHP script which basically says

Code: [Select]

]$_SESSION['lang'] = <Some_language>;
require ('webpage.php');


where webpage.php is the dynamic page, in different languages, with it's content drawn out from a database (which contains the content in all languages I chose to display, blah, blah)
Funny thing - when I look at the page html (View Page Source) - it seems OK (identical from one page to the next) ! But WHAT is displayed after the first attempt to change the language is not.
Is something fundamentally wrong with my approach ?

Mike

Good day:

Is there a way to create a proxy or coding in php that it is constantly getting the data from a sql database and inserting it into a mysql database?

Any help will be appreciated.

Currently, I'm trying to write a contact form, and perhaps I'm overcomplicating it, but I have a public variable called $EquationAnswer that stores the answer to the Captcha method (randomised maths question) and whenever the page reloads, it creates a new instance of the Contact class, which then erases the value that has been stored in that variable.   What I'm trying to achieve is keeping the value stored even after a new instantiation of the class. I remember from a class at University that static was a way to do this, but this was in C#.

<?php

class Contact
{
	public $EquationAnswer;

	public function CaptchaCreation()
	{
		$SignArray = array('+', '&times;', '-');

		$NumberOne = rand(1, 9);
		$NumberTwo = rand(1, 4);

		if($NumberOne < $NumberTwo)
			$SignIndex = rand(0, 1);
		else
			$SignIndex = rand(0, 2);

		$Sign = $SignArray[$SignIndex];

		$EquationString = $NumberOne." ".$Sign." ".$NumberTwo;

		switch($Sign)
		{
			case "+":
				$Answer = $NumberOne + $NumberTwo;
				break;
			case "-":
				$Answer = $NumberOne - $NumberTwo;
				break;
			case "&times;":
				$Answer = $NumberOne * $NumberTwo;
				break;
		}

		$this->EquationAnswer = $Answer;

		return $EquationString;
	}

	public function EchoContactForm()
	{
		$CaptchaMessage = $this->CaptchaCreation();

		echo "<form method='POST' action=''>\n\n";
		echo "\t\t\t\t\t<table>\n\n";
		echo "\t\t\t\t\t\t<tr><td>Name: </td><td><input type='text' name='name' /></td></tr>\n";
		echo "\t\t\t\t\t\t<tr><td>Email: </td><td><input type='text' name='email' /></td></tr>\n";
		echo "\t\t\t\t\t\t<tr><td>Subject: </td><td><input type='text' name='subject' /></td></tr>\n";
		echo "\t\t\t\t\t\t<tr><td>Message: </td><td><textarea rows=5 name='message'></textarea></td></tr>\n";
		echo "\t\t\t\t\t\t<tr><td>What is: ".$CaptchaMessage."?</td><td><input type='text' name='captcha' /></td><td></td></tr>\n";
		echo "\t\t\t\t\t\t<tr><td colspan=2 style='text-align: right'><input type='submit' name='submit' value='Send' /></td></tr>\n\n";
		echo "\t\t\t\t\t</table>\n\n";
		echo "\t\t\t\t</form>\n";
	}

	public function ContactFormValidation($Name, $Email, $Subject, $Message, $CaptchaInput, $CaptchaAnswer)
	{
		echo $CaptchaAnswer;

		$ErrorsArray = array();

		if(strlen($Name) == 0)
			array_push($ErrorsArray, "You must provide a name.");
		if(strlen($Email) == 0)
			array_push($ErrorsArray, "You must provide an email.");
		if(strlen($Message) == 0)
			array_push($ErrorsArray, "You must provide a message.");
		if(strlen($CaptchaInput) == 0)
			array_push($ErrorsArray, "You must provide an answer to the maths question.");
		if($CaptchaInput != $CaptchaAnswer)
			array_push($ErrorsArray, "Incorrect captcha answer.");

		if(count($ErrorsArray) > 0)
		{
			echo "There are ".count($ErrorsArray)." Errors: <br />";

			foreach($ErrorsArray as $E)
				echo $E."<br />";
		}
		else
		{
			return true;
		}
	}
}

?>

^ That's the Contact class, and the main function that I want to focus on is the last one, "ContactFormValidation()".   From the contact form page (which is within a template), I want it to send the EquationAnswer variable to that function so that it can compare what the user has input.

<?php

//Instantiate the contact class
include './inc/PHP/classes/ContactClass.php';
$ContactClass = new Contact;

if(!isset($_POST['submit']))
{
	$ContactClass->EchoContactForm();
}
else
{
	$NameInput = $_POST['name'];
	$EmailInput = $_POST['email'];
	$SubjectInput = $_POST['subject'];
	$MessageInput = $_POST['message'];
	$CaptchaInput = $_POST['captcha'];
	$CaptchaAnswer = $ContactClass->EquationAnswer;

        //Tried echoing out what is in the variable but it produces nothing because the contact class is a new instance.
	//echo $CaptchaAnswer;

	if($ContactClass->ContactFormValidation($NameInput, $EmailInput, $SubjectInput, $MessageInput, $CaptchaInput, $CaptchaAnswer) == true)
	{
		//Mail function
	}
}

?>

Any help would be appreciated.   Cheers.

I am in the process of writing code for a dynamic form. I have the part of the form written for information to be entered. I am now trying to write code for the modification of the  information in the table.

I know that I want to get the table data my doing a MySql Select and putting that information into an array. I am not very familiar with arrays and have spent some time looking for a solution online with no solution. When I print_r the results I get what I want but when I do anything else I get Array. What I am actually looking to do is make it so that the table data is in another variable

this is the section of code that I am working with.
Code: [Select]
$mod_form = "<form name='insert_table' id='insert_table' action='ad_add.php' method='post' enctype='multipart/form-data'>
<fieldset>
<legend>table information</legend>
<input name='table' TYPE='hidden' VALUE='" . $table . "' />";

$mod_sql = "SELECT * FROM $table WHERE id = '$id'";
$mod_sql_result = mysql_query($mod_sql);

$allowed_ext = array('jpg', 'jpeg', 'png', 'gif');
$input_array = array();

while ($row = mysql_fetch_array($mod_sql_result, MYSQL_NUM)) {
    $input_array[] = $row;
}

foreach ($input_array as $input => $data) {
    print_r($data);
}

while ($i < mysql_num_fields($mod_sql_result)) {


    $header = str_replace("_", " ", (mysql_field_name($mod_sql_result, $i)));
    $name = mysql_field_name($mod_sql_result, $i);

    (mysql_field_name($mod_sql_result, $i) == 'image' ? $mod_form .= "<p>" . $header . ": <input name='" . $name . "' id='" . $name . "' type='file' /></p>" : $mod_form .= "<p>" . $header . ": <input name='" . $name . "' id='" . $name . "' type='text' value='" . $input . "'/></p>");

    $i++;
}
$mod_form .= "
<p>
<input type='submit' name='submit_mod' id='submit_mod' />
</p>
</fieldset>
</form>
";

echo $mod_form;

Has anyone done this before?

i have the following VERY basic looking calendar to display the current month and <strong> on the current date;

<?php
/* Set the default timezone */
date_default_timezone_set("Europe/London");

/* Set the date */
$date = strtotime(date("Y-m-d"));

$day = date('d', $date);
$month = date('m', $date);
$year = date('Y', $date);
$firstDay = mktime(0,0,0,$month, 1, $year);
$title = strftime('%B', $firstDay);
$dayOfWeek = date('D', $firstDay);
$daysInMonth = cal_days_in_month(0, $month, $year);
/* Get the name of the week days */
$timestamp = strtotime('next Sunday');
$weekDays = array();
for ($i = 0; $i < 7; $i++) {
  $weekDays[] = strftime('%a', $timestamp);
  $timestamp = strtotime('+1 day', $timestamp);
}
$blank = date('w', strtotime("{$year}-{$month}-01"));
?>
<table class='cal-table cal-table-bordered' border=1 style='table-layout: fixed;'>
  <tr>
    <th colspan='7' class='cal-text-center'> <?php echo $title ?> <?php echo $year ?> </th>
  </tr>
  <tr>
    <?php foreach($weekDays as $key => $weekDay) : ?>
      <td class='cal-text-center"'><?php echo $weekDay ?></td>
    <?php endforeach ?>
  </tr>
  <tr class='cal-row'>
    <?php for($i = 0; $i < $blank; $i++): ?>
      <td></td>
    <?php endfor; ?>
    <?php for($i = 1; $i <= $daysInMonth; $i++): ?>
      <?php if($day == $i): ?>
	  <?php //database code here ?>
        <td><strong><?php echo $i ?></strong></td>
      <?php else: ?>
        <td><?php echo $i ?></td>
      <?php endif; ?>
      <?php if(($i + $blank) % 7 == 0): ?>
        </tr><tr class='cal-row'>
      <?php endif; ?>
    <?php endfor; ?>
    <?php for($i = 0; ($i + $blank + $daysInMonth) % 7 != 0; $i++): ?>
      <td></td>
    <?php endfor; ?>
  </tr>
</table>

how can i get data into this calendar from my 'events' table, to perhaps highlight the date of the event and show a hidden <DIV> when rollover. i have columns: 'eventStart' and 'eventEnd' and 'eventName' in the 'events' table.

or shall i look for something else? this has to be super simple with no backend or multiple files being used etc..

 

thanks

Hi guys,

I have an array:

array 
(
[apple]=> red,
[orange] => orange,
[banana] => yellow
)

That I want to insert into the apidata table, the PDO connection is good so I guess my code is wrong:

    $mykeys = implode(', ', array_keys($newarr));
    
    $myplaceholders[] = '(' . implode (", ", array_fill(0, count($newarr), '?')) . ')';
    
    $values = array_values($newarr);

$res = $db->prepare("INSERT INTO apidata (item, value) VALUES $myplaceholders") ;

$res->execute([$mykeys, $values]); 

The apidata table has three fields id (auto_increment) item and value, where am I going wrong?

Thanks

How to sort data from table? Currently its sorted by ID. But I want to add option that admin can sort data (click on up/down link or whatever).

Its about forum script and all forums have categories. Forum and categories are in same table. Forum "parent" is ID of category. So i have following sorting:

Cat1        [ID1]  
->Forum1    [ID2] [PARENT1]
->Forum2    [ID3] [PARENT1]

Cat2       [ID4]
->Forum3   [ID5] [PARENT2]
->Forum4   [ID6] [PARENT2]


I need to add additional field "sort". On click admin can UPDATE sorting by increasing/decreasing number. But problem is categories and forum are in same table. If I want to move up FORUM1 (ID2) with (for example) "sort" number 2 I must decrease number (-1) and that forum will be with same sort number as category above.
Also if I want to move Category up/down it also must move all forums from that category (but that is not big problem).

What is best way to solve this?