PHP - How To Set Up Verification Before A Script Runs

$news='news';
$sql_news = "INSERT INTO  `rise`.`news` (
`user` ,
`message`
)
VALUES (
    :id, :news
);";
$q_news = $conn->prepare($sql_news);
$q_news -> execute(array(':id'=>$id,
                  ':news'=>$news));
print_r($q_news);
echo $q_news->rowCount();

Why does it echo 1 instead of 2 when everything else on the page is turned off for processing, and it's the last thing on the page?   Why do 2 inserts happen?

I have this function and for some reason it is running over 100 queries on page load.  I'm not sure what I am doing wrong.  Can I please get some guidance on this?

Code: [Select]
<?php

function fetch_users($page = 1, $per_page = 20, $type = null, $country = null, $state = null)
{
$start = (int)(($page - 1) * $per_page);
$per_page = (int)$per_page;
$type  = (int)$type;
$country  = (int)$country;
$state  = (int)$state;

$sql = "SELECT
                `users`.`id`,
                `users`.`firstname`,
                `users`.`lastname`,
                `users`.`username`,
                `users`.`email`,
                `users`.`gender`,
                `users`.`accounttype`,
                `users`.`personalweb`,
                `users`.`guestviews`,
                `users`.`iviews`,
                `users`.`eviews`,
                `users`.`credentials`,
                `users`.`specialties`,
                `users`.`country`,
                `users`.`city`,
                `users`.`state`,
                `users`.`phonenumber`,
                `users`.`dateofbirth` AS `dob`,
`users`.`mail_status`,
`users`.`status`,
                `investor_info`.`investor_type`,
                DATE_FORMAT(`users`.`dateofbirth`,'%D') AS `dayofbirth`,
                DATE_FORMAT(`users`.`dateofbirth`,'%c') AS `monthofbirth`,
                DATE_FORMAT(`users`.`dateofbirth`,'%Y') AS `yearofbirth`,
                DATE_FORMAT(`users`.`dateofbirth`,'%D \of %M %Y') AS `dateofbirth`,
                DATE_FORMAT(`users`.`signupdate`,'%h:%i %p %M %e, %Y') AS `signupdate`,
                SUM(`investor_info`.`capital_available`) AS `totalavailable`,
`companytype`,
`capital`
            FROM `users`
            LEFT JOIN `investor_info`
            ON `users`.`id` = `investor_info`.`uid`
            LEFT OUTER JOIN employees
            ON users.id = employees.userid
            LEFT OUTER JOIN (
SELECT 
companies.companyid, 
companies.companytype AS `companytype`,
SUM(companies.capital) AS `capital`
FROM  `companies`
GROUP BY companies.companytype) SumCompanies
            ON employees.companyid = SumCompanies.companyid
WHERE `users`.`status` > 2 ";

if($type != null)
{
$acctype = $type - 1;

$sql.= "AND`users`.`accounttype` = {$acctype} ";
}

if($country != null)
{
$sql.= "AND`users`.`country` = {$country} ";
}

if($state != null)
{
$sql.= "AND`users`.`state` = {$state} ";
}

$sql.= "GROUP BY `users`.`id` 
ORDER BY `users`.`id` DESC 
LIMIT {$start}, {$per_page}";

$result = mysql_query($sql) or die(mysql_error());

$users = array();

$i = 0;

while($row = mysql_fetch_assoc($result))
{
$users[$i] = array(
'id'  => $row['id'],
'firstname'  => $row['firstname'],
'lastname'  => $row['lastname'],
'username'  => $row['username'],
'email'  => $row['email'],
'gender'  => $row['gender'],
'accounttype'  => $row['accounttype'],
'guestviews' => $row['guestviews'],
'iviews'  => $row['iviews'],
'eviews'  => $row['eviews'],
'credentials'  => $row['credentials'],
'specialties'  => $row['specialties'],
'country'  => $row['country'],
'state'  => $row['state'],
'city'  => $row['city'],
'phonenumber'  => $row['phonenumber'],
'dob'  => $row['dob'],
'mail_status'  => $row['mail_status'],
'status'  => $row['status'],
'investor_type'  => $row['investor_type'],
'dayofbirth'  => $row['dayofbirth'],
'monthofbirth'  => $row['monthofbirth'],
'yearofbirth'  => $row['yearofbirth'],
'dateofbirth'  => $row['dateofbirth'],
'signupdate'  => $row['signupdate'],
'totalavailable'  => $row['totalavailable'],
'companytype'  => $row['companytype'],
'capital'  => $row['capital'],
);

$i++;
}

return $users;
}

?>

This topic has been moved to MySQL Help.

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

Hello all, 
I have a php file connecting to phpmyadmin on xampp. I set the localhost password to ‘password’ I run the script with ajax and it does work because I tested it with a filecreate. I get NO errors and all I want to do is check and see if the email exists and if not then create a row in the database.

<?php
// Connect to Phpmyadmin database localhost.
$hostname = "localhost";//"";127.0.0.1
$username = "root";
$password = "password";//"password";
$dbname = "test";

$conn = new mysqli($hostname, $username, $password, $dbname);
if($conn -> connect_error) {
	die("Connection failed: " . $conn -> connect_error);
}
// USED to CHANGE the db. - (mysqli_select_db($con, "test") or die());

/* Check to make all fields entered -make sure submitted- #2*/
if(isset($_POST["register"])) {
	if(!$_POST["email"] | !$_POST["password"] | !$_POST["password2"]) {
		die("You did not fill in all the fields");
	}

/* do escape strings for SQL injection */
$emailsafe = mysqli_real_escape_string($conn, $_POST["email"]);
$passsafe = mysqli_real_escape_string($conn, $_POST["password"]);
$pass2safe = mysqli_real_escape_string($conn, $_POST["password2"]);

/* Check and see if email EXISTS in db. */

/* Insert email in db if does not exist */
$sql = "SELECT email FROM users WHERE email = '$emailsafe'";//limit 1
$result = $conn->query($sql) or die("invalid email check " . mysqli_error($conn));
$numrows = mysqli_num_rows($result);
if($numrows != 0) {
	die("Sorry the email " . $_POST["email"] . "is already in use");
}
// check if passwords both match
if($_POST["password"] != $_POST["password2"]) {
	die("Passwords did NOT match");
}
// if passwords match encrypt
$hashedpass = password_hash($passsafe, PASSWORD_DEFAULT);
// With everything escaped and hashed INSERT into db.
$sqlINSERT = "INSERT INTO users(email, password) " .
	"VALUES('" . $emailsafe ."','". $hashedpass ."')";
if($query = $conn->query($sqlINSERT)=== TRUE) {
	echo '<script type="text/javascript">alert("Successfully INSERTed");</script>';
} else {
	die("Unsuccessful");
}
$conn->close();
?>

I ran my php with ajax and it creates the file successfully so i know it runs. I wanted to setup PHP debugging with atom or visual studio but i have not been able to successfully do that... I tried with xdebug so i just use the network tab inchrome to find if errors exist.
I wish i was able to run debug line by line I use xampp for some reason my network tab makes me use mysqli I thought the newest php just used mysql I downloaded the php7 and put it on my hard drive but there was no php.ini to setup xdebug. I found a php.ini in xampp but that did not correctly do it. I also downloaded the NEWEST xampp thinking that was the problem.. packages on atom followed many different guides online but nothing was successful.

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.

Hello,

I had updated from PHP 5.x to PHP 7.2. The issue is that my cron files are not running now. The sites based on php 5 code runs without any issues.

The cron files when run from cmd are producing errors like to change to mysqli.

Any solutions?

Thanks.

Hello there   After a few years of spending less and less time coding, I've got a lot of catching up to do. Back when I left I usually would run without classes. Now this is a big deal for me today.   I do understand the concept of classes and already did some working models, mostly from my learning process.   Now here is what is bothering me:

<?PHP

class database {
	// Variables
	public $test;
	
	// Constructor
	public function __construct()
	{
		$test = "4";
	}
	
	
	// Functions
	//
	public function test()
	{
		var_dump($this->test);
	}
	
}

$test = new database;

$test->test();

?>

Wether I run this script on itself, nor through another file, this does work. What i get is:   NULL   The constructor does run, I did an echo inside it. Also it does not matter if the variable is public, private or protected - it will be always NULL.   Error_reporting is on E_ALL, does not show any errors.   What have I overlooked?

dear folks    this question is regarding the plugin update, file uploader and SFTP - on a wordpress that runs on secured- server I think I know the answer to the following question as "not possible" but I figured I would check.
my sites are on servers where we disable FTP access and only use SFTP access, and also on a different port (not port 22).


what if i want to use a automated maintaining service like the following

https://mainwp.com
http://wwww.infinitewp.com


automated Installing and updating plugins to the sites does not seem to work  and I assume this is the reason why.
I'm also assuming the File uploader extension will not work either. Can anyone confirm this for sure though?

Any ideas as far as workaround?


one might think of the following way: Can you try adding your SFTP settings into the wp-config of one of my sites to see if that allows the functions to work? we can see an example in http://codex.wordpre...g_wp-config.php under WordPress Upgrade Constants or possibly try this plugin SSH SFTP Updater Support   do you have any idear!?
 
cf:  https://mainwp.com/f...&highlight=sftp
 

Okay, so I'm pretty new to jQuery but I am pretty experienced with PHP.  I am about to begin coding a script written mostly in jQuery.  It will use AJAX to verify that an article tag a user provides exists in a database.  When a user goes to write an article on my website, my form will ask them to add keyword tags which will be used in searches.  Basically only admins will be allowed to create new tags, so this is why I check the tags first.  And also to prevent duplicates and similar tag entries in the database.   The form will have a single input that the user will use to search for a tag.  Once the user hits the enter key, it will search the database for tags that already exist.  Once the ajax is complete, a list of related tags will pop up and the user will be able to select their desired tag by either clicking the tag link in the list or by pressing enter.   This is a very crude demonstration of what my idea is.  

Hi guys.   I'm using php to randomly generate a simple math verification question.  But, I'm having a hard time validating the input.  Can someone please tell me what I'm doing wrong?

Thank you
 


} else if(trim($verify) != $_SESSION['UserData']['Math'][0]+$_SESSION['UserData']['Math'][1]){
     $error = '<div class="error_message">Attention! The verification number you entered is incorrect.</div>';
}



<?php
echo "<span class='label'><span class='required'>*</span>What is ".$_SESSION['UserData']['Math'][0]." +    ".$_SESSION['UserData']['Math'][1]."?</span> ";
?>

<input name="verify" type="text" id="verify" size="3" value="<?=$verify;?>" /><br /><br />

   

I am about to build a site for a liqueur brand and have to create a simple screen that asks if the user is of the right age. This does not have to be linked to a credit card, just a simple yes or no screen. I am thinking this would probably be done via a cookie, but I am not sure.

Somehow it would have to work where it gets checked each time anyone goes to the site, regardless of the entry point. So for example it would get checked on mydomain.com, but also on mydomain.com/about, or mydomain.com/somethingelse. The yes or no screen would of course only show the first time the user came to site. Via what technology would I do this? Cookie? Can cookies have an expiration date?

I would love some comments or direction on how this is done best.

Thanks a lot!

How to remove the verification code here,i mean the captcha...

<?php

session_start();

if ($_POST['Submit'] == 'Send')

{

if (strcmp(md5($_POST['user_code']),$_SESSION['ckey']))

{ 

header("Location: sendmail.php?msg=ERROR: Invalid Verification Code");

exit();

  } 



$to = $_POST['toemail'];

$subject = $_POST['subject'];

$message = $_POST['message'];

$fromemail = $_POST['fromemail'];

$fromname = $_POST['fromname'];

$lt= '<';

$gt= '>';

$sp= ' ';

$from= 'From:';

$headers = $from.$fromname.$sp.$lt.$fromemail.$gt;

mail($to,$subject,$message,$headers);

header("Location: sendmail.php?msg= Mail Sent!");

exit();

}

?>

<html>

<head>

<title>Email </title>

</head>

<body bgcolor="#ffffcc">

<h2 align="center">

Email
</h2>

<h3 align="center">

Please do not misuse this script.
</h3><br>

<p style="margin-left:15px">

<form action="sendmail.php" method="POST">

<b>From Name:</b><br>

<input type="text" name="fromname" size="50"><br>

<br><b>From Email:</b><br>

<input type="text" name="fromemail" size="50"><br>

<br><b>To Email:</b><br>

<input type="text" name="toemail" size="50"><br>

<br><b>Subject:</b><br>

<input type="text" name="subject" size="74"><br>

<br><b>Your Message:</b><br>

<textarea name="message" rows="5" cols="50">

</textarea><br>

<br><b>Verification Code:</b><br>

<input name="user_code" type="text" size="25">  

<img src="pngimg.php" align="middle"><br><br>

<input type="submit" name="Submit" value="Send">

<input type="reset" value="Reset">

</form>

</p>

<?php if (isset($_GET['msg'])) { echo "<font color=\"red\"><h3 align=\"center\"> $_GET[msg] </h3></font>"; } ?>

</body>

</html>

I am sending a email verification that a person registers on my site. I have two problems. Here is the email script:

Code: [Select]
        $message = "Thank you for registering.";
        mail($email, 'Registration Confirmation', $message, 'From: noreply@website.com');

Problem 1: I have tried this on two different identical pages, index.php and register.php. It only works in the index page.

Problem 2: When it does work on the index page, the From header does not show what is in the mail() function, it shows that it is from my host. What's up with that?

Given the choice, I need to get problem 2 solved way more than problem 1. Thank you.

I'm in the habit of verifying input client side. For example, there is a field to enter a number, and I ensure that it is within a particular range using Javascript.

My backend PHP code does not do such checking... Is this bad? Should I be doing checking using my backend code and send a response back to the client to display a message? Admittedly, I avoid it, since it's a little extra work -- well more extra than just javascripts, IF-THEN-ALERT type statement.