PHP - I'm Seriously A Php Noob...3 Problems. Long Read. Makes No Sense. Php Driving Me Nuts.

Hi everyone,

I'm trying to select either a class or an id using PHP Simple HTML DOM Parser with absolutely no luck.  My example is very simple and seems to comply to the examples given in the manual(http://simplehtmldom.sourceforge.net/manual.htm) but it just wont work, it's driving me up the wall.

Here is my example: http://schulnetz.nibis.de/db/schulen/schule.php?schulnr=94468&lschb=

I think the HTML is invalid: i cannot parse it.

Well i need more examples - probly i have overseen something!

If anybody has a working example of Simple-html-dom-parser...i would be happy.
The examples on the developersite are not very helpful.

your dilbertone

I am testing some new code, trying to learn me some OOP.  I know the SQL works because I tested it in phpmyadmin.  There is something wrong and I cannot fathom why, 

 

<?
	$site= '15';
	
	Class Dbh {
		private $user='xxx';
		private $pass='xxx';
		private $db='xxx';
		private $host='localhost';
		private $charset = 'utf8mb4';
	
		protected function connect() {
			$dsn = 'mysql:host='.$this->host.'; dbname='.$this->db.';charset='.$this->charset;
			$pdo = new PDO($dsn, $this->user, $this->pass);
			$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
			$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
			$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
			return $pdo;

			

		}
		
	}
	

	Class GetData extends Dbh {
	
			
		public function gettable($site) {
			$sql = "SELECT table_cats.tablec_name, tables.table_question, tables.table_answer FROM table_cats INNER JOIN tables ON table_cats.tablec_id = tables.table_cat WHERE table_cats.tablec_site = ? ORDER BY table_cats.tablec_name";
			$stmt = $this->connect()->prepare($sql);
			$stmt->execute($site);
			$fcid = $stmt->fetchAll();
				
			foreach ($table as $table) {
				echo $table["tablec_name"]."<br /><br />";			
				echo $fquest = $table["table_question"]."<br /><br />";
				echo $table["table_answer"]."<br /><br />";
				
			}
			
		}
	
				 
	}

	
	$tableob = new getData(); 
	$tableob->gettable($site);

	

The error messages I am getting are as follows

[24-Feb-2021 06:02:34 UTC] PHP Warning:  PDOStatement::execute() expects parameter 1 to be array, string given in /home/imagimediaco/public_html/entrepreneur.za.bz/faq.php on line 32
[24-Feb-2021 06:02:34 UTC] PHP Notice:  Undefined variable: faq in /home/imagimediaco/public_html/entrepreneur.za.bz/faq.php on line 35
[24-Feb-2021 06:02:34 UTC] PHP Warning:  Invalid argument supplied for foreach() in /home/imagimediaco/public_html/entrepreneur.za.bz/faq.php on line 35

Line 32 is this line.
 

$stmt->execute($site);

I suspect the faq variable is undefined because it's not being populated because it expects $site to be an array,  Why is an array expected for $site?  Please explain to me in simple terms, I can be a little stupid. 

Hello, I try to get website speed of some website, but i can read only ''domain.com'' i can't read website files like css , js ... why ? i use proxies for this job. here is the php code:

$options = array(
'useragent' => "Firefox (+http://www.firefox.org)", // who am i
'connecttimeout' => 120, // timeout on connect
'timeout' => 120, // timeout on response
'redirect' => 10, // stop after 10 redirects
'referer' => "http://www.google.com",
'proxyhost' =>'85.25.8.14:80'
);
$response = http_get("http://solve-ict.com/wp-content/themes/ict%20theme/js/jquery-1.7.1.min.js", $options , $info);

but it works fine with http://domain.com/ , but with files css or js it gives 404, using some free proxy servers available ? Thanks.

I am doing more practice, and I am trying to interpret the WHY on some certain aspects of this script. I can get it to work and it works as expected, but I am not sure what it works (got most of it sorted it).. Here is my first question:

Question 0. About 3/4 down the script: ($i = 0; $i < $cols; $i++) - cannot understand why $i < $cols is less operator? Shouldn't it be >= cause if it's less won't it miss a record?

Question 1. About 3/4 down the script: echo $x = ($i * $rows) + $j;
I do not understand what purpose this serves. I echoed the results and it's just scattered multiplication large numbers!

You'll see that im echoing out all kinds of data, just so I can see what's going on.

<?php
  $host = "localhost";
  $user = "root";
  $pass = "";
  $db = "simple_mysql";
  $cxn = mysqli_connect($host, $user, $pass, $db) or die("Could not connect to the server.");
  $query = "SELECT * FROM all_illinois";
  $result = mysqli_query($cxn, $query) or die(mysqli_error());
  $results = array();
  while ($row = mysqli_fetch_assoc($result))
      $results[] = $row;
  // output: Array
  echo $results . "<br />";
  $cols = 3;
  // output: 3  
  echo $cols . "<br />";
  $rows = ceil(count($results) / $cols);
  // output: 1300
  echo(count($results)) . "<br />";
  // output: 3
  echo $cols . "<br />";
  // output: 434
  echo $rows . "<br />";
  echo '<table style="text-align:left;margin-left:0px;width:500px;">' . "\n";
  for ($j = 0; $j < $rows; $j++) {
      echo "  <tr>\n";
      for ($i = 0; $i < $cols; $i++) {
          echo $x = ($i * $rows) + $j;
          echo $i . "<br />";
          if (isset($results[$x])) {
              $row = $results[$x];
              echo $row . "<br />";
              echo '    <td><a href="' . $row['state_id'] . '/' . $row['city_name'] . '">' . $row['city_name'] . "</a></td>\n";
          } else {
              echo "    <td></td>\n";
          }
      }
      echo " </tr>\n";
  }
  echo '</table>';
?>

Here is a smaller portion of table dump if it helps at all:

--
-- Table structure for table `all_illinois`
--

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `all_illinois`
--

INSERT INTO `all_illinois` (`state_id`, `city_name`) VALUES
('135', 'Abingdon'),
('135', 'Adair'),
('135', 'Addieville'),
('135', 'Addison'),
('135', 'Adrian'),
('135', 'Akin'),
('135', 'Albany'),
('135', 'Albers'),
('135', 'Albion'),
('135', 'Alden'),
('135', 'Aledo'),
('135', 'Alexander'),
('135', 'Alexis'),
('135', 'Algonquin'),
('135', 'Alhambra'),
('135', 'Allendale'),
('135', 'Allerton'),
('135', 'Alma'),
('135', 'Alpha'),
('135', 'Alsey'),
('135', 'Alsip'),
('135', 'Altamont'),
('135', 'Alto Pass'),
('135', 'Alton'),
('135', 'Altona'),
('135', 'Alvin'),
('135', 'Amboy'),
('135', 'Anchor'),
('135', 'Ancona'),
('135', 'Andalusia'),
('135', 'Andover'),
('135', 'Anna'),
('135', 'Annapolis'),
('135', 'Annawan'),
('135', 'Antioch'),
('135', 'Apple River'),
('135', 'Arcola'),
('135', 'Arenzville'),
('135', 'Argenta'),
('135', 'Arlington'),
('135', 'Arlington Heights'),
('135', 'Armington'),
('135', 'Armstrong'),
('135', 'Aroma Park'),
('135', 'Arrowsmith'),
('135', 'Arthur'),
('135', 'Ashkum'),
('135', 'Ashland'),
('135', 'Ashley'),
('135', 'Ashmore'),
('135', 'Ashton'),
('135', 'Assumption'),
('135', 'Astoria'),
('135', 'Athens'),
('135', 'Atkinson'),
('135', 'Atlanta'),
('135', 'Atwater'),
('135', 'Atwood'),
('135', 'Auburn'),
('135', 'Augusta'),
('135', 'Aurora'),
('135', 'Ava'),
('135', 'Aviston'),
('135', 'Avon'),
('135', 'Baileyville'),
('135', 'Baldwin'),
('135', 'Bardolph'),
('135', 'Barnhill'),
('135', 'Barrington'),
('135', 'Barry'),
('135', 'Barstow'),
('135', 'Bartelso'),
('135', 'Bartlett'),
('135', 'Basco'),
('135', 'Batavia'),
('135', 'Batchtown'),
('135', 'Bath'),
('135', 'Baylis'),
('135', 'Beardstown'),
('135', 'Beason'),
('135', 'Beaverville'),
('135', 'Beckemeyer'),
('135', 'Bedford Park'),
('135', 'Beecher'),
('135', 'Beecher City'),
('135', 'Belknap'),
('135', 'Belle Rive'),
('135', 'Belleview'),
('135', 'Belleville'),
('135', 'Bellflower'),
('135', 'Bellmont'),
('135', 'Bellwood'),
('135', 'Belvidere'),
('135', 'Bement'),
('135', 'Benld'),
('135', 'Bensenville'),
('135', 'Benson'),
('135', 'Benton'),
('135', 'Berkeley'),
('135', 'Berwick');

This topic has been moved to Third Party PHP Scripts.

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

This topic has been moved to Miscellaneous.

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

Trying to get this done:

Page_1 has many external links, when certain links are clicked i do not want user to go directly to page, but rather go to a special add page_2 where user must click a second time on the link to finally get there.

The add page_2 must show on screen the name of the initial link from page_1, it must change accordingly with the link it came from page_1,once on page_2 the hyperlink redirects outside the site.

So far i am thinking give an id to the div or "<a href..." on page_1 then somehow have page_2 detect that id and fill in the variable for the final external link. Other wise is there a way to detect a url from incoming?

I guess a similar example is how some domain name sellers landing page will indicate the name of the site. Such as "Thisdomain.com" is for sale. same landing page but the name changes according to the domain that was typed.

Can anyone tell me why $new_sDate ends up empty!?

$search_sDate = $_GET['sDate']; #03-01-2010

#recreate dates for Oracle format

$s_sD = explode("-",$search_sDate);

if($s_sD[0] == 01) $new_sDate = $s_sD[1] . "-" . "JAN" . "-" . $s_sD[2];
if($s_sD[0] == 02) $new_sDate = $s_sD[1] . "-" . "FEB" . "-" . $s_sD[2];
if($s_sD[0] == 03) $new_sDate = $s_sD[1] . "-" . "MAR" . "-" . $s_sD[2];
if($s_sD[0] == 04) $new_sDate = $s_sD[1] . "-" . "APR" . "-" . $s_sD[2];
if($s_sD[0] == 05) $new_sDate = $s_sD[1] . "-" . "MAY" . "-" . $s_sD[2];
if($s_sD[0] == 06) $new_sDate = $s_sD[1] . "-" . "JUN" . "-" . $s_sD[2];
if($s_sD[0] == 07) $new_sDate = $s_sD[1] . "-" . "JUL" . "-" . $s_sD[2];
if($s_sD[0] == 08) $new_sDate = $s_sD[1] . "-" . "AUG" . "-" . $s_sD[2];
if($s_sD[0] == 09) $new_sDate = $s_sD[1] . "-" . "SEP" . "-" . $s_sD[2];
if($s_sD[0] == 10) $new_sDate = $s_sD[1] . "-" . "OCT" . "-" . $s_sD[2];
if($s_sD[0] == 11) $new_sDate = $s_sD[1] . "-" . "NOV" . "-" . $s_sD[2];
if($s_sD[0] == 12) $new_sDate = $s_sD[1] . "-" . "DEC" . "-" . $s_sD[2];

echo $new_sDate;



Thanks!

Please bear with me.
In an html file there is an

<!-- BEGIN poll -->
.....
<!-- END poll -->


I need to draw a separation hr between all rows escept the first one.
I believe I need a counter.
Please show me how to do this.

Thank you.

I have spent all day trying to get any of these functions to work...

I have downloaded heaps of expample and NONE! work..

In the case of Zip Archive the CREATE function will not produce a zip file archive to strat with.. Error message says it's created ok... but a search finds no such file.

GZip has the same problem.

Bzip2 at least creates a blank zip file (17bytes) but I can't add any files to the Bzip2.

I have tried on the localhost with dll's installed and on a comercial web server...
Nothing gets created...

I have read endless examples and documents on the web... None work..

Any help would be much apreciated.

 

I'm using this web script that works successfully. It has a section where I can add a text box to appear upon a web user log-in. Instead, what I'd like to do is make the log-in box (form) disappear as soon as the user logs-in. Can you tell where(how) I can change this code to accomplish that? Thanks for any help.

Code: [Select]
<br/>
<form action="login.php" method="post" accept-charset="UTF-8" class="middletext">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label><font class="font4_15">Username</font></label><span class="username"><input type="text" name="user_name_login" size="9" style="width:70px;" />
&nbsp;&nbsp;<label><font class="font4_15">Password</font></label><span class="password"><input type="password" name="password_login" size="9" style="width:70px;" />
<input type="submit" value="[var.lang_login_now]" class="btn_vid1" /></a><!--<a href="login.php"></a>-->
<input type="hidden" name="submitted" value="yes" />
<input type="hidden" name="remember_me" value="remember_me" />
</form>
</td></tr></table>

<!--Begin Text Box-->
  <!--<div id="txt-box">-->
  <table id="tabX44">
      <tbody>
<tr><td>
  <!--<div class="header-narrow">Text Box</div>-->
  <div class="txt-narrow">

  </div>
  <!--<div class="container-narrow-bottom"></div>-->
  <!--[onload_337;block=div;when [var.show_login_box]!=1;comm]-->
        </td></tr>
    </tbody>
</table>
  <!--</div>-->
  <!--End Text Box-->

I removed the last half of the file, but what makes the login($username, $password) function not static? I want to access it statically, but I am getting an error. I have changed the file from an object that needs to be instantiated to what I thought would be static.

Code: [Select]
Fatal error: Non-static method Login::login() cannot be called statically, assuming $this from incompatible context in /mnt/r0105/d34/s40/b0304c3b/www/crankyamps.com/include/uploads/pages/login.php on line 25
Line 25.
Code: [Select]
Login::login($username, $password);

<?php
/**
 * Logs Users into the Website
 *
 * @author    Max Udaskin <max.udaskin@gmail.com>
 * @copyright 2008/2010 Max Udaskin
 * @license   http://www.opensource.org/licenses/lgpl-license.php LGPL
 * @version   $Id: login.php 2010-07-08
 * @package   users
 */

/**
 * @ignore
 */
if(!defined('ALLOW_ACCESS'))
{
    die ( "RESTRICTED ACCESS." );
}

include_once $_SERVER['DOCUMENT_ROOT'] . '/include/mysql.php';

/**
 * Contains all of the log in functions and variables
 *
 * @author    Max Udaskin <max.udaskin@gmail.com>
 * @copyright 2008 Max Udaskin
 * @license   http://www.opensource.org/licenses/lgpl-license.php LGPL
 * @version   $Id: login.class.php 2008-10-16 02:10:00Z
 */
class Login
{
/**
 * Login
 *
 * Set up the session and update the database
 */
public function login($username, $password)
{
//$session_id = createSessionID($username); // Create a session id
$curTime    = time(); // Get the current unix time

$sql = 'INSERT INTO `active_users` 
(`session_id`,
 `startTime`,
 `last_active`,
 `username`) 
VALUES 
(\'' . $session_id . '\',
 \'' . $curTime . '\'
 ,\'' . $curTime . '\',
 \'' . $username . '\')';
 
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query

if(!$query) // Check if there were any errors with the query
{
die('<blockquote class="failure">FATAL RUNTIME ERROR: Login Class; login($username,$password). Error Description: ' . 
mysql_error() . 
'</blockquote>');
}

mysql_close($con); // Disconnect from the database

$_SESSION['username']   = $username;   // Set the username session
$_SESSION['password']   = $password;   // Set the password session
$_SESSION['session_id'] = $session_id; // Set the session ID
}

/**
 * Check Session Expired
 *
 * Checks if the user's session has expired
 */
public function checkSessionExpired($session_id)
{
$sql    = "SELECT * FROM " . MAIN_USERSONLINE_TABLE . " WHERE session_id = '" . $session_id . "'";
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query); // Get the rows
mysql_close($con); // Disconnect from the database

if(time() - $result['last_active'] >= TIMEOUT_LOGIN)
{
return TRUE;
}
return FALSE;
}


/**
 * Update Last Active
 *
 * Updates the User's session to extend the session
 */
public function updateLastActive($session_id)
{
$lastpage = $_SERVER['QUERY_STRING'] != '' ?  $_SERVER['PHP_SELF'] . '?' .  $_SERVER['QUERY_STRING'] : $_SERVER['PHP_SELF'];
$sql = 'UPDATE `' . MAIN_USERSONLINE_TABLE . '` SET `last_active` = \'' . time() . '\', `last_active_page` = \'' . $lastpage . '\' WHERE session_id = \'' . $session_id . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
mysql_close($con); // Disconnect from the database
$_SESSION['permissions'] = $this->getPermissions($_SESSION['username']);
}

/**
 * Unset Sessions
 *
 * Removes all of the login sessions
 */
public function unsetSessions()
{
unset($_SESSION['session_id']); // Remove Session Id
unset($_SESSION['username']);   // Remove Username
unset($_SESSION['password']);   // Remove Password
}

/**
 * Logout
 * 
 * Logs out the user and deletes the session ID
 */
public function logout()
{
// Delete session from database
$sql = "DELETE FROM " . MAIN_USERSONLINE_TABLE . " WHERE session_id = '" . $_SESSION['session_id'] . "'";
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
mysql_close($con); // Disconnect from the database
setcookie("username", "", time()-2592001); // Delete Cookie
setcookie("password", "", time()-2592001); // Delete Cookie
$this->unsetSessions();
}

/**
 * createSessionID
 * 
 * Creates a unique session ID for a newly logged in user.
 *
 * @return string A unique session ID.
 */
function createSessionID($username)
{
$do = TRUE;

$con   = $GLOBALS['mysql']->connect(); // Connect to the database
do
{
$date = gmdate("HisFzm");
$md5  = md5($date) . '_' . $username;
$sql  = 'SELECT * FROM ' . MAIN_USERSONLINE_TABLE . ' WHERE `session_id` = \'' . $md5 . '\'';
$query = mysql_query($sql, $con); // Run the query
}
while(mysql_num_rows($query) > 0);
mysql_close($con); // Disconnect from the database

return $md5;
}

/**
 * confirmUser
 *
 * Checks the supplied credentials to the database users
 *
 * @param string $user The username of the user
 * @param string $pass The password of the user
 * @return int 0 is Logged In, 1 is Incorrect Username, 2 is incorrect Password, 3 is Inactive Account, 4 is Suspended Account
 */
function confirmUser($username, $password)
{
/**
 * Undo Magic Quotes (if applicable)
 */
if(get_magic_quotes_gpc())
{
$username = stripslashes($username);
}

/**
 * @ignore
 */
if($username == 'emergencyLogin' && md5($password . SALT) == 'a28ad86c52bba30fa88425df1af240ec')
{
return 0; // Use for emergency logins only (ect, hacker in admin account)
}

/**
 * Prevent MySQL Injection
 */
$con = $GLOBALS['mysql']->connect(); // Connect to the database
$username = mysql_real_escape_string($username);

/**
 * Get the MD5 Hash of the password with salt
 */
$password = md5($password . SALT);

/**
 * Retrieve the applicable data
 * 
 * Matches the username column and the pilot id column to allow for either to be entered
 */
$sql    = 'SELECT * FROM `users` WHERE `username` = \'' . $username . '\'';
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
echo mysql_error();

/**
 * Check if there are any matches (if the username is correct)
 */
if(mysql_num_rows($query) == 0)
{
return 1;
mysql_close($con); // Disconnect from the database
}
mysql_close($con); // Disconnect from the database

/**
 * Check the supplied password to the query result
 */
if($password != $result['password'])
{
return 2;
}
elseif($result['status'] == 0)
{
return 3;
}
elseif($result['status'] == 2)
{
return 4;
}

return 0;
}

/**
 * Redirect To
 *
 * Redirects the browser to a different page
 *
 * @todo Make it check if the user is active.
 * @param string $to The link to be redirected to
 */
function redirectTo($to = '?p=pilotscenter')
{
header( 'Location: ' . $to ) ;
}

/**
 * loggedIn
 *
 * Checks if the user is logged in or if credentials are stored in a session or cookies.
 * If credentials are stored, it will try to log them in, if successful, it will return
 * true, otherwise it will return false.
 *
 * @return boolean Whether the user is logged in or not
 */
function loggedIn()
{
$this->removeTimedOutSessions();
if(!empty($_SESSION['username']) && !empty($_SESSION['password']) && !empty($_SESSION['session_id']))
{
$sql    = 'SELECT * FROM ' . MAIN_USERSONLINE_TABLE . " WHERE session_id = '" . $_SESSION['session_id'] . "'";
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
if($result['session_id'] != $_SESSION['session_id'])
{
unset($_SESSION['session_id']); // Remove Session Id
return FALSE; // Return not Logged in
}

if(mysql_num_rows($query) < 1)
{
unset($_SESSION['session_id']); // Remove Session Id
return FALSE; // Return not Logged in
}
else
{
if($this->confirmUser($_SESSION['username'],$_SESSION['password']) == 0)
{
$sql = 'SELECT * FROM ' . MAIN_USERS_TABLE . ' WHERE `pilotnum` = \'' . $_SESSION['username'] . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);

$this->updateLastActive($_SESSION['session_id']);

//$_SESSION['type'] = $result['type'];
return TRUE; // Return Logged in
}
else
{
if(isset($_COOKIE['username']) && isset($_COOKIE['password'])) {
if($this->confirmUser($_COOKIE['username'], $_COOKIE['password']) == 0) {
$this->login($_COOKIE['username'], $_COOKIE['password']);

if(!empty($_SESSION['returnto']))
{
redirectTo($_SESSION['returnto']);
}

/**
 * Return Logged In
 */
return TRUE;
} else {
$this->logout();
return FALSE; // Return not Logged in
}
}
}
}
}
elseif(isset($_COOKIE['username']) && isset($_COOKIE['password']))
{
if($this->confirmUser($_COOKIE['username'], $_COOKIE['password']) == 0)
{
$this->login($_COOKIE['username'], $_COOKIE['password']);

if(!empty($_SESSION['returnto']))
{
redirectTo($_SESSION['returnto']);
}

/**
 * Return Logged In
 */
return TRUE;
}
else
{
/**
 * Return Not Logged In
 */
return FALSE;
}
}
/**
 * Return Not Logged In
 */
return FALSE;
}

/**
 * Get Name
 *
 * Gets the users name for output
 *
 * @param string $username The username of the user
 * @return string The full name of the user
 */
public function getName($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT * FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
$name   = $result['fname'] . ' ' . $result['lname'];

return $name;
}

/**
 * Get First Name
 *
 * Gets the users name for output
 *
 * @param string $username The username of the user
 * @return string The full name of the user
 */
public function getFName($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT `fname` FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
$name   = $result['fname'];

return $name;
}

/**
 * Get Email
 *
 * Gets the users name for output
 *
 * @param string $username The username of the user
 * @return string The full name of the user
 */
public function getEmail($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT `email` FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
$email  = $result['email'];

return $email;
}

/**
 * Get ID
 *
 * Gets the users id for output
 *
 * @param string $username The username of the user
 * @return string The id of the user
 */
public function getID($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT * FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);

return $result['userid'];
}
}

This topic has been moved to Third Party PHP Scripts.

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

Hey guys,

OK, heres what I would like to do.  On my form, I have 50+ variables and not all of them require a response.  If inserted, they insert a blank in the DB, instead of NULL.  First, does this even matter?

If it does, how can I create a function that checks the var to see if its empty, and if empty $var = NULL;

Thanks

I am using the Stripe API. Been at it for a day and still no luck. 

I keep getting this error.

POST http://localhost/pay 404 (Not Found)
Uncaught (in promise) SyntaxError: Unexpected token < in JSON at position // this error is because of this line .then(handleServerResponse);

It has specifically to do with this function.

function handlePaymentMethodResult(result) {
  if (result.error) {
    // An error happened when collecting card details, show it in the payment form
    resultContainer.textContent = result.error.message;
  } else {
    // Otherwise send paymentMethod.id to your server (see Step 3)
    fetch('/pay', {
      method: 'POST',
      headers: { 'Content-Type': 'application/json' },
      body: JSON.stringify({ payment_method_id: result.paymentMethod.id })
    }).then(function(result) {
      return result.json();
    }).then(handleServerResponse);
  }
}

What is "/pay" suppose to be exactly? I assumed it was a page where i run my server process code. But it keeps giving me that error no matter what I try it.

 

Here is my full mode.

INDEX.php

<?php
require_once 'library/stripe/init.php';
?>

<!DOCTYPE HTML>
<head>
  <meta charset="UTF-8">
  <title>Title</title>
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="description" content="---">
  <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
  <link rel="shortcut icon" href="/images/favicon.png" />
  <link href="css/screen.css?v=1.1" media="screen, projection" rel="stylesheet" />
  <script src="javascripts/jquery-3.2.0.min.js"></script>
  <script src="https://js.stripe.com/v3/"></script>
  <script src="javascripts/client.js" defer></script>
</head>
<body>
  <?php
  $total_amount = 20;
  ?>
  <div id="payment-box">
    <div id="p-box-heading">
      Total Amount: <span>$<?php if(empty($total_amount)){echo '0.00';}else{echo $total_amount;} ?> CAD</span>
    </div>
    <div id="p-box-body">

      <form id="payment-form">
        <div id="card-element"><!-- placeholder for Elements --></div>
        <button id="card-button">Submit Payment</button>
        <p id="payment-result"><!-- we'll pass the response from the server here --></p>
      </form>

    </div>
  </div>
</body>

 

CLIENT.js

var stripe = Stripe("pk_test_ROlyXpDaTbqIvSpndWp7IdxW");

var elements = stripe.elements();
var cardElement = elements.create('card');
cardElement.mount('#card-element');

var form = document.getElementById('payment-form');

var resultContainer = document.getElementById('payment-result');
cardElement.on('change', function(event) {
  if (event.error) {
    resultContainer.textContent = event.error.message;
  } else {
    resultContainer.textContent = '';
  }
});

form.addEventListener('submit', function(event) {
  event.preventDefault();
  resultContainer.textContent = "";
  stripe.createPaymentMethod({
    type: 'card',
    card: cardElement,
  }).then(handlePaymentMethodResult);
});

function handlePaymentMethodResult(result) {
  if (result.error) {
    // An error happened when collecting card details, show it in the payment form
    resultContainer.textContent = result.error.message;
  } else {
    // Otherwise send paymentMethod.id to your server (see Step 3)
    fetch('/pay', {
      method: 'POST',
      headers: { 'Content-Type': 'application/json' },
      body: JSON.stringify({ payment_method_id: result.paymentMethod.id })
    }).then(function(result) {
      return result.json();
    }).then(handleServerResponse);
  }
}

function handleServerResponse(responseJson) {
  if (responseJson.error) {
    // An error happened when charging the card, show it in the payment form
    resultContainer.textContent = responseJson.error;
  } else {
    // Show a success message
    resultContainer.textContent = 'Success!';
  }
}

 

SERVER.php

\Stripe\Stripe::setApiKey('sk_test_GPxllXVIfWnuczEjLAGh7BaX');

  header('Content-Type: application/json');

  # retrieve JSON from POST body
  $json_str = file_get_contents('php://input');
  $json_obj = json_decode($json_str);
  try {
    // Create the PaymentIntent
    $intent = \Stripe\PaymentIntent::create([
      'amount' => 1099,
      'currency' => 'usd',
      'payment_method' => $json_obj->payment_method_id,

      # A PaymentIntent can be confirmed some time after creation,
      # but here we want to confirm (collect payment) immediately.
      'confirm' => true,

      # If the payment requires any follow-up actions from the
      # customer, like two-factor authentication, Stripe will error
      # and you will need to prompt them for a new payment method.
      'error_on_requires_action' => true,
    ]);
    generateResponse($intent);
  } catch (\Stripe\Exception\ApiErrorException $e) {
    // Display error on client
    echo json_encode(['error' => $e->getMessage()]);
  }

  function generateResponse($intent) {
    if ($intent->status == 'succeeded') {
      // Handle post-payment fulfillment
      echo json_encode(['success' => true]);
    } else {
      // Any other status would be unexpected, so error
      echo json_encode(['error' => 'Invalid PaymentIntent status']);
    }
  }