PHP - Grab Some Server-data

Ok so i want to grab an id from the checkbox then grab the option drop down associated with that check box and update a mysql row here is my code so far

any help is awesome help taaaanks guys

<?php
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query = "SELECT * FROM tickets ORDER BY id DESC";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{

print "<input name='delete[]' value='{$row['id']}' type='checkbox'>";
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query2 = "SELECT * FROM admin";
$result2 = mysql_query($query2) or die(mysql_error());
print "<form name='namestoupdate' method='post' action='update.php'>\n";
print '<select>';
while($row2 = mysql_fetch_array($result2))
{
if ($row2['priv']==prov){print '<option value="'.$row2['user'].'" name="prov['.$i++.']">'.$row2['user'].'</option>';}
}
print '</select>';
print "<input type='submit' value='submit' />";
print "</form>";
}
?>


Visual aid

I wish to create validation rules once which are used both on the client and on the server.   For instance, I will start off with the following PHP object:

stdClass Object
(
    [rules] => stdClass Object
        (
            [email] => stdClass Object
                (
                    [required] => 1
                    [email] => 1
                    [remote] => stdClass Object
                        (
                            [url] => check-email.php
                            [type] => post
                            [data] => stdClass Object
                                (
                                    [username] => function() {return $( '#username' ).val();}
                                )
                        )
                )
        )

    [messages] => stdClass Object
        (
            [email] => stdClass Object
                (
                    [required] => an email is required
                )
        )
)

When the edit page is downloaded to the client, I will include this object in some format suitable to the client.   The client will then use the jQuery Validation plugin (http://jqueryvalidation.org/) along with the validation object, and client side validate the page.   When the form passes client side validation and is uploaded, PHP will use the same validation object to serverside validate the form (I have this part working as desired).   My question is how should I pass this data to the client?  Originally, I would just use PHP to write some JavaScript.

exit('var myObj='.json_encode($myObj));

Note that when I json_encode the object, the value of $myObj->rules->email->remote->data->username is a string with quotes around it, however, I can easily use PHP to strip these tags before sending it to the client.   As Jacques1 pointed out in http://forums.phpfre...ascript-client/, I should never ever use PHP to generate JavaScript, and should use AJAX to download the JSON directly.  I tried doing the later, but found that a callback function could not be included in the JSON.     Please advise on the best way to accomplish this.   Thank you

Having some issues, hopefully you guys can identify a solution for me.

There are 7 Servers involved in this situation - Each with its own website.

Server 1 houses a page with content that is shared by the other 6 servers.

I need to change an image (logo) at the top of Server 1 page based upon which server they originally came from.

For example they are traveling from server 4, when they arrive at server 1 they see server 1 content however the image at the top will corrospond with correct brand in this example server 4's logo.

Cookies have not been a reliable solution considering they are usually disabled.

Please Help Guys, Any feedback is Fantastic!

hello sir,

            i  have to connect database to my live server using 

<?php

define('DB_HOST', 'localhost');
define('DB_NAME', 'oop_pdo_crud');
define('DB_USER', 'root');
define('DB_PASS', '');

?>

or 

 

All good with sending single dimensional form data to the server using application/x-www-form-urlencoded, and having PHP convert it into an array.  Also, good with sending simple arrays using [].  But then I find myself needing to send a deeper object to the server .  For example, I have a form with three text inputs simpleFormName 1, 2, and 3 plus some deeper object.

Array
(
    [simpleFormName1] => bla
    [simpleFormName2] => bla
    [simpleFormName3] => bla
    [deeperObject] => Array
        (
            [0] => Array
                (
                    [prop1] => bla
                    [prop2] => true
                    [data] => Array
                        (
                            [0] => Array
                                (
                                    [p1] => 321
                                    [p2] => 123
                                )

                            [1] => Array
                                (
                                    [p1] => 121
                                    [p2] => 423
                                )

                            [2] => Array
                                (
                                    [p1] => 221
                                    [p2] => 133
                                )

                        )

                )

            [1] => Array
                (
                    [prop1] => blabla
                    [prop2] => false
                    [data] => Array
                        (
                            [0] => Array
                                (
                                    [p1] => 222
                                    [p2] => 443
                                )

                            [1] => Array
                                (
                                    [p1] => 321
                                    [p2] => 213
                                )

                            [2] => Array
                                (
                                    [p1] => 111
                                    [p2] => 421
                                )

                        )

                )

        )

)

 

I see at least four options:

Come up with naming structure which "flattens" the data.  I have used this approach in the past, but it quickly becomes difficult to manage and I don't want to do so. Not use PHP's POST and and instead use Content-Type: application/json and file_get_contents(php://input) and json_decode the entire request server side. Use PHP's POST and urlencoding but make deeperObject a string using JSON.stringify and json_decode this one field server side. Urlencode the entire object.

simpleFormName1=bla&simpleFormName2=bla&simpleFormName3=bla&deeperObject%5B0%5D%5Bprop1%5D=bla&deeperObject%5B0%5D%5Bprop2%5D=true&deeperObject%5B0%5D%5Bdata%5D%5B0%5D%5Bp1%5D=321&deeperObject%5B0%5D%5Bdata%5D%5B0%5D%5Bp2%5D=123&deeperObject%5B0%5D%5Bdata%5D%5B1%5D%5Bp1%5D=121&deeperObject%5B0%5D%5Bdata%5D%5B1%5D%5Bp2%5D=423&deeperObject%5B0%5D%5Bdata%5D%5B2%5D%5Bp1%5D=221&deeperObject%5B0%5D%5Bdata%5D%5B2%5D%5Bp2%5D=133&deeperObject%5B1%5D%5Bprop1%5D=blabla&deeperObject%5B1%5D%5Bprop2%5D=false&deeperObject%5B1%5D%5Bdata%5D%5B0%5D%5Bp1%5D=222&deeperObject%5B1%5D%5Bdata%5D%5B0%5D%5Bp2%5D=443&deeperObject%5B1%5D%5Bdata%5D%5B1%5D%5Bp1%5D=321&deeperObject%5B1%5D%5Bdata%5D%5B1%5D%5Bp2%5D=213&deeperObject%5B1%5D%5Bdata%5D%5B2%5D%5Bp1%5D=111&deeperObject%5B1%5D%5Bdata%5D%5B2%5D%5Bp2%5D=421

Any recommendations how to best implement?  If you recommend using urlencoding for simple forms, but some other approach for more complex data, what criteria do you use to transition from one approach to another?

Thanks

Hey guys i am writing a code which will get data frm the user and then write a file in my server and well sadly i am really confused with the annoying errors and warnings i am getting please help here is my code
<?php
//This File Gets the data from the chat setup form and then writes the chat file or edits it 
  
 //Get Data from the form
$cname=$_POST['cname'];
$nicklen=$_POST['nicklen'];
$msglen=$_POST['msglen'];
$pm=$_POST['pm'];
$msgh=$_POST['msgh'];
$aname=$_POST['aname'];
$pass=$_POST['pass'];
$cheight=$_POST['cheight'];
$cwidth=$_POST['cwidth'];
$prcadmin=$_POST['prcadmin'];
$cas=$_POST['cas'];
$frznick=$_POST['frznick'];
$sm=$_POST['sm'];
$id=$_COOKIE["id"];
//Check if the cookie id is empty
if (!isset($id))
{
header( 'Location: www.techbreeze.in/mychat/chat-add.html') ;
}
//Check if any field is empty and redirect to setup page if empty
if ((isset($cname))&&(isset($nicklen))&&(isset($msglen))&&(isset($pm))&&(isset($msgh))&&(isset($aname))&&(isset($pass))&&(isset($cheight))&&(isset($cwidth)))
{
if ((is_numeric ($nicklen)) && (is_numeric ($msglen))&&(is_numeric($pm))&&(is_numeric($msgh))&&(is_numeric ($cheight))&&(is_numeric ($cwidth)))
{
//Start writting data into the file
                        $str1=";";
                $str2 = ".php";
                $str4 = "\n";
               
$File = $id . $str2;
$fh = fopen($File, 'w') or die("can't open file");
               
       $stringData = "<?php\n";
                fwrite($fh, $stringData);
               
                $strt1= "require_once /mychat/src/phpfreechat.class.php;\n";
                $stringData = $strt1;
                fwrite($fh, $stringData);
                             
                $strt1='$params["serverid"]    =';
                $stringData = $strt1 . $id . $str1 . $str4;
                fwrite($fh, $stringData);
                fclose($fh);


$strt3 = "$params";
$stringData = $strt3;
fwrite($fh, $stringData);
fclose($fh);
}
else
{
echo "Only numeric Inputs allowed for the fields";
echo  "<br><br><br>";
echo "Enter the maximum length of nick";
echo  "<br>";
echo "Maximum Lenth of message";
echo  "<br>";
echo "Max number of Simultaneous PM";
echo  "<br>";
echo "No. of msg to be stored in history";
echo  "<br>";
echo "Height of the Chat Room";
echo  "<br>";
echo "Width of Chat Room";
echo  "<br><br><br>";
echo "Please Fill them up Carefully!";
echo "<meta HTTP-EQUIV='REFRESH' content='6; url= http://www.techbreeze.in/chat-setup.html'>";

}
}
else
{
echo "You Have one or more incomplete Field";
echo  "<br>";
echo "Please Fill them up Carefully!";
echo "<meta HTTP-EQUIV='REFRESH' content='2; url= http://www.techbreeze.in/chat-setup.html'>";
}

       ?>

ok now the error i am getting is Quote

Warning: fclose(): 3 is not a valid stream resource in /home/techbr/domains/techbreeze.in/public_html/mychat/chatcreate.php on line 52

Any ideas as to what i should do and why i am getting this error.

I've been trying to figure out how chat apps work all afternoon to do dynamic data in HTML loading.  Can someone please tell me where I'm going wrong for the code flow in this script:

<script>
    function submitchat{
        if (form1.uname.value=='' || form1.msg.value==''){
            alert("fill out whole form");
            return;
        }
        var uname=form1.uname.value;
        var msg=form1.msg.value;
        var xmlhttp= new XMLHttpRequest();

        xmlhttp.onreadystatechange = function(){
            if (xmlhttp.readyState==4 && xmlhttp.status=200){
                document.getElementById('chatlogs').innerHTML=xmlhttp.responseText;
                alert("message sent");
            }

        xmlhttp.open('GET', '?page=3.2&amp;uname='+uname+'&amp;msg='+msg, true);
        xmlhttp.send();
    }


</script>
<form name="form1">
    enter your chat name<input type="text" name="uname">
    message: <textarea name="msg"></textarea>
    <br>
    <div id="chatlogs">Loading Chat Logs...</div>
    <a href="#" onclick="">send</a>
</form>

<?php
$uname = $_REQUEST['uname'];
$msg = $_REQUEST['msg'];
if ($msg!='' && $uname!=''){
    $chat="
	INSERT INTO chat (
	`uname` ,
	`msg`
	)
	VALUES (
	'$uname',
	'$msg'
	)";
    $result = mysql_query($chat, $con) or die (sql_death($chat));
}

Hi,

For about a month, I have been trying to figure out why my code will not return anything after posting a wwwForm (I have also tried the newer equivalent of this function but I had no luck with that either.) The nameField and passwordField are taken from text boxes within the game and the code used in my login script is copied and pasted from a Register script but I have changed the file location to the login.php file. The register script works fine and I can add new users to my database but the login script only outputs "Form Sent." and not the "present" that should return when the form is returned and it never gets any further than that point meaning that it lets the user through with no consequence if they use an invalid name because the script never returns an answer. What should I do to fix this?

Thanks,

Unity Code:

using System.Collections;
using UnityEngine;
using UnityEngine.UI;
using UnityEngine.Networking;

public class Login : MonoBehaviour
{
    public InputField nameField;
    public InputField passwordField;

    public Button acceptSubmissionButton;

    public void CallLogInCoroutine()
    {
        StartCoroutine(LogIn());
    }

    IEnumerator LogIn()
    {
        WWWForm form = new WWWForm();
        form.AddField("username", nameField.text);
        form.AddField("password", passwordField.text);
        WWW www = new WWW("http://localhost/sqlconnect/login.php", form);
        Debug.Log("Form Sent.");
        yield return www;
        Debug.Log("Present");        if (www.text[0] == '0')
        {
            Debug.Log("Present2");
            DatabaseManager.username = nameField.text;
            DatabaseManager.score = int.Parse(www.text.Split('\t')[1]);
            Debug.Log("Log In Success.");
        }
        else
        {
            Debug.Log("User Login Failed. Error #" + www.text);
        }
        
    }

    public void Validation()
    {
        acceptSubmissionButton.interactable = nameField.text.Length >= 7 && passwordField.text.Length >= 8;
    }
}

login.php:

<?php
    echo "Test String2";
    $con = mysqli_connect('localhost', 'root', 'root', 'computer science coursework');

    // check for successful connection.
    if (mysqli_connect_errno())
        {
            echo "1: Connection failed"; // Error code #1 - connection failed.
            exit();
        }

    $username = mysqli_escape_string($con, $_POST["username"]);
    $usernameClean = filter_var($username, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW | FILTER_FLAG_STRIP_HIGH);
    $password = $_POST["password"];

    if($username != $usernameClean)
    {
        echo "7: Illegal Username, Potential SQL Injection Query. Access Denied.";
        exit();
    }

    // check for if the name already exists.

    $namecheckquery = "SELECT username, salt, hash, score FROM players WHERE username='" . $usernameClean . "';";

    $namecheck = mysqli_query($con, $namecheckquery) or die("2: Name check query failed"); // Error code # 2 - name check query failed.

    if (mysqli_num_rows($namecheck) != 1)
    {
    	echo "5: No User With Your Log In Details Were Found Or More Than One User With Your Log In Details Were Found"; // Error code #5 - other than 1 user found with login details
    	exit();
    }

    // get login info from query
    $existinginfo = mysqli_fetch_assoc($namecheck);
    $salt = $existinginfo["salt"];
    $hash = $existinginfo["hash"];

    $loginhash = crypt($password, $salt);
    if ($hash != $loginhash)
    {
    	echo "6: Incorrect Password"; // error code #6 - password does not hash to match table
    	exit;
    }
    echo "Test String2";
    echo"0\t" . $existinginfo["score"];

?>

 

Ok this is puzzleing. I am geting "Could not delete data: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1". but its is deleting the entry that needs to be removed. The "1" is the entry. Just not sure what is causing the error. I do have another delete php but I have put that on the back burning for the time being.     <?php

         $con = mysqli_connect("localhost","user","password","part_inventory");
    // Check connection
if (mysqli_connect_errno()) {
  printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
} else {
    
    $result = mysqli_query($con, "SELECT * FROM amp20 ");
    
    $amp20ptid = $_POST['amp20ptid'];                // escape variables for security
    $amp20ptid = mysqli_real_escape_string($con, $_POST['amp20ptid']);
    
    mysqli_query($con, "DELETE FROM amp20 WHERE amp20ptid = '$amp20ptid'");
      
    
if (!mysqli_query($con, $amp20ptid));

{
 die('Could not delete data: ' . mysqli_error($con));    
}
 echo "Part has been deleted to the database!!!\n";
    mysqli_close($con);
}
?>

I have to some how get data from my sql data to a clients sql db server.  They suggested using xml which is great i can output the required fields as xml but how then do i push this so it goes into the clients sql db..

We cant just do a db insert this has been ruled out.

Im happy using xml just have no idea how to push it at a particular host / sql db any ideas or suggestions would be really welcome.. 

basically if you read this, then you can see they have a "passing-var.php" and a "catching-var.php" How can i make this happen without the passing-var.php and make the catching-var.php actually GET a variable

Right now I have a link list a-z and 0-9.
you click one of those links and your taken to page listing all items that start with that character.
currently I'm using:
Code: [Select]
SELECT * FROM my_table where LEFT(`my_item`,1)='$show' ORDER BY my_title ASCall I do right now is just add a link like ?show=a and everything that starts with a is listed.

Now here is my problem. I want to listen all items that start with a numeric value listed all on one page instead of being spread across 0-9.

If another solution becomes available I'd be more then happy to hear you out. But does anyone know how I can change my query to only list items that start with numbers?

Folks,

" http://www.example.com/whatever/whatever.htm "

 how to Grab the Domain name from URLs?
like "http://www.example.com"

Any suh PHP Cde?

For example:
 

$text = preg_replace_callback( "/([@][a-zA-Z-0-9]+)/"    , "umentions", $text, 1); 

That 1 parameter means the maximum times it will iterate right? So If I'm doing:

@Nexus

@Cupcake

@George

it will return:




My problem is. I only want it to iterate over the last match in my function:
 

function umentions($matches){
vdump($matches);
    return "(here you would replace: ".$matches[0]." with something)";
}

How is it possible to use limit, and only iterate the last match not the first?
Edited by Monkuar, 22 January 2015 - 08:46 AM.

I want to be able to grab any new images uploaded and display them right away on the front page, at the moment I can grab the id of each but that won't update the gallery. Once 4 images are uploaded, the next one to be uploaded pushes the last out of the gallery.   At the moment, I only have 2 images on the db, but I want it ready to be used by a community

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post"  
	enctype="multipart/form-data"> 
	Upload:<br><br> 
	<input type="file" name="image"><br><br> 
	<input type="submit" name="submit" value="Upload"> 
	</form>
	
	<?php
	
	if(isset($_POST['submit']))
	{
		mysql_connect("localhost","____","____");
		mysql_select_db("moduni_images");
		
		$imageName = mysql_real_escape_string($_FILES["image"]["name"]);
		$imageData = mysql_real_escape_string(file_get_contents($_FILES["image"]["tmp_name"]));
		$imageType = mysql_real_escape_string($_FILES["image"]["type"]);
		
		if(substr($imageType,0,5) == "image")
		{
			mysql_query("INSERT INTO `images` VALUES('','$imageName','$imageData')");
			echo "Image uploaded!";
		}
		else
		{
			echo '<br>O<font color="#8B0000">nly images are allowed!</font>';
		}
		
	}
	
	?>

<?php 

	mysql_connect("localhost","____","____");
	mysql_select_db("moduni_images");
	
	if(isset($_GET['id']))
	{
		$id = mysql_real_escape_string($_GET['id']);
		$query = mysql_query("SELECT * FROM `images` WHERE `id`='$id'");
		while($row = mysql_fetch_assoc($query))
		{
			$imageData = $row["image"];
		}
		header("content-type: image/jpeg");
		echo $imageData;
	}
	
	else
	
	{
		echo "Error!";
	}
?> 

<div id="user-gallery">
			<h2>Gallery</h2>
			
						
			<div class="img">
			  <a href="scripts/show_image.php?id=2" data-lightbox="image-1">
				<img src="scripts/show_image.php?id=2" width="125px" height="71px">
				</a>
			</div>
			<div class="img">
			  <a href="scripts/show_image.php?id=2" data-lightbox="image-1">
				<img src="scripts/show_image.php?id=2" width="125px" height="71px">
				</a>
			</div>
			<div class="img">
			 <a href="scripts/show_image.php?id=2" data-lightbox="image-1">
				<img src="scripts/show_image.php?id=2" width="125px" height="71px">
				</a>
			</div>
			<div class="img">
			  <a href="scripts/show_image.php?id=2" data-lightbox="image-1">
				<img src="scripts/show_image.php?id=2" width="125px" height="71px">
				</a>
			</div>
		</div>