PHP - Short Hand Variable Loading

What is the best way to handle an auto database check? could php do this without the help of JQUERY or JAVASCRIPT?

So this is a bit of a puzzler for me? I have a code that takes a form submit and chucks it to a DB that all works fine but the second part is it also takes the submit and sends it to a email. now this is the crazy part it works fine 80% of the time but some times it sends back a blank email or one that is only hafe there, but still all shows fine in the DB and I have been trying to work this out for 5 days now and ..... nothing worked and I am lost for any ideas on what it could be 

Long Version Associative Array:

	/* associative array */
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
echo $row["name"]." ".$row["author_name"]." ".$row['price'];
	

Short Version Associative Array:

	($row = mysqli_fetch_assoc($result))
	

As in:

	 while ($row = mysqli_fetch_assoc($result)) {
        echo $row["name"]." ".$row["class"]." ".$row['roll_no']."<br />";
	

Q1. Correct ?

 

Q2. Long Version Numeric Array:

	/* numeric array */
$row = mysqli_fetch_array($result, MYSQLI_NUM);
echo $row[0]." ".$row[1]." ".$row[2];
	

Can you not do short Version like this :

	($row = mysqli_fetch_num($result))
	

As in:

	 while ($row = mysqli_fetch_num($result)) {
        echo $row["name"]." ".$row["class"]." ".$row['roll_no']."<br />";
	

 

Q3. Long Version "Both":

	/* associative and numeric array */
$row = mysqli_fetch_array($result, MYSQLI_BOTH);
echo $row[0]." ".$row["author_name"]." ".$row[2];
	

Can you not do short Version like this:

	($row = mysqli_fetch_both($result))
	

As in:

	 while ($row = mysqli_fetch_both($result)) {
        echo $row["name"]." ".$row["class"]." ".$row['roll_no']."<br />";
	

 

 

 

Edited February 3, 2019 by phpsane

I haven't really messed with PHP in like 2 years. Just little fixes on old scripts every now and then. I've been kind of in an argument with myself the past couple of days while writing a script.

The thing is I only have around 3 or 4 sets of information I need. Such as:

Code: [Select]
option1: information for option 1
option2: information for option 2
option3: information for option 3
etc..

NOW, at first I was doing this all in a text file. This information doesn't necessarily need to be private but i also don't want people to know what file needs to be edited right off the bat.

I don't see any reason at all for using databases here, I'd much rather stick to files.

I'm thinking it may be best to store this is strings in a seperate PHP file and include it? Then if I need to edit it, I can simply write a new file.

Any suggestions?

Hello guys
i want your help in adfly clone script , i have it installed it but i have  problem
- shrinking links not working on main page, but working good when user logged in
all server Requirements are ok
my website: adglo.be
script: mediafire
vt: virustotal
regards,
Edited by ForexSon, 09 August 2014 - 06:49 PM.

Can't fix it?

Code: [Select]
<?php
include('connect.php');
mysql_query("SELECT itemQty SUM(itemQty) FROM transactions Where itemDescription= 'raffle'") or die mysql_error());
$row = mysql_fetch_array( $result );

echo $row['sum(itemQty)'];
?>

This topic has been moved to PHP Freelancing.

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

I am assuming doing the following is bad practice as the short name "Account" is both for the repository and account.  Agree?  Appears that use always takes precedent over namespace and just Account\User is always short for \NotionCommotion\Domain\Entity\Account\User and not \NotionCommotion\Api\Account\User.  Still sees like it could easily result in confusion.

namespace NotionCommotion\Domain\Repository\Account;
use NotionCommotion\Domain\Entity\Account;
class AccountRepository
{
    public function getUser(string $mainKey, int $userId):?Account\User {
        //
    }
}

Would it be better to do something like the following?  Interestingly, it worked fine on the below class but when I tried to do so on the above AccountRepository class, it resulted in AccountDir\User class not found error.  Is there any logic reason why that might/should happen, or is it more likely I just have some error elsewhere?

namespace NotionCommotion\Api\Account;
use NotionCommotion\Domain\Entity\Account as AccountDir;
class AccountService
{
    public function read():AccountDir\Account {
        //
    }
}

Hey, The code below for some reason is showing; Hoes: 20000 Morale: 4.10 (hoes * hoe_morale * 2)); cred.

Any ideas why i need it to show the actual result not the Maths thanks.

<?php
if($_GET['password']!="1234")
{
die("You do not have access to this page.");
}
else
{
include("functions.php");
include("db_connection.php");
$sql = "UPDATE users SET cash = cash + hoes * hoe_morale * 150, cred = cred + hoes * hoe_morale * 2 WHERE is_active = 1";
mysql_query($sql) or die(mysql_error());
$sql2="INSERT INTO messages (to_username,message,type, timestamp) VALUES('$playerdata[username]','     Hoes: $playerdata[hoes] Morale: $playerdata[hoe_morale] (hoes * hoe_morale * 2)); cred','player', NOW())"; 
mysql_query($sql2) or die(mysql_error());
echo "Ho Income complete";
}
?>

As you can see, this array is setting each colorvalue to each idvalue.

Code: [Select]
<?php

include("config.php");
include("db.php");

$arrid=$_POST['id'];
$arrcolor=$_POST['color'];

foreach ($arrid as $idvalue)
{
foreach ($arrcolor as $colorvalue)
{
$sql = "UPDATE colors SET color='$colorvalue' WHERE id = '$idvalue'";
mysql_query($sql) or die("Error: ".mysql_error());
echo $sql;
}
}


header("Location: " . $config_basedir . "adminhome.php");
?>

This topic has been moved to Miscellaneous.

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

Probably real basic but im nto great with the maths aspect of php, how would i get the $level + noto to show from the php below as currently i get,
From: System



4 minutes ago     You have reached level 1 + 1 in Notoriety, Please check the Skill Points section to see if you now qualify for any upgrades!
$sql="INSERT INTO messages (to_username,from_username,message,type, timestamp) VALUES('$playerdata[username]','System','You have reached level $level + 1 in Notoriety, Please check the Skill Points section to see if you now qualify for any upgrades!','Player', NOW())";
mysql_query($sql) or die(mysql_error());

Hi, i made a registration page in php, Only problem is its not submitting anything to the database nor throwing back an errors. I'm confused as to why, the code is below any help will be appreciated thanks

** server.php holds the database info i.e

Code: [Select]
<?php 
///Server Info
$dbhost = "localhost";
$dbuser = "*****";
$dbpass = "******";
$dbname = "****";
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die();
mysql_select_db($dbname);
?>
Registration page in question;
Code: [Select]
<?php
require_once('check.php');
session_start();
$name = $_SESSION['name'];
require_once('server.php');
require_once('stats.php');
    if($_POST) {
        function VisitorIP()
    { 
    if(isset($_SERVER['HTTP_X_FORWARDED_FOR']))
        $TheIp=$_SERVER['HTTP_X_FORWARDED_FOR'];
    else $TheIp=$_SERVER['REMOTE_ADDR'];
 
    return trim($TheIp);
    }
        $ipaddress = VisitorIP();
        $name = $_POST['username'];
        $namelength = strlen($name);
        $email = $_POST['email'];
        $password = $_POST['password'];
        $passwordlength = strlen($password);
        $confirm = $_POST['confirm'];    
        if($namelength < 3){
            
           $error1="<div class='text1' style='background-color:#FF0;'><span style='color:red'>Error: Your username must be at least 3 characters!</span></div>";
           echo $error1;
          } 
        elseif($passwordlength < 6) {
            $error1="<div class='text1' style='background-color:#FF0;'><span style='color:red'>Error: Password must be at least 6 characters long!</span></div>";
            echo $error1;
        }
        elseif($email == "") {
            $error1="<div class='text1' style='background-color:#FF0;'><span style='color:red'>Error: You must enter an email address!</span></div>";
            echo $error1;
          }   
        elseif($password != $confirm) {
        $error1="<div class='text1' style='background-color:#FF0;'><span style='color:red'>Error: Passwords do not match!</span></div>";
        echo $error1;
          } else {
                include("server.php");
            $query = sprintf("SELECT COUNT(id) FROM players WHERE UPPER(name) = UPPER('%s')",
                mysql_real_escape_string($_POST['username']));
            $result = mysql_query($query);
            list($count) = mysql_fetch_row($result);
            if($count >= 1) { 
$error1="<div class='text1' style='background-color:#FF0;'><span style='color:red'>Error: that username is taken.</span></div>";
echo $error1;

        } else {
                $query1 = sprintf("INSERT INTO players(name,password,email,ip_address) VALUES ('%s','%s', '$email','$ipaddress');",
                    mysql_real_escape_string($_POST['username']),
                    mysql_real_escape_string(md5($password)));
                mysql_query($query1);
            
$error1="<div class='text1' style='background-color:#FF0;'><span style='color:#390'>Congratulations, you registered successfully!</span></div>";
echo $error1;

            }    
         }
    }
?>

Hello everybody, i have an easy short code to upload multiple photos to "images" directory. after upload each file, i give it unique name.   the problem i have is: i want see the name of uploaded files and print this using echo as in line 21. the line 21 gives me names but not the same names of uploaded files!   thank you very much for your help. Rafal

<?php
foreach ($_FILES['file']['name'] as $i => $name)
{
$types = array("gif", "jpeg", "jpg", "png");
$temp = explode(".", $name);
$extension = end($temp);
if ($_FILES["file"]["size"][$i] < 10240000 && in_array($extension, $types))
{
if ($_FILES["file"]["error"][$i] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"][$i] . "<br>";
}
else
{
if (file_exists("images/" . $name))
{
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"][$i], "images/" . uniqid() . "." . $extension);
echo "uploaded&nbsp;" . $_FILES["file"] , uniqid() . "." . $extension ;
echo "<br>";
}
}
}
else
{
$error =  "Invalid file";
}
}
?>
<html>
<head>
<title></title>
</head>
<body>
<form enctype="multipart/form-data" action="photo.php" method="POST">
<input type="file" name="file[]" id="file" ><br>
<input type="file" name="file[]" id="file" ><br>
<input type="file" name="file[]" id="file" ><br>
<input type="file" name="file[]" id="file" ><br>
<input type="submit" value="upload">
</form>
</body>
</html>

i have an admin page that lists all the rows from a table. One of the fields is generated using FCKEditor, so the field has HTML Code in it.  I would like to only show the first 100 or so chars of the field, but if the 100 chars ends in the middle of HTML code, specifically in this case <a href>, it cuts off, and creates "havoc" in my page.  Is there a way to avoid this by seeing that the 100 char is in the middle of an <a href> tag (or any tag for that matter?

Here is what the generated html can look like ::

<td class="tdresults">We are very excited to offer three great events at the <a href="http://www.mylongwebsite.c</td>
<td class="tdresults">next field data</td>

Thank you in advance.

Pete