Learn VBA & Macros in 1 Week!

PHP - Input Type Submit / Buttons With Specific Post Results

Full Excel VBA Course - Beginner to Expert

Input Type Submit / Buttons With Specific Post Results	View Content

I think I understand that there can only be one "submit" button on a page. I want buttons for separate forms to not trigger the empty errors on the other forms... How do you accomplish specific button actions? I think I've tried it with javascript but you can do it with PHP right? Thanks for any help.

Full Excel VBA Course - Beginner to Expert

Unique Submit Buttons Won't Post

Similar Tutorials

View Content

I can't figure out why my $_POST['join'] isn't working. Does my form need to be inside my foreach?

Code: [Select]
<?php

if(is_admin($user_info['uid'], $info['companyid']) === false)
{
if (isset($_POST['join']))
{
echo "works";
die();
}

$companies = fetch_company_by_name($info['cname']);

?>
<table class="feed pts pbl">
<?php

foreach ($companies as $company)
{
?>
<tr class="mbm">
<td>
<form method="post" id="ccreateform" class="man">
<input type="submit" name="join[<?php echo $company['companyid']; ?>]" value="Join" />
</form>
</td>
</tr>
<?php
}

?>
</table>
<?php
}

?>

Multipart Form Won't Post When Multiple Type=input Elements Are Defined

Similar Tutorials

View Content

Long time lurker, first time poster here. I am having a problem with a multiple file uploader form I am trying to build. I am using the CodeIgniter framework, but I believe my problem is with the form itself.

Here is the form:
Code: [Select]
<form action="http://localhost/show/submit" id="sendfiles" method="post" name="sendfiles" enctype="multipart/form-data">
<input type="hidden" name="doup" value="1" />
<input type="file" name="userfile1" value="" id="userfile1" size="20" /> <br />
<input type="file" name="userfile2" value="" id="userfile2" size="20" /> <br />
<input type="file" name="userfile3" value="" id="userfile3" size="20" /> <br />
<input type="submit" name="submit_btn" value="Upload" /> </form>

The form is being passed to this function:

if(empty($_POST['doup'])){
            foreach($_REQUEST as $k => $v)
                print ">>> $k : $v <br />";

            $data['form_open'] = form_open_multipart(uri_string(), array(
                'id' => 'sendfiles',
                'method' => 'post',
                'name' => 'sendfiles'
            ));
            $data['form_flag'] = form_hidden('doup', '1');
            $data['file1'] = form_input(array(
                'id' => 'userfile1',
                'name' => 'userfile1',
                'size' => '20',
                'type' => 'file',
            ));
            $data['file2'] = form_input(array(
                'id' => 'userfile2',
                'name' => 'userfile2',
                'size' => '20',
                'type' => 'file',
            ));
            $data['file3'] = form_input(array(
                'id' => 'userfile3',
                'name' => 'userfile3',
                'size' => '20',
                'type' => 'file',
            ));
            $data['form_submit'] = form_submit('submit_btn', 'Upload');
            $data['form_close'] = form_close();
            $this->load->view('show/submit', $data);
        } else {
            $config['allowed_types'] = 'mp3';
            $config['max_size']    = '10240';
            $config['upload_path'] = $this->config->item('file_upload_path');
            $uploaded_files = array();
            for($nona=1; $nona<4; $nona++){
                if (strlen($_FILES['userfile'.$nona]['tmp_name']) <=0){
                    echo  "tempname$nona failed";
                    continue;
                }


                //print "------ USERFILE $nona ------ <br />";
                //print sizeof($_FILES['userfile'.$nona])."<br />";
                //foreach ($_FILES['userfile'.$nona] as $k => $v){
                //    print "$k  :  $v <br />";
                //}

                $this->upload->initialize($config);
                $upload = $this->upload->do_upload('userfile'.$nona);
                if (!$upload){
                    $form_errors = array('form_errors' => $this->upload->display_errors());
                    $this->load->view('show/submit', $form_errors);
                    break;
                } else {
                    $data = array('upload_data' => $this->upload->data());
                    $data = $data['upload_data'];
                    $fp = $data['full_path'];
                    $filename = strtolower(random_string('numeric', 16) . $data['file_ext']);
                    $rel_path = 'show/submissons/uploaded/';
                    $path = $this->config->item('media_root_path') . $rel_path;

                    exec('mkdir -p ' . $path , $a1, $r1);
                    exec('mv ' . $fp . ' ' . $path .  $filename, $a2, $r2);

                    array_push($uploaded_files, $path .  $filename);
                }

            }
            $this->session->set_flashdata('img_data',implode("||", $uploaded_files));
           // redirect("show/submit_info");
        }

The problem is this:

When I choose only one file to upload, it works. I can choose any of the 3 inputs and it works great. But as soon as I try to choose 2 or more files, the form fails to post. When I press submit, the page simply reloads and none of the form variables get posted. I have checked settings in php.ini and tried building and rebuilding this form. I'm hoping someone here can provide some insight into what I'm doing wrong?

Help To Make A Specific Type Of Online Quiz

Similar Tutorials

View Content

So I'm trying to make an online quiz where the user can 'take the quiz' or go to 'module' where the user can edit the quiz. I've tried for days to search through the net for this particular one but I can't find any solutions.

For the quiz I made a comma delimited text file and tried to use that file to make a multidimensional array.
So far I only have the following:

<h2>ONLINE QUIZ</h2>

<ul>
   <li><a href='question.php'>Take quiz</a></li>
   <li><a href='module.php'>Admin Module</a></li>
</ul>

<?php

$file = fopen ("data.txt","r");

   $i=0;
   while (feof($file)==false)
      {
      $line = fgets($file);
      $array[$i]=$line;
      $i=$i + 1;
      }

fclose($file);

session_start();
$_SESSION["questions_array"]=$array;

?>

My question is, how do I turn the text file from something that looks like this:

HTML is...,Main markup language for web pages,Cross-site Security,Cleverly Structured Scripting,eXtremely Safe and Secure,
PHP...,General-purpose server-side scripting language,Cross-site Security,Processing Hypertext Products,Process HTML Prettily

To output something like this:

Question #1

HTML is...
[radio button] a.) Main markup language for web pages
[radio button] b.) Cross-site Security
etc, etc

ll----I will type out the exact plan for this quiz----ll

Main page: module and quiz link.

For the quiz

Question page: Questions only show up one by one.

ex.) What is a dog?
a.) a human
b.) a pet
c.) a job
d.) a car

(Submit button)

Answer page: Once submit is hit, the page goes here, where the user can see whether they answered right or wrong.

ex.) INCORRECT

Your answer: a.) a human
Correct answer: b.) a pet

(continue link)

Note that when 'continue' is hit, the page redirects back to the 'question page' but this time outputs the next question. When no more questions are available, the page automatically redirects to the 'results page'.

Results page: Table of results

For the module

Main: A table of the available questions plus their choice answers

ex.)

Question l choice a l choice b l
[] What? cat toy
[] How? rat pop

etc.

Each row can be selected through a radio button. (so we know which question to edit)

Select option: Drop down list whether to 'add', 'edit' or 'delete' a question. Each choice directs to a different page where you can perform the action. Also, if 'delete' is chosen, a confirmation page should show up. (i.e are you sure you want to delete this file?)

I think that's detailed enough, I'm so sorry for the trouble;;
but please if you don't have the time to help me throughout the whole thing, please help me figure out how to use the text file as a multi-dim array (aka the first thing I asked). I've been dying to know how to do it but I just can't get it to work so I'd really appreciate that!

Thank you!

Automatic Post Type In Title?

Similar Tutorials

View Content

Ok, so can someone edit this code:
Code: [Select]
<center>
<table height="300px" bgcolor="#FFFF00" cellspacing="1" width="75%">
<tbody>
<tr>
<td>
<table height="433" bgcolor="#000000" cellpadding="10px" cellspacing="1" width="995">
<tbody>
<tr>
<td bgcolor="#000000" valign="top" width="20%">

<div id="menu" align="right" >
<a href="/forums/index.php">HOME</a> |
<a href="mailto:xxxxxxx@trigamer.com">CONTACT</a> |
<a href="">ABOUT (soon)</a>
</div>

<?php
$fid = $_GET['fid'];
require "global.php";
if ($_POST)
{
if (! trim($message) ) {
// message is blank
}
$user = $_POST['user'];
$password = $_POST['password'];
$message = $_POST['message'];
$title = $_POST['title'];
$date = time();

$data = sprintf("INSERT INTO threads (tid, fid, title, user, dateline) VALUES (DEFAULT, $fid, '$title', '$user', $date)");
mysql_query($data);
$tid = mysql_insert_id();
$data = sprintf("INSERT INTO posts VALUES (DEFAULT, $tid, '$user', '$message', $date)");
mysql_query($data);
header( 'Location: replythread.php?tid='.$tid );
exit;
}
echo '
<font size=5><b>Add a New Post:</b></font>
<form action="" method="POST" name="formpost" onsubmit="return validate();">
<table>
<tr><td>Username:</td><td><input name="user" /></td></tr>
<tr><td>Password (optional):</td><td><input type="password" name="password"></td></tr>
<tr><td>Post Title:</td><td><input name="title" /></td></tr>
<tr><td valign="top">Message: </td><td><textarea rows="10" cols="50" name="message"></textarea></td></tr>
</table>
<input type="submit" value=" Add new post " />
</form>';
?>
</td></tr></tbody></table></td></tr></tbody></table><br />
</center>

<script>
function validate() {return true;

}
</script>
So that a tickable box can be beside "Post title" to the right of the text box that says, "Review," so that when a post is made, it will have "Review:" before the post title on the forum?

Here is what the code above shows you:

And this is what I want it to look like on the forums:

Thanks!

Displaying Specific Results Using Links

Similar Tutorials

View Content

Hi, fairly new to PHP over the last couple weeks. Been having a problem with certain queries. I have a database with football results, games, teams etc. I can filter these using drop down and that's all well and good. The problem I'm having is displaying the data via gameweek. I've been asked to display the table like so - Gameweek1 will display week1 teams, results etc. Gameweek2 will display week2... and so on. I can manage to do this in a drop down. But I've been asked to display this using links like "Previous, 1, 2, 3 Next". I've tried pagination but I couldn't figure it out. Can anyone point me in the right direction? If I need a GET() method, how would I go about coding that so it will be used in a link(s)? Been searching and searching to find an answer but to no avail...

//Database connection etc...

$gameweek = "SELECT * FROM games WHERE gameweek= 1";
    
    //if(isset($_GET['gameweek']))
    //{
    //    $gameweek = $_GET['gameweek'];
    //    
    //}
    //....
    $result=mysqli_query($connection, "select * from games WHERE gameweek= 1");
 //Print table and table headings...
    
    mysqli_close($connection);
?>
<a href="http://weeks.php?gameweek=2">Week 2</a>
<a href="http://weeks.phpgameweek=3">Week 3</a>

</body>
</html>

Displaying Two Different Imges Depending On Post Type

Similar Tutorials

View Content

I have a video feed from two different sources. One being You Tube. I am having trouble integrating both into my code. Each works fine alone. Here is my code.
Would like to display image based on feed source. either <?php print_video_thumb($post) ?> or <?php tern_wp_youtube_image(); ?>

<div class="paneleft"><?php print_video_thumb($post) ?><?php tern_wp_youtube_image(); ?></div>

Thanks For The Help!

Making The Script Echo Only Specific Results

Similar Tutorials

View Content

Hello community,

I am working on a database of specialties in the hospital I work.

The doctor's referral requests are sent to a mySQL database and I have, with the help of online guidance, produced a working php script that displays the information I need it to.

However, I need it a little bit more specific.

I intend to make multiple copies of this file for each specialty, so that when they open the file they only have the requests for that particular specialty.

My question is, with reference to my code below, can I make echo information so that online, for instance, if 'specialty1 = gastroenterology' (as in, that particular specialty that that referral request is for), then only the rows on the database that have that particular text are displayed only?

Hope that makes sense.

Code below for your reference and assistance is highly appreciated.

<!DOCTYPE html>
<html>
<head>
<title>Specialty Referral Form</title>
<style>
table {
border-collapse: collapse;
width: 100%;
color: #000000;
font-family: arial;
font-size: 10px;
text-align: center;
}
th {
background-color: #588c7e;
color: white;
}
tr:nth-child(even) {background-color: #f2f2f2}
</style>
</head>
<body>
<table>
<tr>
<th>Patient Details</th>
<th>Hospital Number</th>
<th>Date of Birth</th>
<th>Referred by:</th>
<th>New/Repeat Visit to Patient</th>
<th>Specialty</th>
<th>Admission Date</th>
<th>Too Ill for Clinic?</th>
<th>Diagnosis Aware?</th>
<th>Question</th>
<th>History</th>
<th>Medications</th>
<th>Examination</th>
<th>Results</th>
<th>WorkingDiagnosis</th>
<th>Investigation(s) Requested</th>
</tr>

<?php

$conn = mysqli_connect("localhost", "view", "", "referral");

// Check connection

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT patientdetails, hospitalnumber, DoB, referral, admission, specialty1, admissiondate, illness, awareness, question, history, medications, examination, results, workingdiagnosis, investigations FROM referralform";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row
while ($row = $result->fetch_assoc()) {
echo "<tr><td>" . $row["patientdetails"]. "</td><td>" . $row["hospitalnumber"] . "</td><td>" . $row["DoB"] . "</td><td>" 
. $row["referral"] . "</td><td>" . $row["admission"] . "</td><td>" . $row["specialty1"] . "</td><td>" . $row["admissiondate"] . "</td><td>"
. $row["illness"] . "</td><td>" . $row["awareness"] . "</td><td>" . $row["question"] . "</td><td>" . $row["history"] . "</td><td>"
 . $row["medications"] . "</td><td>" . $row["examination"] . "</td><td>" . $row["results"] . "</td><td>" . $row["workingdiagnosis"] . "</td><td>"
  . $row["investigations"]. "</td></tr>";
}
echo "</table>";
} else { echo "0 results"; }
$conn->close();
?>
</table>
</body>
</html>

I guess what I am looking for is something like echo specialty1 IF it writes a particular specialty and only that specialty.

Thank you.

Edited April 2, 2020 by samanj

Convert Search To Type Ahead And Submit...

Similar Tutorials

View Content

I'm converting a search feature that currently uses two successive dropdown fields to do the search. The search is initiated when the user selects the option from the dropdown. The resultant (it's always 1 record) is then displayed in detail with a + sign next to it so that the user can add the record he just searched for.

I've replaced it with a single dropdown and type-ahead field that uses javascript. The type ahead replaces the second drop down. I didn't want users have to select amongst hundreds of records in a drop down, by forcing them to start typing the second drop down, I can narrow the results to the exact item the user is looking for.

My problem is that I'm not sure how to get the type ahead result to initiate the search on the user select. I initiate it like this in the old version...

<table>
<tr>
<td width="130px" valign="top"><form name="nav"><select name="platform" id="platform" onChange="document.location.href=document.nav.platform.options[document.nav.platform.selectedIndex].value">
<option>Platform</option>
<?
$result = mysql_query("SELECT * FROM Platform");
while($row = mysql_fetch_array($result)) {
?>
<option value="?ptfm_ctrl=1&ptfm_id=<?=$row['id_platform']?>" <? if ($_GET['ptfm_id']==$row['id_platform']) { ?>selected="selected"<? } ?>><?=$row['platform']?></option>
<? } ?>
</select></form></td>
<?
if (isset($_GET["ptfm_ctrl"])) {
?>
                        <tr>
                  </table>

The new solution generates the type ahead result like this...

   <div>
      <form>
         <div>
            Start typing the name of the product, select the correct title when it appears:
            <br />
            <input type="text" size="30" value="" id="inputString" onkeyup="lookup(this.value);" onblur="fill();" />
         </div>

         <div class="suggestionsBox" id="suggestions" style="display: none;">
            <img src="upArrow.png" style="position: relative; top: -12px; left: 30px;" alt="upArrow" />
            <div class="suggestionList" id="autoSuggestionsList">
                
            </div>
         </div>
      </form>
   </div>

How can I initiate the search using the second method?

Add Redirect To Specific Url To Submit Button

Similar Tutorials

View Content

Here is code that i want to redirect after submitting to another url

<div class="js-ticket-form-btn-wrp">
<?php echo JSSTformfield::submitbutton('save', __('Submit Order', 'js-support-ticket'), array('class' => 'js-ticket-save-button')); ?>
<a href="<?php echo esc_url(jssupportticket::makeUrl(array('jstmod'=>'jssupportticket', 'jstlay'=>'controlpanel')));?>" class="js-ticket-cancel-button"><?php echo __('Cancel','js-support-ticket');?></a>
</div>

Help With Input Type Hidden

Similar Tutorials

View Content

Hi Guys,

Appreciate any help here please...

Basically I want to hide some inputs on my registration page and populate them will default values. Everything works okay, apart from the input below:

Code: [Select]
<input type="hidden" name="seek_location" value="Anywhere">
When I use the above, the MYSQL database field for seek_location is left empty...

I've noticed that the code below pulls the location into a dropdown list. You know the kind of thing, Australia, UK, USA etc etc:

Code: [Select]
$seek_location = $wcr[$seek_location];
Code: [Select]
<? $p=0;asort($wcr);reset($wcr);
while (list ($p, $val) = each ($wcr)) {
echo '<option value="'.$p.'">'.$val;
}
?>
So, all I want to do is have:

Code: [Select]
<input type="hidden" name="seek_location" value="Anywhere">
Populate seek_location with Anywhere

Any help appreciated
Thanks
Rob

Input Type Integer

Similar Tutorials

View Content

This is a cross between HTML, PHP, and MySQL. I'm not exactly sure which to blame (other than myself of course)

I'm collecting a bid price in a standard form

<input type="number" name="maxbid" value="<?php echo $maxbid ?>"/>

I have recalled the value from the database where I store it and display it in the field if it exists. If the field has never been entered, the field shows nothing. It's not required that a bid be entered. There are other fields of data that may be updated and this field is left blank.

On the page called by the submit button I'm retrieving the fields

$maxbid=$_POST[maxbid];

Then I store the fields in the database either with an INSERT or an UPDATE

if(mysql_num_rows(mysql_query("SELECT id FROM data WHERE id = '$id'")))
{
echo "Updating.....";
mysql_query("UPDATE data SET maxbid='$maxbid', name='$name' where id='$id'");
} else
{
echo "Inserting.....";
mysql_query("INSERT INTO data (id, maxbid,name)
VALUES ('$id','$maxbid',$'name')");
}

I know I'm not handling the Numeric values correctly, and I'm having a hard time finding the correct method for doing so. Right now, if the name is entered byt the maxbid is left blank, nothing gets inserted or updated. if I enter both the maxbid and the name it works. I can't have maxbid show up as a 0, I need it to be blank if nothing is entered.

Also when I check $maxbid, it's not an INTEGER (per INTVAL) when I check it, even though maxbid in the table is an INTEGER. When I pass it around, it seems to lose it's INTEGER value, but still shows as a number.

I know this sounds confusing, heck I'm confused. If someone could point me to a good tutorial, I'd figure it all out, but most tutorials don't get into the data type that much, and the combination of the form, passing the variables, reading the values from the database, etc. is what's causing me grief.

Any guidance would be appreciated.

Pull Post From A Specific Wordpress Category

Similar Tutorials

View Content

Hi, im looking to pull 3 posts from a specific Wordpress Category. At the minute I can pull 3 latest posts and display them in a flash banner using the code below.

Code: [Select]
SELECT yah_posts.*, yah_postmeta.*
FROM yah_posts
LEFT JOIN yah_postmeta ON yah_posts.ID = yah_postmeta.post_id
WHERE yah_postmeta.meta_key = 'largeimage' && yah_posts.post_status = 'publish'
ORDER BY post_date DESC LIMIT 3
I want to be able to pull 3 latest posts from a specific category instead of just 3 latest posts from every category.

I have put together this code below, but it doesn't seem to be working

Code: [Select]
$query = "SELECT yah_posts.*, yah_postmeta.*
FROM yah_posts
LEFT JOIN yah_postmeta ON yah_posts.ID = yah_postmeta.post_id
AND LEFT JOIN $yah_term_taxonomy ON($yah_term_relationships.term_taxonomy_id = $yah_term_taxonomy.term_taxonomy_id)
WHERE yah_postmeta.meta_key = 'largeimage' && yah_posts.post_status = 'publish'
AND $yah_term_taxonomy.term_id = '1'
AND $yah_term_taxonomy.taxonomy = 'category'
ORDER BY post_date DESC LIMIT 3";

Help With Submit Buttons

Similar Tutorials

View Content

I was wondering if you can have a form that has different actions depending on what submit button is pressed. I have two button and with one I was to use

<form action="<?php echo ( $_SERVER['PHP_SELF'] ); ?>" method="post">

and with the other I want to use

<form action="preview.php" method="post">

I was to do this because I want to user to be able to preview their content before submitting. I want the preview page to use the post variables as the value of the input fields so the user doesn't have to input their data again. However because the form doesn't redirect the user to the preview page I have to save all the post variables as session variables.

Not Getting <input Type=hidden> Value Thru $_get

Similar Tutorials

View Content

i have the following code:
<li>Have you read the <?php echo link_to('FAQ','util/faq') ?> ?
<select id="yesnolist" onChange="getChoice(this.value)">
<option value="yes" selected="selected">Yes</option>
<option value="no">No</option>
</select>
</li>
<input type="hidden" name="text" size=30 id="yesandno">
<?php
if ($_GET['yesandno'] == "no")
{
echo "anything!!!!!!!!!!!!!!!!!!!";
}
?>

then my java script for getCoice():
function getChoice(val)
{
yesNo = new Array("Yes", "No");
var getsel = document.contactus.yesnolist.value;
var e = document.getElementById("yesnolist");
var strUser = e.options[e.selectedIndex].value;

document.contactus.yesandno.value = strUser;
alert(document.contactus.yesandno.value);
return strUser;
}

my alert will gove yes or no depending on what i chose in the dropdown
but HOWCOME it does not go into the if ($_GET['yesandno'] == "no") ????

please help???

Remove Recently Type From Input

Similar Tutorials

View Content

How can I make it so that the things that the user recently typed in an input is not displayed as a drop down. I want nothing to be displayed.

Need Help With Shortcodes That Take A Specific Url Or Input

Similar Tutorials

View Content

New to PHP, I wrote a shortcode to use in WP that outputs a nav bar with some icons. One will link to a url, one to a pop up plugin (through a class), and one a phone number. The shortcode will then look like this [footer-btn url="link here "]Name of Icon Here[/footer-btn] Right now when I put the short codes into word press, I get duplicates of the URL ones.

function footer_btn_function($atts, $content){

  extract( shortcode_atts(

    array(
		
	'class' => '',
		
	'phone' => '',
		
	'url' => ''

    ), $atts )

  );
	
	if($class){
		'<a class="text-link" href='.$class.'><img class="popmake-73310 footer-btn mobile" src="'.get_template_directory_uri().'/images/faq-mobile-white.png">'.$content.'</a>';
	}
	
	if($phone){
		
		$output .= '<a class="text-link" href="tel:'.$phone.'" target="_blank"><img class="footer-btn mobile" src="'.get_template_directory_uri().'/images/phone-mobile-white.png">'.$content.'</a>';
		
	};
		
	if($url){
		
		$output .= '<a class="text-link" href="tel:'.$url.'" target="_blank"><img class="footer-btn mobile" src="'.get_template_directory_uri().'/images/vacation-rentals-mobile-white.png">'.$content.'</a>';
	};
	
	if($url){
		
		$output .= '<a class="text-link" href="tel:'.$url.'" target="_blank"><img class="footer-btn mobile" src="'.get_template_directory_uri().'/images/chat-mobile-white.png">'.$content.'</a>';
	};

  return $output;

      
}

Inserting Specific Mysql Records Into A Php Post Form

Similar Tutorials

View Content

I want to pull some records plus unique key from one mysql table and then use them as questions in a form/questionnaire.

The post form will have six radio buttons to the right of the fields pulled with the key posted but hidden and will wirte to another table.

I guess this is a templating question- as I've successfully retrieved the table 1 records via a query - I just can't seem to use them in the form. Below is the code I'm using to view table "PCM1"

<?php // query.php
require_once 'login.php';
$db_server = mysql_connect($db_hostname, $db_username, $db_password);

if (!$db_server) die("Unable to connect to MySQL: " . mysql_error());

mysql_select_db($db_database)
or die("Unable to select database: " . mysql_error());

$query = "SELECT * FROM pcm1";
$result = mysql_query($query);

if (!$result) die ("Database access failed: " . mysql_error());

$rows = mysql_num_rows($result);

for ($j = 0 ; $j < $rows ; ++$j)
{
echo 'RID: ' . mysql_result($result,$j,'mcde') ;
echo 'Statement: ' . mysql_result($result,$j,'oppclub') . '<br />';

;
}

Invalid Input Syntax For Type Timestamp

Similar Tutorials

View Content

This function is throwing the following error:

invalid input syntax for type timestamp "1301297896"

Code: [Select]
function removeInactiveUsers(){
if(!TRACK_VISITORS) return;
$timeout = time()-USER_TIMEOUT*60;

$result = pg_query_params($this->connection, "delete from active_users where timestamp < $1", array($timeout));
$this->calcNumActiveUsers();
}
I know the problem is with $timeout using a php timestamp vs postgresql timestamp but I'm not sure how to fix that

If An Input Has Specific Characters, Strip Them.

Similar Tutorials

View Content

Hiya peeps,

I am using preg_match to validate URLS;

preg_match("/(((https?|ftp|gopher):\/\/|(mailto|file|news):)[^' <>\"]+|(www|web|w3).[-a-z0-9.]+)[^' .,;<>\":]/i", $this->_searchString)

I works great, the only issue I have is I am using it in an if statment, and what I need to do is something like this.

if(preg_match("/(((https?|ftp|gopher):\/\/|(mailto|file|news):)[^' <>\"]+|(www|web|w3).[-a-z0-9.]+)[^' .,;<>\":]/i", $this->_searchString)) {
CHECK IF $this->_searchString has http:// at the start of it or if it has a / at the end and remove them if it does. I need $this->_searchString to end up with only www.SITE.co.uk before I can input it into the relevant function.
} else {

}

Many thanks,

James.

Using Submit Buttons To Increment Through Content

Similar Tutorials

View Content

I'm new to PHP and attempting to set up my first interactive site that is a basic survey for little kids to take. There's a picture shown to them and two submit buttons below the pic, one reads YES and the other NO to register whether they've participated in the activity before or not. Since the only thing that changes on the page after the selection is made is the photo for the next question/activity, I'd like to be able to use the two buttons to both send their choice to a database (Yes=1 and No=2) and also increment a counter so I can update the picture on the page as they progress through the survey.

All the information I've searched/read so far on submit buttons and multiple page surveys doesn't use the actual button itself as data but it's used to submit information gathered elsewhere on the page to another php page for processing via the Action attribute, so I'm wondering if what I want can be done. I'm leaving the Action attribute blank for each button as I want to stay on the same page and attempting to use an incremental counter to update the picture on the page in order to "step" through the survey each time one of the two buttons is clicked, but not having any luck and would appreciate suggestions or points in the right direction on the best way to do this. Apologies in advance if this seems like a basic question, and thanks for any suggestions you can offer.