I am executing the following commands in my model php in Codeigniter:
$sql=mysql_query("select name from reseller_domain where name='".$name."'");
$numrows=mysql_num_rows($sql);
if($numrows!=null || $numrows==0)
{
return 'f';
}
else
{
return 't';
}
I am not getting any result whatsoever. However, the same query is running perfectly fine in phpmyadmin.
1. mysql_* is deprecated so avoid using that...
2. Are you executing the mysql_connect() command first?
3. Your code is prone to sql injection
Try this in CodeIgniter
$sql = "select name from reseller_domain where name = ?";
$this->db->query($sql, array($name));
if($query->num_rows() == 0){
return 'f';
}else{
return 't';
}
try that and see what error you got.
$sql=mysql_query("select name from reseller_domain where name='".$name."'") or die(mysql_error());
edit:
why you check like that ?
try check like that:
if($numrows==0)
{
select name from reseller_domain where name='Yourname' give yourname with an exisitng name and see if it work.Edit: Seriously my man, you need to start using the CI DB class, this is not a good practice. First of all, try getting your query in a var and exit it to the screen. Then see what the actual query gets and try this in your PHPMYADMIN. I suspect errors with the $name var.
===========================================================================
It looks like you didn't select a database.
Try using Code Igniters DB class?
If you don't already do,
$this->db->query('select name from reseller_domain where name='".$name."');
Must say though you'd better read the docs about it, it might help you a little further. If you did the query with the CI Db class you might want to see the actually outputted query with:
exit($this->db->last_query()); //yes exit isn't good, not even for debugging. But it works.
Then see what goes wrong inside of your query.
It is possible that your DB setup in codeigniter, and where you were in phpmyadmin are using a different default schema.
Try it with: "select name from database_name.reseller_domain where name='".$name."'"
