在Ruby Mysql查询中使用变量 [英] Using a variable in Ruby Mysql query

问题描述

我有一个名称存储在变量username中，并且想在尝试时向用户提取行信息

I have a name stored in the variable username and would like to pull users row information when I try

result = dbh.query("SELECT * FROM maintab WHERE user = '#{username}'")

我没有结果.但是，如果我手动输入用户名，它将返回结果.如何格式化查询，以便可以使用变量?

I get no results. If I put in the username by hand however, it does return a result. How format my query so that I may use variables?

推荐答案

尝试以这种方式调试:

username = "Peter" # any of your real name
result = dbh.query("SELECT * FROM maintab WHERE user = '#{username}'")

它应该工作.看起来您的username是nil或blank

it should work. Looks like your username is nil or blank

这篇关于在Ruby Mysql查询中使用变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！