[url redirect, messes up login system]

Hey,

 

Could provide code for better understanding?

 

[PHP freelancer]

Hello Friends,

My self Chintan from pune, I have 4 years of architecture and development experiance in LAMP technoologies.

 

I like to share ideas and give solution.

[Query Issue]

Please use below sql string.

$query = mysql_query('SELECT value FROM countries WHERE value LIKE "'.$queryString%.'" LIMIT 10');

 

[MySQL Query Executes in phpMyAdmin but returns nothing using PHP Script]

I feel string concatenation is not properly, Please replace with below string and then try.

	
$q = 'SELECT * FROM tbl_svc_auto WHERE auto_model = "'.$model.'" AND '.$year.' BETWEEN auto_year AND auto_year_high';

 

I hope it worx.

[777 upload permission problem]

Hello,

 

Please check following things.

1. File uploaded/created properly

2. Where you saved your $outputfile, give server path.

3. chmod, check path also

4. is_writable, please give a file path also.

 

For, debugging mode, please put exit(); after chmod and run the script and check if file has 777 permission or not.

 

[How to set crontab every week?]

it gives below output.

 

no crontab for root - using an empty one

 

Select an editor.  To change later, run 'select-editor'.

  1. /usr/bin/vim.tiny

  2. /bin/ed

  3. /bin/nano        <---- easiest

  4. /usr/bin/vim.basic

 

[How would I create a "DELETE" button on form?]

Please find JS and php code to implement.

 

function delete_submit(prdt_id)
{

document.getElementByID('prdt_id').value = prdt_id;
window.forms['myform'].submit();
}
</script>
<?php

//After form tag open declare hidden variable
<input type='hidden' name='product_id' id ='prd_id' value=''>

/// below is generate by overview loop
<a href="#" onclick="delete_submit(6)">Delete</a>
<a href="#" onclick="delete_submit(24)">Delete</a>
<a href="#" onclick="delete_submit(25)">Delete</a>

?>

 

I hope you must clear with implementation logic.

[How would I create a "DELETE" button on form?]

You can do this via POST method also.

 

On click "Delete", follow below steps.

1. call Javascript function onclick

2. pass one hidden value with Row_id

3. submit form via Javascript.

 

 

[Display data by alphabetical order]

Can you tell me what you get in $_POST['disloc']?

 

No data found then problem with your input.

 

Please try query without WHERE, if you get correct output what you expect then you have problem with inputs.

 

$query = "SELECT * FROM  books ORDER BY suburbz ASC";
$results = mysql_query($query);

[Cookies and or Session HELP]

Create one form with following elements

1. Name

2. Email

3. Mobile

4. Save(button)

 

After filling, user will submit the form at same time you send a SMS with random text-code(like T30SEP, etc....) to that cell number via SMS gateways... that random code should be linked with data which user has inserted. After received a SMS, user should insert a code to text box at that time you should check if entered txt is same what you have sent, if correct then you approved that user for free passes....

 

[Cookies and or Session HELP]

Hi,

 

This is a very typical problem and I am sure you will get 5-10% junky registrations.

 

1. You cannot compare ip, because in organisational level mutiple pcs have single out-ip, so after very first registration others people stopped to say "already register"

2. People can use multiple email

3. People can use multiple phone numbers.

 

The idle solutions is, after registration ask user's mobile number and send a "temp code" in SMS, which user should entered on the screen after received SMS.

 

So, you can check if code entered correctly then you approved that user. 

 

[How to set crontab every week?]

when I gave a command, it says

 

"bash: 0: command not found"

 

Is it require to install crontab? and how to intall on ubuntu?

[How to set crontab every week?]

Can you please tell me how to set crontab on every sunday night.

[NEWBIE: Search engine with dropdown list]

To get the table column list use below query.

 

$query = "DESC tablename";

 

After getting the result you can fill it using for or foreach loop.

[Simple remote image display script help]

opendir is not work for http, it works with ftp only.

 

You should find any alternative solution.

1. CURL

2. Fsocket

 

Please let me know if you are not aware of about two terms.

[Reasons for recieveing mails in spam after successfuly submitting the form]

Hi jsshanthi,

 

Can you please set the header in mail function and then check.

 

But, please set "From" in mail function.

[Importing a database via PHP]

I think, he got the solution and delete the file from the server. right?

[Finding last entry]

In mysql, use max() function to get highest value of particular column.

 

This is the way you can optimise your query also.

 

$getreceiptnum = mysql_query("SELECT max(receiptnum) FROM accounting WHERE agency = '$agency' ") or die(mysql_error());

[Importing a database via PHP]

Hey,

 

I checked the file but it haven't any fault in file.

 

I think you should change your logic to import by source command.

 

$con = mysql_connect('localhost','user','pass');
$db = mysql_select_db('dbname',$con);

$val = file_get_contents('file.txt');
$query = explode('-- --------------------------------------------------------',$val);
foreach( $query as $k=>$v)
{
    mysql_query($v);
}

 

This worked. let me know still you are facing problems.

[An external php file?]

But for external file you have to give fullpath of URL

 

like :

<?php
include("http://www.website.com/include_file.php");
?>

if, file is exist on your server then you can use

 

<?php
include("include_file.php");
?>