Generate bindParam statements for given sql query

pdo.py

import sys

s = "SELECT * FROM course_strucure WHERE program_id = :program_id AND year_of_joining = :year_of_joining AND sem_code_of_joining = :sem_code_of_joining"
s = sys.argv[1]

print ( "$sql = \"" + s + "\";" )

s = s.split()
s = [x for x in s if x[0]==':']

print ( "$stmt = $conn->prepare($sql);" )

for x in s:
        print ( "$stmt->bindParam('" + x + "', $" + x[1:] + ");")

print ( "$stmt->execute();" )