PHP - Mailform With Count++ Function For Products Help Needed

I have no idea why but no matter what the eventid is, the label always returns 20 and I"m not sure why. Is my synatx wrong?


$eventid = (int)$_GET['eventid'];
$result = mysqli_query($dbc, "SELECT count(label) FROM `events` WHERE `event_id` = '$eventid'");
$label = $result + 1;
echo $label;

I am looking to edit my php code to make my own webpages display my thank you message when people submit a form from my website.

I have attached the code of my current form, however these only produce basic text screens and i would like them to be redirected to a premade webpage so it doesnt look so tackey. I am new to php but am desperatly trying to grasp the basics.

I am trying to also send a copy of the submited form back to the sender via email, but again do not know where in this code it goes.

Any Help would be much appreciated.

Thanks

the sript tells me he send it, without i fill in anything. and i dont get any mail
testversion : remcogaasenbeek.nl/nieuw
index.html

<form name="form1" method="post" action="verzenden.php">
  <table width="400" border="0">
    <tr>
      <td colspan="2">
       
        </b></td>
    </tr>
    <tr>
      <td width="30%"><font face="Arial" size="2"><font color="#f19028">*</font> Naam</font></td>
      <td width="70%">
        <input type="text" name="naam" size="20">
      </td>
    </tr>
    <tr>
      <td width="30%"><font face="Arial" size="2"><font color="#f19028">*</font> Email</font></td>
      <td width="70%">
        <input type="text" name="email" size="20">
      </td>
    </tr>
     <tr>
      <td width="30%"><font face="Arial" size="2"><font color="#f19028">*</font> Telefoonnummer</font></td>
      <td width="70%">
        <input type="text" name="telefoonnummer" size="20">
      </td>
    </tr>
 <tr>
      <td width="30%"><font face="Arial" size="2"><font color="#f19028">*</font> Woonplaats</font></td>
      <td width="70%">
        <input type="text" name="woonplaats" size="20">
      </td>
    </tr>
    </tr>
    <tr>
      <td colspan="2">
        <font face="Arial" size="2"><br>
        <input type="submit" name="submit" value="Verstuur">
        </font>
        </td>
    </tr>
  </table>
</form>
<font color="#f19028">*</font> <font size="1"> De proefles is gratis indien men besluit om een rijopleiding <BR>bij rijschool Remco Gaaseneek te nemen. anders blijft het een vrijblijvende les van €25,-.</font>

<?php
if (!isset($_POST['naam']) || !isset($_POST['email']) || !isset($_POST['telefoonnummer'])) {
    echo 'U heeft niet alle velden ingevuld!';
    exit;
}
 
$naam = htmlspecialchars($_POST['naam']);
$email = htmlspecialchars($_POST['email']);
$telefoonnummer = htmlspecialchars($_POST['telefoonnummer']);
$woonplaats= htmlspecialchars($_POST['woonplaats']);
 
$tijd = time();
$datum = strftime('%d/%m/%y %H:%M', $tijd);
$ip = getenv('REMOTE_ADDR');
$message = $naam.' met het e-mailadres '.$email.' en het IP '.$ip.' stuurde op '.$datum.' het volgende nummer en woonplaats:
____________________________________
'.$telefoonnummer.' 
'.$woonplaats.'
------------------------------------';
 
mail('timiejboi@gmail.com', 'proefles', $message, 'From: '.$email);                                 
echo 'Uw bericht is verzonden. U krijgt zo snel mogelijk antwoord.';
?>

i hope u guys can help me out.   cheers, timmiejboi  

How can I modify the following code to not display $hash_row['total'], but to display the sum of the counted "total" value + 1?  Is there a way that I can assign that variable in the "select query" area (for instance, "COUNT(hr.hasher_id) + 1 as total1"), and then call $hash_row['total1] in the result table?

I'm not sure if the syntax exists to add an integer value to a COUNT value and assign to a new variable...

Code: [Select]
<?php 
include "modules/dbase_connection.php";

#create MySQL connection
$sql_connection = sql_connect("blah","blah","blah","blah");

# select the Hashers and  hashes by total number<br />
$hash_query = "
SELECT
ha.*,
COUNT(hr.hasher_id) as total
FROM
hashers as ha,
hash_records as hr
WHERE
hr.hasher_id = ha.hasher_id
GROUP BY
         hr.hasher_id
ORDER BY
total DESC
";

$hash_result = mysql_query($hash_query) or die(mysql_error());

$x = 1;


while($hash_row = mysql_fetch_array($hash_result))
{
#display the table header
if($x == 1) {
echo '
<br />
<table align="left">
<br />
<tbody>
<tr><br /><td colspan="2"><strong>Potential On-Sec</strong></td><br /></tr>';

         $x++;
}

echo '<tr><br /><td>' . $hash_row['hasher_name'] . '</td><br /><td>' . $hash_row['total'] . '</td><br /><td>- ' . $hash_row['real_name'] . '</td><br /></tr>';
}
echo '</tbody></table></td><br />';

?>

Code: [Select]
function width2($noid)
{
$getwidth =  mysql_query("SELECT * FROM block WHERE sid='$theid'",$this->connect);

while($row1 = mysql_fetch_assoc($getwidth)) {

$this->width2($noid);


}

}

how do i count how many times the function loops?

I am writing a function to count the words that have been typed into a text box. I originally had it working when I first wrote it but it was counting all of the punctuation as a word so I I tried adding some code to eliminate that. Now it is not working. Could someone help me?

Here is my code
Code: [Select]
function count_words($description){
$word_count = 0;
$description = trim(preg_replace("/\s+/"," ",$description));
$word_array = explode(" ", $description);

for($i=0; $i < count($word_array); $i++){
if (preg_match("[0-9A-Za-z]", $word_array[$i])) {
$word_count++;
}
return $word_count;
}
  }

Write a function Counter() that keeps track of the number of times it is called. This function should not take any parameters and return the number of times that it has been called.

I know there has to be a better way to count how many entries I have in my mysql db than what I'm currently using. Let me just show you what I'm trying to do and it will make better sense.

http://batads.com/display.php

You see how I am echoing the number of each category on one page?

I am sure the current script I am using is insanely inefficient and as my DB grows I think it will cause me problems. Any suggestions on how to do this more efficiently?

Below is what is currently running that page.

Thank you.

Code: [Select]

<td><h4>Public Ads</h4><br>
<?php echo '<a href="browse1.php?cat=1">Bill Boards<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='1'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }?>
<?php echo '<a href="browse1.php?cat=2">Transportation<a/>';
 $query = "SELECT category, COUNT(*) FROM postlisting WHERE category='2'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }?>
<?php echo '<a href="browse1.php?cat=4">Shopping Centers<a/>';
 $query = "SELECT category, COUNT(*) FROM postlisting WHERE category='4'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=3">Posters / Signs<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='3'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }?>
        <?php echo '<a href="browse1.php?cat=5">Bus Stops<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='5'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }?>
<?php echo '<a href="browse1.php?cat=6"> Other-Public<a/>';
 $query = "SELECT category, COUNT(*) FROM postlisting WHERE category='6'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?></td>
<td><h4>Event Sponsorship</h4><br>
<?php echo '<a href="browse1.php?cat=7">Concerts<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='7'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=8">Fairs<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='8'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?>
<?php echo '<a href="browse1.php?cat=10">Sports<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='10'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } 
 ?>
<?php echo '<a href="browse1.php?cat=9">Trade Shows<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='9'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?>
<?php echo '<a href="browse1.php?cat=11">Other-Event<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='11'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?></td>

<td><h4>Online Ads</h4><br>
<?php echo '<a href="browse1.php?cat=12">Banner Space<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='12' ";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=13">Social Media<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='13' ";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=14">Email Lists<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='14'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=15">Blog Articles<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='15'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=16">Ezine Articles<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='16'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1area.php?cat=17">Other-Online<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='17'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?></td>
</tr>
<tr>
<td><h4>Print Ads</h4><br>
<?php echo '<a href="browse1.php?cat=18">Magazine<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='18'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=19">Newspaper<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='19'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=20">Brochure<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='20'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
 
        <?php echo '<a href="browse1.php?cat=21">Press Release Print<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='21'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=22">Other-Print<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='22'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?></td>
<td><h4>Broadcasting Ads</h4><br>
<?php echo '<a href="browse1.php?cat=23">TV / Commercial<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='23'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=24">Radio<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='24'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
        <?php echo '<a href="browse1.php?cat=27">Movies<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='27'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
        <?php echo '<a href="browse1.php?cat=25">Mobile Phone<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='25'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=28">Cinema<a/>'; 
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='28'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }?>
        <?php echo '<a href="browse1.php?cat=26">Press Release TV<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='26'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=29">Other-Broadcast<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='29' ";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?></td>
       
<td><h4>Commercial Space</h4><br>
<?php echo '<a href="browse1.php?cat=33">Private Property<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='33'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=34">Vehicle Wrap<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='34'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
        <?php echo '<a href="browse1.php?cat=35">Front Yard<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='35'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
        <?php echo '<a href="browse1.php?cat=36">Self Promotion<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='36'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=37">Other-Commercial<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='37'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?></td>
</tr>
<tr>
<td><h4>Business Ads</h4><br>
<?php echo '<a href="browse1.php?cat=30">Window Display<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='30'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=31">Interior Ads<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='31'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=32">Point of Sale Ads<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='32'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?>
<?php echo '<a href="browse1.php?cat=41">Other-Business <a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='41'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; } ?></td>
</td>

<td><h4>Misc</h4><br>
<?php echo '<a href="browse1.php?cat=38">Creative Advertising<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='38'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?>
        <?php echo '<a href="browse1.php?cat=39">Video Games<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='39'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?>
<?php echo '<a href="browse1.php?cat=40">Other-Misc<a/>';
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='40'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {echo '('.$row[COUNT(category)].')<br>' ; }  ?>
</td>


</tr>
</table>

Hi,
This is currently my code that generates a mail to me with all info the user provided in the form on the site.
+ it sends a auto reply to the user with details in it.
I'd like to keep both emails stored in a log file for future use.
Is this possible ? is it hard to add ? I've got no clue
Anyone could help ?


Code: [Select]
<?php ob_start();

include_once('verbinding.php');

$result1 = mysql_fetch_array (mysql_query("SELECT COUNT(*) FROM `Clicks` WHERE Aan = '0'")); // controleren hoeveel rijen er zijn met "Aan" op 0
$lijst1 = $result1[0];
if($lijst1=='0') { // als de lijst leeg is wil dit zeggen dat ze allemaal op 1 staan en mogen ze gereset worden.
mysql_query("UPDATE `Clicks` SET `Aan`= '0' WHERE `Aan`='1'");
} // indien er ook maar 1 veld op 0 staat zal er direkt naar hier worden gesprongen

$result = mysql_fetch_array(mysql_query("SELECT ID,Email FROM `Clicks` WHERE Aan = '0' ORDER BY RAND() LIMIT 1"));
$naarwie = $result['Email'];
$ID = $result['ID'];
echo $ID;
echo $naarwie;

mysql_query("UPDATE `Clicks` SET `Aan`= '1' WHERE ID = '$ID'");



mysql_close($verbinding);          // Sluit de verbinding.
                                //   We hebben hem nu niet meer nodig. 


$fromemail="No-Reply <ikwerkthuis.be>"; // change here if you want
$toemail=$naarwie;   // change here if you want
$sub="Online info aanvraag";          // change here if you want
$success_page_name="bedankt.html";
////// do not change in following
if($_SERVER['REQUEST_METHOD']=="POST")
{
$fieldnm_1=str_replace ( array("\n"), array("<br>"),trim($_REQUEST['fieldnm_1']));  
$fieldnm_2=str_replace ( array("\n"), array("<br>"),trim($_REQUEST['fieldnm_2']));  
$fieldnm_3=str_replace ( array("\n"), array("<br>"),trim($_REQUEST['fieldnm_3']));  
$fieldnm_4=str_replace ( array("\n"), array("<br>"),trim($_REQUEST['fieldnm_4']));  
$fieldnm_5=str_replace ( array("\n"), array("<br>"),trim($_REQUEST['fieldnm_5']));  
$fieldnm_6=str_replace ( array("\n"), array("<br>"),trim($_REQUEST['fieldnm_6']));  


$contentmsg=stripslashes("<br><b><font style=color:#CC3300>$sub</font></b><br>
<table width=708 border=0 cellpadding=2 cellspacing=1 bgcolor=#CCCCCC>

<tr>
      <td width=165 align=right valign=top bgcolor=#FFFFFF><B>Voornaam *:</b> </td>
      <td width=565 align=left valign=top bgcolor=#FFFFFF>$fieldnm_1</td>
</tr>

<tr>
      <td width=165 align=right valign=top bgcolor=#FFFFFF><B>Achternaam *:</b> </td>
      <td width=565 align=left valign=top bgcolor=#FFFFFF>$fieldnm_2</td>
</tr>

<tr>
      <td width=165 align=right valign=top bgcolor=#FFFFFF><B>E-mail *:</b> </td>
      <td width=565 align=left valign=top bgcolor=#FFFFFF>$fieldnm_3</td>
</tr>

<tr>
      <td width=165 align=right valign=top bgcolor=#FFFFFF><B>Telefoon *:</b> </td>
      <td width=565 align=left valign=top bgcolor=#FFFFFF>$fieldnm_4</td>
</tr>

<tr>
      <td width=165 align=right valign=top bgcolor=#FFFFFF><B>Werkstatus *:</b> </td>
      <td width=565 align=left valign=top bgcolor=#FFFFFF>$fieldnm_5</td>
</tr>

<tr>
      <td width=165 align=right valign=top bgcolor=#FFFFFF><B>Leeftijd *:</b> </td>
      <td width=565 align=left valign=top bgcolor=#FFFFFF>$fieldnm_6</td>
</tr>

</table>
");

////
$headers  = "MIME-Version: 1.0
";
$headers .= "Content-type: text/html; charset=iso-8859-1
";

$from=$fromemail;

$headers .= "From: ".$from." 
";

@mail($toemail,$sub,$contentmsg,$headers);


        $IP = $_SERVER['REMOTE_ADDR'];
        $DATE = date("Y-m-d");
        $TIME = date("H:i:s");
$NameOfSender = $fieldnm_1;
$SurnameOfSender = $fieldnm_2;
//$emailadd = $naarwie;
$headers2  = "MIME-Version: 1.0
";
$headers2 .= "Content-type: text/html; charset=iso-8859-1
";

$from=$naarwie;

$headers2 .= "From: ".$from." 
";


$email = $fieldnm_3; // use their addy instead of yours
$subject = 'ikwerkthuis.be inloggegevens introductie film'; // change subject
$text = 'Beste  '. $NameOfSender .' '. $SurnameOfSender .',<br>
<br>
Welkom bij <A HREF="ikwerkthuis.be" TABINDEX="4">ikwerkthuis.be</A>.<br>
Hieronder vind U de logingevens voor het bekijken van de introductiefilm:<br>
<br>
Adres:            <A HREF="http://ikwerkthuis.be/index.php/introductie" TABINDEX="4">http://ikwerkthuis.be/index.php/introductie</A><br>
Gebruikersnaam:   introductie<br>
Paswoord:         film2012<br>
<br>
'. $contentmsg .'<br>
<br>
Wij nemen spoedig contact met u op.<br>
<br>
Met vriendelijke groeten,<br>
Het ikwerkthuis.be team<br>
<br>
IP: '. $IP .'<br>
Date: '. $DATE .'<br>
Time: '. $TIME .''; // change text

mail($email, $subject, $text,$headers2); // send another one out

header("Location:$success_page_name");

}
?>

This topic has been moved to Third Party PHP Scripts.

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

hello.

im trying to write a function that sets the file path depending on what it pulls from the database

i have 2 databases

1 called "templates" which has a list of template names with there id's
and
1 called "basicSetting" which sets the active and default templates.


in the template db i have
id      name         type
id1    = template1    admin
id2    = template1    main
id3    = template1    main


in basic settings i have set

activeAdminTemp_id = 1
defaultAdminTemp_id = 1
activeTemp_id = 2
defaultTemp_id = 2



the path should be something like this
Code: [Select]
include(SITE_ROOT.DS.'GET TYPE/templates/GET TEMPLATE FOLDER NAME'.DS.GET TEMPLATE NAME.php);


SITE_ROOT = www.sitename.com/

GET TYPE    = /admin or in the main root

/templates/ = where the templates are stored

GET TEMPLATE FOLDER NAME = the name of the template is the same as the folder name

GET TEMPLATE NAME.php; = the name of the template.php





this is what i have in my functions file
Code: [Select]

function include_templates(){

$tempBS = basicSettings::find_all();

       //SHOULD GET THESE VALUES
$tempBS->id."<br />";
$tempBS->activeAdminTemp_id."<br />";
$tempBS->defaultAdminTemp_id.'<br/>';
$tempBS->activeTemp_id.'<br/>';
$tempBS->defaultTemp_id.'<br/>';



$temp = Templates::find_all();

        //SHOULD GET THESE VALUES
$temp->id."<br />";
$temp->name."<br />";
$temp->type.'<br/>';

}

now i need to add into my function something like this ... but im not sure.

Code: [Select]
$sql = "SELECT * FROM templates WHERE id='".$tempBS->id."'";

echo include(SITE_ROOT.DS.'.$temp->type./templates/'.$temp->name.''.DS.'temp->name.''.php');


but that i not working.

please help

thanks
rick

Hi there.

I have a PHP Function like so:

 <?php function JomSocial_field($fieldcode) {
 $database=& JFactory::getDBO();
  $user =& JFactory::getUser();
  $userId = $user->get( 'id' );
  $sql = "SELECT (id) FROM #__community_fields WHERE fieldcode= '$fieldcode'";
  $database->setQuery( $sql );
  $fieldID = $database->loadResult();
  $sql = "SELECT (value) FROM #__community_fields_values WHERE field_id= {$fieldID} && user_id= {$userId}";
  $database->setQuery( $sql );
  echo $database->loadResult();
}

?>

I can then insert the results into form inputs like so:  Code: [Select]
<input type="hidden" id="enrolment_year" name="enrolment_year" value="<?php JomSocial_field("enrolment_year"); ?>" />
However, I now want to use the result in a variable like so

 <?php $filename1 = "folder/".print(JomSocial_field("enrolment_year"))."/file.zip";

but it doesn't work...it just actually prints the result as text on the page. The echo command doesn't work either.  If it were an item that has been posted, I could get it using the $_POST["enrolment_year"], but the trouble is, I want to get the value on first page load, not after a post.

Can anyone help me please?

I have 3 actions below which control my cart. My problem is with the minus action. It's supposed to remove 1 quantity from the cart but instead it takes the quantity all the way down to 1.

for example: you add 3 quantities of a usb stick and you want to remove 1 quantity, it would take the amount of quantity to 1 instead of 2.

here are the functions:

switch ($action) {
   case 'add':
      if ($cart) {
         $cart .= ','.$_GET['id'];
         header("Location: cart.php");
      } else {
         $cart = $_GET['id'];
         header("Location: cart.php");
      }
   break;
   case 'minus':
      if ($cart) {
         $items = explode(',',$cart);
         $newcart = '';
         foreach ($items as $item) {
            if ($_GET['id'] != $item) {
               if ($newcart != '') {
                  $newcart .= ','.$item;
               } else {
                  $newcart = $item;
               }
            }
         }
         $cart = $item - $id;
      }
   break;
   case 'update':
      if ($cart) {
         $newcart = '';
         foreach ($_POST as $key=>$value) {
            if (stristr($key,'qty')) {
               $id = str_replace('qty','',$key);
               $items = ($newcart != '') ? explode(',',$newcart) : explode(',',$cart);
               $newcart = '';
               foreach ($items as $item) {
                  if ($id != $item) {
                     if ($newcart != '') {
                        $newcart .= ','.$item;
                     } else {
                        $newcart = $item;
                     }
                  }
               }
               for ($i=1;$i<=$value;$i++) {
                  if ($newcart != '') {
                     $newcart .= ','.$id;
                  } else {
                     $newcart = $id;
                  }
               }
            }
         }
      }
      $cart = $newcart;
   break;
}

can some help with the minus function. thanks

Hi,

Since upgrading to php 5.3 i have a line of code on  my site that is giving me a depreciated error. The line of code is as follows:

$data=eregi_replace(">"."[[:space:]]+"."<","><",$data);

I've got as far as knowing i need to change it from eregi_replace to preg_replace but i can't for the life of me work out where to put any backslashes etc, if any. Is there a formula for working this type of thing out? Every example i see has backslashes and $1's all over the place. Do i simply do this "/ and this /" after and before every double quote? Or is it not as simple as that? Things never are are they!

Please could an expert on here offer me any assistance. This is an important line of code(i think) so i didn't want to experiment as i would normally do, i need to get this right first time as i don't know what will happen if i get this wrong.

Cheers.