[How to escape Ajax Request in PHP]

So something like this

https://www.w3schools.com/php/func_mysqli_stmt_init.asp

http://php.net/manual/en/mysqli-stmt.prepare.php

[How to escape Ajax Request in PHP]

Perhaps it doesn't echo because you commented out the line.

 

Don't escape the variable, use prepared statements instead, binding the variable as a parameter

i commented out the line because the line didnt work.

 

and okay i will look into it

[How to escape Ajax Request in PHP]

<?php
include($_SERVER['DOCUMENT_ROOT']."/ext/inc/header.php");
$q = $_REQUEST["q"];
$username = mysqli_real_escape_string($conn, $q);
//echo $username."test<Br>";
echo $q;

mysqli_close($conn);
?>

$q is the string that is being typed in an input box on another page.

 

$username wont echo but $q will.

how to escape $q so i can use it in database quires? 

[Quick question]

founds the answer you can have

header("Location: ../"); exit;

[Quick question]

can i have 

header("Location: ../"); exit;

on same line?

or 

header("Location: ../");
exit;

? if i cant have it on the same line is there a program which searches for header("Location: ../"); in files and then changes "header("Location: ../");" to

"header("Location: ../");

exit"

 

?

[regex not working]

Your regex doesn't say that at all. You have no anchors (which means a substring match is sufficient), and for some strange reason you're using preg_match_all(), as if you expected multiple matches.

 

If you only want to allow dashes and dots as delimiters between alphanumerics, that's

'/\\A[a-z\\d]+(?:[.-][a-z\\d]+)*\\z/i'

Length checks are the job of strlen() or mb_strlen().

oh my goodness thank you so much. not its fixed!

[regex not working]

this is my code 

$re = '/[^\W][a-zA-Z\d.-]{3,20}/';
if(!preg_match_all($re, $username)){
 do something
  }else{
 do somthing else
}

$username is a $_POST['username'];

when i submit a 3 letter word it works

but when i use symbols like $ and ! and etc it still goes through,

im trying to get a regex where the username is 4-20 characters long and only the alphabet and numbers and

dots and dash but dots and dashs cant be next to each other

 

thx